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

Departmental P&L

Report design issues and solutions.
Post Reply
Janice_xxx
User
User
Posts: 1
Joined: 22 May 2014, 11:48
Sage Version: v2013 19 UK/Europe/Africa

Departmental P&L

Post by Janice_xxx » 22 May 2014, 12:02

How can I run this report for a selection of departments that are not consecutively numbered eg departments 2, 4 and 6 (so missing out 1, 3, and 5)?

There is no option to enter criteria that does not fall within a 'range', for example selecting dept numbers from a dropdown list, and when I try to separate them with a comma, as soon as I hit OK to run the report, it loses the commas and defaults to dept 246.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4629
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Departmental P&L

Post by brucedenney » 22 May 2014, 16:05

I suggest taking a copy of the existing report and altering it to use a filter.
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.
Top
Post Reply

Return to “Sage 50 Report Designer”

Who is online

Users browsing this forum: No registered users and 15 guests