• How to find log in credentials for Sage 50 database

    I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try…
  • Querying Journal Entries - Debit/Credit mismatches?

    I'm working through an export from Simply Accounting into a BI Package. I have a basic query written that flushes out the journal entry - but the debits and credits for the journal entry are not 'netting' zero because of the positive/negative sign.…
  • Alter receipt to show outstanding -DB query help ?

    After all these years the one thing still missing is being able to show customer/remind that there are OTHER invoices still outstanding WHILE entering the receipt which you have to do anyway when funds are received - with NO EXTRA STEP to produce and…
  • Has anyone done a multi-year sql data dump from Sage50 Premium?

    Just as it says. Exact scenario is that the client is switching from Sage50 to an industry specific software and would like to bring in all their transactional history. This is definitely going to require an SQL query across multiple tables and I have…
  • SDKInstanceManager.Instance.OpenDatabase always returning false with no reason why or error message

    I have a C# application that executes a call to SDKInstanceManager.Instance.OpenDatabase to open the data file but it keeps returning false, and it does not give any error message as to why. I have the proper parameters sent because this same data file…
  • RE: How to open a Simply 2010 DB and modify content if possible?

    mis2000 said: I was wondering about what tools are available to open and browse a Simply 2010 DB. Any reporting tool or database client that can connect to data using ODBC. SAP Crystal Reports, Microsoft Excel, Microsoft Query, Microsoft Access, LibreOffice…
  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
  • Any Update on this issue

    Hey Guys, Any update on this issue iv been looking all over the internet for a solution to this issue. I have .net 4.5.2 installed on my machine and the target framework set to 4.5.2 to no avail any other suggestion would be greatly appreciated thanks…
  • MS Query to Sage 50

    I'm trying to query a Sage 50 database ("corpname.sai") from MS Query. I'm on a laptop, so local - no other users. This database has never been on the laptop before, but I seem unable to connect to it for any of a number of reasons. I wouldn't think…
  • Sage 50 SDK Canadian Edition

    is there any complete example about how to create or update a customer and assign the Tax. as it seems to not be possible with the sdk and only with a direct access to Sage 50 Mysql Database Thanks
  • Create/Drop tables

    Is there a way to use the SDK to create or drop a table? I'd like to create a temporary table, then drop it directly in the Sage database.
  • Sage Entrepreneur

    Does any one remember Sage Entrepreneur Edition? I am trying to find it for a client.
  • Inventory out of balance

    I have never used the inventory feature of Sage as I've never had a client that needed it. Now one of my existing clients opened up a small shop. I took all the invoices of the items she purchased and entered the quantity & value of the goods on the history…
  • ODBC connection (MySQL Connector) does not work after Update 2014.1

    Hello, I am using MS Access to connect to the Sage 50 tables via ODBC. Prior to the latest update 2014.1 the ODBC connection worked but now it no longer works. I noticed the MySQL Connector has a different layout now and the Port number is now 13541…
  • RE: Lookup the default invoice number

    Hi Nick_Alpha, Yes, the next invoice number is stored in tCompShr.lInvNum lInvNum Number FT_LONG 4 Next invoice number lNxtPONum Number FT_LONG 4 Next purchase order number lNxtSONum Number FT_LONG 4 Next sales order number lNxtRcNum Number…
  • RE: How to attach the database of sage 50 canadian in my sql

    From Karthik's other posts: " I am developing importing tool for sage 50 canadian. I couldn't find the code in SDK for importing Customer and vendor payments" "need to import customer payment,vendor payment " "I got Sage 50 Accounting SDK to develop…
  • RE: How to attach the database of sage 50 canadian in my sql

    Hi Karthik, As well as what Keith suggested, signing up for the free SDK (it has some documentation, especially dev-datarel.pdf , that you will need) you may find this helpful: http://blog.ijun.org/2010/06/simply-accounting-how-to-connect-to.html…
  • RE: Query for job costing across three databases

    Well, this has proven to be a bit of a wild goose chase so far! I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…
  • ODBC with Access, Release 2014.2

    We're having a problem with an Access database not staying linked to Sage 2014.2 data. I've tried removing all the old 3.51 ODBC connections, but it didn't seem to help. It works for a while, then opening a table or query results in an error 'ODBC-…