Open Forum

Expand all | Collapse all

Changing from serialized lot tracked inventory to just lot tracked inventory

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

    GOLD CONTRIBUTOR
    Posted Apr 12, 2019 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
    ------------------------------


  • 2.  RE: Changing from serialized lot tracked inventory to just lot tracked inventory

    TOP CONTRIBUTOR
    Posted Apr 12, 2019 12:18 PM
    Edited by Lewis Rosenberg Apr 12, 2019 01:48 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
    ------------------------------



  • 3.  RE: Changing from serialized lot tracked inventory to just lot tracked inventory

    GOLD CONTRIBUTOR
    Posted Apr 12, 2019 12:40 PM
    Lewis,
    As usual thank you for your contribution and value.

    Sincerely

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



  • 4.  RE: Changing from serialized lot tracked inventory to just lot tracked inventory

    TOP CONTRIBUTOR
    Posted Apr 12, 2019 02: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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role