PostTrans for Sage and Excel
PostTrans for 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, Invoice, Orders to create quick and easy to OrderPads (demo below). PostTrans also helps maintain Stock/Products, Bill of Materials, Prices, Projects etc through manual input, CSV file, or bulk data edits easily by extracting the data from Sage 50/200, edit and import back into Sage 50/200 using the power of PostTrans.
Use the power of Excel using Excel formula, VLookups, Data Queries, Marcos or VBA to build on the exceptional power of PostTrans to delivery cost effective solutions for your business to quickly recoup on your investment. see customer comments.
Sage Transaction Import
Sage 50: customised sales/purchase order/invoice entry, product adjustment, nominal journals, purchase order with authorisation, inter-company transactions, sales receipts, expenses and quick order pads
Common Sage/Excel 50 Transactional Uses
Sage 200: sales/purchase order/invoice entry, stock adjustment, nominal journals, purchase order with authorisation, sales receipts, inter-company transactions, expenses and quick order pads
Full quick order entry templates can be easily created utilising Printing and emailing, Ledger drill down and Postcode Address Lookup plus posting into Multiple Companies.
"In-cell code searching " helps the user lookup associated values, such as accounts codes, stock/product codes when entering data. Many values are automatically filled in if not specified, using the Sage business logic you would expect.
Common Sage 200 and Excel Transactional Uses
Automatic Customer and Transactional data using PostTrans XML API for Sage 200 our un-attended XML importer
Extract, Amend or Import Sage Static Data
Sage 50: Asset, Customer / Suppliers, Products, BOM's and Manunfacturing, Product Category, Prices, Alternative Stock Codes, Stock Analysis Search Values, Departments, Nominal Budgets, Projects, Nominals, Currency etc.
Common Sage 50 and Excel Uses
Sage 200: Asset, Customer / Suppliers, Stock, Warehouse Bins (including Stock Take), BOM's and Manufacturing, Alternate Stock Codes, Stock Analysis Search Values, Price Matrix, Price Price Bands, Supplier Prices, Locations, Nominal Accounts, Projects Structure inc Title, Budgets etc.
During import, new or amended data, PostTrans will report back any errors in the data, including text fields which are too long, allowing corrections to be made from within Excel, before re-imported into Sage 50/200.
Common Sage 200 and Excel Uses
Examples: Many Excel examples are included for Sage 50 or Sage 200 with links to blog articles and videos which explain the functionality
Full Product Demo: PostTrans for Sage 50 Full Demo and PostTrans for Sage 200 Full Demo at the comfort of your desk.
Online Training: Two 30 minutes on-line training videos explain the basics of Excel to Sage template design, and numerous blog articles explain specific areas.
Trial: PostTrans can be easily evaluated with Sage Demonstration data. Download for Sage 50 or Sage 200
Prices: Prices for Sage 50 and Prices for Sage 200
Any other questions? Contact us with question or pickup the phone and dial 01945 464854.
Want to be a Reseller? or promote the software and get commission. Sign up as a reseller