Add Item tracking on Item with ledger entry

EtienneRoy

Hi

can you tell me what is the best ways to add a Item Tracking Code to some items with already have ledger entry ?
but it affect several thousand item so is not possible to recreate all item

Regard,

EtienneRoy

Anybody have some recommendations about that ?

ssingla

IF NOT ItemTrackingCode.GET(Rec."Item Tracking Code") THEN
  CLEAR(ItemTrackingCode);

IF NOT ItemTrackingCode2.GET(xRec."Item Tracking Code") THEN
  CLEAR(ItemTrackingCode2);

IF (ItemTrackingCode."SN Specific Tracking" <> ItemTrackingCode2."SN Specific Tracking") OR
   (ItemTrackingCode."Lot Specific Tracking" <> ItemTrackingCode2."Lot Specific Tracking")
THEN
  TestNoEntriesExist(FIELDCAPTION("Item Tracking Code"));

The abovementioned code clearly requires that there should be no Item Ledger entries for the item. The only way (not recommended)is to block the code and change the values and then unblock the code.

KYDutchie

Hi,

Please do not disable the code that checks for Item Ledger Entries until you know all the files/records that need to be changed. You will get into some serious problems if you do.

Trust me it is best to create new items. For example, do you have inventory on these items, if so you will need to create lot no's and serial no's for these items. If you are switching to serial controlled items, then you can have a max qty of 1 per serial number. Do you have these items on Sales Orders? Then you will to create item tracking lines for these items.

It is way easier to just create the new item, post a negative adjustment for the available qty of the old item and create a positive adjustment for the new item. This available quantity consists of the Qty on hand - Qty on any outbound order - Quantity on consumption journal lines. For the positive adjustment you will have to create item tracking lines specifying the lot and lot size or the serial number.

This might seem to be a lot of work, but in the long run, it will be a lot less work.

Regards,

Willy

bob_up

Have you resolved this now and, if so, how ?

Bob