Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Generate Item Number

 6 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
dykesjk
Basic Member
Posts: 7
Basic Member
8/22/2017 11:50 AM

    Our organization has ran into issues with Item Numbers being reused in the past. This primarily occurs when a prior Item Number is no longer active and a new item is assigned to the number. The idea has been brought up that we should only allow for an Item Number to be used one time and once it is used, the number will no longer be used. 

    1 - has anyone else implemented this idea?

    2 - is there a configuration that allows for the Item Number to be generated? 

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    8/22/2017 12:22 PM

      Do you mean the Lawson Item on IC11 (you are recycling item numbers) or the vendor part number (You inactivate it and then add it in again as new)?

      Recycling IC11 ITEM - we do this for conversion on the non-chargeable med-surg items (alcohol prep pads) unless there are drastic changes to the UOM conversions that would cause problems.

      Duplicate part numbers being created: This is a challenge, but if you set up manufacturer codes and require them on all items, when you add the new item, you'll get "Warning: Manufacturer Information Exists for Item [LawsonItemHere]" - which is a soft warning - not a hard stop.

      We also upload to PO25.6 with FC B (Both) which will return hard stops if the vendor part number and vendor are already in PO13.

       

      (Edit: Also - yes, there is a company setting to auto generate IC11 item numbers, but I don't know anyone who stop manual items and then turned on auto numbering)

      dykesjk
      Basic Member
      Posts: 7
      Basic Member
      8/22/2017 12:27 PM

        This is occuring on the IC11 setup. Makes sense to allow for the same number to be recycled for similar items, but i believe this has occured for varying items that are not related.

        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        8/22/2017 12:33 PM
          IC11 Item is indexed - it shouldn't allow you to create duplicates. Do you have an example?
          dykesjk
          Basic Member
          Posts: 7
          Basic Member
          8/22/2017 2:21 PM

            Let me get a number from my business unit. This came up as a high level discussion taht is was going on and at the time they did not have much detail. I will follow up and get back to you with that answer.

            Russell Spreeman
            Veteran Member
            Posts: 61
            Veteran Member
            8/25/2017 2:18 PM
              IC00.1 allows you to specify 'Automatic Item Numbering'. If you want to upload or add items using specific numbers you can switch that off, add the items, then switch it back on again. However, using this setting would certainly preclude the same item number being re-added to the inventory item file.
              Maris Fisler
              Basic Member
              Posts: 8
              Basic Member
              9/1/2017 6:19 PM
                We never re-use an item number in IC11 (with one exception and that is for our custom surgery packs, when an item is removed or added Cardinal adds a letter to the end of the manufacturer number and we do make that change in IC11 for this one exception). If a product is changing to something new and the manufacturer number is new then it gets a new Lawson number. The manufacturer number is the key for us, no items should have duplicate manufacturer item numbers and if that number changes then it gets a new number in IC11. This is important to be able to track down the usage for a manufacturer item that has been recalled and we need to find where it is being used.