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

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.