Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

AX2009 InventDim table Cleanup

Posted on by 3,252

Our client needs to clean up / delete unwanted records from this table. what is the best way to accomplish this. what is the impact if we delete these records.

*This post is locked for comments

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: AX2009 InventDim table Cleanup

    Hi GeorgeK,

    This table contains the various dimension combinations. If you want to delete not used records, it has almost no use. What would be the gain of it?

    You can try to see if the combinations are used in the Inventory transactions. Also the 'all blank' should remain.

    I think there are relatively little records which seems to be obsolete.

    When not linked to an inventory transaction there is a little chance that  it is used at other places, like a sales order of type 'Journal'.

    So I would not recommended to delete records from this table.

    I you do delete records and it was used, AX does not know e.g. which Warehouse or other inventory dimensions are applicable.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans