• Subject: RE: Purchasing unit of measure conversion
  • From: "Shrader, Patrick" <pshrader@xxxxxxxx>
  • Date: Wed, 20 Sep 2000 17:03:38 -0400

Ahah! I missed the part about setting it up in the ITEMBL file. I had read
these messages as setting up the generic UOM conversion tables, not at the
item level. 

Many thanks to all who helped! I have seen the light, and it has solved my
problem.

Patrick


> -----Original Message-----
> From: Tindell-Sobieski, Marsha C [SMTP:TindeMC@ch.etn.com]
> Sent: Wednesday, September 20, 2000 3:48 PM
> To:   'MAPICS-L@midrange.com'
> Subject:      RE: Purchasing unit of measure conversion
> 
> I agree...  That is how we did it - a different conversion factor for each
> item...  For example, steel sheet, steel coil, steel bar, etc..  I
> previously did SAP MM installs and it was the same - by item...   I know
> it
> seems like alot of work but again its in the item master so you only have
> to
> do it once and it defaults to your PO's.  We've literally had to set-up
> hundreds of these conversion factors for items for every purchasing
> install
> we've done.
> 
> Marsha Tindell-Sobieski
> 
> 
> -----Original Message-----
> From: Shaw, David [mailto:dshaw@spartan.com]
> Sent: Wednesday, September 20, 2000 1:22 PM
> To: 'MAPICS-L@midrange.com'
> Subject: RE: Purchasing unit of measure conversion
> 
> 
> Unless something has changed drastically, it's possible to have a
> different
> unit of measure conversion factor for each item, maintained in either Item
> Master or Item Balance (I've been away from MAPICS for a year, sorry for
> the
> imprecision of my memory).  The default unit of measure conversion factors
> are just that, defaults - it's what's actually stored for the item that
> gets
> copied to the PO, and in fact it's possible to change it on each PO,
> although there may not be a MAPICS screen which allows that (yes, I know
> DFU
> is almost a dirty three-letter-acronym <grin>).
> 
> Dave Shaw
> MAPICS-L Moderator
> Spartan International, Inc.
> Spartanburg, SC
>  
> -----Original Message-----
> From: Shrader, Patrick [mailto:pshrader@wkep.com]
> 
> This explanation makes sense.
> 
> However, product A weighs 3 pounds per 1000 yards, and product B weighs 50
> pounds per 1000 yards. If I set the UOM conversion for product A where 1
> lb
> = 333 yards, what do I do when I order product B (1 lb = 20 yards)?
> 
> It is unrealistic to create a different UOM conversion for every product
> that I purchase. 
> 
> Things like thread, ribbon, and the such is sold by weight but used by the
> yard. Is this something that the system can calculate, or will I need to
> manually convert it to yards for my receiving, and add to the comments of
> the PO the weight for the vendor's use?
> 
> David, yes I have purchasing installed (as of last week). 
> 
> Patrick
> 
> 
> > -----Original Message-----
> > From:       Tindell-Sobieski, Marsha C [SMTP:TindeMC@ch.etn.com]
> > Sent:       Wednesday, September 20, 2000 9:33 AM
> > To: 'MAPICS-L@midrange.com'
> > Subject:    RE: Purchasing unit of measure conversion
> > 
> > Patrick,
> > 
> > We had the same issues when we implemented.  We went back and forth with
> > Mapics for a long time till we got an answer on how to do this.  Here's
> > the
> > scenario:
> > 
> > If you have an item that you purchase in lbs and stock in yds in the
> item
> > master you need to load the purchasing unit of measure and the stock
> unit
> > of
> > measure along with a unit of measure conversion factor.  What Mapics
> does
> > when a PO is created is to look at the purchasing unit of measure and
> the
> > stocking unit of measure and if different will display the purchasing
> unit
> > of measure on your PO.  Since Mapics considers your stocking unit of
> > measure
> > to be the primary units the price of an item with a conversion can be an
> > issue.  Here is how the formula works (its not documented in Mapics
> info):
> > 
> > If a PO uom is different than a stocking uom then Mapics does the
> > following
> > for price:
> > 
> > Purchase price in item master C is multiplied by the uom conversion
> factor
> > to create the price per purchasing unit.
> > 
> > ex:  .45/yd (record c) x .52 (uom conversion factor) = 0.234/lb
> > 
> > This formula should help you determine what your uom conversion factor
> > should be.  
> > 
> > Marsha Tindell-Sobieski
> > 
> > 
> > -----Original Message-----
> > From: Shrader, Patrick [mailto:pshrader@wkep.com]
> > Sent: Tuesday, September 19, 2000 5:04 PM
> > To: Mapics Mailing List
> > Subject: Purchasing unit of measure conversion
> > 
> > 
> > I have a different type of problem, and am looking for suggestions from
> > the
> > peanut gallery.
> > 
> > Facts:
> > I purchase ribbon in pounds, but receive and use it in yards.
> > 1 pound is 5,000 yards.
> > I need for the purchasing module to print in pounds, but I want to
> receive
> > it in yards.
> > 
> > How should I set this item up so that it is purchased in the correct
> > quantities, yet is also received in the correct quantities and UOMs? I
> > don't
> > think a standard uom conversion will work, since other items way more or
> > less than 5,000 per lb.
> > 
> > I'd appreciate any hints or tips you can give me.
> > 
> > Patrick Shrader
> > White Knight Engineered Products
> +---
> | This is the MAPICS Mailing List!
> | To submit a new message, send your mail to MAPICS-L@midrange.com.
> | To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> dshaw@spartan.com
> +---
> +---
> | This is the MAPICS Mailing List!
> | To submit a new message, send your mail to MAPICS-L@midrange.com.
> | To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> dshaw@spartan.com
> +---
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.