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 Topics