Reservations Entry Table Import Template

te6

Hi all,

I have to upload the Item Inventory. Our client has aroud 4000 Items. And they all have Lot No.'s..

what I feel is , can I import Lot No details into reservation table for all those 4000 Items, without going and attaching them through the Journal..

can, I proceed with this . Am i doing the correct.

Please suggest me.

Can I get any template for this,

ara3n

Yes, you can use the following code to insert the lot

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,
  '',
  'Lot No Put it here!!!');

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

CreateReservEntry is CU 99000830

te6

Hi Rashed,

thanks for the reply.

I have one doubt. Normally, we insert from excel into Item Journal to Upload the Inventry and attach the Lot No.

we don't import Lot No. in Item Journal. while Importing from excel to Item Journal.

From your reply , what I understood is , I have to Insert the Lot No in Item Journal and Call the three Functions , to insert into Reservation Entry Table, \\

Am I correct Rashed. ....

If not please ,suggest me.

te6

hi Rashed,

Thanks for the Reply..

that helped me a lot. And Lots work has come down...