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 School: Your 25 minute free personal training videos
We have developed a 25 minute training course to give you a complete understanding of how to create your own PostTrans templates to achieve your goals, using our example templates as a starting point.
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 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 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 Enterprise stock adjustments
Video : Create Stock Adjustments |
Match Payments |
Imports Sales receipts and matches them off against an outstanding Invoice See Match Payments |
SOR with Job and Cust create |
This example uses VBA code to make posttrans create a customer, job and then post SOR |
Inter Company Transation |
Demonstrates an inter-company sales an purchase. First we post in a SIN to company 1, and then a PIN into company 2. |
LIVE LOOKUP SQU and stock edit |
Demonstates LIVE searching for account and stock items with Discount Matrix applied pricing.
This contains a special sheet which allows the user to edit stock items, and if they are Bill of material stock items allow you to edit the Bill of materials contained in the build. Allow stock items to be copied. Therefore templates can be created bespoke stock items created by copying existing items and easily editing the stock descriptions. Six lines of stock description automatically wordwrap. As quantities entered the stock price will change according to the stock discount matrix within Exchequer. |
LIVE LOOKUP Stock from matrix |
Demonstates LIVE searching for account and stock items with Discount Matrix applied pricing.
When the account code is entered in the header of the transaction, in this case and SQU, the sheet is populated with any stock items entered with bespoke pricing in the stock discount matrix. This allows for bespoke OrderPad fridge individual customer to be defined within Exchequer, and PostTrans used to create a sin, saw or and SQU. As quantities entered the stock price will change according to the stock discount matrix within Exchequer. |
LIVE LOOKUP Telesales |
Demonstates LIVE searching for account and stock items with Discount Matrix applied pricing.
In the account code is entered in the header of the transaction spreadsheet is populated with stock from telesales history. This does require the stock history/telesales module within Exchequer. As quantities entered the stock price will change according to the stock discount matrix within Exchequer. |
SRI |
Imports a SRI |
SQU |
This spreadsheet shows how to import Sales Quote information in to 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 |
See last section on this page |
Timesheet |
This spreadsheet shows how to import Timesheet information in to 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 New |
This sheet posts a SOR and then posts a matching POR to raise an order for goods on SOR This uses an easier method of producing the B2B POR (add in V7.3.0 of PostTrans) |
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 Video: about Sales Order with Back to Back Purchase Order with auto pick when received |
Transaction Add Lines |
This sheet demonstrates the ability to add lines to a transaction in the daybook, using THAddMatch tag. more in on THAddMatch |
Other Transactions Not covered in examples above |
This spreadsheet shows how to import Other types of Transaction information in to 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 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 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 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 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 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 Enterprise, Customer and Supplier database. More information Import Stock >> Allows importation, extraction, and amendments, to made to the 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 Enterprise, Stock superceding, opportunity, equivalent database More information Stock Alt Code DB >> Allows importation, extraction, and amendments, to made to the Enterprise, Stock alternative code database More information Stock Discounts >> Allows importation, Account Discounts >> Allows importation, extraction, and amendments, to made to the 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 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 Enterprise, Job Costing database More information Job Analysis >> Allows importation, extraction, and amendments, to made to the Enterprise, Job Analysis codes database More information Job Rate >> Allows importation, extraction, and amendments, to made to the Enterprise, Job Charge/Cost Rates database More information Job Employee >> Allows importation, extraction, and amendments, to made to the 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:
|