Create ItemJnlLine with LotNo and Post via Codeunit

jordi79

Hi,

I am trying to create an ItemJnlLine with ItemTrackingSpecification and Post. All this is done via Codeunit.

What I have coded is below:

ItemJnlLine.INIT;
ItemJnlLine.VALIDATE("Posting Date", TODAY);
ItemJnlLine.VALIDATE("Document No.", 'QWERTY1111');
ItemJnlLine.VALIDATE(ItemJnlLine."Entry Type", ItemJnlLine."Entry Type"::"Negative Adjmt.");
ItemJnlLine.VALIDATE("Item No.", 'LOTITEM');
ItemJnlLine.VALIDATE("Location Code", 'DEFAULT');
ItemJnlLine.VALIDATE(Quantity, 1);

TempJnlLineDim.RESET;
TempJnlLineDim.DELETEALL;

TempTrackingSpec.RESET;
TempTrackingSpec.DELETEALL;
// not sure how to specify TempTrackingSpec and pass to ItemJnlPostLine codeunit for posting!!!

ItemJnlPostLine.RunWithCheck(ItemJnlLine, TempJnlLineDim);

Item LOTITEM, is a LotSpecific Tracking Item. I have no idea how to pass Tracking Specification table into ItemJnlPostLine. I know that if I were to insert
"actual" TempTrackingSpecification records, I am able to post. But this of course is not the way to go. I was hoping of somehow to pass TrackingSpec records into ItemJnlPostLine, like how TempJnlLineDim is passed to ItemJnlPostLine Codeunit.

Jordan

ara3n

You need to create reservation entry. NAV in CU 22 grabs them and creates tracking lines.

Here is code on how to create the reservation entry.
CreateReservEntry = CU 99000830 Create Reserv. Entry

CreateReservEntry.SetDates(
  0D, 0D);

CreateReservEntry.CreateReservEntryFor(
  DATABASE::"Item Journal Line",
  ItemJnlLine."Entry Type",
  ItemJnlLine."Journal Template Name",
  ItemJnlLine."Journal Batch Name",
  0,
  ItemJnlLine."Line No.",
  ItemJnlLine."Qty. per Unit of Measure",
  1,
  SerialNo,
  '');

CreateReservEntry.CreateEntry(
  ItemJnlLine."Item No.",
  ItemJnlLine."Variant Code",
  ItemJnlLine."Location Code",
  ItemJnlLine.Description,
  ItemJnlLine."Posting Date",
  ItemJnlLine."Document Date",
  0,
  2);

jordi79

Hi,

Thanks. It is working now.

Jordan

ara3n

You are welcome.