Associating serial numbers on item journal

NaveenReddyNaveenReddy Member Posts: 53
Hi Guys,
I am trying to create the item jornal from the data capture table it contains item no. , Serial no and quantity. So the serial number should go into item tracking lines form(I researched on this and found when we enter the serial on this form it will not save in the table or i couldn't found where it is saved). Now i am stuck on where to insert this serial numbers from the data capture table in order to create the item journal for serialized items.
And i have to create the item journal for 2000 items, which is not easy to manually enter the serial numbers.

Thanks

Comments

  • kinekine Member Posts: 12,562
    Base table for this is Reservation Entry (337) table.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • fbfb Member Posts: 246
    If you strip away all the cruft, the Item Tracking Lines form uses two procedures in Codeunit 99000830 to create the proper T337 entries.

    I've re-used them in various places as follows:
    // now that the ItemJnlLine is setup, create the item tracking entries...
    CreateReservEntry.CreateReservEntryFor(
      DATABASE::"Item Journal Line",
      "Entry Type",
      "Journal Template Name",
      "Journal Batch Name",
      0,
      "Line No.",
      "Qty. per Unit of Measure",
      myQuantity,
      mySerialNo,
      myLotNo);
    
    CreateReservEntry.CreateEntry(
      "Item No.",
      "Variant Code",
      "Location Code",
      Description,
      0D,
      "Posting Date",
      0,
      3);
    
  • mrQQmrQQ Member Posts: 239
    well this is wrong. first of all, for transfers you need two reservation entries.. then F6510 seems to do much more than just creating reservation entries (not sure though). i find it so annoying that m$ wouldnt provide us with a flexible way of creating tracking lines automatic!

    besides, this new tracking functionality.. omg, why on earth did they have to make it SO complicated!
Sign In or Register to comment.