Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Table Cleanup

  • 1.  Table Cleanup

    Posted Nov 29, 2018 02:41 PM
    I'm attempting to find some direction on some table cleanup. The 3 primary tables that I'm interested in cleaning up ar ethe ProdCalcTrans, Prodroutetrans, jmgchangelog. I'm not finding much in the way of documentation that would pertain to these tables. Though not my biggest these 3 are in my top five tables encompassing approximately 40 gigs would of data. Are there some predefined tasks within AX that would clean these up already? Thanks for any assistance!


    Zach Henry
    IT Specialist
    Ag Growth International
    Grand Island NE

  • 2.  RE: Table Cleanup

    Posted Dec 18, 2018 03:22 AM
    Hopefully Ax 2012 is similar enough to AX 2009. to have its Production order clean-up routine (Production > Periodic > Production Order Cleanup). This deletes production orders which also clears up ProdCalcTrans. I think ProdRouteTrans might be core information (like InventTrans, CustTrans, and VendTrans). I cannot find much info on other table.

    Nik Lawrence
    ERP Co-ordinator
    Hill and Smith Limited

If you've found this thread useful, dive deeper into User Group community content by role