Import & Export Add-Ons for Sage
Import & Export Add-Ons for Sage 50 & 50cloud
This range of Adept Add-On Tools have been developed to assist with importing and exporting data to and from Sage 50 & 50cloud. They resolve the most common requirements that are not available in the core accounting software and the Sales Invoice CSV Tool has been the most popular Add-On over the last few years.
Choose from:
Address CSV | Customer CSV | Fixed Asset CSV | INV Header CSV | Own Part Numbers | POP Header CSV | Price CSV | Product & BOM CSV | Project Charge CSV | Purchase Order CSV | Sales Invoice CSV | Sales Order CSV | SOP Header CSV | Supplier CSV | Transaction CSV
Sales Invoice CSV
This program will import Sales Invoices into the Sage 50 Invoices and Credits Module from a CSV file, the current best seller in our Add-Ons range.
- Can be used to import data into any field in the Sage 50 Invoice file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- Will import Excel style multi line data into the Service Text field.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Create new template CSV files by selecting fields from a list of available field names.
- Select a delivery address from the customer’s list of delivery addresses by entering its description in a DELIVERY_DESCRIPTION column.
- Export option will load your CSV template with data from your current invoice files.
- In a multi company Sage environment the company that each invoice should be loaded into can be specified in the CSV file.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Transaction CSV
This program can import and export Transactions into the Sage 50 Audit Trail from a CSV file. Unlike the standard Sage 50 importer you can import Donations, set Gift Aid & Small Donation flags so it’s a great Add-On for Charity’s!
- Correctly creates a single header with multiple splits for invoices and other grouped transactions.
- Optionally the column headings in the first line of the CSV file can be used to define the fields that the data should be imported into.
- Export option loads your CSV template with transactions from the current Audit Trail, includes a new export only field TRAN_NUMBER.
- New field HEADER_DETAILS allows you to import the Header Details field separately from the Split Details field.
- Will import SR & PP transactions with auto allocation by invoice number or reference held in any of the invoice’s reference or detail fields.
- Import a Bank Transfer, eBanking payment types and an Invoice and Payment together plus Charity Donations with Auto Gift Aid & Small Donation flags.
- Optionally create new Customer/Supplier records if the Account Ref is not found and monitor a specified folder for new CSV files & import them automatically.
- In a multi company Sage environment the company that each transaction should be loaded into can be specified in the CSV file.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Sales Order CSV
This program will import Sales Orders into the Sage 50 Sales Order Module from a CSV file.
- Can be used to import data into any field in the Sage 50 Sales Order file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- Will import Excel style multi line data into the Service Text field.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Create new template CSV files by selecting fields from a list of available field names.
- Select a delivery address from the customer’s list of delivery addresses by entering its description in a DELIVERY_DESCRIPTION column.
- Export option will load your CSV template with data from your current sales order files.
- In a multi company Sage environment the company that each order should be loaded into can be specified in the CSV file.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Purchase Order CSV
This program will import Purchase Orders into the Sage 50 Purchase Order Module from a CSV file.
- Can be used to import data into any field in the Sage 50 Purchase Order file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- Will import Excel style multi line data into the Service Text field.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current purchase order files.
- In a multi company Sage environment the company that each invoice should be loaded into can be specified in the CSV file.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Product & BOM CSV
This program will import and export Products and BOM Components into the Sage 50 Product File from a CSV file.
- Can be used to import data into any field in the Sage 50 Product file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- Will import Excel style multi line data into the Product Memo and Web Long Description fields.
- Unlike the standard Sage 50 CSV Product import you can import data into virtually every field in the Product file including Web Descriptions, Discount Tables, Product Memo and the BOM.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current product & BOM files.
- A special CLEAR option will allow entire Discount or BOM tables to be cleared with only one column in the CSV file.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Price CSV
This program will import Customer Special Prices, Customer Price List Prices and Supplier Price List Prices into the Sage 50 Price File from a CSV file.
- Can be used to import data into any field in the Sage 50 Price file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- A simple five column CSV file handles most situations.
- The CSV file contents are displayed, along with any error messages, before the import takes place.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current price files.
- The program can be run from a button in the Sage 50 Product Module (dependant on Sage version).
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Customer CSV
This program will import Customers into the Sage 50 Customer File from a CSV file. Unlike the standard Sage 50 CSV Customer import you can import data into virtually every field in the Customer file including the Memo.
- Can be used to import data into any field in the Sage 50 Invoice file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- Will import Excel style multi line data into the Customer Memo field.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Optionally move the CSV file to an Archive folder after it has been successfully imported.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current customer files.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Address CSV
This program will import Addresses into the Sage 50 Customer Delivery Address Files from a CSV file.
- Can import data into any field in the Sage 50 Customer Delivery Address file that is exposed by the Sage SDO.
- The column headings in row 1 of the CSV file are used to define the fields that the data should be imported into.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current address files.
- Import Contacts into the Address File when used with Sage 50 2009 or higher.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Supplier CSV
This program will import Suppliers into the Sage 50 Supplier File from a CSV file. Unlike the standard Sage 50 CSV Supplier import you can import data into virtually every field in the Supplier file including the Supplier Memo.
- Can be used to import data into any field in the Sage 50 Suppliers file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- Will import Excel style multi line data into the Supplier Memo field.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Optionally move the CSV file to an Archive folder after it has been successfully imported.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current supplier files.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Project Charge CSV
This program will import Project Charges and Project Credits into the Sage 50 Project Costing module from a CSV file.
- Can be used to import data into any field in the Sage 50 Project file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- The CSV file contents are displayed, along with any error messages, before the import takes place.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Optionally move the CSV file to an Archive folder after it has been successfully imported.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Fixed Asset CSV
This program will import Fixed Assets into the Sage 50 Fixed Asset File from a CSV file.
- Can be used to import data into any field in the Sage 50 Fixed Asset file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- The CSV layout is easily configured to suit your requirements by using the Sage 50 field names as column headings.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current fixed asset files.
- The program can be run from a button in the Sage 50 Fixed Asset Module (Professional only).
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Own Part Numbers
This program will manage customer’s and supplier’s own part numbers and descriptions.
- Own part numbers can be held for customers, suppliers or both.
- Own part numbers may be entered manually or imported from a CSV file.
- Optionally hold own descriptions as well as or instead of own part numbers.
- High speed searching on words within product descriptions and customer/supplier names.
- An update option will load own part numbers and descriptions into orders.
- The quick update option will only process new orders or invoices.
- An export option will export own part numbers and descriptions to a CSV file.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £300.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Invoice Header CSV
This program will import amendments to existing Invoice headers from a CSV file.
- Can be used to import data into any field in the Sage 50 Invoice Header file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- The CSV layout is easily configured to suit your requirements by using the Sage 50 field names as column headings.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current invoice header files.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
POP Header CSV
This program will import amendments to existing Purchase Order headers from a CSV file.
- Can be used to import data into any field in the Sage 50 Purchase Order Header file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- The CSV layout is easily configured to suit your requirements by using the Sage 50 field names as column headings.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current purchase order files.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
SOP Header CSV
This program will import amendments to existing Sales Order headers from a CSV file.
- Can be used to import data into any field in the Sage 50 Sales Order Header file that is exposed by the Sage SDO.
- The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
- The CSV layout is easily configured to suit your requirements by using the Sage 50 field names as column headings.
- Optionally monitor a specified folder for new CSV files and import them automatically.
- Create new template CSV files by selecting fields from a list of available field names.
- Export option will load your CSV template with data from your current sales order files.
- You do not have to log other users out of Sage while using this Add-On Tool.
- Free 30 Day Trial available.
- Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
Click here for more information
Adept Tools Reseller Program
Are you a Sage 50 Business Partner, Accountants Club member or other Sage Professional?
If so, we have an attractive reseller scheme for companies who would like to resell our range of Add-Ons for Sage 50 & 50cloud.
Email info@adepttools.co.uk for further details.
