Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

AX2009 InventDim table Cleanup

(0) ShareShare
ReportReport
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,391 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans