INVSUM

Returns the details for invoices for a particular person.

Reporting Area(s):

Invoices

Required Parameters:

1. Name ID (i.e. nmid, rgid, pyid)

Optional Parameters:

2. Logical .t. only include unpaid invoices; .f. (default) show all invoices.

3. Displays amount Due, Paid or the Balance when passing "Due", "Paid", or "Bal" (defaults to "Due" if left blank)

Example(s):

INVSUM(pyid) returns amount due for an individual's invoices.

INVSUM(pyid,.t.) returns amount for each unpaid invoices for an individual.

INVSUM(pyid,.f.,"Paid") returns amount paid for all invoices for an individual.

 

Related Topics