3305 Main Street Ste 019 Vancouver, WA 98663

TSCount Examples

General Ledger Example

Return the number of records in the New GL Transaction file (the number of unposted entries). TSCount("NEW_GLT_RECORD_1")

Fast Transaction Example

Return the total number of records in the Current GL Transaction file using WHERE technology so you don't have to wait for the entire table to load. TSCount("CURRENT_GLT_RECORD_1","WHERE TACCT <> ''")

Job Cost Example

Return the number of jobs that are in progress. TSCount("MASTER_JCM_RECORD_1_1","JSTATUS='In progress'")