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'")