IsPaid

Determines if a transaction is fully paid or if a payment, fully allocated.

Syntax

IsPaid() --> lPaid

Returns

Logical TRUE is returned if the transaction is fully paid or if a payment, whether it is fully allocated against other transactions; otherwise logical FALSE is returned. If the invoice.dbf or accpay.dbf database has not been opened by the form, logical FALSE is always returned.

Description

Determines whether a transaction is paid up and returns logical TRUE if so. If the transaction is a payment and it is fully allocated against invoices, a logical TRUE is also returned. Only transactions held in either the invoice.dbf (customer transactions) database or accpay.dbf (supplier transactions) database can be paid or unpaid. The form must therefore open either the invoice.dbf or accpay.dbf database. Ensure that IsPaid() is used in the specific body that opens invoice.dbf or accpay.dbf, otherwise logical FALSE will always be returned.

In the event that both invoice.dbf and accpay.dbf are opened by the same body at the same time, use the alias operator to refer to the one you need to query.

Example

If invoice->(IsPaid())

   Echo('Customer transaction is paid or fully allocated.')

Endif

If accpay->(IsPaid())

   Echo('Supplier transaction is paid or fully allocated.')

Endif