• upgrade to Sage 100 Premium (SQL) problem with missing NULL values

    Hello, We just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium. It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields. This is causing…
  • Safe to convert Sage 100 Premium to Temporal Tables in MS SQL?

    Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…
  • Need help getting "Invoice History Printing" data in SQL database.

    Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
  • Unable to create or copy company in Sage 100 Premium version 2018. Databases are not added and 42000 Modify File Failed errors occur

    Good evening. I have tried to create new companies and activate them in Sage 100 Premium. Currently creating a new company does not add a new database. Attempting to activate the company also fails Attempting to copy a company to a new company…
  • Sage 100 Premium 100 SQL and Database Requirements

    We are purchasing Sage 100 Premium 100 SQL version. We will be purchasing a new server (Server 2012). I know little about SQL. My question is, does Sage provide the SQL version we need, or do we purchase it. Would it be Microsoft SQL server? Also…