12-08-2006 7:59 PM
Hi,
In my report I need to pull company address. I am able to pull the company address but if the company has multiple address (BP-->Address overview) then its pulling up that company that many times.
How can I get only the default address?
Regards,
D
12-18-2006 7:39 AM
Hi
There are different tag marked with the address when it is filled initially through BP transaction.
To pull the correct or required address you need to initialize that in the query.
If more than one address is maintained in the system for same address type. You need to make one address as a default or standard address and while fetching initialize that in the query. If you dont put the flag in the query, it will not give the desired result.
Regards
Mithlesh