Announcements
No record found.
Hi all,
How to update/create Storage dimension group if empty. i all ready working this issue but storage dimension group already is there i will do that update "EcoResStorageDimensionGroupItem" -> StorageDemensionGroup(mapping) into "EcoResStorageDimensionGroup"-> RecId.
But now I try to empty value in storage dimension group -> itemid not in their "EcoResStorageDimensionGroupItem" table.
Please help anyone how to update the value in storage dimension group if empty.
*This post is locked for comments
what is your business requirement; lets forget about code for a moment
I noticed that some of the released products in company IN01 does not have a specified storage dimension group. Can you please run a script in production that will make the Storage dimension group BinLoc if found empty in company IN01?
Yes we can run a script BUT only try for items, which have not been used so far. If an item has been used, analyze the impacts of doing so.
Does standard AX allows you to change the storage dimension of an item that has transactions? If answer is no; please reach to Microsoft support, before running such a dangerous script on production. For unused items it should be safe to do so.
Hi Sohaib,
My question :
I had already updated this issue. but I want update empty field. if storage group dimension already exists means this item will show in "EcoResStorageDimensionGroupItem" table. but now not exist if it is empty. how to move next step.
my question is simple.
Do you item have transactions..?
No.
you can delete records for such items from EcoResStorageDimensionGroupItem and then can reassign dimension groups to product. Please make sure to have database backup.
Also note that standard ax do not allows to change storage dimension group for an item, if the dimension group has been set on product level. as each item has product, so unless you remove dimension group from product, the user interface would not allow you to update dimension group for item, from front-end. i have done such job in past, by deleting records from table EcoResStorageDimensionGroupProduct and EcoResStorageDimensionGroupItem, for Unused items.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader