Prev
Next
Forums Financial Management Lawson S3 Financials

AP Vendor's payment address

 3 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
2/20/2015 12:22 PM
    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
    2/25/2015 5:04 PM
      Have you tried pulling the remit address?
      Chesca
      Veteran Member
      Posts: 490
      Veteran Member
      3/2/2015 2:12 PM
        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
        3/5/2015 10:27 PM
          Try using field REMIT_TO_CODE unde APPAYMENT table..