Business Central forum

How to assign lot/serial number to Sales Order Line by program

(0) Share

Report

Posted on by Community Member

Hi Experts!

We're working on an Extension for 365BC.

We have some items with Tracking.

Could you please guide me how to assign lot/serial number to Sales Order Line by program?

And make sure it can be post to create a Posted Sales Shipments successfully.

Does 365 have some codeUnit help us to do that?

Thanks

Billy

Categories:

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Amit 2,559 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Refer the below code-:

ReservationEntry.INIT;

ReservationEntry."Entry No." := ReservationEntryNo;

ReservationEntry.Positive := False;

ReservationEntry."Item No." := SalesLine."No.";

ReservationEntry.INSERT(True);

ReservationEntry."Location Code" := "Location Code";

ReservationEntry."Reservation Status" := ReservationEntry."Reservation Status"::Surplus;

ReservationEntry.Description := SalesLine.Description;

ReservationEntry."Creation Date" := "Posting Date";

ReservationEntry."Source Type" := 37;

ReservationEntry."Source Batch Name" := '';

ReservationEntry."Source ID" := "No.";

ReservationEntry."Source Subtype" := 1;

ReservationEntry."Source Ref. No." := SalesLine."Line No.";

ReservationEntry."Expected Receipt Date" := "Posting Date";

ReservationEntry."Lot No." := BatchNo;

ReservationEntry.VALIDATE("Quantity (Base)", -1);

ReservationEntry."Qty. per Unit of Measure" := 1;

ReservationEntry."Warranty Date" := ManfDate;

ReservationEntry."Expiration Date" := ExpDate;

ReservationEntry."Item Tracking" := ReservationEntry."Item Tracking"::"Lot No.";

ReservationEntry.Modify(True);

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Dhirenders 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Umar,

I'm stuck on same; did you find any solution?

Thanks

Was this reply helpful? Yes No
Hot Potato 25 on at

Like (0)

Report
Copy link

Link copied!

What about if you want to split the sales line with lot number quantity into the next line if the quantity is greater than a particular number? Let's say, you have 1000 cases for item no. 1 and you are comparing it to a number 500, which is the number of cases per pallet - with this, the report should create one line for 500 and another line for the other 500 but with the same lot number from reservation entry?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report
Copy link

Link copied!

@KC Lai you can see the second reply on the post by Suresh Kulla. It has solution.

Was this reply helpful? Yes No
KC Lai 335 on at

Like (0)

Report
Copy link

Link copied!

Hi PHT80,

We are having similar request from client to assign serial number to SO line.

wonder you have solution?

Was this reply helpful? Yes No
Umar Farooq Raja 15 on at

Like (0)

Report
Copy link

Link copied!

Hi PHT80!!!

I am having same problem, I am using the code above, but when I go to the Item Tracking Lines window, the "Lot No." field is empty.

Will you please share your findings with me , so I can resolve my problem.

Thanks

Was this reply helpful? Yes No
PHT80 40 on at

Like (0)

Report
Copy link

Link copied!

I solved the problem. There were erroneous data in the "Reservation Entry" table. I cleaned this data and now it works OK.

Thank you !!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Where your lotNo field value come from? did you pass lotNo field value?

Was this reply helpful? Yes No
PHT80 40 on at

Like (0)

Report
Copy link

Link copied!

Hi MIng0515,

I am not using web service, I am importing from a text file.

This is the code I am using:

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Maybe you need provide some screen shots or code sample. Did you use web service to create lot&serial?

Was this reply helpful? Yes No