Sage 100

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…

In Sage Intelligence Reporting we frequently find that we need to clear out the Tenant cache. The error message we get back is: Problem Loading Data A row with duplicates was encountered at row number 248 for data object Accounts The Values are…

Hello. We are looking to upgrade from Advanced to premium primarily because of the need for external reporting from "3rd Party" tools. These tools require SQL server access to be able to PULL data from Sage running SQL. We have read where the SQL server…

Hi All. We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables. I'm…

How can I use a Sage UDT SQL table as a source for a VI job?

I have a client using Sage 100 Premium for core accounting for 200 companies installed in the default instance. I need to upgrade for 2019 to 2021, what is the procedure to keep using the default instance on a single server? Ideas? There are multiple…

Hi, I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium. Question 1 - What are the perquisites for upgrading/migrating? Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

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…

We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

We're looking into upgrading from Sage 100 Standard to Premium. Currently we do a lot of connecting directly to the database via ODBC for querying; our AP users query the AP tables, our Payroll users query the Payroll tables, etc. I don't want these two…

For FFCRA, we need to add the same 4 new GL Accounts to over 200 different companies. Does anyone have a suggestion on how to "automate" this process? We are using Sage 100 on SQL Server. My background is in MS SQL Server database management and development…

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.

We are currently on Sage 100 v2016 Cloud and looking to upgrade to v2019. Is there a 2019 SQL version or only Provide X? I see a few years back that Sage 100 Premium was available but nothing recent.

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 want to upgrade our version of Sage 2017 to 2018 and at the same time start using SQL for our database. With that, we would need to purchase a license of Microsoft SQL. The documentation states that Sage 2018 is only compatible with SQL 2017, however…

Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…