I've always struggled with this one too. Credit notes and Payments on Account get forgotten and the supplier ends up overpaid. We definitely need Sage to create a report to cope with this situation.

I just removed the filter for the "PI" header type to get credit notes however I can't get this to work for payments on account  (get a numeric error) as there is no due date posted. Not being able to include these causes me a real issue as I have to try and remember who has Payments on Account.

I think PoAs should have a due date posted of the same date as the PoA

Hi Ken

How do you do that? 

AUDIT_HEADER.DATE_TO-AUDIT_HEADER.DUE_DATE > 0.0 AND AUDIT_HEADER.AGED_BALANCE <> 0.00

Copy the above code and replace what you already have in the Filters for the report

Hi, so putting the above filter in will include credit notes in the supplier invoices due report?

Yes it will as you're removing the current filtering of invoices only - the statement that has the wording "PI" in it.

Give it a go - if it doesnt work you can always not save the changes

Hello, I'm trying to amend the statement letter so it pulls in credit notes and POAs too. Would this same code above work, and where would I put it - see attached screen shot of the body of the letter template that we're using? (basic user here)

You say Statement Letter - which one are you talking about or are you talking Customer statements here ?

If statements it already lets all items through.

Apologies, no it's not a statement, it's a chasing letter called "Itemised Chase Letter 1 (Reminder) "  The Filename is ICHASE1.

It pulls through the outstanding invoices but not any credit notes or POAs.

Thank you

I don't think Chase letters are designed for use with POAs and Credits. POAs don't have a Due Date to start with and some of the crieria and formatting are using the Due Date.

I'd suggest using Statements only for those customers