• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Associate a APPAYMENT Invoice with GL Trans

 3 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member
9/15/2009 6:47 PM
This is a hard association I am finding.

I need to associate a APPAYMENT Invoice with a GLTRANS transaction(s).  Has anyone done this?  If so, how do you accomplish it?

Thanks!
Sam Simpson
Veteran Member
Posts: 239
Veteran Member
9/15/2009 7:33 PM
It has been a long while but I thought it should be:

APPAYMENT using invoice to APINVOICE then to GLTRANS using OBJ-ID.
Deleted User
New Member
Posts: 0
New Member
9/17/2009 6:34 PM
That's not going to work.
The standard relation between GLTRANS and ap is to the APDISTRIB file.
If you look in the APPAYMENT file, there is neither an object ID or any payment accounting information.
You can (theoretically) tie out APPAYMENT against GLTRANS if you map find the gl account debited by looking up the account for the cash code. YOu can use CHECK-DATE in APPAYMENT transaction as the posting date. And that should work.
But there are no obvious indexes on check date so I'm not sure how this would run.
muffntuf
Advanced Member
Posts: 41
Advanced Member
9/17/2009 7:27 PM
Slowly! Thanks for the info. Using GL.Post_Date = APPAYMENT.Check_Date does not exactly work either. Not the best to run off of date field.