IRIS Exchequer Enterprise Plug-ins

Option

Description

Override with OLE CODE in Cell

Use the OLE code specified in cell to determine the company PostTrans will import into.   Also used by Authorise-e to get user.

Transaction Tag Row

This is the row where, when importing transactions, PostTrans will look for tags to identify Exchequer Enterprise fields

Transaction Line Data start row

This is the row where, when importing transactions, PostTrans will expect to find data

Maximum Number of lines

Maximum Number of lines, in spreadsheet PostTrans will read

Delete Markers fount in row

This is the row where, used to identify deletion markers.   More on deletion markers

Option

Description

Use Account 'Alt Search Ref' to match accounts instead of code

When ON PostTrans will convert account "Alt Ref" code to account codes when importing data

Don't enforce Job codes in Job Code Cells

If on then makes user fill in all job codes specified   Turn on for timesheets, etc

Manually Calc VAT (by-pass Exchequer VAT Verification 

VAT will be specified on spread sheet, and manually calc flag turn on for each transactions.  Use with care!

Allow Manual VAT adjustment buttons on Confirmation Window

Note it adjusts whatever VAT code has the highest value.

Ignore 0 qty stock values on Transactions and Zero value on NOMs

This allows a template containing a list of stock codes to be used.  The user can simply enter qty against stock codes they wish to order/stock adjust, PostTrans will ignore any lines with 0 qty.   Used for Simple Order pad using excel

Also works on NOMs for zero credit/Debit values and TSH hours = 0 

Note: This is automatically turned on for ADJ's

The "Quick Order Pad", "ADJ", "Timesheet"  Examples shows this in action.  Click here for more information on PostTrans examples

Video : Create Quick order pads for Telesales operations

Discount as %

Any Discount specified, will be a percentage, else an amount

Write back lookups and defaults 

Write back any values looked from Exchequer Enterprise database.  For Example when importing Timesheets PostTrans will fill in Cost and Charge out rates in spreadsheet if not specified when [Update Lookups] button is pressed

Default Stock location

If Locations is turned on, then use this location if not specified on Transactions.

Don't get extra stock lines from stock record

to stop multiple lines being added from stock record, when using multiple lines on a transaction import  Click here

and break on ","

If ticked then lines are broken up using "," in description line on Transactions

Also effects Stock import too, so Desc1 becomes the 6 lines, separated by ","

[Import CSV File] button Defaults:

Import file directory

When press [Import File] button, use this directory as default.   Click here for more information

Post Filename back to cell

After import post filename to cell.  This can be the Alt Ref field so the transaction can be linked to originating file

File Delimited by

File is delimited by ","

Fixed Length Format (Specified in rows 200 onwards in Defaults Sheet)

If file is fixed length format, format can be specified in "Default" sheet, row 200 onwards

Option

Description

Before Posting Transaction:

Show Confirmation before posting transaction

Turn ON/OFF conformation window.   You may want to suppress this window if importing data which contains multiple Transactions from an external system.   

Note : Credit Check will not be applied if this is turned OFF

Show Cost Centre/Department break down

Turn ON/OFF

Show Job Costing break down

Turn ON/OFF

Show Stock Code break down

Turn ON/OFF

Apply Credit Check

Warn user if over account over credit limit, on stop, see notes, closed.  User can still import transaction but will be on "Credit hold" status

Note : Will only check this if Confirmation is enabled

Do NOT allow negative Stock

If ON will stop user posting stock QTY which will make system go negative

Allow overwrite transaction

Allows user to amend transaction and repost into Exchequer

When posted, PostTrans deletes all existing lines on Transaction, then adds the lines again 

Note : It does not clear notes lines or links when being overwritten

          Will not update TSH/ADJ/SRI/PPY/NOM transactions

          For single Transactions only

The "SQU" Example shows this in action.  Click here for more information on PostTrans examples

Video : Sales Quotes with revision history

If Account Code on Transaction is un-recgonised:

Allow User to change Account Code

Allow User to change Account Code, from within the

Allow user to create account called 'UNKOWN'  

If Account does not exist in Exchequer Enterprise, then create an account using specified account code, but give name "UNKOWN"

Warn before creating new 'UNKOWN' Account

Warn user before creating above account

Option

Description

Operator

When importing a Transaction, stamp with this operator name

else in Cell Ref

Enter here the cell where PostTrans will find Exchequer Operator name

Currency

When importing a Transaction, use this as default currency 1-89

Sales GL Code

When importing a Transaction, use this default GL

Cost of Sale GL Code

When importing a Transaction, use this default GL

Payment GL Code

When importing a Transaction, use this default GL

VAT code

When importing a Transaction, use this default VAT code

Due Days

When importing a Transaction, if not specified then due date is Transaction date +

Cost Centre

When importing a Transaction, use this default

Department

When importing a Transaction, use this default

Rules

"PostTrans Default", "Stock, Account, PostTrans Default" or "Account, Stock, PostTrans Default"

Status

When importing a Transaction, give status 0=Post,1=On Query,2=Unitl Aloc,3=Authorise

Default Stock location

If Locations is turned on, then use this location if not specified on Transactions.

Do NOT set costs automatically on SOR

Read the label on the tin!  (This options was removed in V6.3, as it fills in costs if not specified)

Option

Description

Transaction Type

SIN,PIN,SOR,ADJ...

Customer/Supplier Account:

Customer/Supplier account code.  Ignores anything after ","

Transaction Date

Date of Transaction

Due Date

Due Date if applicable

Your Ref

Subject or description of Fax/e-mail

Alt Ref.

Alt Ref. or Description on TSH/NOM/ADJ Transactions

Unique

This tick box ensures a transaction has not been posted before by checking that the select ref has not been posted against the account before

Ctrl GL Code

Transaction Control GL Code

Year

Normally set automatically 

Period

Normally set automatically  

User 1-4

Transaction Header User fields 1-4

Timesheet Wk/Month

Timesheet Wk no

Timesheet Employee Code

Timesheet Employee Code

Job Code

Default Job Code for all lines.

Analysis code

Default Analysis Code for all lines.  Ignores anything after ","

Option

Description

Default Currency

1-89 (if multi currency system)   Ignores anything after ","

e-mail, if email in cell

2 cell references where the e-mail address will be found in spreadsheet

IN/OUT Location

When posting ADJ, post opposite side to this location

When using Multi-Bins, by using Tag 'BinContraCode' you can specify the new Bin location to move stock IN

When using Serial/Batch items, the serial/batch number will be moved IN to this location

Discount Days

Apply settlement discount after x days

Discount %

Apply settlement discount percentage

Tag No

Tag no of transaction

Intra Stat ...

Intra stat fields.  Intra stat process defaults to N for normal

Daily Exchange rate

Exchange rate of transaction 

Delivery Address 1...5

Transaction Delivery address lines 1...5 

Option

Description

Line 1...25

These cell references allow up to 25 lines to specified which import General Notes.

All of these lines word wrap, so each can be really long.  (chr$(10) or "<br>" gives new line)

Notes line 1 can be overridden on each line of transaction using in Tag "THGNotes"

The "Other Transactions >> SOR" Example shows this in action.  Click here for more information on PostTrans examples

Import Blank Lines

When OFF PostTrans skips lines which are blank.

When ON PostTrans will import lines even if blank, this allows extra information to be posted with a transaction, and printed on an Exchequer Invoice/Order, since we always know the line number of the extra information.

Transaction Header Alarmed Dated Notes

Lines

Line of alarm note

The "Other Transactions >> SOR" Example shows this in action.  Click here for more information on PostTrans examples

User

User for alarm.

Date

Date for Alarm.  If nothing is specified then today's date will be used

Links to external document:

Link1/2

Filename of file including path (84 characters), which is posted as a linked document into IRIS Enterprise.

Link1/2 Description

Description of file

Header Payment details for SRI

Payment GL

Payment line GL code

Note : If this cell is has contents then attempts to use this information for payment line 

The "Other Transactions >> SRI" Example shows this in action.  Click here for more information on PostTrans examples

Cheque No

Cheque No for payment line

Pay Ref

Payment ref, as appears in bank rec

Option

Description

Always to ask to print after posting

If ON, then PostTrans will prompt for printing after transaction has been posted, using IRIS Enterprise form

The "SQU" Example shows this in action.  Click here for more information on PostTrans examples

Video : Sales Quotes with revision history

or e-mail, if email in cell

2 cell references where the e-mail address will be found in spreadsheet

Fax, if fax no in cell

2 cell references where the Fax number will be found in spreadsheet

Tick "Print Hard copy" by default

If ON, then defaults to printing a hard copy

Don't Tick "e-mail" by default

If ON, then printing is un-ticked by default

Subject or Description

Subject or description of Fax/e-mail

Message

Cell reference to body of e-mail text

Override Print/email form

Cell reference, to override IRIS Enterprise default form, when printing and e-mailing 

Print to XML writer, if C/S set to eBix

Will write the Transactions to XML file, for IRIS eBis module to send to Customer or Supplier if set to "XML eBis" on the Customer/Supplier record

or if email in cell

If cell contains "YES" the create XML transaction.  this overrides above if YES

XML written to directory

Write XML transactions to directory.  This should be the same directory the eBis module is using to auto send.

Override Fax form

Cell reference, to override IRIS Enterprise default form, when faxing 

Printer User

This needs to be a valid Exchequer user

Option

Description

Auto save spreadsheet:

Save before and after posting a Transaction

Always force a save of sheet if .xlt

If current spreadsheet is a template (.xlt) then save as:

PATH & FILENAME & "_00.xls" before importing.   This option can be used in conjunction with "Auto Link "PostTrans Template"", to link the transaction to current sheet.

The "SQU" Example shows this in action.  Click here for more information on PostTrans examples

Video : Sales Quotes with revision history

if file exists then ask to save revision

If file already exists then ask user to save a revision.

PATH & FILENAME & "_xx.xls" before importing.  where xx is a count.

PATH

Points to cell containing path to save transaction

FILENAME

Points to cell containing Filename of sheet.   Use a unique reference number

This automatically links current spreadsheet to Transaction when posted, under name "PostTrans Template".   If the spreadsheet is saved as a .XLT (Template, thus protecting the design) then PostTrans will ask the user to save file before posting transactions.

Note the filename, including path should not exceed 84 characters (limit in Exchequer).  PostTrans will validate this.

The "SQU" Example shows this in action.  Click here for more information on PostTrans examples

Video : Sales Quotes with revision history

POR Cheapest Supplier:

Lookup price for cheapest supplier from Alt DB

When turned on this function looks up prices from Alternative DB for cheapest supplier

The "Cheapest Supplier" Example shows this in action.  Click here for more information on PostTrans examples

More information on ordering from the cheapest supplier in IRIS Enterprise

Job Costing Chargeout:

Set Charge Out Rate to Cost Price for Labour

If ticked, then will set Job costing Chargeout rate to NetValue for all lines with a Labour analysis code has Line Type 1 (Labour by default)

Bank GL for Bank Recs:

Bank Account GL

Default Bank Account GL when importing Back reconciliation data.   Click here for more information

The "GL and bank rec" Example shows this in action.  Click here for more information on PostTrans examples

Update Lines:

Use LineNo instead of StockCode

Normally the update lines procedure updates lines by matching by Stockcode, when on it will match by LineNo. 

See Edit Picked Qty and other Fields on Transaction Line

Option

Description

Chain Postings

Warning Validation

If the cell contains text, then PostTrans displays the text as message.  The contents of the cell must be cleared before posting can be made.   The text in cell can be the result of a formula. 

Sheet to Post Next

The name of the next sheet to post, after attempting the first one.  The first sheet must be posted before posting the second sheet.

Write OurRef after Posting

After posting PostTrans writes back the OurRef back to this cell.  This allows the designer to use this ref when posting POR's, to allow "Auto picked when purchase order received"

And add sideways drill link

Other Transaction Ref

This links a POR to the SOR transaction ref.  Thus linking in the sideways drill

Name to put against

Name put against the sideways linking

Auto picked when purchase order received

Sets the Auto pick when the POR is received.

Note : This function has to match off stock codes in SOR & POR.  To allow duplicate stock codes in a Transaction, it also uses TLUser3 to match off relates lines in SOR -> POR.  So map something unique to TLUser3, e.g. Line number, which is mapped on the SOR and POR.

Update Another Transaction after Posting

if cell x has OurRef in it

This allows a previously posted transaction, to have the referance of the transaction just posted, put in THYourRef, THAltRef, THUser 1-4.

Note: THYourRef, THAltRef cannot be updated if Trasaction is a SRI, since it is allocated and the COM Toolkit does not allow update.   Any attempt to update these fields will be ignored.

Save In

Where to put on transaction

Option

Description

Allow printing of unauthorised transactions

Allow printing of unauthorised transactions

POR Authorisation

If set to cell ref, then get the Authorisation limit from cell*

POR Floor

If set to cell ref, then get the Floor limit from cell*

* Setting either of these, will stop PostTrans calling the authorisation module

See: FAQ section of for more info on Authorisation Module

Option

Description

Match By

matched by THOurRef, THYourRef or THAltRef

Bank GL Code

Bank GL to put on SRC

Control GL Code