We control our Gross Margins and Costs by expressing every Profit and Loss item as a percentage of the Total Sales. So our Total Sales is 100%. So everything is divided by the 100% to calculate a Percentage. So for example a Gross margin is 45% (Of the 100%). Advertising Cost is 15% of Total Sales. Net Profit may be 4% etc. My question is if anybody knows if such report exisits in SAP b1. as a Standard or how can I achieve this?
EG
SALES $10,000 100%
COST OF GOODS $ 5,500 55%
Gross Profit $ 4,500 45%
Advertising Cost $ 1500 15%
Telephone $ 200 2%
Admin $ 1600 16%
Overheads $ 800 8%
-
Net Profit $ 400 4%
Thanks
Robert