• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

BR21 - how does this work?

 2 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
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!
Deleted User
New Member
Posts: 0
New 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.