Open Forum

Expand all | Collapse all

Same item in inventory with different Country of origin?

  • 1.  Same item in inventory with different Country of origin?

    Posted 5 days ago
    Does anyone have the same item in inventory with different Country of origin? Due to small warehouse size, same item (with different COO) will store in same bin location. How we can track inventory in this situation? How shippers can pick items with correct COO based on Sales order?

    Any comment/suggestions will be highly appreciated.





    ------------------------------
    MP Patel
    Amoena
    Kennesaw GA
    ------------------------------


  • 2.  RE: Same item in inventory with different Country of origin?

    TOP CONTRIBUTOR
    Posted 5 days ago
    I think you might have to consider lot tracking to have the same item in inventory with two different country of origins.

    ------------------------------
    Kim Dallefeld
    Kim@Dallefeld.com
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee
    ------------------------------



  • 3.  RE: Same item in inventory with different Country of origin?

    Posted 5 days ago
    Hi MP Patel,

    I agree with Kim.  And with lot tracking enabled our WithoutWire system can track the country of origin as an item attribute, typically captured at Receiving and then to be confirmed at time of Picking from your bins and reported on as needed.

    https://withoutwire.com/blog/custom-attributes-one-reasons-medical-companies-love-withoutwire-inventory-science/

    https://withoutwire.com/items/custom-attributes/

    https://withoutwire.com/industry-inventory-solutions/

    Let me know if you have additional questions.

    Steve Dwyer
    612-343-0404 x109

    ------------------------------
    Steve Dwyer
    VP Sales and Marketing
    WithoutWire Inventory Sciences
    minneapolis MN
    ------------------------------



  • 4.  RE: Same item in inventory with different Country of origin?

    TOP CONTRIBUTOR
    Posted 5 days ago
    ​My first thought was that perhaps you could use variants for different countries of origin.  Lot tracking will probably give you better conrol and tracking abilities however,  Someone with more experience with the use of variants may be able to discuss the pros and cons.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    Call for proposals: https://www.surveymonkey.com/r/UGSummitNA2019
    ------------------------------



  • 5.  RE: Same item in inventory with different Country of origin?

    TOP CONTRIBUTOR
    Posted 5 days ago
    The major difference in using variants is that there is no requirement to enter a variant. NAV will process the transaction with or without the variant value. A lot number, on the other hand, can be required for various transactions and controlled by setup as to when the lack of a lot number will stop a transaction from continuing. In my opinion, out of the box usage of lots is a better control. It would be even better to use the lot no. information card and have a country of origin field added there.

    ------------------------------
    Kim Dallefeld
    Kim@Dallefeld.com
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee
    ------------------------------



  • 6.  RE: Same item in inventory with different Country of origin?

    Posted 4 days ago
    Hi Kim,

    Thanks for the response. We can not use Lot No. since we are using same Lot No. (DP00001) for all the items no matter what.(There was a glitch in Lot No. implementation from previous consultant) and it will be still there. So basically we are using Lot No. but not in actual use.

    I am not able to find a solution how we can track inventory if we are using same Bin Location for same Item(with different COO). How the shipper will know which Item(COO) will go and pick from that location. For eg

    In sales order Item X is listed with variant code HK (X - COO is HK) and in Bin Location item X has 3 Different COO(HK, CR, China), how shipper will know he/she will pick item from COO HK? How we can track inventory in this case. Also for customers we need to put COO in Labels alonfg with other info(Like size, color etc) and also COO information is required international shipping. :)



    ------------------------------
    MP Patel
    Amoena
    Kennesaw GA
    ------------------------------



  • 7.  RE: Same item in inventory with different Country of origin?

    GOLD CONTRIBUTOR
    Posted 4 days ago
    The lot tracking error puts a major limitation on your options.  Are you do for an upgrade or move to BC anytime soon?  One option would be to bundle fixing the lot number with the upgrade.  As I was reading the thread my thoughts went to serial tracking, but you can't use that if lot tracking is already turned on.

    If you fix lot and move to serial tracking one option would be to modify your serial number generator to add a suffix or prefix based on the country of origin.  Maybe during the receiving process the receiving clerk is prompted for a COO and that answer is incorporated into the serial number generator.  This way your system is tracking the country of origin and your warehouse staff has an indicator of the country of origin as well.  An additional validation could be created during the shipping process that disallows shipping of certain serial number suffix or prefix's.  I am not sure how far you want to go with this.

    Good luck.  Please post the solution that you implement.  Thanks.

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich LLP
    Dublin IL
    ------------------------------



  • 8.  RE: Same item in inventory with different Country of origin?

    TOP CONTRIBUTOR
    Posted 4 days ago
    If you can't use Lot Tracking for this then the variant solution Lewis suggested might be your best option.
    To address the issue Kim brought up, we use code like the following at a number of different Events to ensure variants are selected if they exist. Basically it just tests to see if variants exist, and if they do, then it forces the user to select a variant.

    IF SalesLine.FINDSET THEN
    REPEAT
      ItemVar.RESET;
      ItemVar.SETRANGE("Item No.",SalesLine."No.");
      IF NOT ItemVar.ISEMPTY THEN
        SalesLine.TESTFIELD("Variant Code");
    UNTIL SalesLine.NEXT = 0;

    Once you have this in place, then you might need to do some further customization to show the proper COO where you need it to (like on your shipping documents) but that shouldn't be terribly difficult.

    ------------------------------
    Greg Enns
    ERP Coordinator
    Technical Prospects
    Kaukauna WI
    ------------------------------



  • 9.  RE: Same item in inventory with different Country of origin?

    TOP CONTRIBUTOR
    Posted 4 days ago
    Jason is correct and Greg provides good information. I agree with Gregg when he states that you should have a further customization to require the user to indicate the proper COO being picked.

    ------------------------------
    Kim Dallefeld
    Kim@Dallefeld.com
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee
    ------------------------------



  • 10.  RE: Same item in inventory with different Country of origin?

    TOP CONTRIBUTOR
    Posted 4 days ago
    ​MP, your partner should be able to come up with a resolution for the lot glitch.  If you can get that fixed, Jason's though about a suffix or prrefix on a tracking number is interesting.  NAV can generate lot numbers for you, so you can create different number series with different prefixes.
    I know that for items, you can have multiple number series to choose from.   I'm not sure if you can do the same for lot tracking.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    ------------------------------



  • 11.  RE: Same item in inventory with different Country of origin?

    GOLD CONTRIBUTOR
    Posted 2 days ago

    ​Hello,

    There is nothing wrong with creating a separate Item card for each Country of Origin. This way, not only do all of these other problems go away, but you can set your Foreign Trade/Tariff Information more accurately, and associate vendors to the Item a little more nicely. Plus it will help you better distinguish the cost of goods sold. There are a list of advantages to doing it this way.



    ------------------------------
    If my response has helped you please mark the answer.


    Best Regards,

    Alex A
    Sr. NAV Consultant, DXC Technology
    Los Angeles, CA, United States
    ------------------------------



  • 12.  RE: Same item in inventory with different Country of origin?

    Posted 2 days ago
    My organization has a quality management tool that integrates to Nav but that would allow you to setup lot ids just in the quality system and the data tied to those lots could then be used to support your other requirements like printing the correct data on labels etc.  The lot id you create in the quality system would have to be incorporated in your item records in inventory, but there are a number of ways to do that.  So it's an idea you can pursue.  It is like the concept from Without Wire but it does not have to be based on the lot number in Navision.

    However, Lot tracking is definitely the functionality most manufacturers and distributors would use in this circumstance.  Out of the box there is a great deal of functionality to support your needs and the value of accessing that functionality should offset the cost of having the glitch fixed.  Alex suggests that the difference between the lots should actually be at the item level and he would be correct if you have a need to plan for replenishment of inventory based on an attribute like COO.  (Country of Origin)  Material planning tools offset supply and demand in their algorithm using identical part numbers.

    It strikes me that you also likely have an inventory count problem with your current set up because without either item numbers specific to COO and with no ability to track for lots and everything in the same bin, how does staff know the available quantities by COO or similar factors.  At least with Lot fixed you would see that data too.

    If you would like to learn more, let me know.  Maybe some of these comments will help justify the investment in the fix.
    Frances@qualityessentialssuite.com

    ------------------------------
    Frances Donnelly
    Director of Sales & Product Development
    Horizons International
    Julian CA
    ------------------------------



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