Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
My client is using Dynamics AX 2009, there is a case where they have identified that they have entered some Sales Orders & some Purchae Orders in-correct, now they want a routine through which they can delete selected Sales Orders, Purchase Orders which are already invoiced.
These transactions should be deleted in such a way that Customers / Vendor Ledgers GL & Invenotry is updated. In order to explain the requirement followin is the example:
Following are the Posted POs:
1. PO 1 (invoiced) Amount 10,000
2. PO 2 (invoiced) Amount 5,000
3. PO 3 (invoiced) Amount 10,000
Now PO 3 is entered wrongly and they want to delete it through routine in such a way that its impact is deleted from PO Table, Vendor's Ledger Inventory Transaction & GL Transactions.
Transaction Reversal is not acceptable. Please help.
There is really no easy way of doing this.
Take a look at the class SysDatabaseTransDelete. With some modifications you can use this class to delete transactions. You would have to modify to specify transactions... If you currently run it, it will delete all transactions in the company.
Be careful however. Backup your DB and use a test environment for this.
I have never used the framework but it claims it can purge transactions and still keep the DB consistent. Most likely worth a look.
Thanks for the reply , yes I think you are right this is the only option, by the way how about using Intelligent Data Management Framework for Microsoft Dynamics AX?
Can this tool help?
Thanks Kent. I will look into this and will try to update this post.
Any luck Muhammed Saad on This Subject ?
Well we are still waiting for our customer to confirm whether problem is solved or not
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics