Items Dimension Change on AX

(0) Share

Report

Posted on by Islam Ayman Emam

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

I have the same question (0)

All responses (6)

Answers (0)

Sort by

André Arnaud de Cal... 304,193 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Islam Ayman Emam 45 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,193 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Islam Ayman Emam 45 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Yohann Rolland Axcible 3,111 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Islam Ayman Emam 45 on at

Like (0)

Report
Copy link

Link copied!

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 :(

Was this reply helpful? Yes No