cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate Total Gross Profit % in SAP

mat_mat
Active Participant
0 Kudos

Hi,

I'm concern about how does B1 calculate the total of gross profit %, what is the formula that system use?

Example: I have two items in my sales order, and the gross profit is set to (Profit / Base Price),

Item A :

Base Price = 8.62

Sales Price = 15.60

Qty = 2

Gross Profit = (Sales Price - Base Price) * Qty = (15.60 - 8.62) * 2 = 13.96

Profit % = Gross Profit / Base Price / Qty = (13.96 / 8.62 /2) * 100 = 80.97

Item B:

Base Price = 3.25

Sales Price = 16.25

Qty = 2

Gross Profit = (16.25 - 3.25) * 2 = 26.00

Profit % = (26.00 / 3.25 / 2 ) * 100 = 400.00

Total Profit % for this two items = 168.32

The above calculation I can understand. But how does system calculate the Total Profit % = 168.32

Any one know the formula for Total Profit % ?

Thanks in advance for any help.

Regards,

Muhamad

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi mat mat,

so you have kept your gross profit according to your base price.calculate the total profit and calculate the total base price.then do total gross profit/total base price * 100 will give you the gross profit for the document....

in brief according to your scenario......

total gross profit for itemA and itemB = (15.60-8.62)2+(16.25-3.25)2

= 13.96+26 = 39.96

total base price for itemA and itemB = (8.622)+(3.252)=17.24+6.5=23.74

finally total gross profit/total base price = (39.96/23.74)*100 = 168.32

hope this will give you a clear picture

regards

Ravindran srinivasan

Answers (2)

Answers (2)

mat_mat
Active Participant
0 Kudos

Hi Rahul,

Thanks for your reply.

Hi Ravindran,

Yes, thats what I want, thank you so much for your help.

Regards

Muhamad

Former Member
0 Kudos

Hi Mat...........

It gets calculated automatcally.....

It totally depends upon the simple funda wherein sales total value be calculated against the purchase value and will

get the profit and loss figure............

Regards,

Rahul