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 Apr 15, 2019 04:50 PM
    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
    ------------------------------
    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 15, 2019 05:57 PM
    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
    ------------------------------

    NAVUG Summit - Post


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

    Posted Apr 16, 2019 09:14 AM
    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
    ------------------------------

    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 16, 2019 09:20 AM
    ​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
    ------------------------------

    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 16, 2019 09:42 AM
    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
    ------------------------------

    NAVUG Summit - Post


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

    Posted Apr 17, 2019 08:59 AM
    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
    ------------------------------

    NAVUG Summit - Post


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

    GOLD CONTRIBUTOR
    Posted Apr 17, 2019 09:21 AM
    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
    ------------------------------

    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 17, 2019 09:31 AM
    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
    ------------------------------

    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 17, 2019 09:33 AM
    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
    ------------------------------

    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 17, 2019 09:38 AM
    ​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
    ------------------------------

    NAVUG Summit - Post


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

    GOLD CONTRIBUTOR
    Posted Apr 18, 2019 07:12 PM

    ​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
    ------------------------------

    NAVUG Summit - Post


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

    Posted Apr 19, 2019 01:38 PM
    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
    ------------------------------

    NAVUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted Apr 21, 2019 06:15 PM
    Great response @Frances Donnelly, very thorough.​

    ------------------------------
    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
    ------------------------------

    NAVUG Summit - Post


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

    SILVER CONTRIBUTOR
    Posted Apr 22, 2019 10:25 AM
    I was thinking this as well. How do you know which item has been sold by what COO if they are in the same bin.  That makes tracking COO almost impossible.

    Our company wanted to use cost averaging across COO for the same item with different COO.  What we did was to use our lot number to indicate COO.  ID for Indonesia etc.  You have to manually assign the lot number though, and I'm not sure how many lots you would be using. Possibly this is not practical for you.  But a potential option if you get the glitch worked out!


    ------------------------------
    Ruth Entwistle
    Customs Broker/Vendor Relations
    Heron Point Seafood
    Newmarket NH
    ------------------------------

    NAVUG Summit - Post


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