Client_ARAgingOver120

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

Syntax

Timeinfo ("Client_ARAgingOver120")

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

Timeinfo ("Client_ARAgingOver120",<client number>)

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

Example 1

If the receivables over 120 days old for Test Corporation is $2,740 and Timeinfo ("Client_ARAgingOver120") is entered in a cell on Test Corporation's statement, then the string 2,740 will appear in that cell.

Example 2

If the receivables over 120 days old for Test Corporation is $2,740 and Timeinfo ("Client_ARAgingOver120", "TEST01") is entered in a cell on Test Corporation 's statement, then the string 2,740 will appear in that cell.

Replaces macro used in previous version: OVERONETWENTY.