• Subject: RE: Purchasing unit of measure conversion
  • From: "Tindell-Sobieski, Marsha C" <TindeMC@xxxxxxxxxx>
  • Date: Wed, 20 Sep 2000 15:47:34 -0400

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

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.