Total Profit and Total Margin fields

On Sales Quote, Order, Invoice, RMA and Credit Memo, added a total field for the Profit and Margin columns.

By default, Profit and Margin columns are not shown in the above mentioned forms.  You will have to add those first.  To do that, on the column header, right-click and select Column Chooser.

When Customization mini-form opens, drag the Profit and Margin fields onto the grid area.

Profit’s computation:

Price – Cost = Profit

For BED- FITTED SHEET:

9.99 – 6.44 = 3.55

For BED- FLAT SHEET:

15.59 – 10.55 = 5.04

Margin’s Computation:

Profit / Price =Margin rate

For BED- FITTED SHEET:

3.55 / 9.99 = 35.54%

For BED- FLAT SHEET:

5.04 / 15.59 = 32.33%

Total Profit’s computation:

Sum of profit per line item selected

3.55 + 5.04 = 8.59

Total Margin’s computation:

Total Profit / Total Price = Total Margin

8.59 / 25.58 = 33.58%