Client_WIPBalance

Calculates the total WIP balance for the client according to document date selection.

Syntax

Timeinfo ("Client_WIPBalance")

The macro "Client_WIPBalance" returns to the cell the total WIP balance of the current client.

Timeinfo ("Client_WIPBalance",<client number>)

The macro "Client_WIPBalance" returns to the cell the total WIP balance of the client g number <client number> passed.

Example 1

If the current WIP for Adam Smith is $54,500 and Timeinfo ("Client_WIPBalance") is entered in a cell on Adam Smith's statement, then the string 54,500 will appear in that cell.

Example 2

If the current WIP for Test Corporation is $2,500, then entering Timeinfo ("Client_WIPBalance","TEST01") in a cell places the string 2,500 in that cell.

Replaces macro used in previous version: TOTWIP