UOM sales data B1 9.0

[Former Member]

Uom sales data shouldn't take the base as pieces it should be taken in square meter,

company buys in sq.ft & sells in sq.meter base UOM taken as pieces(pcs),there is no issue with buying calculations,when we do selling it should not take base as pcs it should be calculated in sq.meter

can anyone suggest me solution for this issue

[kothandaraman_nagarajan · Accepted solution]

Hi Kiran,

Define same UOM under purchase, sales and inventory tabs of item master data.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thanks Nagarajan,

i have updated datas in all this field ,is there possiblity to change the base UOM in sales data

(For instance i have created Base UOM as pcs--purchase will be in sq.ft,,sales will be in sq.m)

i want the base to be reflected  as sq.m for sales  alone...rest Uom base should be in pcs.

pls suggest me on this issue

Regards,

kiran

[Former Member · Accepted solution]

Base UoM is always inventory UoM which is sq.ft in your case. Your sales UoM can be sq.m. The quantity would be 10.764 per sale UoM.

[Former Member · Accepted solution]

Thanks gordon,

i have resolved the issue by changing the base to SQ.M.

Thanks to all for giving me valid solutions.

[Former Member]

Hi,

You need setup sales UoM as follows:

1 sq.mt = 10.764 sq.ft

Thanks,

Gordon

[Former Member]

Hi Kiran,

As suggested by Rahul, you have to updated the calculations in the respective fields and also make sure that while you are booking a SO, the inventory UoM is set to 'No'.

This should resolve your issue.

Thanks,

Joseph

[Former Member]

Hi Kiran....

In order to get this done you have to set the Relation between how much is Sq. Mtr. in 1 Sq. Ft. under Item Master Data's Sales Tab...

Please look into Screen Shot...

Regards,

Rahul