Sage 100

Hello friends, We have begun working with our awesome consultant on our Sage 2023 Premium upgrade from an older Providex version of MAS. It's very exciting! We are at the point now where we need to get backups running for our new accounting system…

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…

This is a Go-Live upgrade, so obviously the test upgrade, and a subsequent "refresh migration" were able to go through. However, now that we are trying the final migration, with just the MAS_XXX company data (no system files) we are getting this - over…

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…

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!

I did a test migration last night (v2017 Premium to v2020 Premium, same server, both SQL instances are local), with the new instance's default data directory changed to the E-drive. When I installed v2020, the MAS_ABX and MAS_SYSTEM files were properly…

I created a copy of our production company (DUS) into another company called (BKP). Now, I want to copy the BKP company data back to the DUS company data, effectively restoring from the backup I made. When attempting to go into Company Maintenance and…

We do most of our custom development work for clients on our own system. (Build and test VI jobs, create and modify Crystal Reports develop custom forms, data troubleshooting, etc.) For the past 20+ years we simply copy the client data folder (MAS_xxx…

Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…

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

We are using Sage 100 Advanced V 5.20 OS Windows Server 2012 R2 We have a backup server where we have Sage 100 installed in case of disaster recovery. We copy the data files over daily. When I first migrated the data over all the Paperless Office…

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…

I have a client that leases VM's on a Network Operation Center. That NOC has high end hardware such as HPE 3PAR from HP large storage array for storing the VHD's. The NOC guys tell me the hardware array itself does bit level snap shots hourly which…

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…

We just upgraded to Sage100 2016 Premium (yes BL, we are no longer on v 4.2). We are setting up SQL Backups and having issues with the SQL Transactional Backups. They are enormous in size and killing our drive space. Is there anyone that can help…

I deleted the parts number and descriptions, therefore when I try to enter an item into the estimate, only the "cost code, Cost type, Default cost....."headers appear. Is there a way to restore the part number and description headers?

One of our employees cleared the history files from our order entry module. Is there anyway we can get that information back?

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…

I wanted to change a vendor name from "SMITH" TO "3SMITH" however I ended up deleting the original vendor name. How can I get this information back? What I did: Modules > AP > Utilities > Delete and Change Vendors. (I used the first tab instead of the…