�Our Pension contributions are prepared at external sites in excel and we use PostTrans to import the contributions straight in to Exchequer Enterprise saving valuable time and effort." says Laurence Dobney of Caterpillar Pensions Trust Ltd.

Tell me again!

Demonstration video

Prices

Import XML PostTransXML

Basic Version [Prices] [Examples included] [Download]

Allows you to:

	Import/Export/Amend Customer/Suppliers
	Import/Export/Amend Stock
	Import/Export/Amend GL
	Import Transactions SQU,SIN,PIN,POR,SOR,ADJ, and TSH etc.

with General/Date note lines
with Links to external documents

	Bill of Materials
	Update user fields on transaction header/lines after being posted
	Edit Picked Qty and other Fields on Transaction Line
	Quickly perform a basic stock take from file every morning from spreadsheet
	Import Automatic Bank Reconciliation Records from Excel

Professional Version [Prices] [Examples included] [Download]

Allows you to:

Ability to use Lookup Tables for Customer/Supplier/Stock, etc. codes, for easy data entry

Import/Export/Amend Customer/Supplier/Stock Discount Matrix

Import/Export/Amend Customer/Supplier/Multi-Buy

Import/Export/Amend Alternate Stock Code Database

Import/Export/Amend Job, Employees, Time Rates.

Printing/Faxing/e-mail transactions after posting

Order from cheapest supplier based on Alternate code prices

Stock Take Serial/Batch and Multi-bins

Include Serial/Batch and Multi-bins on PIN,SIN,ADJ, etc.

Enhanced Reorder Wizard

Note : This product requires a COM Toolkit Runtime License.

Uses/Benefits:

	Remote Entry Gathering Timesheets, Sales/Purchase Orders from remote users, then import into Exchequer Enterprise Accounting Software
	Buy from the cheapest supplier Use PostTrans to select the cheapest supplier, from the data held within Exchequer's Enterprises alternate code database and discount matrix, to save you money.
	Bulk Transaction Entry Collate multiple Transactions on one spreadsheet to post into Exchequer Enterprise Accounting Software. Such as monthly rent, etc.
	Setting up initial system Great for setting up systems. As PostTrans imports data, it checks the length of any fields and warns if they are over the length in Exchequer Enterprise Accounting Software. To correct simply edit the Excel spread sheet and press the import button again. Export/Amend/Import Customer/Stock records FREE!
	Importing Transactions from legacy systems Simply read text files from legacy systems into Spreadsheet. Optionally manipulate data, in excel, before importing either manually or by using macros or VB Code. Such as adding Cost Centre/Department analysis code
	Maintain Stock Bill of materials Bill of materials for stock items can easily be Exported/Amended/Imported by simply specifying the parent code, subcomponent stock code and the quantity
	Maintain Customer/Supplier Discount Matrix Complex discount matrix, for customer and supply records, can be Exported/Amended/Imported into Exchequer Enterprise Accounting Software very easily.
	Update user fields on transaction lines after being posted Used for importing updated costs , even though transactions have been posted in Exchequer Enterprise Accounting Software
	Quickly perform a stock take every morning from spreadsheet This feature is used by a company who has multiple locations. Each morning, their distributors (setup as a location) submit a current stock levels in a structured text file. This text is read into a spreadsheet, and PostTrans amends the stock levels in Exchequer Enterprise Accounting Software by simply posting a stock adjustment transaction. If new stock codes are contained in the file, PostTrans automatically creates new stock records with the details contained within the file.

PostTrans is an Excel add-in, which enables user to import many different Exchequer Transaction types, such as Timesheets, Sales Invoices, Purchase Invoices, Nominal journals, etc. from external systems. It also provides for the importation of Customer/Supplier Account records and Stock records.

PostTrans Features:

Detailed confirmation is given before importing each transaction. This allows the user to reject errors and amend before importing.

All Rate, Job codes etc. are validated, before importing, and the cursor is moved to any errors that may exist in the imported data.

PostTrans will optionally look up Timesheet defaults before importation and fill in missing details, such as Analysis code, charge out rate and cost rates.

Very quick and easy importation of Customer/Supplier records with warnings of any data which exceeds the field length within Enterprise.

Excel can be used to manipulate the imported data, and display totals, before importation into Enterprise.

Using Excel functionality, the user can add additional data to transactions from external systems

Will convert external Account codes to Enterprise Account codes

The data can be either manually entered into a spreadsheet or imported from delimited or fixed length file format text file. This is optionally renamed *.OLD to stop users re-importing data twice.

PostTrans: PostTrans for IRIS Enterprise Prices

[ About Exchequer Enterprise ] [ Buy a Holiday Cottage ] [ Buy a Vacation Cottage ] [ More Information about Exchequer Software ]

[ Home ] [ Up ] [ PostTrans Prices ] [ Downloads ] [ Common Q/A ] [ CheapestSupplier ] [ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: April 28, 2010