ComTek Accounts

Where Are we?

Full list of Exchequer Add-ons

Interactive Remote Support

Pay us by Credit Card

Remote Ordering Via PDA

Reps taking customer orders

IRIS Enterprise CRM Links

Master Link for Goldmine

Master Link for ACT

Prices, Download

Common Support Q/A

Enhanced TeleSales

Enhanced TeleSales

PostTrans, XL Importation

About PostTrans

Import Transactions

Stock take Batch/Multi-Bins

Import Customer/Suppliers

Import Stock

Import Price Matrix

Import Bill of Materials

Import Bank Rec

Import General Ledger

Import Price Matrix

Import Alternate Code DB

Order from Cheapest Supplier

Edit Line/Header in daybook

Enhanced Reordering

Prices, Installation, Download

Licensing, System Setup, Lookups

Common Support Q/A, Examples

XML importation

About PostTransXML

Data warehouse MS Access/SQL

Reporting in MS Access/MS SQL

Other IRIS Enterprise Enhancements

Notes Plug-in for Popup Alerts

Statement Filter

Order from cheapest Supplier

Auto Maintain Price Matrix

Distribution route planning

Pick all on a WOR

Prioritised bespoke picking list

Hide Stock Descriptions

VAT report by Cost Centres

Produce Stock control

Stock Consignment module

Training

Fixing OLE Referances

Other Software

Online Backup Software

Postcode Address Lookup

UltraVNC Single Click

IRIS Enterprise - Import Job Employee records using PostTrans

This is only available in the Professional version of PostTrans

Demonstration Videos

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

Extracting Job Employee Costing Data from Exchequer Enterprise

To extract Job Costing data press [Update Lookups], on the PostTrans Toolbar. All employee data will written to the spreadsheet:

Exchequer IRIS Enterprise Employee Job Costing criteria

Amending the Exchequer Enterprise Job Employee Data

Having extracted data, the user can now simply edit the IRIS Enterprise data, before re-importing it back to Exchequer Enterprise.

Importing new Exchequer Enterprise Job Employee Data

Simply add new lines to the spreadsheet from row 3 onwards. Then press [Post Transactions], on the PostTrans Toolbar, to import Exchequer Enterprise data.

Restrictions

At present the COM toolkit does not give access to QS Code. Therefore PostTrans cannot import QSCodes on to Job record

Tag Name	Data Type Length	Description
Required (Prof version):
JobEmpPosted	Yes/No	Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required)
ErrorDesc	Text	Description of error posted back if record unsuccessfully posted
EmployeeCode
EmployeeType	Integer	Production,Sub Contract,Overhead
Name	Text 30	Employee Name
Identifiers:
SupplierCode	Text 6	Supplier Ledger
PayrollCode	Text 10	Payroll ID
TimeSheetRules	Integer	GOJ=Global Own Job,O=Own Only,GJO=Global Job Own,J=Job Only
Address:
Add1	Text 30
Add2	Text 30
Add3	Text 30
Add4	Text 30
Add5	Text 30
Other:
Phone	Text 20
Fax	Text 20
Mobile	Text 20
NINumber
Defaults:
CostCentre	Text 3
Department	Text 3
CIS Tax:
CertificateType	Integer	N/A,4=CIS4,5=CIS5,6=CIS6
GroupCertificate	Yes/No	Yes if Group Certificate
CertificateNumber	Text 10	Certificate number
CertificateExpire	Date	Expire date
SelfBilling	Yes/No	Yes=Subcontractor Timesheet to create invoice
LabourViaPurcahseLedger	Yes/No	Yes if all time to go through Purchase Ledger
User Defined:
User1	Text 20
User2	Text 20
User3	Text 20
User4	Text 20

[ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: August 18, 2006