Skip to content

GTINVPAID ​

Returns total amount paid for a specific invoice.

Reporting Area(s) ​

Invoices, Accounting

Required Parameters ​

  1. Invoice # (pyrecnum)

Optional Parameters ​

  1. Field to return (i.e. "pytype", "dtoc(pydate)", "pycrse"). Field must evaluate to character string.
  2. 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 '-'

GTINVBAL
GTINVDUE
GTINVSTAT