INVDETL ​
Returns the details of all invoices for a specified individual.
Reporting Area(s) ​
Invoices
Required Parameters ​
- Name ID (i.e. nmid, rgid, pyid)
Optional Parameters ​
Logical .t. only include unpaid invoices; .f. (default) show all invoices.
Delimiter to place between invoices (e.g. " - "). Default is a line break.
Character return value: fields from pay table to return (e.g. "pyrecnum+' ' - '+dtoc(pydate)+' Balance: '+transform(gtinvbal(pyrecnum),'@$')"). Defaults to "pyrecnum+CHR(9)+CHR(9)+DTOC(pydate)+CHR(9)+CHR(9)+'Due: '+STR(gtinvdue(pyrecnum),12,2)+CHR(9)+'Paid: '+STR(gtinvpaid(pyrecnum),12,2)+CHR(9)+'Bal: '+STR(gtinvbal(pyrecnum),12,2)".
Example(s) ​
INVDETL(pyid) returns all invoices for an individual.
INVDETL(pyid,.t.) returns all unpaid invoices for an individual.
INVDETL(pyid,.t.,chr(13),"pyrecnum+' ' - '+dtoc(pydate)+' Balance: '+transform(gtinvbal(pyrecnum),'@$')") returns all unpaid invoices for an individual with invoice number, date, and balance due.