Good day forums,

Under a specific customer, we are missing invoices in the column for "Transactions for" "Receivable". Under "Transactions for" "OrderEntry", the invoices are there for the same customer. When we look at General Ledger, the invoices in question were already posted.

What can be done? If you have any questions regarding our situation, I can try to answer them.

Thank you,
Terrence

Hi Terrence

Are they there when you move the button over to "Both" instead of "Current"? I'm willing to bet they were paid and moved to History as part of Period End or Year End.

Remember, the transactions sort by date or by Type/Doc No, depending on the option selected.

Steve

Either what Steve says or you may have an outstanding batch to post in Receivables or it has been deleted.
If you have version 9.2A, you can recover the batch. Be sure to keep the same number and date.

The other possibility is that you are keeping more history in OE than in AR.

Hello Steve,

To answer your question, when I look in Current, Historical, and Both, and sort by Type/Doc No, the result is the same. The three invoice did not appear in either Current of Historical transactions in Receivables.

Thank you for checking.

Terrence

Hello Patricia,

I've looked in the Historical transactions and didn't find the missing invoices.

Regarding batches, one of the three missing invoices does not appear in Receivables > Inquiries > Batch Status > Invoices. The other two missing invoices do appear in a numbered batch, with the status "Posted" and Type "Received".

And we are using Receivables 9.2A (170711), but when I looked up Recover Batch and highlighted the batch with the missing invoices, the Recover button is greyed out.

Terrence

Terrence

You may want to contact you Adagio Consultant for further assistance.

Hello Douglas,

From OrderEntry, when I look in Inquiries > Historical Invoices, and look up the Customer # and Invoice #, In the Invoice details there is a Restore button. Could this be a solution or will something else occur buy Restoring this invoice?

Terrence

Hi Terrance,

The Restore button on a historical OE Invoice will create a new Order based on the contents of that invoice. You don't want to do that.
AR and OE transactions are stored in separate files. As Steve said, they might possibly have been purged through current and history. Or perhaps there was a write error when posting the AR batch. Hard to say definitively.
You may not have security access to Recover batches in Receivables, if the highlighted batch has a status of Posted.

I agree with Doug that having your consultant take a closer look with you will likely get to the bottom of this faster than on a forum.