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

What am I missing? - GL Q

 1 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member
9/14/2009 7:04 PM
If you want to match transactions say a summarized transaction with its corresponding payments - how do you do that?

If you have a summarized transaction fo $65,0000 and that is posted to the GL- it is the first line in the sequence of events.  There are two separate invoices that make up that $65000.  Invoice A is $13,000.  Invoice B is $52,000.  And the two combined make the $65k.

How do you associate the Invoice with the Summarized transaction in the GL?  Outside of showing a double entry for the GL because there are two invoices.  The OBJ_ID in gl = the GLT_OBJ_ID in AR but the two invoices have their own OBJ_ID's so you cannot connect the dots that way.

Is there an intermediary table?  Working with AR and GL.

Thanks!
Deleted User
New Member
Posts: 0
New Member
9/14/2009 10:22 PM
when you do a join like this, its by definition a one to many relationship. so your raw data will come back like this

GL Journal GLtrans-obj id glt-amount invoice invoice amt
1 12345 65,000 A1234 13,000
1 12345 65,000 A9675 52,000

so, in your reporting tool, you need to work with the result set to, for example, only print the glt-amount once.