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