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