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

Archive by category: Static DataReturn
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:
Sage 200 Customer Price Band Assignments
A PostTrans template can be used to quickly extract your customer list, with any price bands, order value discounts, or discount groups the customers are assigned to. You can you then simply edit those assignments within Excel, and pressed the import button to post back any changes into Sage 200.         Customer Price Band Assignment using PostTrans:    1:00 Open Example Template for editing Customer Price Band Assignment    4:00 How to find more information and Training   ...
Read More
Categories: Static Data | Tags:
Sage 200 Stock Locations/Bins
On Stock Record CreationRequires PRO version of PostTransPostTrans will create a Stock item given the new Stock code, Description and Stock Group.  But in order to be active, Sage 200 needs to create a location to store the stock.  This can be set in system Setup under the “Stock” tab.   Further Location related data can be accessed by using tags.  Tags StCreateLoc,StCreateBin, StCreateMin, StCreateMax, StCreateReorder optionally allow the further location details to be defined at the point of...
Read More
Categories: Sage Line 200, Static Data | Tags:
Sage 200 Stock Price Band Prices (Pro Version)
Sage line 200 stock prices can easily be edited using PostTrans within Excel. Using the example provided “Stock Prices”, you can extract up to 10 price bands at once, into columns, edit the data, and post back any changed stock price values back into Sage 200. The video below demonstrates this, by first extracting whole series of price bands from Sage 200, editing the values, and updating the prices within Sage 200. Standard prices can be specified by entering a X in the cell.        ...
Read More
Categories: Sage Line 200, Static Data | Tags:
Sage 200 Stock Analysis Search Values
Search Categories ValuesRequires PRO version of PostTransTags StSearch1-32 can be specified, to extract/amend or import stock Search Category Values. When extracted tag StSearch1-32 contains the Search Category as defined at Product Group Level. StSearVal1-32 column then contains the values associated with the selected category.Demonstration video      Edit Stock Search Category Values using PostTrans : 0:40 What we are editing in Sage 200 stock record  1:30 Extract Search values, edit import ch...
Read More
Categories: Sage Line 200, Static Data | Tags:
Sage 200 Stock Supplier Prices (Pro Version)
Tags StSuppCode1-5 can be specified, to extract/amend or import stock supplier information. When extracted tag StSuppCode1 contains the preferred supplier, and name. To delete a supplier from the supplier list, simply delete the code in StSuppCode1-5 cell, and press Import. Demonstration Video                                                                                                                                                                                                      ...
Read More
Categories: Sage Line 200, Static Data | Tags:
Alternative Stock Requires PRO version of PostTrans Demonstration Video The video shows how to use PostTrans for Sage 200, to import, or amend stock records, Alternate code database, in Sage 200 from within Excel.         Sage 200 Easily Import/Amend - Alternate Stock Codes Records from within Excel   0:00 Intro   0:33 Product demo   0:50 Extract Stock Records with Alternate Stock Cod...
Read More
Categories: Sage Line 200, Static Data | Tags:
Sage 50/200 In Cell Searching
Often the user is required to enter a code while entering Sage 50/200 data in to a PostTrans template. PostTrans code search allows the user to easily search for that code, by simply entering the start of the code, and moving to the next cell using tab or enter key. If only one match exists then that value is used, otherwise all matches are shown for selection. After selection the code is written back to the cell with it description. CODE, Description PostTrans strips the description off the con...
Read More
Categories: Sage Line 50, Sage Line 200, Static Data, Transaction Data, Common Functions, Fast Orders Entry, Nominal | Tags:
Importing CSV/Fixed file into Sage 50, 200 and Xero
This article explains how import delimited, or fixed length, text file into Sage 50, using PostTrans which has the following advantages: Interactive Data Validation Optional Confirmation before import Print or e-mail transactions after import PRO Import SINGLE file or ALL files from directory Archive file to processed directory after successful import, so use only new files which have not been imported Run batch file before selecting file Easy to use interface for end users, simply press the Fil...
Read More
Categories: Sage Line 50, Sage Line 200, Static Data, Transaction Data, Nominal | Tags:
Clear transaction and copy down formula
Pressing the Clear button on the PostTrans toolbar, clears the sheet ready for data entry. In a transaction based template the Clear button will look at the contents for row 27 and depending on the content of each cell PostTrans will:        “X” - Delete the content of the column from row 30 onwards.        Formula -  Copied down the sheet from row 30 onwards.        Any other value - Copied down the...
Read More
Categories: Sage Line 50, Transaction Data, Fast Orders Entry, Sage Line 200, Static Data | Tags:
Page 1 of 2 FirstPrevious [1]

Blog Categories