View Full Version : Dual UOM & item master revisions
scottm
04-11-2007, 01:23 PM
We are currently running 11i 5.9
I am new to the OPM module and would love some insight to how Dual UOM works.
We hope to utilize core requisition module with OPM item codes, but we are having trouble with the purchase UOM and the receipt/issuance UOM.
Also how do you assign the different costs?
We purchase them in 1 UOM and need to receive/issue them in a 2nd UOM.
We have items linked to approve suppliers that have a single UOM and look to have a single cost. Is there a conversion rate that determines the 2nd UOM cost?
Can someone explain how this is setup or point me to some reference materials (user guide module?) I could look for more info?
Also, Can this be done within a rev of an item code or does updating the UOM conversions force you to create a new rev?
Thanks for all your help!
NickP
04-12-2007, 08:29 AM
If you have transacted against the Item Master record, you must create a new rev. to switch from single to multiple UOM type. Notice I say "type" here. If you are within the same UOM type, say, Mass, Volume, Count, etc. - and if you have defined under that type both of the UOM's you wish to use, with conversions (lb. to oz., oz. to Kg., etc.) then you can transact in any UOM within a given type, and the system will internally convert the UOM you transact into the Base UOM, and properly update. This includes costing.
Tarpon
04-12-2007, 08:32 AM
That a lot of questions: I can answer a few:
1. Once UOMs are saved they cannot be changed. You need to create a new item in that case.
2. The UOM is not related to the revision at all.
3. Regarding Cost - Do you want to set a different cost for each UOM? Like if UOM1 is pounds you want a cost for 1 pound, but UOM2 is Box (12 pounds) you want to set a different cost or is UOM2 just 12 times the UOM1 cost?
Later
scottm
04-12-2007, 10:18 AM
If you have transacted against the Item Master record, you must create a new rev. to switch from single to multiple UOM type. Notice I say "type" here. If you are within the same UOM type, say, Mass, Volume, Count, etc. - and if you have defined under that type both of the UOM's you wish to use, with conversions (lb. to oz., oz. to Kg., etc.) then you can transact in any UOM within a given type, and the system will internally convert the UOM you transact into the Base UOM, and properly update. This includes costing.
Reviewing our type UOMs sounds like the solution. Thank you both for your quick replies.
I'll do some testing and let you know how it turns out.
3. Regarding Cost - Do you want to set a different cost for each UOM? Like if UOM1 is pounds you want a cost for 1 pound, but UOM2 is Box (12 pounds) you want to set a different cost or is UOM2 just 12 times the UOM1 cost?
We have both cost situations. often times our bulk packaging is not the same cost as the individual items. have any suggestions for setting the different cost?
Tarpon
04-17-2007, 07:15 AM
Found out from NickP that OPM will not allow you to set a different cost based on UOM. Any packaging in this case would need to be expensed.
TO maintain two costs, you would need to create a new recipe for the packaged item with a different cost and use a Batch order to produce it.
So if you have one item where a UOM1 bottle cost $1 and you have a UOM2 of case of 24 bottles, either way its $1 per bottle. If you enter UOM2 of 2 then its $24 because conversion is 1 to 24.
Good luck.
Tarpon
vBulletin® v3.7.3, Copyright ©2000-2010, Jelsoft Enterprises Ltd.