Sage 50 Report Designer Help

Question

I have a report summarising invoice totals for today, the past week and the past month. Unfortunately, if an invoice is highlighted in in the Invoice List, the report picks that up a the data source, so ignores the in-built filters for dates. How do I prevent the report from picking up highlighted invoices and solely use the report's filters for the date range ? 
 It's got to be a setting in Report Designer but I can't spot it and google search doesn't help. 
 Thanks. Dave

Darron Cockram · Accepted Answer

It's not a setting but rather some default behavior that Accounts applies to automatically filter reports based on the selection. You'll have a criterion in your report for INVOICE.INVOICE_NUMBER (possibly a disabled one) and it is this that triggers the automatic filtering. Remove that criterion and your report should return the same thing regardless of selection in the invoices ledger. 
 Hope that helps

Sage 50 Accounts

Sage 50 Report Designer Help

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING