Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

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: 4616
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests