GTINVSTAT

Returns the total amount due, paid, or balance due for specified invoice.

Reporting Area(s)

Pay, Registrations

Required Parameters

1. Invoice # (pyrecnum)
2. Character return value:

"i"= Total Due For Invoice

"p"= Total Paid to Invoice

"b"= Balance Due for Invoice

Optional Parameters

3. Condition to return amount (i.e. "'456' $ pytype")

Example(s)

GTINVSTAT(pyrecnum,"i") Returns total amount invoiced

GTINVSTAT(pyrecnum,"b","pydate < ctod('07/01/04')") Returns balance due for invoice excluding any payments made since 07/01/2004.

Related Functions

GTINVBAL
GTINVDUE
GTINVPAID