Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Reporting Invoice Date with GL Trans

 6 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member
7/9/2009 1:03 PM

    HI,

    What is the best way to get Invoice Date added to a report with GLTrans?  I have looked at APInvoice and HCHISTDTL with ACHISTHDR.

    They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period.

    I am pretty new to this stuff.


    Thanks!

    Derek Czarny
    Veteran Member
    Posts: 63
    Veteran Member
    7/9/2009 1:08 PM
      You can join GLTRANS (OBJ_ID) to APDISTRIB (GLT_OBJ_ID) and APDISTRIB (API_OBJ_ID) to APINVOICE (OBJ_ID).
      John Henley
      Posts: 3353
      7/9/2009 1:30 PM
        ACHISTDTL & ACHISTHDR are for invoicing customer receivables (i.e. AR, not AP).
        APINVOICE & APDISTRIB are for invoicing vendor payables (i.e. AP, not AR).

        You want to go from GLTRANS to APDISTRIB to APINVOICE to get the invoice date.
        Thanks for using the LawsonGuru.com forums!
        John
        muffntuf
        Advanced Member
        Posts: 41
        Advanced Member
        7/9/2009 2:46 PM
          Thank you.

          Next question - for these joins, this would only give one record back for one invoice, or do I need to know how to deal with a one-to-many relationship here? If so, how do I make sure I only have one invoice accounted for?

          Thanks!
          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
          7/9/2009 3:06 PM
            GLTRANS to APDISTRIB has a one to many relationship. Again APDISTRIB to APINVOICE has a many to one relationship.

            On one invoice you may have multiple lines of items you are ordering that may hit diffrent GL Accounts. So there is a many to one relationship between APDITRIB to APINVOICE.

            Again if you run the GL190 depending on whether you summarize your subsystem entries there may be one journal entry with multiple transactions on it. This explains a ONE to MANY relationship between GLTRANS and APDISTRIB.
            John Henley
            Posts: 3353
            7/9/2009 3:14 PM
              Posted By muffntuf on 07/09/2009 09:03 AM

              HI,

              What is the best way to get Invoice Date added to a report with GLTrans?  I have looked at APInvoice and HCHISTDTL with ACHISTHDR.

              They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period.

              I am pretty new to this stuff.


              Thanks!


              Just buy this report

              www.lawsonguru.com/Store/p/Crystal-...ID/16.aspx

              Thanks for using the LawsonGuru.com forums!
              John
              muffntuf
              Advanced Member
              Posts: 41
              Advanced Member
              7/9/2009 4:53 PM
                So you have multiple lines of items for one invoice, but you just want the summary of the invoice, or do you mean the GL will bring in line item details as well?

                "GLTRANS to APDISTRIB has a one to many relationship. Again APDISTRIB to APINVOICE has a many to one relationship.

                On one invoice you may have multiple lines of items you are ordering that may hit diffrent GL Accounts. So there is a many to one relationship between APDITRIB to APINVOICE.

                Again if you run the GL190 depending on whether you summarize your subsystem entries there may be one journal entry with multiple transactions on it. This explains a ONE to MANY relationship between GLTRANS and APDISTRIB."