Order Entry: Missing Sales or Purchase Orders on Sales/ Purchase Order report

You may observe that one or more Sales or Purchase Orders to be missing on the Sales/ Purchase Order report.

The following steps explain how to resolve the abovementioned query:

1. This issue may be due to a manual deletion on the Sales Order Maintenance screen and the rest of the steps below will help you to prove or disprove it.

2. Go to Administration | System Tools | Message Log Viewer | Company node in which all actions for Sales/Purchase Order deletions are stored.

3. However, you may observe a significant number of entries in the Company node so it may be quite challenging to find evidence in here of the specific sales/purchase order that was deleted.

4. Fortunately, the following efficient procedure can be employed to prove or disprove if the sales/purchase order was manually deleted.

Note: It is recommended that this issue should preferably be handled and fixed by a professional Evolution support consultant.

This is due to the solution requiring advanced, database analysis skills and an understanding of how to compile SQL queries, to correct the above problem.

Therefore, please contact either your Evolution business partner (BP) or Evolution Support to resolve this issue.

Apply the following steps to resolve your query:

1. In this case we’ll be referring to missing Sales Order SO2382, but the same logic also applies to missing purchase orders.

2. Restore an older backup of the Evolution company in which Sales Order SO2382 was still available, as DEMO

3. On the Sales Order Maintenance screen, find and confirm its existence.

4. Go to the Accounts Receivable | Enquiries | Transaction Enquiries | Orders tab.

5. Enter the relevant customer code for which SO2382 is missing.

6. On the Orders grid, Right-click | Customize Grid Column

7. Find and then drag the Invoice ID field to the top of the header row below.    

8. On the Order Number column find SO23825 and note the relevant Invoice ID value e.g. 1369 in this case.

9. In MS SQL run the following SQL script, on the current, live (not DEMO) company database (using the above ID example)

select * from  _btblLogDetails

where cDetails LIKE '%1369%'

10. If found, the cDetails column should indicate if this sales order has been manually deleted.

11. Also notice the iAgentID value in this case 5, as well as the dTimeLogged value, in this case, 2016-08-18  17:36:57

12. To identify the specific agent with an agent ID of 5, run the following SQL script

               select * from _rtblagents

               where idAgents = 5

13. The results show in this case the agent (who deleted the sales order) is Theresa 

Conclusion:

a) Applying the above steps proves or disproves if a sales/purchase order has been deleted and it assists you to indicate which agent deleted the order on which date.

b) However, once a sales/purchase order has been deleted it cannot be recovered, unless a backup is restored over the live company.