Debitors Statement

[bigfatgreedykat]

Hello all

I've had a call from my accountant he requires a list of all outstanding invoices.

I've been able to work out invoices due!

Each invoice table has a portal named Payments. When client makes a payment this field/record is completed.

I think i can create a script that searches PAYMENTID field but returns results if field is empty!

Searching HELP now but if anyone has any advise it will be greatly appreciated!

regards

BFGK

[bigfatgreedykat]

Hello all

I got it sorted finally. Was able to use SET FIELD to search on PAYMENTID then again using SET FIELD to search on Amount Due " = "

The " = " searches on empty fields.

regards

BFGK

[bcooney]

hi again. Wouldn't outstanding invoices be invoices that have a balance due? Can't you just do a find on the balance due field >0?

[Søren Dyhr]

SET FIELD to search on Amount Due " = "

The " = " searches on empty fields.

It make me wonder if not the portal is there to facilitate partial payments, otherwise would just a boolean attribute be sufficient.

No! make an aggregate (sum) over the related stuff, and hold it against the invoice sum in a seach via a diff'ing calc'field. Then make a search for those >0 to prevent excess payments mixing up with the open ones.

--sd