Short Pay Report

Hello All,

I'm trying to create a report that will show me all outstanding invoices that have been short paid (the remaining amount is not equal to the original amount). In theory what I would like to do is have a FilterField and a Filter both equal to fields in Navision. Here is my formula as it currently is…

=NL("Rows","Cust. Ledger Entry",,"Document Type","Invoice","Remaining Amount","<>0",)

I would like to add another filter that filters out any value where the Remaining amount is equal to the Original Amount, therefore filtering out any invoice that does not have any payment applied to it leaving only invoices with partial payment applied to them. In other words, "Remaining Amount","<>Original Amount".

Any help is much appreciated!

Thanks!

Jet Reports Historic Posts June 04, 2012 23:53 Official comment

Hi,

I think you could do this with a calculated filter, something like this:

=NL("Rows","Cust. Ledger Entry",,"Document Type","Invoice","Remaining Amount","=""<>0&<>""&NF(,""Original Amount"")")
Does that work for you?

Regards,
Hughes

Jet Reports Historic Posts June 05, 2012 18:21

It worked perfectly! Thank you so much! :D

Short Pay Report

2 comments