Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Combining Item Groups?

 6 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
chadC
Basic Member
Posts: 9
Basic Member
9/21/2010 8:40 PM
    We have 5 IC companies (1 of which is a Canadian company). Each has it's own Item Group. We are looking into combining those 5 into 1 Item Group (either by keeping an existing one or creating a brand new one). We are hoping to correspond this with the v9.0.1 upgrade this winter (from v8.1.0). Does anyone have any thoughts to any ramifications this could have with PO, MA or AP?
    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran Member
    9/22/2010 11:00 AM
      The key question: Do your item numbers overlap and represent different things:
      For example:
      If Item 12345 in Item Group/Company 1 - Paper Towel holders
      and Item 12345 in Item Group/Company 2 - X Ray film
      your going to have issues
      Similarly, you need to think of any setup you have tied to IC11 - e.g. UOMs. Even if the item is the same in both company 1and company 2, this may cause issues.
      chadC
      Basic Member
      Posts: 9
      Basic Member
      9/22/2010 1:40 PM
        Thank you for the response Adam. We are definitely going to have overlapping Item Numbers and UOM's. Decisions are going to have to be made on those, and other things like: # of Decimals, Auto Document Numbering, etc. However, no one here seems to believe that those are the reasons for the separate Item Groups in the first place.

        The thoughts are that since each company also has its own Vendor Group and Pay Group, they had to set up IC with individual Item Groups. I can't seem to find a reason that would be the case. So I'm wondering what I am missing here?
        Adam Jacobson
        Veteran Member
        Posts: 69
        Veteran Member
        9/22/2010 2:58 PM
          I don't think your missing anything.
          I write (or used to write) dozens of queries over Lawson data.
          And I can see no way where item group needs to align with Vendor group.
          I could be missing something but I have a lot of years with the data.
          True - your kind of consolidation doesn't come along often but I can't see a problem other then the overlapping numbers (which is going to make converting your PO Line records just an absolute joy.
          chadC
          Basic Member
          Posts: 9
          Basic Member
          9/22/2010 5:14 PM
            Thanks again for your insight Adam, I appreciate it. It'll be a huge project, that's for sure.
            JonA
            Veteran Member
            Posts: 1163
            Veteran Member
            11/4/2010 11:34 AM
              We only have one item group and one vendor group for multiple companies. I'm wondering how PO13 works with multiple vendor groups. I don't envy you in this project.
              Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
              chadC
              Basic Member
              Posts: 9
              Basic Member
              11/4/2010 2:14 PM
                Hi Jon, thanks for the message. Yes, PO13 is probably a big reason why we are not going to do this now: After additional research and testing, I have found that PO00.1 Procurement Group will not allow you to use one Item Group on multiple Procurement Groups (which we have - and do not plan on changing that). Therefore, this project has been put on the back burner for now (sigh of relief).