Anyone know what drives the assignment of the GL account # on the actual report RGNI Report?
As you can see on the summary page of the attachment, each site has a grand total amount, but there is $70,814.43 which has been received but not linked to an account on the report. In reality the amounts did post to the GL, but the report is not allocating the missing amounts. Therfore the report doesn’t equal the Balance Sheet. I have traced the problem back to Purchase Orders which have line items which have not been received yet. If you look on pg.35, you can see that PO # 72659 is missing lines 8 & 9.
Did you check that the lines on the PO have a Part Class assigned?
Is any user by chance first received the items and then deleted them later.
Are you using any Unreceived Line functionality in AP, rather than Advanced Billing, for pre-paying suppliers? We used to use Unreceived Lines but switched to Advanced Billing because the GRNI goes out of balance and our internal audit procedures require this to balance.