Question Status

Verified
Muhammad Saad asked a question on 30 Jan 2012 12:18 AM

Dear All

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.

Regards

Muhammad Saad

 

Reply
Verified Answer
Kent Carstens responded on 30 Jan 2012 5:39 AM

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.

Good luck.

Reply
Muhammad Saad responded on 30 Jan 2012 9:17 PM

Dear Kent

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?

Regards

Muhammad Saad

Reply
Verified Answer
Kent Carstens responded on 31 Jan 2012 5:34 AM

I have never used the framework but it claims it can purge transactions and still keep the DB consistent.  Most likely worth a look.

Reply
Muhammad Saad responded on 31 Jan 2012 8:42 PM

Thanks Kent. I will look into this and will try to update this post.

Reply
Mohamed A.Raouf Elkhouly responded on 23 Feb 2012 4:52 AM

Any luck Muhammed Saad on This Subject ?

Reply
Muhammad Saad responded on 23 Feb 2012 5:22 AM

Well we are still waiting for our customer to confirm whether problem is solved or not

Reply
Verified Answer
Kent Carstens responded on 30 Jan 2012 5:39 AM

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.

Good luck.

Reply
Verified Answer
Kent Carstens responded on 31 Jan 2012 5:34 AM

I have never used the framework but it claims it can purge transactions and still keep the DB consistent.  Most likely worth a look.

Reply