Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Items Dimension Change...
Microsoft Dynamics AX (Archived)

Items Dimension Change on AX

(0) ShareShare
ReportReport
Posted on by Islam Ayman Emam 45

Hi,

I have a case where the storage dimension group was set wrong and needs to be changed (physical inventory checkbox was unmarked so on hand view is not consistent). Now I know to solve this, all I need to do is close all open transactions, count out the on hand and do the inventory closing.

The Customer said that this solution would not comply as he will have invoices open for the current period of the closing, and the next ones, and there is no way he will be able to post invoices or close production orders prior to their time. Is there a way to overcome this issue? Knowing that changing the Storage dimension group is a must.

*This post is locked for comments

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: Items Dimension Change on AX

    Hi Yohann,,

    Great Work. I read it thoroughly and admiring the way. Unfortunately I tested it and would not let me clear the storage dimension group. Here is the error.

    Looks like I am going to go for the hard option :(

    1563.Err.png

  • Yohann Rolland Axcible Profile Picture
    Yohann Rolland Axcible 3,111 on at
    RE: Items Dimension Change on AX

    Hi Islam,

    I've never tested this hard method in Ax 2012 and neither when there is a lot of transactions but I might give you some ideas.

    In my situation it helped me and was useful, it was just after go live and we had the same issue as you have. Check my post :

    http://d365tour.com/en/microsoft-dynamics-d365o/trade-logistics-d365fo-en/go-live-experience-items/

    But handle this with a lot of care it is not adviced and looks like the hard way. I wouldn't doing that myself before doing a lot of tests.

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: Items Dimension Change on AX

    Hi Andre,

    True, and that is what I am telling them. Anyways I have a meeting with them next week and they will have all options on the table. Let's see what they will decide.

    For me after testing I believe the best option for us and them is to do a period closing, post all open transactions and change the dimension. But it's their decision after all

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Items Dimension Change on AX

    Hi Islam,,

    Everything comes with a price... Indeed using new items, it would be nasty as there would be many open orders. They are claiming the "old" items then. How to deal with the period where you would have new and old item numbers for the same product... That would require some special procedures at the customer.

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: Items Dimension Change on AX

    Hi André,

    Thanks for your reply. I closed with them any possible changing from SQL or directly on the database. They know I am not going to even look at this solution.

    New items is on the table also, and the Finance team there would fancy this option than the dimension change through inventory closing and zero qty.

    However, if I am correct they would still need to close all open transactions for the current items if they want to have correct numbers when they create the new items. Business wise that is.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at
    RE: Items Dimension Change on AX

    Hi Islam,

    Another workaround which would probably not accepted is creating new items with the correct settings.

    The customer might look for a solution where the setting would be changed without validations (e.g. directly in the database). This might work depending on all settings and existing transactions if you review all scenarios carefully. Test it in a separate environment first. This is not recommended by Microsoft; also not by me. Let the customer be responsible for accepting the test.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans