cancel
Showing results for 
Search instead for 
Did you mean: 

Price List behavior when Purchase and Inventory UoM are different (e.g. FT vs. Meter)

kevinmark
Explorer
0 Kudos

Hi ,

After reading the question at " Purchase in KG and inventory in LBs "  ( http://scn.sap.com/thread/3225198)

I have the following related question:

Can you comment on whether SAP B1 price list for the above thread is also "aware" and responds to the conversion factor between Purchase UoM and the Inventory UoM (this conversion is a field in the Item Master record - under purchasing tab).

I have setup a Purchase price list for the item I purchase.

My item Purchase UoM is FT (we purchase wires) and the inventory UoM is Meters. So the conversion factor is 0.305 Items per purchase unit.

It works fine with the inventory - I purchase 1000 FT, and I automatically receive into the inventory 303 meters.

My question is related to the price conversion (if at all).

The price is $0.352 per FT, and that is how I have set up the price list.

However, when I create the purchase order,  (with "Stock UoM" = NO), I notice that the Unit price is converted into $0.107, while I was expecting the $0.352 price per foot to be used.

It seems to me, that if this is how the system works, I need to setup my Purchase Price List so that the price is for the UoM of the invnetory, and not per the UoM of the purchase unit, does this make sense?

(I dont see in the 8.8 SAP B1 version any association between a Price List and a UoM been used - is that correct?)

thanks in advance,

Kevin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kevin,

Your guess is correct. A price list for different UoM is needed. Price list itself will not do conversion.

Thanks,

Gordon

kevinmark
Explorer
0 Kudos

Hi Gordon,

Sorry, butI don't understand your response. Currently our supplier price list has been setup with prices that assume a UoM of FT (e.g. for item number A , its 0.352 $ per FT). At the same time the inventory UoM is in Meters.

But what I observe, is that when entering a line in a PO for item A, with a UoM of FT, the price changes and instead of  0.352 $, its converted into $0.107 (which tells me that the conversion factor between the purchase and Inventory UoM of 0.305 I have setup in the item master record is responsible for this change). When I repeat this step, but setting to "Stock UoM" = Yes, then the price is the correct price, 0.352 $, but my lines UoM is the wrong one - it's Meter instead of FT.

I don't see how I can assign a price list to a UoM as you suggested above, the price list appears to be dimensionless. But when looking at my above observation I come to the conclusion that all price lists are always associated with the inventory UoM.

BTW - when I changed the supplier price for item A from 0.352 $ to 1.154$ (0.352/0.305), (and Stock UoM" = No) the PO price was the correct => 0.352 $ - this is what supports my assumption, but I want to be sure this is by-design, and if so, why I have not found in documentation on this behavior?

thanks

Kevin.

Former Member
0 Kudos

Sorry for the confusion. It is true all prices under price list should be stick on Inventory UoM.

kevinmark
Explorer
0 Kudos

thanks Gordon, that was what I was waiting to hear.

I will run some final test to confirm this and then I will update the thread.

(BTW - is this explained in the documentation? I was not able to find any reference to this)

Kevin

Former Member
0 Kudos

Documentation may not be able to tell you everything. The fact is: only one UoM can be used to calculate the item price and value with the consistency. It is an expected result.

kevinmark
Explorer
0 Kudos

Hello Gordon,

I have checked, and it seems now to work as you explained above. this is very helpful.

thanks!

Kevin.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kevin

In this case, 1000ft= 330meter, when you set item price, you set price for inventory UoM, it mean 1 meter = 0.352$ => 1ft = 0.107$ is correct. I think system calculate correctly.

GLU