Report of possible deleted PO's/SO's

(0) Share

Report

Posted on by Community Member

Greetings!

Accountants are checking our books and so today I was asked to run a report that shows if any purchase and/or sales orders have been deleted from our system over the past year. I figured I could do this by using the "database log" report in the Administration section of AX.

This report showed me a lot of information but no deleted purchase/sales order lines (or complete orders for that matter). To be completely sure the deleted orders/lines weren't being hidden from the report I was asked if I could delete a test order and run the report again. However this deleted order (and it's lines) did not show up in the report. The report is also made up of a lot of deleted "Number sequence list" items (about 95% of the report I'd say) but no PO/SO lines. Do these perhaps resemble the PO/lines?

Am I using the wrong report for what I want to achieve? Or is something else going wrong somewhere?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (1)

Report

Hi Sebasshhh,

To be able to see details in the database log, you need to enable the logging for these tables.

For sales and purchase orders you can also enable a parameter called 'mark order as voided'. This will ensure the orders are stored in history tables:

Accounts Receivable > Periodic > History > Voided sales orders

Accounts Payable > Periodic > History > Voided purchase orders

Note that it will not contain the history if you enable it after deleting the orders.

Was this reply helpful? Yes No
Verified answer

Kauto 2,699 on at

Like (0)

Report

From a sales perspective - check the SalesTableDelete table - if the created date time is on this you can export the sales order Ids from this and then do a filter on the date in excel to give them what they require.

I think the same applies to Purchase orders

Was this reply helpful? Yes No
André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

The table name provided by Kauto is the base for the historical data I referred to.

Also when orders were deleted and there was a posting like a confirmation, packong slip or invoice, the journals are still available in the inquiries section of the menus.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I was unable to find the directory provided by you André. We do not seem to have a history folder in the Accounts Receivable/Payable > Periodic path. Is there any other place/path it could have been placed?

Logging does seem to have been enabled on the sales orders though because when I use the AOT and table browser to look up and see the contents of the "SalesTableDelete" table (as mentioned by Kauto) it's filled with orders dating back to 2009.

Unfortunately the "PurchTableDelete" table is empty so I'd still love to know where I can find the option to log voided purchase orders (as I don't assume it's empty because there's never been a deleted purchase order). I understand it might not help me get the information I need right now but it'll help for any future questions I might get regarding the subject.

Thank you both for your assistance so far!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Just found the voided purchase orders under "Accounts Payable > Inquiries > History" but, like the PurchTableDelete table it's empty. So I'd still like to know how I could enable logging for the purchase table. Thanks again! ;)

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

Did you also found the history in accounts receivable?

Can you check the AP parameters if the 'Mark as voided' for purchase orders is enabled? It seems to be enabled for sales orders as you had found some records in the table SalesTableDelete.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ah, yes I've found it... I totally missed that little checkbox when I looked over the parameters yesterday! Mark as voided was enabled for the sales orders but disabled for the purchase orders. I just enabled it!

Thanks a lot!

Was this reply helpful? Yes No