AP Vendor's payment address

 3 Replies
 1 Subscribed to this topic
 44 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
New Poster
New Poster
Congrats on posting!
Hello, hope some can help me out here. We have a custom program that creates a vendor's payment history report. It reports vendors ID, name, tax ID, invoice amt, Net Payment Amount, class, and address. The only problem is the some of the address are incorrect because they want to see not the main address but the transaction address. So if a vendor's main address is in IL, but they did the transaction in WNY, the it should report the WNY address. I don't know where this address would be store other than the AP vendoradress file.
jjcyeshua
Veteran Member
Posts: 49
Veteran Member
New Poster
New Poster
Congrats on posting!
Have you tried pulling the remit address?
Chesca
Veteran Member
Posts: 490
Veteran Member
New Poster
New Poster
Congrats on posting!
I pulling the vendor location code from the invoice file. So if the if the purchase from location code matched the address on the master file, use this this address.
jjcyeshua
Veteran Member
Posts: 49
Veteran Member
New Poster
New Poster
Congrats on posting!
Try using field REMIT_TO_CODE unde APPAYMENT table..