Hi , I need to extract data from sage to import into a CSV file , I can do most of it , but just need some pointers :-
I am going to need Delivery address for each order , I assume the Invoice Table ?
also the Customers e-mail address , where is this held , i can't seem to find it.
I assume the customer will be linked to invoice by customer account ref ?
I have got a ODBC connection open with Access so can see all the tables , is there anywhere I can mark an invoice as "shipping label printed" by using an update query ?
Thanks for your help
Sage Newbie !
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
Getting Correct Data from sage for Interlink
-
crazycucumber
- User
- Posts: 2
- Joined: 05 Jul 2007, 13:53
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
You can not update sage via odbc it is one way.
You can update the data in sage by using the SDK at £1500 pa or you can use a 3rd party integration tool like the one we sell for £225
The email address is in the Sales Ledger Table.
ODBC is a bit slow, there are other ways to do things if you need to be quicker.
You can update the data in sage by using the SDK at £1500 pa or you can use a 3rd party integration tool like the one we sell for £225
The email address is in the Sales Ledger Table.
ODBC is a bit slow, there are other ways to do things if you need to be quicker.
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 1 guest