Office Connector Web HelpOnline Help

TSSum Examples
Contents Index

 

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

See Also



Content updated 12/4/2012
Copyright © 2012 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.