Prev
Next
Forums Lawson S3 Financials

Invoice Distribution from AP Payment

Sort:
You are not authorized to post a reply.
Author
Messages
G. Monaghan
Basic Member
Posts: 6
Basic Member
4/4/2012 3:29 PM
    I am trying to write a report of cash by activity. The activity is attached to the invoice on AP invoice distribution table (apdistrib) and posts to GL via AP175. When the check is written the entry to GL to cash just clears AP via AP170. There appears to be no way to tie the entry from the AP175 to the corresponding payment done via AP170. Has anyone found a way to accomplish this?
    jjcyeshua
    Veteran Member
    Posts: 49
    Veteran Member
    4/10/2012 1:33 PM
      Once you are done with AP Payment cycle, run GL190 you will see the how cash, AP, expenses are getting posted...
      Adam Jacobson
      Veteran Member
      Posts: 69
      Veteran Member
      4/25/2012 6:05 PM
        You can get from an AP175 (APDISTRIB) to a check number (stored in APPAYMENT/
        APD-COMPANY -> APP-COMPANY
        APD-VENDOR -> APP-VENDOR
        APD-INVOICE -> APP-INVOICE
        APD-SUFFIX -> APP-SUFFIX
        APD-CANCEL-SEQ -> APP-CANCEL-SEQ
        The field in APPAYMENT IS TRANS-NBR

        The fundamental challenge here is that a given distribution/invoice can be paid on multiple checks and you need to create some logic to figure out which distributions go to which check.
        It's doable if you do something like assume that each payment is spread evenly across distributions.

        I'm not sure this is what you want exactly.
        You are not authorized to post a reply.