Customer Invoices Overdue report - please help!

[SallyR]

I'm running the Customer Invoices Overdue report but I've run into a serious wall. I choose to show all customers with overdue invoices and the default date range (1980 to present I think.)

However, what is happening is that I'm getting ALL customers who have EVER had overdue invoices This gives me pages of customers who have "£0.00" total outstanding, which is really annoying as all I need are those who actually have a current overdue balance.

We've tried to amend the filters to exclude if total is "0" but all that does is hides the total for those who are at "0" and not just exclude them from the report completely.

Can anyone please help?

[brucedenney]

What version of Line 50 are you running?

[SallyR]

opppsss, sorry

I'm running V12

[brucedenney]

I think you must have altered the filter on it or something.

It should be

'SALES_LEDGER'.'PAYMENT_DUE_DAYS' <> 0
AND
'AUDIT_HEADER'.'AGED_BALANCE' <> 0
AND (
('AUDIT_HEADER'.'DATE' +
'SALES_LEDGER'.'PAYMENT_DUE_DAYS')
< 'AUDIT_HEADER'.'DATE_TO' )

If you want I could email you a "fresh" copy of the report.

[SallyR]

This is our current filter:

'SALES_LEDGER'.'PAYMENT_DUE_DAYS' <> 0
AND
'AUDIT_HEADER'.'AGED_BALANCE' <> 0
AND (
('AUDIT_HEADER'.'DATE' +
'SALES_LEDGER'.'PAYMENT_DUE_DAYS')
< 'AUDIT_HEADER'.'DATE_TO' )

And it shows the customers who have at some time been overdue on their invoices but are currently at an account balance of £0.00 We've tried to alter the filter using the "sections" but all that does is remove a line which says "0" and I want it to completely ignore the account and not show it at all if the current value on the account is "0" but can't seem to figure out how to do it

We're using the default report that comes with Sage V12. We saved off seperately named copies when we tried to alter the filter. It is working in that it's showing only those invoices which are over the agreed "payment due days" but still shows those who are now at 0

I've done a screengrab of the report as it runs using the filter above...

http://www.rhadeya.com/report_example.jpg

[brucedenney]

Well it looks as if the problem is that those items ARE still outstanding.

Try running a statement showing outstanding items only for one of the accounts and see if they show up as outstanding.

I can see Credit Notes and Invoices that leave a zero balance on the accounts but that I expect have never been matched and so ARE outstanding.

You NEED to match these off other wise they will remain outstanding and never ever be cleared from the system when doing year ends etc.

To match them off in the bank, do a zero value receipt from the customer, match the credit note and then match the invoice. Save it it is zero value so has no impact on the bank and the items will disappear from the outstanding report.