Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

BR21 - how does this work?

Sort:
You are not authorized to post a reply.
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member
8/13/2009 2:46 PM
    I am hunting around for information on BR21, BR152 and BR121 I have isolated a GLTRANS record and the source is BR21 - which seems to be a invoice reversal or deletion?

    But there is still the record in GLTRANS, so I am trying to track down the tables the transaction originated from.  I have tried ARDISTRIB, APDISTRIB, AROIHDR and AROITEMS.

    Where else can I look for the origintating transaction be or how can I trace this back to the originating invoice?

    Thanks!
    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran Member
    8/13/2009 6:30 PM
      BR21 reverses the posting of a BR invoice. However, unlike links back to AR and AP, getting to this detail is not so easy.
      In AR and AP, there are actual reversing transactions when you credit or debit another transaction.

      With BR, the original transaction simply gets cancelled - the status is updated in ACHISTHDR and ACHISTDTL.

      The problem here is that the GLT-OBJ-ID in the ACHISTDTL file relates (I think) to the original posting of the invoice, not to the reversal. But you can check that. A quick look at aCHISTHDR indicates that there's not even a cancel date on the invoice.

      Good luck.
      muffntuf
      Advanced Member
      Posts: 41
      Advanced Member
      8/13/2009 7:38 PM
        Thanks for the confirmation Adam! I did start working this out and you confirmed what I was seeing.
        You are not authorized to post a reply.