Sage 100

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…

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…

Posting this to help others in the same situation. The client system had a 3rd party modification to their SQL databases (by FYISoft / Renovo), adding table level SQL triggers that became broken with the migration (since the new SQL instance didn't have…

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, I know SequenceNo counts up if a duplicate record is generated on the same day but I am not sure what fields exactly need to be used. Is it just SalesOrderNo, WTNumber, WTStep, RecordType, and TransactionDate? Or is it the rest of the fields as…

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…

During the migration process, the following error appears. Parallel Migration Wizard - InstallShield Wizard Error execute: Select ServerProperty('ProductVersion') As Product Version. After clicking on the OK button. This error appears: SQL Server…

We were needing to have Microsoft reporting services (SSRS) on the same server as Sage 100, but as sage uses the sql database, and has (I believe?) Crystal Reports built in, would there be any issue installing the SQL Server Reporting Services onto the…

Sage Premium version 2020 Reinitialize Datafiles utility I get the above message/problem when trying to reinitialize any AP or AR data files. I don't get the message when reinitializing IM, PO and SO files. So when this message pops up I have to…

The current SPM for v2020 (and v2021) both list compatibility with SQL 2017 CU "20 and earlier"... ...yet the current CU# is 23. https://docs.microsoft.com/en-us/troubleshoot/sql/general/determine-version-edition-update-level Is there a compatibility…

Hope my Monday doesn't bite me. I rebuilt some key files over the weekend. A couple samples from the common info key rebuild log Illegal characters have been found in the key. The record was not copied. The key read was P18569351 . Illegal characters…

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

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…

Asking for friend who just moved to Sage 100 Premium from Advanced and he has a question. "I need to figure out how to get all of my SQL data (logs and data) to reside on the D: drive instead of the C: drive. If I make a backup company the C drive starts…

Good evening. I have tried to create new companies and activate them in Sage 100 Premium. Currently creating a new company does not add a new database. Attempting to activate the company also fails Attempting to copy a company to a new company…

Hi; Please someone can help me ; i need a manuell of structure database SAGE 100 ; thnks!

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 have been using Sage since 2012; we started with MAS90 4.5. Starting with Sage 100c 2018 it seems that a pvxwin32 is left running on the workstation and on the server for every session we start. Every morning when we open the Launcher we get told that…

Hello, Just a basic question, I'm reading the file layout for SAGE 100 and most the file/table layout has following options on the top of the section. Most of the options are self explanatory but is there any document on SAGE 100 that will explain all…

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…

We are currently running Sage100c Premium v5.40.2 with MS SQL 2014. We would like to upgrade to MS SQL 2016 SP2. Will this present any issues or should we be okay?

Have a situation where a company code exists and the client wants to copy the company to a new company code (no problem). Question is, the client wants to re-use the existing company code for a new company. If I delete the company, can I recreate…