• Search Forums
    Advanced Search
Prev
Next
Forums Financial Management Lawson S3 Financials

Invoice Distribution from AP Payment

 2 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
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
New Poster
New Poster
Congrats on posting!
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...
Deleted User
New Member
Posts: 0
New 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.