Profit margin % configuration

Julieta Oberti

• March 06, 2023 12:39

Hi!

In our team we identify that Calculation Object Profit margin % calculate profit margin as  Profit/Cost of Sales, and that it is not configurable. We will really need an option to display in calculation schema Profit margin % as Profit/Sales Price.

For Sap B1 documents we can configure it in Document settings

Maybe something similar in Configuration Wizard or in the calculation object will do it.

Thanks in advance.

Julieta

Vote

0

• 

  Ana Bracho

  • May 30, 2023 14:45

  In the standard object of the cost schema you will find 2 Profit Margin Elements.

  By default 1 i a surcharge element ( the green one at you can define the Margin that you would like to have) and the other (The blue one) Will be calculated by the system when a sales price is provided could calculate the margin comparing the Cost of sales and the Sales Price.

  Use the gree one if you want to define your own.

  

   

   
• 

  Julieta Oberti

  • May 30, 2023 17:58

  Ana, thanks for your answer but that´s not what I was looking for. Actually I need blue field to display Profit/Sales Price and not Profit/Base Price. This percentage is variable over each work order and I want it with reporting purposes not as a surcharge.

  We`ve finally solved the issue with some window customizing script that makes the calculation, which is not the neatest solution but it works.

  Hope is clearer now :)

Please sign in to leave a comment.