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