Microsoft Dynamics NAV (Archived)

How to create Item Tracking line for Sales Order and Transfer order through CAL Code???

(0) Share

Report

Posted on by Community Member

Hi all,

Can you share me how I can create Item Tracking Lines automatically in Sales order with C/AL code?

one simple example is appreciated.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Rashed 3,765 on at

Like (0)

Report
Copy link

Link copied!

Here is an example

forum.mibuso.com/.../259094

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

was able to find the how to create Item Tracking lines in Sales Order automatically

I have checked CDU 99000830 and found two Function.
CreateReserveentryfor.
CreateReserveentry.

Here is the code that i have added and reservation entry is getting created for the same.

CreateReservEntry.CreateReservEntryFor(DATABASE::"Sales Line",
LT37."Document Type",
LT37."Document No.",
'',
0,
LT37."Line No.",
LT37."Qty. per Unit of Measure",
ABS(LT37.Quantity),
ABS(LT37."Quantity (Base)"),
InventorybyLocAndSerial."Serial No." ,
InventorybyLocAndSerial."Lot No.");

CreateReservEntry.CreateEntry(
LT37."No.",
'',
LT37."Location Code",
LT37.Description,
0D,
LT37."Shipment Date",
0,
3);

But Am not able to find any line in Item Tracking lines when i check IN Sales Line --->Line--->Item Tracking lines. it is seems to be empty. Please refer the attachment Picture(Item Tracking Line).

But when i check Reservation entry Table(337). I found a record has been created for that particular line with Source ID = Sales order no.

I dint understand why it is not coming in item Tracking line.

Could any one help me , where the actual mistake , i have done.

Looking for your valuable advice

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (2)

Report
Copy link

Link copied!

Insert the serial no manually through UI. And then compare the record in reservation entry table and see which field is not being populated correctly.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sir,

One small clarification,

Do the reservation status , plays important role as far as item tracking line is concerned.

Why because ,i have passed reservation status = 3(Prospect).

Was this reply helpful? Yes No
Verified answer

Rashed 3,765 on at

Like (2)

Report
Copy link

Link copied!

The status needs to be prospect. Please run the reservation entry and compare the record inserted through code with the one inserted manually and see which field is not populated correctly.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sir, I have found my mistake.

i have not passed the parameter variant code in the cdu.

Thank you very much for your input.

One more issue.

is this same Item Tracking line creation done for sales order is applicable in case of Transfer order?

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (0)

Report
Copy link

Link copied!

Yes it can be used for all document lines and item journal

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for your valuable guidance Sir.

Was this reply helpful? Yes No