I have an order that was invoiced yesterday. The invoice was printed and I have the hard copy. Now the invoice is no longer in O/E or A/R. I can pull up the order (under the "order" tab), and it shows an invoice number accociated with it, and it says that it is complete. Yet, that invoice number is missing when looking under the "invoice" tab.

This is not the first time this has happened either, but it is always only one invoice, never a group of invoices, and all other invoice from that day are fine. I deal with it by copying the order and invoicing it again (this always works).

How can this happen?

Hi Nick,

Printing Invoices out of Order Entry occurs after posting. That means the invoice had to have posted correctly before it could be printed.

Does your data pass an integrity check? Does the invoice (which has been printed) exist in History, moved there because Day End Processing put it there? Day End would also create the invoice to be sent to Receivables.

You are correct. This invoice was purged to history. I am not sure why, but I think it may be because it was for a "misc charge" only, no inventory was sold.

I was mis informed about the A/R aswell, it did indeed hit the customer's account.

Thanks.

Hi Nick,

Glad to hear that's all that was.

Just so you know, there are default settings in the Order Entry company profile for how long to keep completed orders, invoices and credit notes in the 'Current' screens and not purge. This is on the 4th screen - System Defaults. You can set different number of days for each (ie 30 days for orders and 180 days for invoices, etc). These settings are used when running Day End Processing, and can be over-ridden as necessary, including not purging any transactions at all.

Yeah, I have it set at 90 days (orders and invoices). Yet, for some reason, this invoice, and only this invoice, was purged to history after 1 day.

Hi Nick,

I think I know what that may be, and if so it will be fixed in the next upcoming service pack. If an invoice only contained misc charges (no items), there sometimes was a scenario where the invoice date may not be set/updated correctly. If so, then Day End wouldn't be comparing the purge date to the correct invoice date. Perhaps check the invoice in history to look up what the invoice date shows there...