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

Summarized Transactions

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member
8/17/2009 4:36 PM

I need a quick lesson in invoices - particularly if they have a GLTRANS that says summarized transaction.  I need to provide the details of the summarized transaction.

So if a GLTRANS  has system code of AP, System is AP, lets say the summarzied transaction is for $5000.00.  And there is an invoice number attached of 2009.  How can I get the $5000.00 broken down?


I have GLTRANS joined to APDISTRIB and find the invoice there.  I also have APPAYMENT attached to APDISTRIB and find some information there, but no details for the summarization of $5000.00.

So what am I missing?  Where are the Invoice details that make up the $5000.00?

Thanks if anyone can give me a clue to what I am missing here.    

Deleted User
New Member
Posts: 0
New Member
8/17/2009 5:01 PM
Hi,

I'm little rusty with my Crystal skills which is why I'm learning from everyone here on the forum. Your key to unlocking the APDISTRIB to GLTRANS records wll be the APDISTRIB object IDs. You'll see a GLTRANS object ID which will link back to the APDISTRIB object ID. I remember this being a tricky query but take a good look at the object IDs.
muffntuf
Advanced Member
Posts: 41
Advanced Member
8/17/2009 5:50 PM
So are you saying instead of using the GLT OBJ ID, pick up on the APDISTRIB OBJID?
Deleted User
New Member
Posts: 0
New Member
8/17/2009 6:15 PM
Per the Lawson Data file text on GLTRANS
Apdistrib APDISTRIB

GLT-OBJ-ID -> APD-GLT-OBJ-ID
APD-API-OBJ-ID
APD-DIST-SEQ-NBR

glt - the prefix for GLTRANS
apd - the prefix for APDISTRIB

So, you see that apdistrib has a field called glt-obj-id. That's the one you want to link to.
muffntuf
Advanced Member
Posts: 41
Advanced Member
8/17/2009 6:17 PM
Thanks Adam, actually he was right. If you want the details of an invoice to match up to GLTRANS you have to use the Invoice table obj id. Proved it out in a jiffy!

Thanks for that tidbit!