3305 Main Street Ste 019 Vancouver, WA 98663

TSLookup Examples

General Ledger Examples

Return the title of a GL Account "10-5001"

TSLookup("MASTER_GLM_RECORD_1","ATITLE","10-5001")

Return the balance of the GL Account that is stored in cell B5

TSLookup("MASTER_GLM_RECORD_1","ACRBAL",B5)

Job Cost Examples

Return the description of job "01-002"

TSLookup("MASTER_JCM_RECORD_1_1","JDESC","01-002")

Return the JTD Cost for cost code "1-040" under job "01-001"

TSLookup("MASTER_JCM_RECORD_3","PJTDC","01-001","","1-040")

Accounts Payable Examples

Return the vendor name for the vendor ID in cell C16

TSLookup("MASTER_APM_RECORD_9","VNAME",C16)

Return the paid status of invoice 8192 for vendor 702.

TSLookup("MASTER_APM_RECORD_1","OISTAT","702","8192")

Accounts Receivable Examples

Return the name for customer "NM1"

TSLookup("MASTER_ARM_RECORD_1","CNAME","NM1")