Add Item tracking on Item with ledger entry

EtienneRoyEtienneRoy Member Posts: 24

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



  • Options
    EtienneRoyEtienneRoy Member Posts: 24
    Anybody have some recommendations about that ?
  • Options
    ssinglassingla Member Posts: 2,973
    IF NOT ItemTrackingCode.GET(Rec."Item Tracking Code") THEN
    IF NOT ItemTrackingCode2.GET(xRec."Item Tracking Code") THEN
    IF (ItemTrackingCode."SN Specific Tracking" <> ItemTrackingCode2."SN Specific Tracking") OR
       (ItemTrackingCode."Lot Specific Tracking" <> ItemTrackingCode2."Lot Specific Tracking")
      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.
    CA Sandeep Singla
  • Options
    KYDutchieKYDutchie Member Posts: 345

    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.


    Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.
  • Options
    bob_upbob_up Member Posts: 155
    Have you resolved this now and, if so, how ?

Sign In or Register to comment.