Reservations Entry Table Import Template

te6
te6 Member Posts: 89
edited 2009-06-01 in NAV/Navision Classic Client
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,

Answers

  • ara3n
    ara3n Member Posts: 9,258
    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
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • te6
    te6 Member Posts: 89
    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
    te6 Member Posts: 89
    hi Rashed,

    Thanks for the Reply..

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

Categories