PostTrans XL Visual Importer: PostTrans Examples
When PostTrans is install, a series of example spreadsheets are loaded to give examples of common types of importation, into Exchequer Enterprise. These can be accessed from "Start >> Program Files >> PostTrans"
PostTrans Training Video:
What is PostTrans video and introduction training
The above video, which has several different chapters, explains how to:
- Import/amend customer records; the same principle is used for all other non-transactional data.
- Importing IRIS Exchequer Transactions
- Design of templates
- Installing PostTrans
Tip : Having completed the above video, you should have a clear understanding of PostTrans design and implementation.
PostTrans Examples for Importing Transactions:
|
Name |
Description |
Blank import |
This template is intended as a basic clean template to start of a new project with. But we would suggest using a template which closest fit your needs if possible. |
Cheapest Supplier |
Order from the cheapest supplier, using price information in stored against the supplier, in Alt code database. more info on order from cheapest suppier |
|
NOM |
These spreadsheets allow a user post Nominal journals into IRIS Enterprise Contra Nom with Jobs >> Post a simple journal, into Exchequer Enterprise, with automatic contra lines Nom with Jobs >> Post a simple journal, into Exchequer Enterprise, with Job Costing information NOM >> Post a simple journal, into Exchequer Enterprise, with different currencies NOM with Credit and Debit Cols >> Post a simple journal, into Exchequer Enterprise, with Traditional Credit/Debit columns NOM in diff cur >> Post a simple journal, into Exchequer Enterprise, with Traditional Credit/Debit columns + different currencies with exchange rates specified on each line. Uses : Automate repetitive Nominal Journals Automate repetitive Currency based Nominal Journals Video : Create Nominal Journals |
NOM with VAT |
Shows NOM’s with VAT on them Uses : Expense claims |
|
ADJ |
This spreadsheet shows how to import stock adjustment information in to IRIS Enterprise ADJ >> This sheet will post a Stock Adjustment for Quantities specified in “In/Out” column. If a location in specified in M3, then will contra to this location Allocate Stock to a job >> This sheet will post a Stock Adjustment for Quantities specified in “In/Out” column. And allocate stock to a job
Help automate repetitive large IRIS Enterprise stock adjustments
Video : Create Stock Adjustments |
|
SQU |
This spreadsheet shows how to import Sales Quote information in to IRIS Enterprise with revision History SQU >> This sheet will post a Sales Quote for Prices/Quantities specified. This sheet also saves to "C:\" + "SS0000003" * "xx.xls" (Your Ref) automatically, as specified in cells N2 and N3. The reference to the saved sheet is then automatically added to the Links in Exchequer. Uses : Quote Revision History Allows detailed information to be stored with quote Demonstrates: General Exchequer notes, Alarmed Exchequer Notes, Automatic Linking to Transaction in Exchequer Enterprise with revision tracking |
Stock Take |
|
|
Timesheet |
This spreadsheet shows how to import Timesheet information in to IRIS Enterprise Detailed Timesheet Import >> This sheet will post many timesheets into Exchequer Job Costing for each Employee and day Summary Timesheet Import >> This sheet imports total hours for each week onto Exchequer Enterprise Uses : Remote timesheet entry. We recommend the Professional version since it display popups for easy code selection, for remote data entry. Video : Create remote Timesheets, using popup lookups |
Transaction Back to Back |
This sheet posts a SOR and then posts a matching POR to raise an order for goods on SOR |
Transaction Back to Back Multiple |
Simplar to above example, but posts POR to different suppliers |
|
Other Transactions Not covered in examples above |
This spreadsheet shows how to import Other types of Transaction information in to IRIS Enterprise. Multi Type >>This example show PostTrans importing different transactions type all in one sheet SOR >> This sheet will post a Sales Order for Prices/Quantities specified into Exchequer. see "Quick Order Pad" as a better example Video : Create Sales Orders PIN >> This sheet will post a Purchase Invoice for Quantities/Prices specified for job. SRI >> This sheet will post a Sales Receipt with Invoice for Quantities/Prices specified. Payment details are entered in H4,H7 and H8. Change cell C3 to PPI for Purchase Payment PPI >> This sheet will post a Purchase with Payment with separate lines. PostTrans will break in to separate transactions when the account code in column E changes value. SJI diff cur >> This sheet will post a Sales Journal Invoice posting to four new accounts with different currencies. PostTrans will break in to separate transactions when the account code in column E changes value or the date in B. PPI from file >> This sheet will post a PPI's for cheques/BACS payment produced in an external bespoke system. A simple file is imported into this sheet to create the journals in IRIS Enterprise SIN from file >> This sheet will post many SIN's. PostTrans will break in to separate transactions when the account code in column E changes value or the date in B.
Cost effective integration into
|
|
Order from cheapest Supplier (Professional version) |
This spreadsheet shows how to Import Stock, Import Stock prices into the Alternative stock codes database, and then use this information to raise purchase orders, to order from cheapest Supplier within IRIS Enterprise. More information To use example you must first import data in "Stock Alt Code DB" and "Discounts" then use "POR Entry" to choose cheapest supplier POR Entry >> Allows user to specify the stock they want to purchase. Then as it is being posted into IRIS Enterprise, the operator can view suppliers, together with prices and discounts given. The operator then select who to purchase from and finally the POR's are raised for stock in Exchequer Enterprise. Discounts >> Allows importation of discounts suppliers may give Stock Alt Code DB >>
Uses : Save money by ordering from cheapest supplier |
|
Import History |
This shows demonstrates some of the rounding problems which may be experienced if importing from an external system, such as importing the history from a redundant accounts package. Uses : This sheet can be used to import Sage Transactional history |
|
Quick Order pad |
This spreadsheet allows a user to take an order quickly, then import it into IRIS Enterprise. Simply enter the account code, and enter the quantities to order in Qty column. You will need to fix the OLE references to allow it to display price, description Demonstrates: Ignore 0 qty, e-mail (Professional version), fax printing (Professional version), General Exchequer notes, Alarmed Exchequer Notes, the use of Exchequer OLE to get stock Qty free and current prices, Grouping of stock
Uses : Cheap alternative to TeleSales module Remote order entry. We recommend the Professional version since it display popups for easy code selection, for remote data entry. |
WOR |
Example of posting a WOR |
|
Update Lines
|
These sheets were developed to allow transaction fields to updated Update Header >> Example to show how to update transaction header details Update Lines >> This Sheet allows the user to update existing lines, on un-posted transactions, within Enterprise. It simply loads the specified Transaction, then searches for the Stock Code within the Transaction. If it exists then updates the Specified fields. If the item is not on the transactions then it is added to the Transaction.
Uses : Adjust the time booked to a job on an SOR Pick SOR/POR in daybook
Update TLUsers >> This Template was written to update user fields on each transaction line for a Stock item between two periods. This allowed the customer to post back revised cost, for each stock item, months after the transaction has been posted, for reporting purposes. |
PostTrans Examples for Importing Data:
These can be invaluable when setting up IRIS Enterprise, and maintaining complex data, such as BOM's, Alternate code DB, Discount Matrix, etc.
|
Name |
Description |
|
Customers and Stock |
These spreadsheets allows Exchequer Enterprise Customer/Supplier/Stock records to be imported/extracted/updated, plus the other associated records: Import Cust and Supp >> >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Customer and Supplier database. More information Import Stock >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Stock database. More information BOM >> Allows update/importation of bill of material,
The following are only available in the Professional version of PostTrans: Stock Sup Eq Opp DB>> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Stock superceding, opportunity, equivalent database More information Stock Alt Code DB >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Stock alternative code database More information Stock Discounts >> Allows importation, Account Discounts >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Account discount database More information Account Multi Buy >> Shows how to Import/ament Multi-buy against Account records Stock Multi Buy >> Shows how to Import/ament Multi-buy against Stock records |
|
GL and Bank Rec |
These spreadsheets allows Exchequer Enterprise General Ledger records to be imported/extracted/updated, plus the other associated records: Import GL codes >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, General Ledger structure More information Bank Rec >> Imports data to allow automatic Bank reconciliation |
|
Jobs (Professional version) |
These spreadsheets allows Exchequer Enterprise Job costing records to be imported/extracted/updated, plus the other associated records: Job >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Job Costing database More information Job Analysis >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Job Analysis codes database More information Job Rate >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Job Charge/Cost Rates database More information Job Employee >> Allows importation, extraction, and amendments, to made to the IRIS Enterprise, Job Costing Employee database More information
At present this Job Costing functionality will not Amend or Import data |
PostTrans Examples for Importing Serial/Batch and Multi-Bins:
|
Name |
Description |
Stock Take |
Stock Take Spreadsheet, similar to sheet below |
|
Bins Serial Batch |
This spreadsheets allows shows how to use Exchequer Enterprise Serial/Batch and Multi bins with PostTrans:
see Stock Take for Serial/Batch/Multi-Bins
It is suggested that you:
|