Changing from serialized lot tracked inventory to just lot tracked inventory

  • Changing from serialized lot tracked inventory to just lot tracked inventory

    Posted by Ronald L McVicar Jr on April 12, 2019 at 11:29 am
    • Ronald McVicar

      Member

      April 12, 2019 at 11:29 AM

      Has anyone changed from serialized lot tracked inventory to just lot tracked inventory?

      This would seem to remove some heavy lifting for NAV and especially at the item ledger entry table level?

      I know this is not going to be a magic wand activity.

      ——————————
      Ronald McVicar, IT Software Mgr
      NSP (Quality Meats)
      nspproteins.com
      ——————————

    • Lewis Rosenberg

      Member

      April 12, 2019 at 12:18 PM

      ?I’m not sure about turning serial control on or off, but I assume the same issue (that exists for lot control) exists that NAV will not premit a change once there are iten ledger entries for the item.

      We have turned lot control on many times for items with item ledger entries.Ā  The process is basically:

      (1) Remove all inventory for the item (this can get messy if the item is on any shipment picks – they have to be cleared too – really just the bin code).
      (2) Run our magic reportĀ  to turn on lot control (see below)
      (3) Add all inventory back (and add back to any picks that the item was removed from).

      The “magic” report has a check box on the request page and also a filter field to enter the item number(s).Ā  Check the box if turnig lot control on and uncheck if turning lot control off.Ā Ā  The report reads the item card and its logic is below.

      Item – OnAfterGetRecord()
      //SetLot := FALSE; //Will be set from Request Form in the future

      IF SetLot THEN BEGIN
      Ā  Item.”Item Tracking Code” :=’LOTALL’;
      Ā  Item.”Lot Nos.” := ‘LOT’;
      Ā  Item.MODIFY;
      END
      ELSE BEGIN
      Ā  Item.”Item Tracking Code” :=”;
      Ā  Item.”Lot Nos.” := ”;
      Ā  Item.MODIFY;
      END;

      You may be able to alter the report to handle serial tracking.

      ——————————
      Lewis Rosenberg
      IT Manager
      Mars Fishcare
      Chalfont PA
      ————————————————————————
      BCUG/NAVUG All-Star
      BCUG/NAVUG Board of Advisors, Chairperson
      BCUG/NAVUG Programming Committee

      Twitter: @RosenbergL
      LinkedIn: https://www.linkedin.com/in/rosenbergl
      ————————————————————————

      NAVUG/BCUG Summit (navugsummit.com)
      Orlando, FL – October 15-18, 2019
      Call for proposals: https://www.surveymonkey.com/r/UGSummitNA2019
      ——————————
      ——————————————-

    • Ronald McVicar

      Member

      April 12, 2019 at 12:40 PM

      Lewis,
      As usual thank you for your contribution and value.

      Sincerely

      ——————————
      Ronald McVicar, IT Software Mgr
      NSP (Quality Meats)
      nspproteins.com
      ——————————
      ——————————————-

    • David Wiser

      Member

      April 12, 2019 at 2:02 PM

      One way to reduce the heavy lifting within the Item Ledger Entry table is to reduce when you are capturing serial numbers.Ā  I worked with one company who didn’t need to track serial numbers when receiving or through their internal processes, but they did want to capture them on sales transaction.Ā  For this, they set up serial number tracking but only clicked the boxes for outbound and inbound “Sales” transactions.Ā  This way they could capture the serial numbers sent to customers, but make other transaction easier to use.

      Not necessarily a direct answer to your question, but an alternative for others looking at serialization.

      ——————————
      David Wiser
      Project Manager/Solution Architect
      Beck Consulting
      Seattle WA
      ——————————
      ——————————————-

    Ronald L McVicar Jr replied 7 years ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Changing from serialized lot tracked inventory to just lot tracked inventory’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!