Transfer order in AX 2012 R3

(0) Share

Report

Posted on by udaY-ch

5,175

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

I have the same question (0)

All responses (7)

Answers (0)

Sort by

udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

Were any items returned?

Was this reply helpful? Yes No
udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

new dimension combination is created when setting up wmsLocationId in

Was this reply helpful? Yes No
udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No