DNN module 1331

Save time updating

Stock/Product CreationCustomer/Supplier PricesBill of MaterialProject CreationLocation Bins

Simply extract, edit and import

DNN module 1533
XML imports into Sage 50 and Sage 200

PostTrans XML API for Sage 50/200

PostTrans XML for Sage 50/200 monitors a directory, or an IMAPI e-mail address, looking for formatted XML to import. The XML can import Customers, Journals and Transactions. See:

PostTrans for Xero, Sage 50/200 - Excel Addon

PostTrans for Xero, Sage 50/200 is an extremely powerful Excel Extract/Import utility to save time and money. Using its power you can reduce the time taken entering Quotes, Invoices and Orders to create quick and easy OrderPads. PostTrans also helps maintain Stock/Products, Bills of Materials, Prices and Projects through manual input, CSV files, or bulk data edits by extracting the data from Xero or Sage, editing it and importing it back.

Use the power of Excel formulae, VLookups, Data Queries, Macros or VBA to build on PostTrans and deliver cost-effective solutions for your business.

PostTrans links Excel with Xero, Sage 50 and Sage 200
DNN module 963
PostTrans product workflow for accounting systems

Easy To Customize

  • Full Evaluation

    Full product available for instant evaluation in a demonstration company. A subscription can be purchased using a credit card to instantly enable the software on a LIVE company.

  • Online Training

    Online training videos cover how to design your own data entry templates from the many examples included.

  • In-Cell Searching

    Look up associated Xero values such as Products, Customers and Nominal Account codes within cells for easy data entry.

  • Easy Licensing

    Simple licensing, paid monthly per user. Basic and Pro versions are available, and subscriptions can be cancelled online.

  • Ease of use

    Simple to use, with many Excel and Sage examples, help and online training to get you up and running fast.

  • Cost effective

    Use Excel formulae, macros or VBA to create order-entry templates, telesales entry, or sheets customers can use to place Sage orders.

DNN module 917

If its that good, show me... Quick Order Pad

▣   1/2 Quick Sales Order Pad using PostTrans in 30 seconds

0:00Video Introduction
1:10Taking an order in 30 seconds
2:08Rewind for a slower explanation of process
4:00Adding another product to Order Pad
6:50Posting the Sales Order into Sage 50
8:00How to find more information and Training

View the full article on this

DNN module 967Customer comments

Customer Comments

Our customers say great things about PostTrans

Customised Order Entry - We have used PostTrans as our primary data-entry system for over 5 years. It is reliable and fast; allowing our team to process orders through our own customised Excel interface straight into Sage, with additional functionality not available within our core accounts system.

Alex - Krome Ltd

Price Updates - We use PostTrans to update our price matrix in Excel. We simply extract the existing customer special price data, amend using Excel formulae, and post it back into Sage, saving many hours and reducing mistakes.

Toni - Tri Star Packaging

Sales Order Pad with Back to Back Purchase Order - We have a whole order entry system written using the power of Excel and PostTrans. We enter the customer details, take payment, then import a sales order followed by a purchase order to a specific supplier, very quickly.

Ben - AMA Waste Management

Monthly Payments - We use PostTrans to post our monthly pension payments. It makes life easy: manage all payments in one spreadsheet, then post them into our accounts system as purchase invoices against suppliers.

Laurence - Caterpillar Pensions

Management of Bill Of Materials - We use PostTrans to manage our complex bills of materials in Excel and push changes to Sage. Being able to extract, amend and re-import saves us loads of time.

John - PHL Manufacturing

Initial System Setup - PostTrans was invaluable when first setting up our accounts system. It warns about truncated data, removes hidden characters, highlights errors during import and lets the process continue after corrections.

Tim - Salvesens