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

Stock shortfall report expression

Report design issues and solutions.
Post Reply
Minty
User
User
Posts: 2
Joined: 06 Dec 2019, 19:47
Sage Version: v2018 24 UK/Europe/Africa

Stock shortfall report expression

Post by Minty » 06 Dec 2019, 20:04

Hi

I'm new to Sage and still learning.

I've added cost price and total to the shortfall report, what would be needed in the expression to show the total cost of quantity to order?

Thanks

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

Re: Stock shortfall report expression

Post by brucedenney » 07 Dec 2019, 17:08

In the section where you want the total, you put the expression or value, on the items properties you select function = sum.
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.

Minty
User
User
Posts: 2
Joined: 06 Dec 2019, 19:47
Sage Version: v2018 24 UK/Europe/Africa

Re: Stock shortfall report expression

Post by Minty » 09 Dec 2019, 09:52

That's great, working now. It was the properties that needed changing. Thanks

Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests