Open Forum

Expand all | Collapse all

Solution for multiple definitions/usage of items

  • 1.  Solution for multiple definitions/usage of items

    Posted 15 days ago
    We have a need to use and or define when and how an item might be used.

    Over the last few years we have acquired several companies and have begun integrating into GP.

    The situation is that many of the parts the new companies have are the same as the parent company, however they also have (Restricted) items that can only sell be sold in their location and not available to the parent company.

    To complicate it further we also have certain customers that have agreements with suppliers that we can only sell certain parts to certain customers, another form of restriction.

    We have Binary Streams MEM module implemented that helps with the restrictions to some degree and then we also have customizations that handle the remaining.

    The bigger issue we have is that this is becoming a bigger issue as we continue with additional integrations as well as new agreements with customers and suppliers.

    The scope and management of all the customizations currently and in the future is becoming a challenge, at best to manage.

    Is anyone aware of GP solutions that we might look at to help with managing items that could have multiple defined uses in GP?


    Jeff Roe
    Kele Inc
    Bartlett TN
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Solution for multiple definitions/usage of items

    Posted 14 days ago
    Maybe take a look at using Site IDs (location codes). I've had over 30,000 active Item numbers and over 1000 site ids. Many physical sites, but also logical sites.
    Items are only assigned to a site ID location code if they are allowed there. Sites can be customer specific, contractor specific and so on.

    For a large Google Fiber project in Memphis,we had over 200 site IDs. One master site ID in Memphis (physical), one Returns SIte ID (logical). One Google Parts only Site ID (logical) and then a Site ID location code (physical) for each building/job site for the fiber installs- over 200 of those.
    Because we used many contractors we also had a site ID for each contractor to manage parts they took for jobs but had not issued to the job Sites.

    For other purposes, I also like Lot Tracking to track various attributes of Items where the SKU Item Number is the same but we must track the Distributor(supplier), COO, condition,or some other attribute for each item issued. Similar to serial tracking which we use for items like fiber jacks where you must track the MAC Address,install date, activation date or other unit specific data.

    Here is a sample of using Lot attributes

    Thaddeus Suter
    Retus, Inc

    Academy - Online Interactive Learning from Experts

  • 3.  RE: Solution for multiple definitions/usage of items

    Posted 14 days ago

    Here are a couple tools I've used in the past for these type of challenges...

    The item modifier in PSTL can rename an item.  This will rename the item and all of the history.  When two entities cannot play nice in the sandbox (agreeing on a naming convention or sharing an item ID), sometimes you can rename the item of the 'loser in the sandbox' and give the item number to the 'winner in the sandbox'.

    There is built-in functionality to assign 'customer items'.  Typically, it holds the ID of the item number that the customer likes to use for your item.  The data structure can come in handy for a variety of challenges like this.  Unfortunately, I don't believe there is similar functionality on the procurement side (maybe someone else in the group knows).  I bet there is an ISV for this.

    I hope this helps.


    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role