3305 Main Street Ste 019 Vancouver, WA 98663

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