Who's On?

	Membership:
	Latest: Steve G
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5242

	People Online:
	Visitors: 124
	Members: 0
	Total: 124

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Vendor Address Defaults

1 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

dukeslater

Basic Member

Posts: 9

6/18/2012 5:54 PM

I'm having trouble figuring out the logic for returning the default addresses for each vendor.

For example, in APVENMAST vendor 8 is 3M. Both the REMIT_TO_CODE and PURCH_FR_LOC are null.

In APVENADDR vendor 8 has 36 addresses, all have CUR_ADDR = Y.

Each has a different location code, but only about 10% of the vendors have an address with the location code I would consider our 'home' location.

If the location fields in APVENMAST are null, how would I return the default addresses (for this project either purchasing or remittance address would work equally well.)

TIA.

JonA

Veteran Member

Posts: 1163

6/22/2012 2:10 PM

Are you looking for the address that you see in AP10.1? This would be the address in APVENADDR that has no location code. {APVENADDR.LOCATION_CODE} = " " in the record selection will give you this. Or if you want the address for the remittance code and that code is standard accross all vendors then use that. Frankly, I don't know what the REMIT_TO_CODE and PURCH_FR_LOC fields are used for in APVENMAST. Those fields are really stored in APVENLOC. Just use the APVENADDR table in your query and link to APVENMAST if you need the vendor name or other fields.