I would like to import the information from our database into sageline 50 in order to record the invoice data formally.
(a) i imagine it is possible
(b) do I have to map the fields
or
(c) do I have to rename the fields in access
(d) are there any required fields?
It would be great if you could help!
Thanks
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
importing from microsoft access
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
To get data into line 50 you need to use a third party package or the SDK.
The SDK costs £1500 per year and you call routines to create the types of transactions you want.
http://www.sage.co.uk/partners/home.asp ... tid=139041
The import tool cost £225 it extracts data from and ODBC data source, a CSV file or any sort of text file
If you want more information.
http://www.makingithappen.co.uk/feedback.htm
The import routines only allow very basic import, note that the formats are now different for some versions of line 50.
http://sage.support.makingithappen.co.uk/importing.htm
The SDK costs £1500 per year and you call routines to create the types of transactions you want.
http://www.sage.co.uk/partners/home.asp ... tid=139041
The import tool cost £225 it extracts data from and ODBC data source, a CSV file or any sort of text file
If you want more information.
http://www.makingithappen.co.uk/feedback.htm
The import routines only allow very basic import, note that the formats are now different for some versions of line 50.
http://sage.support.makingithappen.co.uk/importing.htm
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 2 guests