We offer both packaged and bespoke solutions for your Sage Data
Import requirements. As a Sage
Authorised
Professional Developer and a Sage Accountancy Club
Member we understand both the technical and business requirements for Sage
Line 50 Integration.
We can import Invoices, Orders (SOP and POP) and Transactions to all versions of Sage Line 50 from version 8
through to 2007, 2008 , 2009 and 2010 as well as Despatch Express
integration (excluding Sage Instant - for Instant please
email us with your requirements. Sage have announced that Sage Instant v15
will now have Developer Support).
Our proven, tried and tested Transpose product provides the most
commonly requested Sage Importer facilities such as Importing Invoices and
Orders into
Sage in one product and also forms a proven base on which
we can quickly build customised Sage Import solutions. Transpose is
very cost effective (£99 - £350) and there are no hidden charges for setup or
configuration saving you time and money.
Over 200 companies currently use our products.
If you need to import Timesheets into Sage
Payroll we have a new Timesheet Importer product that can save
you hundreds of pounds.
Sage Line 50 is an extremely popular choice for many businesses
and there is often a need for web and other developers to get financial
information into Sage Line 50 in a simple and reliable way that meets the customers
requirements. Transpose provides all the Sage Importer facilities you are likely
to need to import Product and Service Invoices, Orders and Transactions from Excel, CSV or
Database files and includes Sample Import files that use the Sage Demo Data so you can
be running a test import within minutes of installation.
Transpose can also Export Sales, Supplier,
Invoice, Order and Product information including Memos
We offer free initial guidance to help you to
understand the various ways in which data can be imported and exported , how Sage Line 50 treats the
different types of imports and the best solution for your needs. Please
call on the above numbers or
email for a prompt and (hopefully) helpful reply.
Above all, Transpose is easy to implement,
competitively priced and
very straightforward to integrate with other systems.
Like John Lewis, we guarantee you will not find a
better price on a like for like basis.
If you are looking for support information on
common Sage Line 50 problems check our
Sage Performance page.
Click here to calculate your potential Cost Savings when using Transpose
Demonstration Videos
Download a wmv file
showing Transpose in use. It shows 2 invoices being imported, each with 3
item lines. The first invoice uses prices set in the import file. The second
picks up pricing from the Sage Product Records and applies the Price List set
for the Sales Account. It then re-imports the same file to show how Transpose
validation can be used to prevent duplication of imported data.
This video shows a basic Sales Invoice import using the standard Sage Import
format. Transactions are grouped together by Invoice number.
Click here to
view an example Microsoft Access / VBA procedure that demonstrates how to run
Transpose from another program.
Click here to view
code that demonstrates how to run Transpose from within an Excel spreadsheet to
directly import Excel data to Sage.
Transpose Importer Overview
Transpose is a packaged solution designed to import transactions into Sage Line 50
from CSV files. (most applications, including Excel, can save files in CSV
format).
Transpose can also import via XML files and import directly from
Database Tables in a variety of Databases including MySQL, Access and SQL
Server. Sage Data can also be Exported in XML format
Transpose supports most transaction types including
Sales Orders, Sales Invoices and Credits, Payments On Account,
Purchase Invoices, Purchase Credits,
Stock Invoices
(with stock level checking), Project Records
and Foreign Currency.
Transpose is very flexible and can import as Audit File
Transactions with grouping or as Sales Invoices or Orders.
Transpose also
imports Customers, Suppliers, Stock, Stock Transactions and Project Costs
and can Export in XML format. Sage Accounts, Product
and Projects can be automatically created on Import.
Transpose can be run from the Command Line allowing
simple integration with other applications such as Access, Scripting languages
and ASP. The Command Line option can
additionally be used to get information from Sage such as an Account Balance or
a Stock Level.
Audit File Transaction Import
This option uses the same import file format as Sage Line 50.
Many applications support this format as standard, so this is a good choice if
you can't change the import file format. Unlike the Sage Line 50 Import
function, Transpose will group transactions with the same Invoice Reference and
Date together so that they appear as a single line on a statement.
Transpose will also ensure that the same transactions are only processed once.
This type of Sage Data Import is normally used when the actual Invoices are not created in
Sage and you just need to get the details into the accounts.
Alternatively, the transactions can be imported as Sage
Product Invoices using a stock code of S1. This option would be used where you
want Sage Line 50 to create the Invoices and is most useful if you are not able
to change the import file format.
Project Records and Foreign Currency imports are also
supported.
Transpose can also automatically allocate Credits and Payments
to matching Sales and Purchase Invoices
Sales Invoice Import
This option uses a slightly different import file format and
can be used to create Sales Invoices and Credits as if they had been entered via
the Sage Line 50 Invoicing module. Invoices using Stock
or Special items can be created. Sales and Purchase Orders
may also be created.
Details such as the Stock Item Description and Address can be
taken from the Import file or directly from the Sage Stock Item. VAT amounts can
be supplied or calculated by Transpose. The Invoice Number can be generated by
Sage or taken from the Sage Import file. Transpose can also use Sage Price Lists
to automatically generate the Best Price for a Customer and automatically create
Account and Product records..
Foreign Currency and Project Records
Transpose supports Foreign Currency imports for Sage Line 50
version 12 onwards.
Project Records are supported from Sage Line 50 version 11.1
onwards. A Project Reference, Cost Code and Resource can be specified for all
appropriate import types. If you are familiar with Line 50, you will know that
it is not currently possible to import transactions with project references via
the Line 50 import routines. Transpose provides the solution. The latest version
also supports importing Project Charges.
Full Import Mapping
Transpose allows the input files to be "mapped" to the
required import fields. This means that a file in virtually any format can be
imported into Sage Line 50 without having to change the application that generates the file,
saving time and money. Transpose even allows special values such as nominal
codes or transaction types to be inserted on import so that the correct Sage
Import settings can be used even if they aren't present in the input file.
Transpose can also use Look Up Tables to cater for differences
between applications. For example, Account References can be "mapped" (i.e.
Account "FRED-01" can be mapped to "FRED01") or a value of "Taxable" could be
converted to the expected Sage value such as "T1"
An offset to the Invoice reference can also be added if the
numbering systems differ.
No Hidden Costs
We don't charge extra for telling you how to set up Transpose
and site visits are very rarely required. The latest versions of Transpose
automatically installs sample import files that use the Sage Line 50
demonstration data. You should be able to run a test import within minutes of
installing Transpose.
Transpose is very competitively priced and offers more
functionality than most similar products. All Transpose features are available
in the Standard product (no extra costs), multi company support is standard and
Transpose is licensed on a per site basis. We also offer
special pricing to developers wishing to use Transpose to integrate with Sage
Line 50. For pricing information click here.
Need to do something different?
We can also customise the application to meet any specific
processing requirements that you may have.
If we can readily
accommodate your needs this may be a no cost option. Please let us know
what you want to achieve and we will do our best to help.
We also can help in uploading Sage data to your application.
Any or all of the fields from Invoice, Orders, Header Transactions, Customer, Supplier and Product records can be
exported in XML format.
Recent Projects include importing Bill of Materials (BOM)
Product Records with automatic Stock Transfers to build the BOM Product and
enhanced processing of BACS payments.
Sometimes this part of a development project can be overlooked
until late in the day. Call us, we may be able to help.
Still not sure?
Try the free download or just give us a call for a free, no
obligation discussion. If your requirement is complex or you are not familiar
with Sage Line 50, we can arrange an on site meeting with our developers
and our Accounts specialist to clarify your needs, but please note this may be
chargeable.
Transpose is used every day by a wide variety of clients and
applications including Web Shops, Visa Processing, Event Management, IT
Solutions Providers, Recruitment Agencies, Property Developers, Shipping
Companies, Metal Finishers, Greeting Cards suppliers to name but a few.
We are pleased to announce that Transpose has been selected by
the biggest processor of travel bookings in the world to integrate their systems
with Sage 50.
Transpose Features & Benefits
| Imports Sales Stock and Service Invoices, Orders and
Purchase Orders including Proformas and Quotations. |
√ |
| Imports Audit File Transactions with Full Grouping of
Item Lines. Transactions with the same Reference appear as a single line on a
Statement. Supports most Transaction Types including Journal Credits and
Debits. |
√ |
| Automatically allocate Payments and
Credits to matching Invoices (new feature) |
√ |
| Automatically generate a Sales Receipt
for an Invoice (new feature) |
√ |
| Net Value Discounts on Invoices and
Orders (new feature) |
√ |
| Import Accounts, Stock Records, Stock Transactions,
Project Charges, Sales Memos and Delivery Addresses. Stock Record import fields include
Quantity Discount Fields, Custom, Web and Purchase Nominal fields with
optional Stock Level Update. |
√ |
| Import from CSV, XML and directly from Database
Tables in Access, SQL, MySQL and any DB that you can specify a DSN for. |
√ |
| Automatically download XML and FTP files
from Web Servers |
√ |
| Import Data fully validated to ensure no duplication
of Import transactions |
√ |
| Import File field mapping means a CSV file in
virtually any format can be imported without modification. |
√ |
| Import Map Filters allow only specified
records to be imported thus allowing selective import of, for example,
PayPal Payment records. |
√ |
| Automatically create Sales and Purchase Accounts, Stock Items and
Projects on Import (no separate import files required) |
√ |
| Best Price option uses Sage 50 Price Lists to
automatically generate Unit Price for Customer or Supplier with Foreign
Currency support. |
√ |
| Optionally apply Settlement Discounts to
Import |
√ |
| Sales Account, Addressing and Stock
Details can be taken from Sage or the Import file |
√ |
| Account References can be automatically changed on Import i.e. SBS-01
becomes SBS01 |
√ |
| Automatic Net and VAT calculation if required |
√ |
| XML Export of Invoices, Sales and
Purchase Orders with Item Lines, Product,
Customer and Supplier Records, Nominal, Memos, Aged Balances and all Transaction Types with
Splits. |
√ |
| Full support for Foreign Currency and Project Charges |
√ |
| Multi Company Support |
√ |
| Multiple installations on same machine |
√ |
| Supports new Sage Departmental References |
√ |
| Option to Build BOM Items (contact us for
details) |
√ |
| Automatic Detection of Import File Type |
√ |
| Unattended Mode automatically imports to Sage Line 50 |
√ |
| Royal Mail Despatch Express Label
Printing support
We also have a standalone Despatch Express Interface |
√ |
| Silent Mode allows Transpose to run
"invisibly" in the background |
√ |
| Can be controlled via Command Line allowing Import
and Export on
Demand from other applications |
√ |
| Command Line Switches allow Sage "Enquiries" i.e.
Transpose can
return the status of an Invoice, Free Stock, whether an Account exists,
Project Status etc. The Path to the Sage Data files can also be
specified by command line allowing import to multiple Sage Companies. |
√ |
| Built in Editor for ease of viewing and editing of Import files. |
√ |
| Email Notification of Import Success or Failure |
√ |
| Comprehensive Logging
and Reporting |
√ |
| Sage 50 does not need to be closed to run an Import |
√ |
| Works with single user versions of Sage
50 (from version 2009). You don't need a multi user Sage license to run
Transpose at the same time as Sage. |
√ |
| Sample Sage Import Files included to shorten
implementation time. |
√ |
| Save time and money - Normally no changes are required to
the application that generates the import file. |
√ |
| Cost Effective Customisation Service |
√ |
| Sage Professional Developer with In-House Accounts
expertise to advise on your
requirements |
√ |
* Some new features require a later version of the Transpose
program file. Contact us for details.
Newsletter
If you would like to be kept informed of new developments with
Transpose and our other products please
click
here to register. or click here to view the
latest edition.
Help & Support
We want to do everything we can to assist you during the
installation and evaluation of Transpose. If you have any questions please
contact the developers directly by
clicking here.
We also appreciate any comments you might have (good or bad!). If we don't know
about it, we can't fix it.
Version 2.0.16 Revision 8 is the current release as of
February 2008.
To download a trial copy select
the version of Sage Line 50 you have from the list below. You will need to unzip
the downloaded file and run the setup program to install Transpose.
Please note that Transpose installs in Test Mode which
validates Import Data but does not actually post the import data to Sage Line 50.
Use the Settings -> Import Parameters to turn off Test Mode when you are ready
to post data.
Windows Vista - Transpose runs on Vista. You will need to
configure some program settings (Transpose must be setup and run as
Administrator), please contact us for details. A configuration guide will be
available shortly.
Sage Line 50 Updates
You must ensure that all service Packs and hot fixes are
applied to your version of Sage Line 50. Do not assume that the patches have
been applied
To check for Sage updates please visit
http://www.sage.co.uk/updates/line50.aspx
Current Version Downloads
To download the latest program updates
click here
Sage Line 50 Version 2007 updates
If you have applied the Sage Line 50 2007 updates you will
also need to download the latest sdo engine
(dated 01/03/2007). This file needs to be copied to the Windows\System32 folder and
registered using Regsvr32. Please note that Sage have changed how Departments
are referenced in Sage 2007 onwards.
Sage Line 50 Version 2008 update
Sage have released a hot fix on the 12th October 2007 which
must be applied if you are using any product including Sage Job Costing and BOM
that uses the Sage Data Objects. This hot fix corrects a problem with dual
posting of invoices, orders etc.
On the 25th October 2008 Sage have released another hot fix
for the SDO.
http://www.sage.co.uk/updates/line50.aspx?ID=2008
Sage Line 50 Version 2009
SDO Hot Fix (dated 01/10/2008)
Documentation
See the links below to download the Import File
Structures etc.
Sage Line 50 Updates
You should ensure that all service Packs and hot fixes are
applied to your version of Sage Line 50. Do not assume that the patches have
been applied
To check for updates please visit
http://www.sage.co.uk/updates/line50.aspx
Installation Tips
Important - if you are downloading for Windows XP, please ensure that
you unzip the download to a folder before trying to install. The setup program
will not run directly from a zipped folder.
Please also ensure that you unzip the files to a folder near the root of your
Drive e.g. C:\Download. The Setup program will not install if the path to
the setup files is too long and an error similar to the following will be
generated :-
Sage Line 50 should be installed on any machines you want to
run Transpose on.
Can't Locate the Sage Data Files
during Transpose Set up? Some versions of Sage place the Data Files
in a Hidden Folder. You must unhide the folder during Transpose set up so you
can browse to the Folder Location. This limitation is removed in Revision
8. To view Hidden Folders in XP click on the Tools Menu Option and Select Folder
Options -> View Tab and select the Show Hidden Files and Folders option whilst
viewing the required folder in My Computer / Windows Explorer.
For a new Sage 2008 on Windows Vista the data files will be in
C:\Program Data\Sage\Accounts\2008
For a new Sage 2008 XP installation the data files will be in
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2008\.
Both these folders are Hidden by Default.
The Sage Data files should be excluded from any Anti Virus
Scans. This includes server based scanning engines. Apart from causing general
performance issues with Sage itself (in particular with Norton AV) we have one
reported incident of application crashes caused by McAfee scanning Sage Data
files located on a file server.
Not Posting Data? Make sure you have turned off Test Mode in
Settings - > Import Parameters
Downloaded File Blocked?
Windows may prevent you from extracting or unzipping a file. To unblock the
file, right click on it, select Properties then click the Unblock button and
then Apply
For general Sage performance and configuration information
click here.
SDO Activation Key
Please note that you will need to obtain an SDO Activation key
directly from Sage Customer Services in order to run Transpose more than a few times. This key is
supplied free of charge and must be entered in Sage Line 50 (not Transpose) via
the Tools -> Activation -> Enable 3rd Party Integration menu option.
Sage Customer Services can be contacted on 0845 1116666 (Great
Britain), 0845 2450280 (Northern Ireland), 01 6420863 (Republic of Ireland)
An SDO key is required for all applications that use the Sage
Data Objects (SDO).
You cannot obtain an SDO Key for a Demo
version of Sage 50. This is a restriction imposed by Sage.
Pricing
For pricing information please call on 0771 388 2553 or send
us an
email
How to Order
Just send us an
email with your Purchase Order Number. We will then send you an invoice
together with payment details and a temporary license. Once we have received
payment we will send you a permanent product license. Please specify the Sage
Version you require (i.e. 12, 2007)
OEM
If you would like to brand Transpose with your own identity
please
email us with details of your projected sales and requirements.. Let us take
care of your Sage integration needs and save the cost of Sage Developers
licenses and the need for ongoing upgrades. Every little helps as they say.
Transpose can also be preconfigured using ini files so that al
Import Parameters can be set up in advance.
Sage Trial Versions
To request a Trial version of Sage 50 directly from Sage
use this link
To search Google for more information use the search box below
