<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a requirement to produce a report from SSRS which combines data from an ordering system with one field from Sage 50 accounts.<br />
<br />
We need to interrogate the sage line 50 database to find the account balance for a particular account and use that figure to show how close the account is to their credit limit.<br />
<br />
I am going to install web services on the server that holds the Sage 50 database and write an ASP script to read the Sage Line 50 database, pull the account balance for each account and populate a table in SQL Server (so I can run SSRS report against it). Not exactly a live feed but a snapshot is better than nothing. <br />
<br />
I need two things:<br />
<br />
1) An example connection string to allow me to connect to the Sage Line 50 database.<br />
2) The names of the database fields that store the account reference (or Sales_Ledger_Id?) and the account balance (so that I can write an SQL statement to pull the data).<br />
<br />
Kind Regards,
</div>
</div>


Hi,
I have a requirement to produce a report from SSRS which combines data from an ordering system with one field from Sage 50 accounts.

We need to interrogate the sage line 50 database to find the account balance for a particular account and use that figure to show how close the account is to their credit limit.

I am going to install web services on the server that holds the Sage 50 database and write an ASP script to read the Sage Line 50 database, pull the account balance for each account and populate a table in SQL Server (so I can run SSRS report against it). Not exactly a live feed but a snapshot is better than nothing. 

I need two things:

1) An example connection string to allow me to connect to the Sage Line 50 database.
2) The names of the database fields that store the account reference (or Sales_Ledger_Id?) and the account balance (so that I can write an SQL statement to pull the data).

Kind Regards,

Need to read sage Line 50 customer account balance

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.

Tax / Financial Software

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.