Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

What am I missing? - GL Q

Sort:
You are not authorized to post a reply.
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!
    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran 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.
      You are not authorized to post a reply.