Dynamics GP Received Not Invoiced report issue

Client called with an issue - items were dropping off the Received Not Invoiced report in Purchasing.

This report shows the balance of accrued purchases - that is the items you receive but which have not been invoiced. On receiving the items would debit inventory and credit accrued purchases, and on invoicing you'd get a debit to accrued purchasing and a credit to accounts payable.

The two items in question were both open purchase orders, but the problems were very different.

PO 1. The first PO had two line items. The line at issue had been inadvertently received at qty 12, when it should have been received one per month. So this receiver should have remained open as invoices were posted one per month. At some point in 2015 the receiver dropped from the report. The lines on the PO remain in a received status.

PO 2. The next PO had 6 detail lines. Several receivers remained open, but there were many more that should have been open.

My investigation of these two revealed the following. First, being the suspicious person I am, I asked that they run check links on the Purchasing work files. I had a gut feeling that something may have been stuck.

PO 1. Sure enough check links popped an invoice for the remaining quantity on the receiver. My examination of a backup database revealed that the invoice lines and quantities records were present in the receipts work tables but the invoice header was missing. The existence of this data resulted in the report thinking that receiver was fully invoiced.

PO 2. Simple but harder to substantiate - the lines on the PO are in status closed, except for the one open line that has receivers on the report. As the lines have cancelled quantities I can only surmise that someone went into the Edit Purchase Orders window and closed the lines. The receivers remain un-invoiced but since the lines are closed no more invoice transactions can be processed. A dead-end.

As the client uses RDS the recovered invoice transaction may have been a victim of a killed GP session, or some other calamity. The receipt number for the transaction is in line with a batch of a dozen others entered by one person on 1/6. No idea how it happened but pretty good evidence of why.

As to the closed PO lines, while a report does print no record of the closing process is retained.

No complete answers but enough evidence of what transpired to satisfy the issue.