Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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!
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.
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
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.
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!
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! ;)
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.
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!
Business Applications communities