• How knowing your version can help save time setting up your database

    Did you know that Sage 50--U.S Edition version 2020 and later use Actian Zen for the database engine, while versions 2019 and earlier use Pervasive? Head over to our article on how to troubleshoot the installation of your database to find out more!
  • Sage 2023 - Serious flaw in current release. Need fix right away.

    Based on the multiple experiences I'm reading here about 2023, it is clear that there is a flaw with this release. After working with support for almost 10 hours, we've come to the conclusion that it is not our network or environment. The database itself…
  • Did you already purchase Sage 2023 because of the "third-party database" issue and are disappointed that the 50% off deal only showed up today?

    Survey: Did you already purchase Sage 2023 because of the "third-party database" issue and are disappointed that the 50% off deal only showed up today - seven months after the issue arose? We Did. Unless we missed an email somewhere along the way…
  • Connection to the Sage 50 Accounting 2018 Database

    Good morning everyone I would like to know if it is possible to make a connection to the Sage 50 DB, I currently have the US 2018 version. The reason is because I would like to be able to get information with a separate development and if it is possible…
  • Actian GUID fields and Entity References

    Hello, I've written two programs that work together to generate real time reports out of Sage 50c. One program uses the SDK to create, update and delete data in Sage while the other uses ODBC to make sure the report data stays up to date. It's working…
  • Prevent local copy from being saved?

    Hi all, I'm a computer technician at a community college that uses Sage 50 2017 presently in the classroom. I'm new and the previous technician kept no notes on the specifics of how Sage 50 should be installed which could be my issue. I needed to reinstall…
  • Importing and Exporting using .NET API

    Hello Everyone, I am having trouble figuring out how to import and export to and from Sage 50 Quantum using the US SDK. I have gone through several of the sample apps and I am just not seeing how things are transacting. I want to import CSV files in…
  • Sage sdk singleton error

    FormerMember
    FormerMember
    Hi, We use the sage sdk framework for a tool who works well, but for 90% of installation case, we have a "Sage.sdk.singleton" during the connection process. In local, we can bug fix this by reinstall Sage. but for our clients, that's more complicated…
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
  • Query Sage 50 database and extra basic inventory information

    Can someone provide a general SQL script/statement that I can use to extra basic inventory data from the Sage 50 Accounting (2016) database? All I really need are things like the part number/Item ID, description, Active/Inactive, and price levels (price…
  • Sage 50 Accounting database table layout?

    I've asked a similar question earlier regarding the database layout/design and got a piece of code from someone (which I will paste below). This piece of code gets the Shipping info, the order number, and other info. What I'm looking for is how to get…