Dynamics Community Forum Thread Details

Change Storage Dimension Group on Products\Items

I am needing to change the storage dimension group on our items. A live environment with transactions. The number of items would be 50,000+ that need changed.

Everything I am reading says it has to be done using the following steps...

Count inventory down to zero. You will need to temporarily remove any existing reservations, registrations, etc.
Perform an Inventory close (Inventory management > Periodic > Closing and adjustment)
After performing the inventory close, you can change the storage dimension group at the Released item level.
Note that you will not be able to make this change unless the current session date is after the date of Inventory closing.

Currently our "finished goods" are marked with Site, Warehouse, and Location as Active. With only Site marked on both Physical Inventory as well as Financial Inventory.

I would like to create a new Storage Dimension Group with a new name. Have it marked with Site, Warehouse, and Location as Active. With Site, Warehouse, and Location marked for Physical Inventory and still just Site marked for Financial Inventory.

I have tested multiple times creating this new storage dimension and then via code doing the following...

EcoResStorageDimensionGroupItem storageItem;
EcoResStorageDimensionGroupProduct storageProduct;

update_recordSet storageItem setting StorageDimensionGroup = 5637149078 where storageItem.StorageDimensionGroup == 5637146082;

update_recordSet storageProduct setting StorageDimensionGroup = 5637149078 where storageProduct.StorageDimensionGroup == 5637146082;

There have been no issues in all the testing after this has been done in a test copy of AX 2012 R2

I am thinking there have been no issues seen because we don't take financials past Site level as well as Warehouse and Location were already Active. We just now want to mark both at Physical Inventory.

Am I way off track and risking corrupt data? Or can I do a mass update to the Storage Dimension Group on our finished goods as above?

Thanks,

David

Quick Links