Page 1 of 1
v8 PL over 60 days
Posted: 18 Feb 2008, 11:09
by Emily
I'm trying to run the Outstanding Purchase Invoices Over 60 Days report and it's including invoices that are not outstanding but probably have been at some point. All invoices have been allocated to their relevant credit notes and payments, so I don't know why the report isn't being clearer. Any help?
Cheers
Posted: 18 Feb 2008, 12:54
by brucedenney
What version of Line 50?
Are the transactions that show all deleted?
Posted: 19 Feb 2008, 08:54
by Emily
I'm running v8.2.
The transactions do appear to be deleted, yes.
Posted: 19 Feb 2008, 09:43
by brucedenney
You need to amend the report to exclude deleted transactions.
I don't have V8 running right now, but....
Open the report in the report designer by pressing the edit button instead of run.
Go to Format
then filter
the filter expression should be extended to add
AND 'AUDIT_HEADER'.'DELETED_FLAG' = 0
the whole thing should read.
'AUDIT_HEADER'.'TYPE' LIKE 'PI' AND ('Age of Trans' >60) AND 'AUDIT_HEADER'.'AGED_BALANCE' <> 0 AND 'AUDIT_HEADER'.'DELETED_FLAG' = 0
Posted: 19 Feb 2008, 13:36
by Emily
That works! Thank you very much.