GTINVPAID ​
Returns total amount paid for a specific invoice.
Reporting Area(s) ​
Invoices, Accounting
Required Parameters ​
- Invoice # (pyrecnum)
Optional Parameters ​
- Field to return (i.e. "pytype", "dtoc(pydate)", "pycrse"). Field must evaluate to character string.
- Delimiter to place between field (i.e. ", " ,"-",CHR(13) default)
Example(s) ​
GTINVPAID(pyrecnum) returns total paid for specific invoice
GTINVPAID(pyrecnum,"dtoc(pydate)") returns dates of payments to invoice separated by carriage return
GTINVPAID(pyrecnum,"dtoc(pydate)","-") returns dates of payments to invoice separated by hyphens '-'