AX 2012 R3 - using WMS - location is a required field. Operator intended to process WMS work to move inventory from location X to location Y.
After reviewing inventory records, the product currently resides in a blank location.
Any thoughts on how to get that inventory balance from blank to a legitimate location? Movement journal and quantity adjustments fail as Location is a required field.
Thanks,
*This post is locked for comments
Hi Mike,
It requires some unsupported manual handlings. There are two options which should be evaluated and tested carefully.
I do hope the Financial inventory option is not enabled on location level.
Option 1: Make a change in the database directly to allow blank values on location level. Perform the posting and revert the settings to again not allow blank values.
Option 2: Also a change via database backend. Change the InventDim value on the transactions, so it would have the same site, warehouse etc, but the correct location. Don't change the values on the InventDim record itself as it then will break everything. You have to find or create the correct InventDimId to be used on transactions. The also run the consistency check for Inventory with the option to repair enabled. This will then rebuild the InventSum table.
Note that both options might require AOS restart after changing records via the SQL server.
Please test carefully and validate future postings on the same item.
Location is mandatory - nothing was changed. It is not clear how the transaction was processed via WMS and allowed to land in a "blank" inventory location.
This is an isolated incident - and I need to determine how to correct this by adding a location to this particular inventory record.
Thanks.
Hi Mike,
Can you tell how it was possible to get the items on a blank location? Is this from the history where you now want to change it to be used mandatory or was it caused by some software bug?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (