web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Ship transfer order with different warehouses in lines

(0) ShareShare
ReportReport
Posted on by 1,087

Hi,

in ax 4.0 was possible to have warehouse A in header and warehouse (say) A and B in corresponding lines.

If i try doing the same on 2012 i get this error when trying to ship:

Line number: -1,00

A quantity cannot be picked.

Insufficient inventory transactions with status On order, Reserved ordered, Reserved physical and Picked.

How can i fix this issue?

Is there a workaround?

thank you in advance

*This post is locked for comments

I have the same question (0)
  • dolee Profile Picture
    11,279 on at
    RE: Ship transfer order with different warehouses in lines

    Hmm, I think AX2012 does support shipping order lines to different addresses. You might want to take a closer look to see what is triggering the error message.

  • vv1984 Profile Picture
    1,087 on at
    RE: Ship transfer order with different warehouses in lines

    Thank you for your reply. I've notice that if the "explode lines" option is flagged, i do not get any error and the trasnfer order gets posted properly.

    In the InventTransferUpd class, createInventTransferJourLine method there's a if condition on this parameter:

    if (inventTransferParmTable.ExplodeLines)

       {

           select forceplaceholders TableId from inventTransOrigin

               where inventTransOrigin.InventTransId     == _inventTransferParmLine.InventTransId

                  && inventTransOrigin.ReferenceCategory == inventTransType

               join sum(Qty) from inventTrans

                   group by InventDimId

                   where inventTrans.InventTransOrigin == inventTransOrigin.RecId

                      && inventTrans.StatusIssue       <= statusIssue

                      && inventTrans.StatusReceipt     <= statusReceipt

                      && inventTrans.Voucher           == voucherId

                      && inventTrans.DateFinancial     == inventTransferParmTable.TransDate

           #inventDimExistsJoin(inventTrans.InventDimId,inventDim,_inventDimCriteria,_inventDimParm);

       }

       else

       {

           select TableId from inventTransOrigin

               where inventTransOrigin.InventTransId     == _inventTransferParmLine.InventTransId

                  && inventTransOrigin.ReferenceCategory == inventTransType

               join sum(Qty) from inventTrans

                   group by InventDimId

                   where inventTrans.InventTransOrigin == inventTransOrigin.RecId

                      && inventTrans.StatusIssue       <= statusIssue

                      && inventTrans.StatusReceipt     <= statusReceipt

                      && inventTrans.Voucher           == voucherId

                      && inventTrans.DateFinancial     == inventTransferParmTable.TransDate;

       }

    So i've tried to comment the  #inventDimExistsJoin macro in InventUpd_Physical class,

    updatePhysicalIssue method (line 52,right before the while statement):

           select forupdate inventTrans

           order by StatusIssue,InventDimId

               where inventTrans.InventTransOrigin == movement.inventTransOriginId()

                  && inventTrans.StatusReceipt     == StatusReceipt::None

                  && inventTrans.StatusIssue       >= caseStatusIssueFrom

                  && inventTrans.StatusIssue       <= caseStatusIssueTo

                  && inventTrans.TransChildType    == movement.transChildType()

                  && inventTrans.TransChildRefId   == movement.transChildRefId();

               //#InventDimExistsJoin(InventTrans.inventDimId,inventDimJoin,inventDimCriteria,inventDimParmCriteria);

    It worked like a charm, but i now need to check for the explodelines parameter here and write an if condition like the one i've found in the InventTransferUpd  class.

    Any idea? I cannot find it anywhere...

  • dolee Profile Picture
    11,279 on at
    RE: Ship transfer order with different warehouses in lines

    Hi there,

    Sorry I mis-read your question. I was thinking of PO/SO some way some how.

    So it's Transfer order...

    How do you change the warehouse of a transfer order line? I checked just now and it doesn't seem to allow it.

  • Weaveriski Profile Picture
    23,616 Moderator on at
    RE: Ship transfer order with different warehouses in lines

    In version 4.0 the warehouse was in the header of the transfer order and could not be edited at the line level as standard and this has carried on in version 2009 and 2012. Is this a customization or localization?

  • vv1984 Profile Picture
    1,087 on at
    RE: Ship transfer order with different warehouses in lines

    If you go to Inventory-->Reservation ( on the lower half of the Tr.Orders. form) you'll see you can have a different warehouse than the one in the transfer order header.

    This warehouse is the one you set in Released Products, Manage Inventory, Site Specific Order Settings.

  • Verified answer
    dolee Profile Picture
    11,279 on at
    RE: Ship transfer order with different warehouses in lines

    Hi,

    Thanks for the info. I tried what you said and with "Explode lines" checkbox checked it worked.

    That option was meant for something else when I checked the training document. However, that seems a valid work around ready made for your needs.

    Why would you still need to make changes to the InventUpd_Physical class?

    (As a side note, InventUpd_Physical has an effect on all types of physical updates [not limited to Transfer order]. I would recommend against making changes to it.)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans