|
|
|
|
Need to import Data into Sage Line 50?Contact us on 0771 388 2553 Import Invoices, Import Orders and Import Transactions to Sage Line 50We offer both packaged and bespoke solutions for your Sage Data
Import requirements. As a Sage Our proven, tried and tested Transpose product provides the most commonly requested Sage Import facilities such as Importing Invoices and Orders into Sage and also forms a proven base on which we can quickly build customised Sage Import solutions. With pricing starting from as low as £220 Transpose is very cost effective and there are no hidden charges for setup or configuration saving you time and money. 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. Transpose Overview
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. Please note that Transpose does not support importing data to Sage Instant Accounts. You will need to upgrade to Sage Line 50 to be able to import data via any SDO based application. Audit File Transaction ImportThis 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 an Payments to matching Sales and Purchase Invoices Sales Invoice ImportThis 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 RecordsTranspose 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 MappingTranspose 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.
Other Import Options Transpose can read import files from any folder on the local
computer or network. The files may be
imported manually, hourly or at a specified daily time.
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. 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
* 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 & SupportWe 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. DownloadsVersion 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 updates please visit http://www.sage.co.uk/updates/line50.aspx Current Version Downloads
Previous Version Downloads
Program Updates for Revision 7 only You should also download the latest zipped version of the program file (transpose.exe). This file should be used to replace the transpose.exe file that is installed using the links above and may contain program enhancements and corrections since the initial release. Please check the "Last Updated" column to determine if you need to download the exe file. Note that the Import File Structures may contain differences between Revisions. If you are an existing user please contact us before installing any updates. This download will not work without the set up package (above) being previously installed. To install the updated program file, unzip the downloaded file and copy it to the Transpose Program folder. By default this will be c:\ program files \ Transpose
Sage Line 50 Version 2007 updatesIf 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 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 |
|
|
| free hit counter |
|
Copyright © 2005 - 2008 Steve Blencowe Systems LimitedLast Updated 13/11/2008
|
Authorised
Professional Developer and a Sage Accountancy Club
Member we understand both the technical and business requirements for Sage
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 and 2009(excluding Sage Instant - for Instant please
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). 
