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.    

    jrbledsoe001
    Veteran Member
    Posts: 91
    Veteran 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?
        Adam Jacobson
        Veteran Member
        Posts: 69
        Veteran 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!