Open topic with navigation

> Sage 50 Accounts / Example: Filters

See also

Filter information

Sage 50 Accounts example: Filters

To set a filter on the whole report, select Report > Filters.
To set a filter on a section in a report, select the section, then select Filter in the Properties pane and click the finder button .

Filter examples

Action	Filter
To exclude control accounts from nominal reports.	NOMINAL_LEDGER.ACCOUNT_TYPE Does not equal 4
To exclude fully paid transactions.	AUDIT_HEADER.FOREIGN_AGED_BALANCE Does not equal 0
To exclude customers with a zero balance.	SALES_LEDGER.BALANCE Does not equal 0
To exclude suppliers with a zero balance.	PURCHASE_LEDGER.BALANCE Does not equal 0
To exclude the suspense account. Note: This example assumes you are using the code 9998 for your suspense account.	AUDIT_SPLIT.NOMINAL_CODE Does not equal 9998
To include supplier invoices over a certain value (exclude below the value). The example used a notional value of £100.	AUDIT_HEADER.FOREIGN_NET_AMOUNT Less than "-100" or you could use AUDIT_SPLIT.FOREIGN_NET_AMOUNT Less than "-100"

Advanced filter examples

To enter the following examples, select Use Advanced Filter when you set the filter.

Action	Filter expression
To include customers that have exceeded their credit limit (exclude customers within credit limit).	SALES_LEDGER.BALANCE > SALES_LEDGER.CREDIT_LIMIT
To include suppliers where the credit limit has been exceeded (exclude suppliers where the credit limit has not been exceeded).	PURCHASE_LEDGER.BALANCE > PURCHASE_LEDGER.CREDIT_LIMIT