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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Sync Item Tracking Lin...
Small and medium business | Business Central, N...
Suggested answer

Sync Item Tracking Line with warehouse Receipt Line

(0) ShareShare
ReportReport
Posted on by jyoon0619 50

Hi I have added new lines to warehouse receipt line using code and realize Item tracking line does not match with warehouse receipt line. 

For example,

pastedimage1613361553543v1.png

Im using WhseRecLine for Warehouse reciept line record and reserveEnt for reservation entry record.

WhseRecLine."Source Document" := whseRecLine."Source Document"::"Purchase Order";
WhseRecLine."Source No." := JpnTranDet.THOPONO;
WhseRecLine."Item No." := JpnTranDet.Item;
WhseRecLine."Description" := purchLine."Description";
WhseRecLine."Bin Code" := WhseRecHead."Bin Code";
WhseRecLine."Invoice No." := JpnTranDet."TGINV1 & TGINV2";
Evaluate(whseQty, JpnTranDet.THQTY);
WhseRecLine.Quantity := whseQty;
WhseRecLine."Qty. to Receive" := whseQty;
WhseRecLine."Due Date" := purchHeader."Document Date";
WhseRecLine."Unit of Measure Code" := purchline."Unit of Measure Code";
whseRecLine."No." := WhseRecHead."No.";
//whseRecLine."Qty. (Base)" := PurchLine."Qty. to Receive (Base)";
WhseRecLine."Qty. (Base)" := PurchLine."Quantity (Base)";
WhseRecLine."Qty. Outstanding" := PurchLine."Quantity (Base)";

lastEntNo := reserveEnt.GetLastEntryNo();
reserveEnt.Validate("Entry No.", lastEntNo + 1);
reserveEnt.Validate("Creation Date", WorkDate());
reserveEnt.VALIDATE(Positive, true);
reserveEnt.Validate("Item No.", JpnTranDet."Item");
reserveEnt.Validate("Location Code", WhseRecLine."Location Code");
reserveEnt.Validate("Quantity (Base)", whseQty);
reserveEnt.Validate("Reservation Status", 2);
reserveEnt.Validate("Description", purchLine.Description);
reserveEnt.VALIDATE("Source ID", purchLine."Document No.");
reserveEnt.Validate("Source Ref. No.", purchLine."Line No.");
reserveEnt.Validate("Source Type", 39);
reserveEnt.Validate("Source Subtype", 1);
reserveEnt.Validate(Quantity, whseQty);
reserveEnt.Validate("Qty. to Handle (Base)", whseQty);
reserveEnt.Validate("Qty. to Invoice (Base)", whseQty);
reserveEnt.Validate("Created By", UserId);
reserveEnt.Validate("Item Tracking", 1);
reserveEnt.Validate("Lot No.", 'LOT');
reserveEnt.Validate("Carton No.", JpnTranDet.THCANO);

reserveEnt.Insert(true);
please help thank you
I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Sync Item Tracking Line with warehouse Receipt Line

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist.  If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

    Thanks.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans