Stack Overflow
Stack Overflow

Questions tagged [sage-line-50]

Sage Line 50 (or Sage 50) is an enterprise accounting package

Sage 50 Accounts, also called Sage Line 50, is an accounting package by the Sage Group.

28 questions
30
votes
4 answers

Integrating with Sage Financial Software

I have recently been asked to develop an application that will have to integrate with Sage Line 50 financial software. I've done some googling and I am surprised at the lack of info on interfacing with Sage from Java or .Net. Is Sage such a black…
Paul
  • 2,543
  • 3
  • 26
  • 36
7
votes
5 answers

Integrate Sage Line 50 with windows application

I have to integrate C# Windows application with Sage Line 50. (To send all invoice details from application to Sage). I searched on Google and most of the places it says to integrate Sage Line 50, we need to use Sage development kit (SDK). But it's…
mugzi
  • 809
  • 4
  • 16
  • 33
4
votes
1 answer

How to access the product list from Sage Line 50?

I need to pull the product list from Sage Line 50. Is there any way to do this without having to spend £1500 on joining the developer program? I only need to read data, I do not need to put data back into Sage. I've seen the odd mention of an…
djdd87
  • 67,346
  • 27
  • 156
  • 195
3
votes
1 answer

SData Integration with Sage Accounts 50, 2010 release

Sage says that SData is available in Accounts 50, 2010 release onwards. I have this version installed, but when I go to http://myserver.com:5493/sdata/accounts50/GCRM/-/$schema or even http://myserver.com:5493/sdata/accounts50/SDO/-/$schema, (and…
Andrew
  • 702
  • 7
  • 24
2
votes
1 answer

how to query multiple endpoints with curl on sdata web serivce

I am trying make a request query to Sage sdata web service to the following endpoints tradingActivites and receipts as nothing is obvious on these docs I have this so far…
Artful_dodger
  • 698
  • 2
  • 7
  • 26
2
votes
0 answers

Sage Line 50 SQL Query throws column not found error or numeric data is returned

I'm trying to query Sage Line 50 via a .NET app. Connecting via ODBC is working fine. I can open/close the database and run very basic queries but one of my query is slightly more complex and I need to include default hardcoded values but it's…
Thierry
  • 6,142
  • 13
  • 66
  • 117
2
votes
1 answer

Sage Line 50 ADODB connection with Classic ASP on IIS6 - Authentication Failed

We have a classic asp page running on IIS6, which connects to our Sage Line 50 (v17) with the following code: 'Create an ADO connection object Set adoCon = Server.CreateObject("ADODB.Connection") Err.Clear On Error Resume…
DjHexy
  • 51
  • 3
2
votes
2 answers

I am trying to synchronise a Sage Line 50 Access database with Mysql via ODBC

I am trying to source the structure and data from a sage line 50 database but am having trouble with my update/create script. Basically, I am writing a tool so that the local intranet site can display data sourced from sage to normal employees…
David Robilliard
  • 87
  • 1
  • 8
2
votes
5 answers

Sage 50 Accounts Database Schema

I am accessing Sage 50 data via their ODBC Driver but cannot seem to establish if the tables have a unique / primary key. The ODBC.NET Driver does not seem to return any information relating to indexes or key field information. Anyone got any…
Tim
  • 561
  • 12
  • 22
1
vote
1 answer

Retrieving All Payments From Sage Line 50 Database

I'm trying to retrieve a list of all payments received/entered into a Sage Line 50 database. The company I work for are members of the Sage developer program, so I have access to the SDK, help files and the like but I have been unable to find any…
Graham Cuthbert
  • 152
  • 1
  • 10
1
vote
1 answer

Sage 50 ODBC using PHP-SQL state IM002

I'm trying to set up an ODBC connection to connect to Sage. The DSN is set up and works via Access and Excel. However using the PHP code below, I get "SQL state IM002" or "[Microsoft][ODBC Driver Manager] Data source name not found and no default…
Kinfe
  • 305
  • 1
  • 3
  • 14
1
vote
1 answer

Connecting two web application through API using SDK

I have two SDK from Web and Desktop applications, Sage Line 50 SDK and Trackvia SDK, which approach works well to sync these two thank you!
Kinfe
  • 305
  • 1
  • 3
  • 14
1
vote
1 answer

Subquery not working with Access linked tables

I'm attempting to build a tool that pulls information from a database containing financial information, but I've hit a wall with this problem. The following query would give me some of the data I require, but as soon as I add in the sub-query, I get…
user3295060
  • 13
  • 3
1
vote
3 answers

Error with app accessing Sage Line 50 data via ODBC

I've developed a simple C# console based application to pull some data from tables in Sage Line 50, and upload the data to a web server. It uses on ODBC connection on Windows 7 x64, and works perfectly. Sage accounts data is located on a mapped…
Bryan
  • 3,224
  • 9
  • 41
  • 58
0
votes
0 answers

Excel ODBC SQL query does not add empty columns

I try to create data ODBC connection in MS Excel (on Windows) to download data from SAGE using a SQL query via **SageLine50v29 **ODBC data source. I need to create few empty columns for later joins and etc. The simplified code example is shown…
NoobVB
  • 989
  • 6
  • 10
1
2