Question Status

Verified
John Bellinger asked a question on 5 Apr 2013 11:04 AM

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?

Reply
Suggested Answer
Neville Foyn responded on 7 Apr 2013 4:26 PM

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
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
John Bellinger responded on 7 Apr 2013 7:00 PM

Nev,

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

Reply
Verified Answer
Neville Foyn responded on 7 Apr 2013 8:04 PM

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
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
John Bellinger responded on 16 Apr 2013 4:57 AM

Thanks!

Reply
Neville Foyn responded on 21 Apr 2013 7:57 PM

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

Neville Foyn
NAV Developer, Consultant & Trainer
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
Verified Answer
Neville Foyn responded on 7 Apr 2013 8:04 PM

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
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
Suggested Answer
Neville Foyn responded on 7 Apr 2013 4:26 PM

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
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply