Sage 100

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

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 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…

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

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…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

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…

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…

MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned. 1) MAS 90 has been set up with a role that gives me read access to all…

We use SSIS to grab all the information from MAS for use in reporting. We use the ODBC driver to do this. This works with no issues the majority of the time. Occasionally, but still often enough, there will be an issue with the extraction, causing…

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered. Is this normal? I can import…

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…

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…