Transfer Orders, planning worksheet, carry out action message creates on Transfer Order per item

Transfer Orders, planning worksheet, carry out action message creates on Transfer Order per item

This question is answered

In Microsoft Dynamics NAV 2009 R2, Verison US Dynamics NAV 6.01 SP1 (6.00.33046)

When you create transfer orders by running the Carry Out Action Message function in the Requisition Worksheet dialog box, transfer orders are created that have only one line. That means, a transfer order is created for each item that is listed as a transfer to the same location. However, only one transfer order that has multiple lines should be created.

Is there a setting that will result to a single transfer order?  Or, is this by design?

Verified Answer
  • Sure,

    In Codeunit:

    99000813 - Carry Out Action

    Function:

    InsertTransLine(ReqLine : Record "Requisition Line";VAR TransHeader : Record "Transfer Header")

    Add the following right to the beginning of the function:

    //EBS:NJF - Consolidate Documents per day

    TransLineRec.SETRANGE("Shipment Date",ReqLine."Transfer Shipment Date");

    TransLineRec.SETRANGE("Transfer-from Code",ReqLine."Transfer-from Code");

    TransLineRec.SETRANGE("Transfer-to Code",ReqLine."Location Code");

    IF TransLineRec.FINDSET(FALSE,FALSE) THEN

     TransHeader.GET(TransLineRec."Document No.");

    //EBS:NJF - Consolidate Documents per day

    No warranty on the code but shout if you have any questions and i would be happy to help,

    Cheers

    Nev

    Neville Foyn
    NAV Developer, Consultant & Trainer (Since 2001)
    MCTS NAV, CRM, Sharepoint, SQL
    MCITP NAV
    MCT 

All Replies
  • Hi

    This is by design, we found the same thing when creating transfers from full manufacturing, it required a customization to our clients system to have them consolidate by day,

    Cheers

    Nev

    Neville Foyn
    NAV Developer, Consultant & Trainer (Since 2001)
    MCTS NAV, CRM, Sharepoint, SQL
    MCITP NAV
    MCT 

  • Nev,

    Thanks for the reply.  Would you be willing to share your customization?    

  • Sure,

    In Codeunit:

    99000813 - Carry Out Action

    Function:

    InsertTransLine(ReqLine : Record "Requisition Line";VAR TransHeader : Record "Transfer Header")

    Add the following right to the beginning of the function:

    //EBS:NJF - Consolidate Documents per day

    TransLineRec.SETRANGE("Shipment Date",ReqLine."Transfer Shipment Date");

    TransLineRec.SETRANGE("Transfer-from Code",ReqLine."Transfer-from Code");

    TransLineRec.SETRANGE("Transfer-to Code",ReqLine."Location Code");

    IF TransLineRec.FINDSET(FALSE,FALSE) THEN

     TransHeader.GET(TransLineRec."Document No.");

    //EBS:NJF - Consolidate Documents per day

    No warranty on the code but shout if you have any questions and i would be happy to help,

    Cheers

    Nev

    Neville Foyn
    NAV Developer, Consultant & Trainer (Since 2001)
    MCTS NAV, CRM, Sharepoint, SQL
    MCITP NAV
    MCT 

  • Thanks!

  • Happy to help, let me know if your guys run into any trouble implementing it

    Neville Foyn
    NAV Developer, Consultant & Trainer (Since 2001)
    MCTS NAV, CRM, Sharepoint, SQL
    MCITP NAV
    MCT