Does anyone know of any instance where random sales order numbers go missing from the database, making sales order searches come up as ‘Not Found’?
Our inhouse Epicor support reports that the sales order number is simply ‘gone’. We have ruled out user error or deletion, for now, and we only realize that the sales order is ‘gone’ when performing a search. No error messages or notifications occur.
Also, is there a tracking log we can use to see where and when a deletion might have occurred?
The change log does not cover deletions by default. Also, it is very easy to start an order, save it and finally delete it all before creating lines.
The only way to stop this is a BPM to prevent deletions.
There are a few things you can do. Most times this comes up in an audit where the sales order numbers skip. The first thing to do is to create a BPM to prevent deletion and train users to void orders rather than delete them. Secondly you can use an SQL trigger to detect and log when a record is deleted. As Jason said though the best is the BPM and then the subsequent training. Hope this helps.
And this is not just sales orders. This happens for other counters in Epicor as well. Two thoughts though:
As for sales orders, there is a BookDtl table that will still show the number IF Ready for Processing was checked.
For items where it’s important to have sequential numbers (mostly invoices for VAT), Epicor uses the Legal Number functionality as a way to ensure an unbroken sequence of a counter.
one other “nasty” place is in Quick Job Entry… when you press the “next Job” button, it increments the next job number, but nothing is saved until you actually save it. you can click that butting a bunch of times, and skip a series.
For the heck of it, check the users territory rights (Work Force and Territory maintenance). Even system managers can have orders and customers hidden from them if they are not authorized to see all territories.
If change logs are on they should still exist for the deleted record. You should be able to see the creation of the order in the change log even if it was deleted. You will have to use a BAQ to search the log for a specific record or search for log entries where the order does not exists.
