Office Connector Web Help | Online Help |
TSLookup Examples |
Contents | Index |
General Ledger ExamplesReturn 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 ExamplesReturn 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 ExamplesReturn the vendor name for the vendor ID in cell C16TSLookup("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 ExamplesReturn the name for customer "NM1"TSLookup("MASTER_ARM_RECORD_1","CNAME","NM1") See Also |