Hi. I want to change storage dimension group for products that have transaction. how can i do it?
Regards
*This post is locked for comments
Hi,
Honestly I wouldn't try and 'unravel' the logic AX has implemented (especially if this is a production/live system that you are referring too).
If it isn't a production system then make sure you don't make the same mistake in live :)
I would suggest creating a new Item and setting a restriction on the old item (This can be done through the default order settings Product information > Manage inventory > Default order settings > Stopped).
No its not recommended even if you do it some how you will fall into data integrity issue.
may you can try with data analysis
identifying which all data are affected and how to update them related to new inventory dim id
doing this will take lots of effort depending on how much data you have.
so once you identify the data, then may be you can write a job to re generate the inventory dim Id
Please verify and update if this solution is workable for you.
Dear Patrick
Hi. my product have transaction in inventory and sales order and i want change storage dimension group of this product. i know first, i have to delete all transaction associated with this product but i didn't know how can i delete transaction? Any solution?
Hi. we delete transaction of a product. the product have a movement journal and we delete it. but now we could not delete product to recreate and assign correct Storage Dimension Group.What can i do?
Essentially you cannot change the storage group.
See the msdn page: technet.microsoft.com/.../aa549043.aspx
If a product has transactions, the storage dimension group and the tracking dimension group cannot be changed. However, if the product is not used in any transactions, the following rules apply:
For a shared product, the storage dimension group and the tracking dimension group can be changed if the product has not been released.
For a released product, you must follow these steps to change the storage dimension group and the tracking dimension group:
1. Delete the setup of the storage dimension group and the tracking dimension group for the shared instance of the product.
2.Delete the setup of the storage dimension group and the tracking dimension group for the released instance or instances of the product.
3. Select a new storage dimension group and a new tracking dimension group for the shared instance of the product.
The new storage dimension group and the new tracking dimension group are replicated in the released instance or instances of the product.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
Guy Terry 2 Moderator
Martin Dráb 2 Most Valuable Professional
