|
Fred ... All the answers I'm reading to your question seem to be pointing to selling unit of measure, or using the unit of measure conversion file, but, if I understand your original question correctly, don't you want a different stocking unit of measure for each warehouse? That seems to be much more of a difficulty! You didn't mention what version you are on, but we have the same issues in 4.05, and haven't found an easy solution. When I read your question, I was hoping to hear that some magic answer from someone else! Do you move the product from US to Canada using DRP, or do you enter regular customer orders and purchase orders? (Our experience in doing the same thing has been that customs does not like us shipping things across the border without an invoice, so we have had to use the latter method.) If it's a regular customer order, have you tried using a customer cross reference number, thereby allowing you to have the same item with two different item numbers (and stocking units) at the two facilities? Lisa Abney Sensient Flavors Indianapolis, IN |---------+---------------------------> | | "Jose Torres" | | | <jjtorres63@xxxx| | | ail.com> | | | Sent by: | | | bpcs-l-bounces@x| | | idrange.com | | | | | | | | | 07/30/2003 04:38| | | PM | | | Please respond | | | to "SSA's BPCS | | | ERP System" | | | | |---------+---------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: bpcs-l@xxxxxxxxxxxx | | cc: | | Subject: Re: Multiple Units of measure for one item | >------------------------------------------------------------------------------------------------------------------------------| Fred, Not need to setup duplicate item numbers to do this. BPCS allows you to sell a given item on any unit of measure you setup in the system. If the selling unit of measure is different that the stocking unit of measure, then all you have to do is setup conversion factors between them using the appropriate program which is part of the inventory module. BPCS will track customer order pricings and quantities in both units of measures. But, there is a catch... Which we are facing right now... If product weight is critical for you and it varies from production run to production run (of the same finished good item that is) then you might have problems. In our industry, some customers purchase in "weight" units of measures. Others buy in "Length" units of measure. If the production runs are not always the same in terms of the stocking unit of measure, this will bring conversion issues. We called SSA about this and they don't have a solution. We track inventory by lot and yes, you can track quantities (issues, adjustments, available) by lot. But you cannot track tare, gross and net weights. SSA also talked about the weigthcatch product but we are not licensed for it in versio 6 (it because available after we signed the license agreement) and don't know much about it. In summary, if you production runs are same in terms of weight, I think you will be ok by setting up the conversion factors in the inventory module. If the weights are different, you will be able to get about 90% of the job done with base-BPCS functionality. You may have to do some additional development to get the rest done. I hope this helps. Regards, Jose J. Torres - MS, CISA >From: "Fred Berger" <FBerger@xxxxxxx> >Reply-To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> >To: <BPCS-L@xxxxxxxxxxxx> >Subject: Multiple Units of measure for one item >Date: Tue, 29 Jul 2003 21:59:33 -0400 > >We are a US based company working in LB. We are opening a new facility in >Canada that will work with KG. They will manufacture and distribute all >their products in KG. Our Canadaian customers will order in KG from both >our Canada and US warehouses. > >How can I define items in BPCS to accomodate for both needs? > >The idea I had was to create duplicate items with a suffix of some sort for >the KG managed items. When our Canadian facility or customers order it from >us in the USA we would create orders in KG and debit inventory in LB in the >US warehouse (using the selling U/M conversion factor from the Item >Master). When they receive it in BPCS at our facility in Canada they would >need to convert it to the KG based item so that it can be received and >managed in KG in their inventory. > >Is there a better way to handle this? > > Fred >_______________________________________________ >This is the SSA's BPCS ERP System (BPCS-L) mailing list >To post a message email: BPCS-L@xxxxxxxxxxxx >To subscribe, unsubscribe, or change list options, >visit: http://lists.midrange.com/mailman/listinfo/bpcs-l >or email: BPCS-L-request@xxxxxxxxxxxx >Before posting, please take a moment to review the archives >at http://archive.midrange.com/bpcs-l. > _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.