Tag Name

Data Type

Description

Important Fields:

TLPosted

Text Req

Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row

Posting Settings:

THBankAccList

Text Req, HeadOnly

Filter by Currency and allocate to Bank Account for currency. e.g. List of Currency Code, Bank Account No like ‘GBP,1,EUR,2,USD,3’

THMatchBy^

Text 60 Req, HeadOnly

Match by x when looking for invoice to allocate too in field TLMatch
        In Cell Searching values:Match BY
                  MANUAL, Manual Allocation or URN
                  VALUE, Account Oldest Matching Value
                  REF, Reference
                  REF2, Reference2
                  USER, User defined
                  REFACC, Reference and Account Code
                  REF2ACC, Reference2 and Account Code
                  USERACC, User defined and Account Code

THTolerance^

Integer Req, HeadOnly

Match Tolerance
        In Cell Searching values:Tolerance
                  1, Exact
                  2, Exact and Anything less

THUserDefName

Text 60 Req, HeadOnly

If USER is selected then this cell defines the user defined field name, in table SLPostedCustomerTran, to match on

Receipts Lines:

TLRcRef

Text 8 Req

Set Referance of Receipt. Repeat Ref or 'X' to continue allocation to one recipt

TLRcMatch

Text 60 EOF Req

Use this value to search for matching Invoice, allocate payment to this matched invoice

TLRcPayment

Currency Req

Payment Amount, zeros are ignored

Sales Receipt Fields:

TLRcRef2

Text 30

Set Referance2 on Sales Receipt

TLRcDetails

Text 60

Details. If not specified will be `Sales Receipts`

TLRcTaxCode^

Integer

Tax Code. Make sure the format of the cell is “General” else search may not work properly
    In Cell Searching values in table Tax

TLRcAcCode^

Text 8

Optional, depending on match settings
    In Cell Searching values in table Cust

TLRcPaymentDate

Date

Date paid, blank defaults to today

TLRcProject^

Text 12 Pro

Project Code
    In Cell Searching values in table ProjectCode

Ready Only Tags:

TLInvOut

Double Read

When used in Manual Mode, will be populated with Outstanding amount on Extract

TLInvDate

Date Read

Date of invoice

TLInvDueD

Date Read

When used in Manual Mode, will be populated with Due Date on Extract

TLInvRef

Text 20 Read

Reference

TLInvCur

Text 3 Read

Currency Number

TLInvRef2

Text 20 Read

Reference2

TLInvTransType

Text 60 Read

Transaction Type Invoice/Credit Note

Header:Before Posting:

THBefDisplayMess

Text 60 HeadOnly

If contains value, then this text is displayed, and import cannot take place until this text if clear. Thus you can your own formula, macro or VBA code to stop import until a certain condition.
Validating Transaction before posting

THBefDisplayMessYN

Text 60 HeadOnly

If contains value, then this text is displayed. Asks Yes/No to continue
Validating Transaction before posting

Header - After Posting:

THAftProcessSheet

Text 60 HeadOnly Pro

After posting this sheet, switch to work book with this name, and post that. Allows back to back purchase orders, or multiple company transfers. PRO
Posting multiple sheets

THAftSwitchSheet

Text 60 HeadOnly Pro

After posting this sheet, switch to work book with this name PRO
Posting multiple sheets

Header - After Save:

THAftSavePATH

Text 60 HeadOnly Read Pro

If THAftSavePATH and THAftSaveFilename specified, will save as PATH + ‘\YYYMM\’ + Filename + "_0000.xls". YYYMM can be overridden with value in THSaveSubDirectory cell.
more about saving

THAftSaveSubDir

Text 60 HeadOnly Read Pro

See THAftSavePATH
more about saving

THAftSaveFilename

Text 60 HeadOnly Read Pro

See THAftSavePATH. Example ‘ABAP01’ will save as ABAP01_0001.xls.
more about saving

Import File:

THImportFullName

Text 500 HeadOnly

Full PATH and Filename of the file just imported using the Import button. This is required if you set the directory to move file after posting transaction.
File Import instructions

THImportFileName

Text 500 HeadOnly

Filename of the file just imported using the Import button
File Import instructions