D365 Finance & Operations and Dynamics AX Forum

Cleaning large number of inventory transactions

  • 1.  Cleaning large number of inventory transactions

    Posted May 25, 2020 02:01 AM
    It is coming to our attention that INVENTTRANS table is becoming our largest table in system (after BomCalcTrans) and that maybe it might be good idea to see if we can somehow clean it. We are on AX 2012 R3 CU10 and heavily use WMS. Current table is over 50 million records big and data and indexes take over 40 GB of space each (total over 80GB)

    Has someone gone over this route of cleaning it? Maybe part of WMS transactions? Is there a reason for us to worry about its size?

    Vjekoslav Levacic
    XAL Holding GmbH
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready

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