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

Associate a APPAYMENT Invoice with GL Trans

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member
9/15/2009 6:47 PM
    This is a hard association I am finding.

    I need to associate a APPAYMENT Invoice with a GLTRANS transaction(s).  Has anyone done this?  If so, how do you accomplish it?

    Thanks!
    Sam Simpson
    Veteran Member
    Posts: 239
    Veteran Member
    9/15/2009 7:33 PM
      It has been a long while but I thought it should be:

      APPAYMENT using invoice to APINVOICE then to GLTRANS using OBJ-ID.
      Adam Jacobson
      Veteran Member
      Posts: 69
      Veteran Member
      9/17/2009 6:34 PM
        That's not going to work.
        The standard relation between GLTRANS and ap is to the APDISTRIB file.
        If you look in the APPAYMENT file, there is neither an object ID or any payment accounting information.
        You can (theoretically) tie out APPAYMENT against GLTRANS if you map find the gl account debited by looking up the account for the cash code. YOu can use CHECK-DATE in APPAYMENT transaction as the posting date. And that should work.
        But there are no obvious indexes on check date so I'm not sure how this would run.
        muffntuf
        Advanced Member
        Posts: 41
        Advanced Member
        9/17/2009 7:27 PM
          Slowly! Thanks for the info. Using GL.Post_Date = APPAYMENT.Check_Date does not exactly work either. Not the best to run off of date field.