01-18-2016 01:41 PM
Before I put this in the new ideas section, just want to make sure I'm not missing something.
I see that the price, cost, subtotal and total can be displayed, but the Gross Margin doesn't seem to be there.
Is there a way to display the GM? That would be particularly useful when there are multiple line items and we can then see the GM per line.
Regards,
01-19-2016 09:32 AM - edited 01-19-2016 09:34 AM
Hi John,
You're correct. Currently there's no way to display the Gross Margin column currently in the products/services table.
Please link your idea in this thread once posted, as others may come across this thread in the future.
01-19-2016 02:29 PM
I'm no expert, but the video is an idea
Do not forget to back up your database periodically - And before any change like this
Best regards,
01-21-2016 07:43 PM
This was a great solution.
By taking advantage of the parenthesis, gross margin can accommodate quantities and with a like manner add what the profit margin is.
([Price] - [Cost]) * [Quantity] This gives the profit per line item. The total profit is shown on the screen in the system field Gross Margin
Likewise, the markup percentage can be displayed in the column view ... ([Price] - [Cost]) / [Price]