[Ronald McVicar]

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]

?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]

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

Sincerely

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

[David Wiser]

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
——————————
——————————————-