Clean up Sales Update History

Submitted by Nathan Clouse on 02/25/20.

Last modified:

03/06/20

Clean up sales update history!

Just like purchase orders, this is a way to cleanup the update history for sales orders. For similar reasons as with purchase orders, you should periodically clean up sales order update history at least once a year.

AX 2012

In Sales and Marketing > Periodic >Clean up, look for sales update history cleanup.

You will have an option for the status of the update and a created until date. You can use the date to clean out prior years where knowing exactly who posted what is of little to no importance. This process is fairly straight forward and cut-and-dry as there is very little behind the scenes logic. This will go through and delete records from the following tables based on your selection:

Sales Order - Update table (SalesParmTable)
Sales Order - Update (SalesParmUpdate)
Sales Order header - Updating table (SalesParmSubTable)
Sales Order Line - Delivery Address - Update Table (SalesParmLine)
Purhcase Order Line - Connection - Update Table (SalesParmSubLine)

Depending on what was deleted above, it will clean up the data in the related table if the transaction posted successfully.

Localization (SalesParmTableExtension_CN)
Unknown (PIInventPackageParm)
Customer - Payment schedule (CustPaymSched)
Shipping Specification (SalesShippingStat)
Localization (SalesParmUpdate_IN)
Localization (SalesParmLine_IN)
Sales order line update information for potency (PDSSalesParmLinePricingCalculation)
Sales order line - update table (MCRSalesParmLine)
Items to pack into containers (MCRPackagingItem)
Packing box transactions (MCRPackagingBoxTrans)
Unknown (PIInventPackageParm)
Localization (SalesParmLineCorrLink_RU)