GTINVPAID

Returns total amount paid for a specific invoice.

Reporting Area(s):

Invoices, Accounting

Required Parameters:

1. Invoice # (pyrecnum)

Optional Parameters:

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

Notes:

Available only with Company Invoicing module

*In the Pay table pyinvpaid field is how the current payment is linked to a specific invoice

 

Related Topics