I have a posted sales order and sales order that I'm not able to find on the customer account except in the customer ledger entry. The change log shows me that the Sales Order was posted to a PSI but all my searches in both sales orders and PSI's can't find that document. Where can I see who deleted that posted sales order from the record? The only way I can see things in the change log is by filtering for the Sales Order number in the Primary Key Field 2. Is there an easier way to search for deleted sales orders and posted sales orders?
*This post is locked for comments
Hi,
Under the circumstance that you have enabled the Change Log functionality for Posted Sales Invoices.
- Get the Document No. from the Customer Ledger Entries (this Document No. is the original Invoice Number)
- Open Change Log and Filter for "Table No. = 112" (112 is the Posted Sales Invoice-Table)
- Filter with the Document No. (from Customer Ledger Entries) on the field "Primary Key Field 1 Value"
It's always frightening that NAV allows to delete a Posted Sales Invoice. NAV is designed based on Customer Accounts. That means, for NAV a Posted Sales Invoice is just a "Document". All other functions (like payment application, reminders etc.) is based on the Customer Ledger Entries.
Sohail Ahmed
2
mmv
2
Amol Salvi
2