When UOM changed the Price conversion accordingly not happening

[Former Member]

Hi,

We have client requirement in the following way, For some of products they want to change the UOM to another and accordingly the price have to change.

Example we have 3 keyfigures sales forecast, Product price and revenue. UOM for now is LBs

Sales forecast of 100 LBs and its price is $ 10 unit of measure in LBs total revenue is $ 1000.

Now user changes the UOM from Lbs to KGs.

Now sales forecast is 45.45 KGs and the price is not changing to 22.2, it still shows as 10 which is causing a concern for revenue.

Users change UOM in ad-hoc manner.

Have you come across this kind of scenario and how it can be managed.

Appreciate your help.

Thanks,

Sreeni

[former_member583013]

Hi,

what you describe corresponds to the system design. If you change the UOM for a product,

the keyfigure which is of type currency related will not be converted automatically.There is a solution to change the macros using DISPLAY_CONV_FACTOR.For example you can write the macro as follows:

SAP price = forecast * DISPLAY_CONV_FACTOR (forecast)

• Price UNIT.

DISPLAY_CONV_FACTOR (Row) returns the conversion factor between the unit in which the data is stored internally and the unit in which it is displayed for the row. For example, time data may be stored in LiveCache in seconds but it is displayed in the planning table in hours.DISPLAY_CONV_FACTOR would then return 3600 In the attributes of the row or cell, set the Data source to Row Attributes.refer to the note 1480509 which explains in details about this macro function .

Regards,

Sunitha