• Subject: RE: Purchasing unit of measure conversion
  • From: "Shaw, David" <dshaw@xxxxxxxxxxx>
  • Date: Wed, 20 Sep 2000 13:22:08 -0400

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


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

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.