Sage 100

Does anyone know if the creation of these cached reports is dependent on the configuration of the RDS server itself, or is there programming within the application that defaults to this location? The reason I'm asking is because I'm upgrading a client…

Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…

Dramatic slow down on the update process, compared to prior Sage 2018 Premium version. The processing Sales History work file status bar takes up to 10 minutes to finish. Has anyone else come across this issue? Were you able to resolve it?

I have had this occur with 2 clients in the past week. Both are on Sage 100 2022.3 with Payroll 2.23.0. They download & install the latest Tax Table update. The error occurs when the select to print the Tax Table Update Report. There is a Sage KB on this…

Just upgraded Fixed Assets to 2023 for a client and they are still using Sage 2018 (in the process of upgrading to 2023 just waiting for a new server) and now they cannot print in Sage or in Fixed Assets. Getting this error. Report file C: ProgramData…

Does anyone have advice on how to handle the file not found error, where the rpt file mentioned in the error is located in the C:\ProgramData\Sage Software\Cache\MAS 200\Reports folder? I did a go live last night and users are seeing this error when…

I'm upgrading from 2015 SQL to 2020 PU3 SQL. The migration and conversion has been successful, but I can't go live tomorrow, unless I resolve their printing problem on their Citrix Server. That's where all users connect and work. I started the go…

In the latest versions of Sage 100, how do I print a data dictionary listing?

Hi, Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat I moved things around in the PM WT Traveler report that came with the install…

I am looking to add the Routing (now Template) description to my printed Work Ticket Traveler. I want it to appear in a header section of the crystal report. The routing description is now step 000000 of the route instead of its own field. How do I get…

Has anyone found a workaround for the Microsoft and Google authentication changes? We have Sage 100 v2018 and it looks like we will be forced to upgrade.

Just did a fresh install of Sage 100 2021 Premium. When printing any report, getting error 15 SY_REPORTCOMMON.PVC 1877. O/S Error 28000 [Microsoft][SQL Server Native Client 11.0] Login failed for user "MAS_User". Verified the password is correct for MAS_User…

Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…

We have one workstation where we get this message on some companies but not on all companies, some companies work fine. Any ideas?

What happened to field 20 WorkstationName -- it is in the File Layouts but not in DFDM.

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

There are 19 Custom PR reports. Most fail with error 88 line 705 which has you check for enhancements - Followed those steps to determine it is not the enhancement. Problem is in connecting to old SOTAMAS90 KB 104971 Sage suggests rewriting the reports…

We're running the A/P month end process for the first time. However, there are no period end reports listed in the Period End Report Selection. These are the reports I expect to see listed How do I get the A/P period end reports to list in the…

I have a report from v2017 that utilizes the table PR4_EmployeeEarningDeduction. The documentation says that in v2019 the equivalent table name is PR_EmployeeDeduction. The problem is that the new table doesn't seem to include earning information, and…

v2019.3. The help files only describe Y & N.

v2019 Adv. Customer would like a Crystal report showing what email address is set up in Employee Maintenance/Paperless for Electronic Delivery. It may/may not be the same as the Email that is on the Employee Header. The PR_EmployeeDocuments.m4t is an…

I'm looking to clean up custom reports before migrating from 2017 to 2020. Is there a report or database I can look at to see which custom reports link to which Crystal Reports files? Thank you in advance for any help.

Ok, new to supporting Sage, so not that familiar with much; was just a user for 12 years. The ticket originally came in with this Crystal error when they tried to print a picking sheet. Fumbled through some web searches, and ended up finding the dll…

I have a request for a custom form code where, when printing an invoice batch, invoices with a specific terms code are omitted (without wasting a blank page). I tried report selection criteria, with a formula that 100% works fine (with no typos) and…

This is on my workstation, and I basically get the same thing on v2016, 2017 and 2018. (2016 and 2017 needed the config file from KB 86964 to actually produce the report results). Is anyone else seeing this (error, but the output is produced anyways…