• Visual Integrator not importing all rows to SO_Invoice

    I'll probably rebuild this process as a BOI but.... this is just so perplexing I'd kind of at least like tug the thread and see where it leads. Environment: Sage 100c 2021 v7.05 I have an ETL process that brings the invoices in from our mobile invoicing…
  • Windows 10/11 ARM processor and pdf converter

    Hope a community member can help here. I have a few machines that are running the ARM version of windows 11. The sage pdf converter for paperless office does not include a arm version of the driver. I have reached out to both sage and amyuni (the…
  • Sage 100c Premium (SQL) Disaster Reocvery

    I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different…
  • Sage 100 2021 premium slow performance

    Setting up my testing environment (test => prod) and performance is unberably slow. Typing in an item code in inquiry has a multiple-second delay between key presses and seeing letters. Search-while-typing is enabled, as it is in in my live 2018 installation…
  • Quantity on sales order does not match order tab quantity

    Sage 100c Advanced SQL 2018 6.00.5.0 So I think this is happening because of me... Before last year, when we pulled orders on paper, we would take the sales order and move it to invoicing, then key punch all of the backorders on the Sales Order Invoice…
  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
  • ODBC for VI using Access Split Database

    Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…
  • database entry for what user has a sales order open?

    Is there any record made to the database when a user has a sales order open? IE, Sage 100c SQL knows when a user has an order open, since another user cannot also open the same order... but is that information written to the DB or is it only a flag within…
  • non MAS database on MAS server? (Sage 100c SQL)

    Sage 100c 2018 SQL server I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.
  • Changing from Sage 100 to Sage 100c. Activation Keys

    We just changed from perpetual to subscription and I received the emails with the activation keys and unlocking keys. Where do you apply the new Activation keys?
  • Sage 100c v3 PHP Tutorial

    Hello everyone, Is there anyone who would be kind enough to provide us with a tutorial to link Sage 100c (Cloud) v3 to PHP? Thank you.