|
Patrick, I know it sounds like a pain, but UOM conv. factor is set item by item for exactly the reason you state - different items have different conv. factors. You only need to set this up once and the system handles it from there. Just remember, if the specs change ie. heavier ribbon someone must change the conversion factor for the system to correctly calculate the usage. Ed Chabot The Marlin Firearms Company 100 Kenna Drive North Haven, CT 06473 (203)985-3254 -----Original Message----- From: owner-mapics-l@midrange.com [mailto:owner-mapics-l@midrange.com]On Behalf Of Shrader, Patrick Sent: Wednesday, September 20, 2000 12:27 PM To: MAPICS-L@midrange.com Subject: RE: Purchasing unit of measure conversion 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 +--- +--- | 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 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.