Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Invoice Product profit report

Report design issues and solutions.
Post Reply
Rupert E
User
User
Posts: 1
Joined: 22 Jan 2018, 20:12
Sage Version: US Sage 50 Version (Peachtree)

Invoice Product profit report

Post by Rupert E » 22 Jan 2018, 20:35

Hi,
I'm trying to re-design my invoice product profit report to actually show the profit as a percentage. It currently just shows the actual amount of profit
in £'s. It would make it a lot easier when glancing down a list if it showed a % and so show up errors/low margins. I've tried searching for the correct data field but not had any luck so far. It may not be possible but wonder if anybody has any ideas?
Thanks

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4256
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Invoice Product profit report

Post by brucedenney » 23 Jan 2018, 16:55

You need to add an expression field.

In the expression editor you then want to Divide the Profit Amount by the Sale Amount to get profit as a %ge of Sales.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest