Hi all,
Customer told us to update location in Inventory management > Inqueiries > Onhand form. I mean InventDim.WMSLocationId. I saw Every line has IneventDimId.
Kindly let me know how can i proceed?
If i update the location ( wmsLocationId )? it will impact anywhere in application?
Please give me more shed on this.
thanks!
No, updating InventDim isn't possible, if your customer cares about their data at least a little bit. As Ergün said, you need to transfer the goods from one location to another. It's possible in code, but you need to understand what process you want to perform (e.g. creating and posting a transfer journal) before you can automate it. Therefore your next step shouldn't be writing code - you need to go back to analysis and define the business process to follow.
Hi ergun,
I have almost more than 1000 records.
as you mentioned
Where are you going to update? InventDim record? Then all the records you use this inventDim for won't be corrupted?
yes InventDim
So, not possible through code??
kindly elaborate
You need to transfer the stock. I'm sure even in the company you work for, there are people who can guide you better than me, so I won't go into details. But I am clear about not tampering the stock records, via code. (unless there is an obvious and unfixable problem)
In fact, with a little thought, you can realize that this process is not possible with code.
InventTrans or InventSum? So what about other trasactions associated with these trasactions? What will happen to the records that cause these movements (orders/journals etc.)
Then how we can fix that without code ?
You cannot do this with code.
I am not an expert on the functional side of the business. Expert friends can answer, but stock transfer can be provided with journals such as Count journals or transfer journals.
Don't try to do this by updating the field with the code, if the stocks get mixed up, you won't be able to fix it without recounting.
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 Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 764 User Group Leader
Martin Dráb 619 Most Valuable Professional
André Arnaud de Cal... 603 Super User 2025 Season 2