Client_ARAgingOver30

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

Syntax

Timeinfo ("Client_ARAgingOver30")

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

Timeinfo ("Client_ARAgingOver30",<client number>)

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

Example 1

If the receivables over 30 days old for Test Corporation amounts to $18,625 and Timeinfo ("Client_ARAgingOver30") is entered in a cell on Test Corporation 's statement, then the string 18,625 will appear in that cell.

Example 2

If the receivables over 30 days old for Test Corporation amounts to $18,625 and Timeinfo ("Client_ARAgingOver30","TEST01") is entered in a cell on Test Corporation 's statement, then the string 18,625 will appear in that cell.

Replaces macro used in previous version: OVERTHIRTY.