Client_ARBalance
Calculates the receivable balance for the client according to document date selection.
Syntax
The macro "Client_ARBalance" returns to the cell the receivable balance of current client.
OR
Timeinfo ("Client_ARBalance",<client number>)
The macro "Client_ARBalance" returns to the cell the receivable balance of the client number <client number> passed.
Example 1
If the current outstanding balance for ABC Limited is $37,600 and Timeinfo ("Client_ARBalance") is entered in a cell on ABC's invoice, then the string 37,600 will appear in that cell.
Example 2
If the current outstanding balance for Test Corporation is $2,000, then entering Timeinfo ("Client_ARBalance","TEST01") in a cell places the string 2,000 in that cell.
Replaces macro used in previous version: TOTAR