Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Transfer order in AX 2012 R3

Posted on by 4,624

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

  • udaY-ch Profile Picture
    udaY-ch 4,624 on at
    RE: Transfer order in AX 2012 R3

    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.

  • udaY-ch Profile Picture
    udaY-ch 4,624 on at
    RE: Transfer order in AX 2012 R3

    new dimension combination is created when setting up wmsLocationId in

    WMSLocationId.png

  • udaY-ch Profile Picture
    udaY-ch 4,624 on at
    RE: Transfer order in AX 2012 R3

    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.

  • udaY-ch Profile Picture
    udaY-ch 4,624 on at
    RE: Transfer order in AX 2012 R3

    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.

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Transfer order in AX 2012 R3

    Were any items returned?

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: Transfer order in AX 2012 R3

    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

  • udaY-ch Profile Picture
    udaY-ch 4,624 on at
    RE: Transfer order in AX 2012 R3

    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.

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans