x Want to participate? Join the group to interact

Sage 50 Accounts

Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion UK Filter to show only unpaid sales invoices

Options

Replies 1 reply
Subscribers 54 subscribers
Views 1232 views
Users 0 members are here

Browse Forums

Announcements

766

Financial year end

180

General Discussion UK

19k

General Discussion Ireland

176

312

Install your software

141

379

Making Tax Digital

286

692

Manage your VAT

152

326

Protect and repair your data

139

Run your accounts remotely

200

Working with the bank

117

297

Filter to show only unpaid sales invoices

Posted By Former_Member over 7 years ago

I'm trying to set a filter to show only unpaid items on mt invoices and credit notes screen, but I can't find any paid or balance field except Foreign balance. When I filter on foreign balance <> 0, nothing happens. What should I be filtering on?

Paul Morgan over 7 years ago

Hi Fred,

The Invoices and credits screen shows the invoices and credits before any payments have been received an applied against them. Therefore, this screen is not suitable to apply a filter to show only unpaid items.

Instead, to show your invoices that are yet to be paid you can run the Customer Invoices Due report. This report is held in Customers > Reports > Customer invoices.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 50 Accounts

Filter to show only unpaid sales invoices

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING