Postcode Programming API  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
NOM VAT Inclusive – Shows posting with inclusive VAT

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


Uses : Move Demo stock to and from a VAN location easily.  

          Help automate repetitive large Enterprise stock adjustments

Allocate stock to a Exchequer Enterprise  job

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.

Quote Revision History
Therefore a user can open a template, create and post a quote into Exchequer, this spreadsheet could hold a wealth of other information regarding the quote or job. The Quote spreadsheet can easily be access from the Links button in Exchequer, and the quote can then be modified and reposted. PostTrans will then save a new revised copy of the quote, with a new link to quote template. 

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

Video : Sales Quotes with revision history

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
Uses: Back to Back ordering

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
Uses: Back to Back ordering

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.
SRI from file >> A series of lines to represent a sale, stall rent at a show, which posts payment line also.


Uses : This allows an external system to create a simple file, which can be easily imported into Exchequer

          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.

Video : Create Quick order pads for Telesales operations

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
          Fill in the finished Issue figure on an WOR, therefore a whole batch of WOR's can be finished

 

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:

1) Import Stock, via “Import Stock” sheet.   This includes Exchequer Enterprise Serial/Batch and Multi-bin stock items
2) Purchase the stock, via “PIN” sheet.  This creates stock levels within Enterprise
3) Optionally stock take, via “Stock Take” sheet
4) Optionally Sell stock, via “SIN” sheet
5) Optionally Adjust stock, via “ADJ” sheet