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.
A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11
While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert
"The database login…
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…
Hi,
I am looking at our backend tables and I am trying to determine what user did what.
In our worktickets I see UserCreatedKey and UserUpdatedKey but I cannot find a table that links those to the employees table.
I read that they might be stored…
I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day.
Pulling FULL tables…
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…
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.
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…
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…
We have Sage 100 Advanced (MAS200).
Sage 100 Premium has a sql database. My very general question is "why would someone choose Premium over Advanced?
What advantages does have Sql provide over not having sql. Aside from reporting speed, does it offer…
We have Sage 100 (MAS200) with providex database. We are thinking of getting a sql based version of Sage whether than be 100 or 500.
My question is very general. It is generally accepted that having an "open database" is superior to a Proprietary. Am…
