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

Sage 50/200 Purchase Order Authorisation
PostTrans can offer a cost affective Purchase order authorisation system for Sage 50 and 200.  The following principle is true for both systems and an example is included with the system.  Simply press help button and type “Auth” in search box. This requires the PRO version of PostTrans. Purchase Order with Authorisation The principle is quite simple.  Each person raising purchase orders (Originator) is given a simple excel template to fill in.   This completed purchas...
Read More
Categories: Transaction Data | Tags:
Sage 200 Stock Discount Groups  (Pro Version)
PostTrans can be used to help edit discount groups, Stock Group Discounts and Stock discounts within Sage 200. The Discount Group structure can be quite a complex beast to manage.  At the top level we have the Discount Group (Assigned to a group of Customers), which is linked to either individual Stock discounts (Qty breaks Discount/Surcharge, Flat Discount, special prices…) or Stock Group Discounts (Qty breaks Discount/Surcharge, Flat Discount) Discount Group – Assigned to a customer, simple...
Read More
Categories: | 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:
PostTrans Registration
PostTrans will start the registration process when ever the Import or Setup button is pressed.  It will contact our server an generate a 30 days evaluation license, which will be restricted to Transaction values imported may be set to 1, 1/3 of the time, and text may have “PostTrans Eval” in it occasionally Importation/amendment of static data will be restricted to 5 records at a time. To Register PostTrans please purchase a license by calling 01945 464854 Please see Prices for Sage Lin...
Read More
Categories: | Tags:
Sage 50 Transaction Product Descriptions
In a PostTrans transaction template, PostTrans scans down the sheet until it finds 5 consecutive blank description lines,and then posts the transaction.  Thus the tag TLDesc is used to detect the “End of File”.Service TransactionsService Invoices can be imported using the Transaction type ‘SSI, Sales Service Invoice’.   This allows allows a simpler import:is imported as:Description of a ProductTransaction type ‘SQ,Sales Quote’, ‘SO,Sales Order’, ‘SI,Sales Invoice’, ‘PO,Purchase Order’...
Read More
Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags:
Page 2 of 5 [2]

Blog Categories