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.
Questions tagged [sage-line-50]
28 questions
0
votes
0 answers
Cannot create a linked server for Sage Line 50 to SQL Server using the 64 bit driver for Sage
I have a Sql Server 2019 Express database to which i want to create a linked server to Sage Line 50.
Now i have installed the 64 bit ODBC driver for Sage Line 50 (see attached Screenshot) and then proceeded to set up the linked server (see…
ChrisAsi71
- 41
- 4
0
votes
0 answers
How to setup Linked Server from SQL Server Express 2019 to Sage Line 50
We have a Sage Line 50 Reports application located on one of our servers. This has been setup on our server as ODBC System DSN (Screenshots attached)
Now Im trying to set up a linked server from this SageLine50 to SQL Server Express 2019 using the…
ChrisAsi71
- 41
- 4
0
votes
0 answers
Sage Line 50 ODBC issues with Python 3
I'm trying to connect to Sage Line 50 ODBC (uk). This works fine if I use Python 2.7 when I change over to 3.7 it will not work bringing up the following error.
pyodbc.OperationalError: ('08001', "[08001] Cannot find all files in data path (0)…
Foxman
- 11
- 3
0
votes
1 answer
Pulling data from Sage Line 50 Cloud
It is June 2018. I have been tasked with architecting a solution to integrate data from SAGE 50 into a web application. The specific task is to pull account credit position data from Sage into the web app so that users of the latter can appreciate…
Vanquished Wombat
- 9,075
- 5
- 28
- 67
0
votes
1 answer
Update posted transaction using SageDataObject220
I am trying to update a field inside a posted transaction.
This is what I have:
Dim oWS As SageDataObject220.WorkSpace
Dim SD As SageDataObject220.SplitData = oWS.CreateObject("SPLITDATA")
SD.Open(SageDataObject220.OpenMode.sdoWrite)
…
Ash King
- 229
- 5
- 20
0
votes
1 answer
Wine / native ODBC integration
I'm trying to connect to a Sage Line 50 database (which is some awful old .DTA format) on a Linux machine. Sage provides ODBC drivers that work under Windows, and approximating the instructions here I've been able to get a DSN setup in Wine using…
themgt
- 1
- 1
- 2
0
votes
2 answers
Using access vba to pass the login via variables to automate the login to Sage Line 50 ver20
So i managed to connect Sage to my access database which is great but every time i close the database and open it up again i have to login again manually is there anyway of storing that data in Access? Be it via a variable or a table because clearly…
0
votes
1 answer
how to query bank activity with sage sdata service
I am looking at sage 50 sdata webservice I am able to list all bank accounts and I am able to list customer bank account ect but I can not figure out how to list the activity of one of the bank accounts say the the cash account.
I am hitting the…
Artful_dodger
- 698
- 2
- 7
- 26
0
votes
2 answers
Import Inventory Item from Excel to Sage 50 using window scheduled task
How can i import Inventory Items from EXcel to Sage 50 or vise versa automatically using Window Task Scheduler or something similar, without using 3rd Party Application?.
Thanks!
KGK
- 107
- 1
- 13
0
votes
1 answer
Forked thread in C# .net App dies inexplicably and without throwing any errors
Firstly, I am sorry if this is quite a vague question, it is quite difficult to explain and quite bizarre and it also does not seem like a particularly specific problem. but I will do my best to explain here:
I have a C# .net application which forks…
Mayb2Moro
- 3
- 1
- 5
0
votes
2 answers
Export data from datafile to excel format
Background:
Our company uses Sage Line 50 as our accounting software. We generate all of our Sales Orders from this program. We also use MS Access 2010 to store order information and generate our internal shop paperwork and packing slips.
The…
prayingmantes
- 155
- 1
- 7
- 19
0
votes
1 answer
Where do I find the expenses data in Sage?
I'm accessing sage 50 via the v16 ODBC driver, and I'm struggling to find the expenses data.
i.e. I'm shown an export which shows things like water bills, phone bills, salary etc, all going out from the company / main bank account
However I dont see…
Codek
- 5,114
- 3
- 24
- 38
-1
votes
2 answers
Is it possible to connect to a microsoft database like sage from a Linux server?
The documentation of sage says this.
You have a Linux Server (Operating system:openSUSE 11.1 + Plesk 9.5) not a windows Server Thus the technical specifications for the Sage Line 50 are not met and cannot be installed on the Server you have.
Sage…
Steven Kinnear
- 412
- 3
- 19