Browse By Tags

  • Looking for a Microsoft Power App expert

    Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • 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…
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    Hi, I've been working on automatic registration of transactions for Bill of materials. but I've been encoutering this issue for a couple of days now. its been throwing me an error that says "Invalid or missing posting date encountered" I opted…
  • BM Production register Error "The register must be printed prior to posting"

    Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…
  • BM ProductionRegister - New object error:200

    Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…
  • 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…
  • 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…