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.