Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…
We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…
In regards to the design of Sage 100 ERP, does it use a single database and store all data from all modules (CRM, HRM, Payroll, Inventory, MRP) into one centralized database, or does each module have its own own database?
My concern is that each module…