INVSUM ​
Returns the details for invoices for a particular person.
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.
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.