Client_ARAgingOver150

Calculates the over 150-day receivables balance for the client according to document date selection.

Syntax

Timeinfo ("Client_ARAgingOver150")

The macro "Client_ARAgingOver150" returns to the cell the over-150-day AR balance of the current client.

Timeinfo ("Client_ARAgingOver150",<client number>)

The macro "Client_ARAgingOver150" returns to the cell the over-150-day AR balance of the client number <client number> passed.

Example 1

If the receivables over 150 days old for Test Corporation is $1,200 and Timeinfo ("Client_ARAgingOver150") is entered in a cell on Test Corporation's statement, then the string 1,200 will appear in that cell.

Example 2

If the receivables over 150 days old for Test Corporation is $1,200 and Timeinfo ("Client_ARAgingOver150", "TEST01") is entered in a cell on ABC Limited's statement, then the string 1,200 will appear in that cell.

Replaces macro used in previous version: OVERONEFIFTY.