Client_ARAging120_150

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

Syntax

Timeinfo ("Client_ARAging120_150")

The macro "Client_ARAging120_150" returns to the cell the one twenty to ninety day AR balance of the current client.

Timeinfo ("Client_ARAging120_150",<client number>)

The macro "Client_ARAging120_150" returns to the cell the one twenty to ninety day AR balance of the client number <client number> passed.

Example 1

If the 120-150 day-old receivables for Test Corporation amounts to $900 and Timeinfo ("Client_ARAging120_150") is entered in a cell on Test Corporation's statement, then the string 900 will appear in that cell.

Example 2

If the 120-150 day-old receivables for Test Corporation amounts to $900 and Timeinfo ("Client_ARAging120_150", "TEST01") is entered in a cell on Test Corporation 's statement, then the string 900 will appear in that cell.

Replaces macro used in previous version: ONETWENTYAR