TSSum Examples

General Ledger Example

Return the sum of the balances for accounts between 10-5001 and 10-5005

TSSum("MASTER_GLM_RECORD_1","ACRBAL","AACCT>='10-5001' AND AACCT<='10-5005'")

Job Cost Example

Return the sum of the balances for categories with a base account of 5002

TSSum("MASTER_JCM_RECORD_4","CJTDC","CCSTACC='5002'")