Comtek Accounts : Exchequer Software Enterprise Reseller for Accounting, Telesales, CRM Goldmine, ACT, MicroSoft CRM, Exchequer Plug-ins and Addons
 

         Full list of Exchequer Add-ons
         Interactive Remote Support
 
 
 
 

         Import Bank Rec  

       Edit Line/Header in daybook 
         
 
 
 
 
 
 
 
 
 

PostTrans for Exchequer Enterprise, Easy Importation from Excel

“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

    Downloads

    Update History

    Common Q/A

    Manual/Specification

    Examples included

       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 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

Import PostTrans for IRIS Enterprise Transactions, PostTrans for IRIS Enterprise Customer/Suppliers, PostTrans for IRIS Enterprise Stock, PostTrans for IRIS Enterprise BOM (Bill of Materials) (, PostTrans for IRIS Enterprise Price Matrix, PostTrans for IRIS Enterprise Alternate Code DB, PostTrans for IRIS Enterprise Job, PostTrans for IRIS Enterprise Job Analysis, PostTrans for IRIS Enterprise Job Rates, PostTrans for IRIS Enterprise Employee, PostTrans for IRIS Enterprise Order from cheapest supplier, PostTrans for IRIS Enterprise Enhanced Reorder, PostTrans for IRIS Enterprise Serial/Batch and Multi-Bins, PostTrans for IRIS Enterprise Examples included

[ 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: January 31, 2008