When working with transfer orders in AX 2012 R3, I could see some inventDims are created with wrong warehouses and it is not connected with any inventory transaction.
Site Warehoue
S1 W1
S2 W2
T1 TW1 (transit)
Transfer order created From warehouse W2 to warehouse W1.
Once the order completes, I could see the below inventory transaction and with the inventdim combinations as
S2 W2 Shipped
T1 TW1 transit
T1 TW1 transit
S1 W 1 Received
But also, I could see some inventDims which are hanging alone without any inventory transactions and it looks like
S2 W1
S2 TW1
Any suggestions would be helpful :)
*This post is locked for comments
The issue with the incorrect inventory dimensions is a standard behaviour and it seems unavoidable.
By default, transfer order line will have the inventory dimension (From site and warehouse). Issue happens when the transfer order line gets inserted and system tries to create an inventory dimension combination for To warehouse from the transfer order line invent dim and by passing the To warehouse into the combination as (Site (From warehouse) and location (To warehouse)and tries to find any combination exists and if not found, then system creates the combination as Site (From warehouse) and location (To warehouse).
And then, inventory site is picked from location (To warehouse) master and then the required inventory dimension combination is created.
new dimension combination is created when setting up wmsLocationId in
HI sukrut
Inventory transaction for the transfer order is created well with four transaction as you mentioned but the inventory dimension is created with additional records which arent used anywhere at all.
/Uday.
No and this happen when the system does the insert into the InvetTransferLine table, I tried debugging a lot of times and seems system is doing well but couldn't get this mismatched combination is a system behaviour or we have something wrong with the setup or something else.
Were any items returned?
I never saw such a invent dims . Usually four transactions created , two for transit , one at receiving end and one for shipping end. Please check if you have any customizations in place
Has anyone noticed such a inventory dimensions being created and I don't think it is a bug and couldn't able to understand or figure out the reason behind those combinations creations. Im just wondering, it just left alone without any transaction reference and those inventDims stays in the table, if the cleanup jobs doesn't running after all.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156