Menu

Blog

Search

Category

AutoUpdated

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Xero

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Image Alt TextImage Alt Text

Multiple Transactions from CSV file

Xero

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Image Alt Text

Xero

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Image Alt TextImage Alt Text

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Image Alt Text

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

Image Alt Text50 Projects

PostTrans Blog

Why not sign up to recieve news, tips, ideas, training.  Sign up for bi-weekly newsletter.

Blog Search

Install/Upgrade across a network can be facilitated by creating a network folder, for PostTrans 50/200 to use as a central deposit to store the latest version.  On opening Excel, PostTrans will then check this for an upgraded version and automatically upgrade the user with as little fuss as possible.Advantages:Simply upgrade one user session, using download form this siteTest new version under one user sessionEasily publish to network new version, see section below.Each user upgraded with l...
Read More
Categories: | Tags:
Sync Multiple Xero/Sage 50 Companies – Static Data
The following article explains how to configure PostTrans add/update, or keep in sync, Customer and Nominal records in multiple Xero/Sage 50 companies in one operation.  This would work with any other static data, such as Departments, Stock, Projects etc.Simply maintain the data in an Excel/PostTrans template.  Press Import button to update multiple Xero/Sage 50 companies.See also Inter-Company TransferThis article assumes you have an understanding of PostTrans, see online trainingSet ...
Read More
Categories: Sage Line 50, Static Data | Tags:
Remote Purchase Order for Sage 200
Remote Restaurant Purchase Order This sheet can be prepopulated with regular items to be ordered, and sent out to subsidiary Restaurant’s for data entry. The manager of each subsidiary Restaurant can then fill in their requirements and e-mail back to head office. All items with zero quantity will be ignored (Pro Feature). Back at HQ a user simply opens the sheet, in Excel, and presses Import button on the Posttrans Toolbar to import PO’s. The Unit Price column, which can be deleted if not nee...
Read More
Categories: Sage Line 200, Transaction Data | Tags:
Remote Purchase Order for Sage 50
Remote Restaurant Purchase Order This sheet can be prepopulated with regular items to be ordered, and sent out to subsidiary Restaurant’s for data entry. The manager of each subsidiary Restaurant can then fill in their requirements and e-mail back to head office. All items with zero quantity will be ignored (Pro Feature). Back at HQ a user simply opens the sheet, in Excel, and presses Import button on the PostTrans Toolbar to import PO’s. The Unit Price column, which can be deleted if not nee...
Read More
Categories: Sage Line 50, Transaction Data | Tags:
Import Sage 200 Orders from Web Cart Export
Requires the Pro version of PostTransThis article explains how import Web Cart Orders from CSV, delimited, or fixed length, text file into Sage 200.  PostTrans has the following advantages: Data Validation of all data and easy to error correction Detailed Optional Confirmation before import Print or e-mail Orders during import PRO Easy to customise mapping and add custom mappings Archive Order file to processed directory after successful import, so use only new files which have not been im...
Read More
Categories: Transaction Data | Tags:
Import Sage 50 Transactions from Payment/Line Total
Requires the Pro version of PostTransThis article explains how import delimited, or fixed length, text file into Sage 50, using PostTrans which has the following advantages: Interactive Data ValidationFix Rounding Issues – Can automatically round Up/Down a Transaction to match Payment AmountAdd up to 4 extra charges per line for Carriage, Insurance, etc. Optional Confirmation before import Print or e-mail transactions after import Pro Archive file to processed directory after successful impor...
Read More
Categories: Transaction Data | Tags:
Define Sage 200 ObjectStore Builder customisations
It is possible to define customised user defined fields, added to Sage 200 in ObjectStore Builder, in the PostTrans templates:Sage200asset - Asset Sage200cust - CustomerSage200custCont - Customer ContactSage200custDel - Customer Delivery AddressSage200supp - SupplierSage200suppCont - Supplier ContactSage200stk - StockSage200nom - Nominal AccountsSage200manLab - Resource Labour Sage200manTool - Resource ToolsSage200manMac - Resource MachineSage200TransNom - Nominal Journals Header/Lines Nominal J...
Read More
Categories: | Tags:
Troubleshooting – PostTrans Tab does not appear in Excel
Problem: I have installed PostTrans, with no errors, but when I start up Excel the PostTrans tab is not visible. Answer:Review the following may help…Disabled within Excel?The “COM Add-in” may have been disabled in Excel.  To check this, simply go to “File >> Options”. Then on the window that opens select “Add-ins”.  Now look down the list to see if the PostTrans COM Add-in is in the disabled or inactive section: Should be shown as ActivePostTrans for Sage 200: This would ...
Read More
Categories: | Tags:
Sage 200 Transaction Description
When posting a Transaction, PostTrans scans down the description column, posting the lines it reads until it finds 5 consecutive blank description lines.The description is handles in different way according to the data specified.Any text in TLDescription will be word wrapped.  By default PostTrans will use the stock description from the Sage 200 stock items database, and ignore any texted entered in the sheet, unless the “Read Stock Description from spreadsheet” is ticked in Setup.Which in Sag...
Read More
Categories: Transaction Data | Tags:
How Nominal, Cost Centre and Departments are handled in Sage 200
In order to make nominal selection easy, PostTrans for Sage 200 handles the Nominal codes in one of two ways.Option 1 : Nominal/Cost Centre/DepartmentIf a template has just NomCode specified on it, then the Nominal analysis is entered as Nominal/Cost Centre/Department.For Example:Of course the nominal code is easily selected thanks to In Cell SearchingOption 2 : Specify Nominal, Cost Centre and Department in separate cellsThis format is more useful if formulas are use to derive the Cost Centre a...
Read More
Categories: Transaction Data | Tags:
Page 1 of 5 FirstPrevious [1]

Blog Categories