Browse By Tags

  • ODBC Error using MS Power Query (Office 365)

    ODBC Driver error in Power Query "Unexpected error: Attempted to read or write protected memory..." We are using the Sage 50 v25 32b ODBC driver. The underlying query is "select * from ACCOUNT_STATUS" or specifically when querying date time (tz sensitive…

  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…

  • 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…

  • List of Invoice using API

    Hi, I would like to get all entered invoice into sage 50 accounting. Filter: All / Date range Does anyone have any Idea how to do this?. I'm using Microsoft .Net Framework. Thanks Sandeep

  • How do you keep from having to 'allow access' every time you run your app?

    I have an Application ID and I can start a new session and open our production company, but every time I (or anyone) runs this c# .net app it always says that I have to open Sage and allow access. I open Sage and select 'Always Allow' but we have to do…

*Community Hub is the new name for Sage City