Sage 100

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…

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…

I have just upgraded my client's live Sage 100c advanced 2019 PU 4 to Sage 100c 2022 PU 1. Everything migrated to new server properly and the data for the live company was converted fine too. I am experiencing an issue with the ODBC both for User and…

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…

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…

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…

I know there is an order for installation that will allow HRMS and Sage 100 to peacefully co-exist on the same PC, however I am not sure what the exact order is. Also when ever we do a quarter update with HRMS, we invariably break Sage 100 (specifically…

Is it possible to modify the name of a report that was added to our AR Custom Reports menu?

I'm editing accounts payable checks in crystal reports. I click on "View" and then "Preview". It then has a popup that says OLE DB, and then has the following fields: Server: OURSERVER\SAGE100V2017 User ID: Mas_Reports Pasword: *blank Database:…

We recently upgrade Sage fixed Assets from 2016.1 to 2019.1, today a users reported issues generating reports from Sage 100 2016, that's all the relevant changes that we have made recently. May Sage could be affected because of this?

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Hi Super Heroes, 1. we used TCP 9500 as the port id, and it is working fine after we disabled the firewall for domain users. What other ports do we need to open other than the 9500, because after i opened 9500 inbound and outbound, server pop up with…

Hi Guys I have been having this issue on just 1 of our workstations the past few months. When we try and print anything we get this error Anyone see this before?

We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…

Trying to write a report that shows Sales Order line items and any Work Orders that have been created for them. I thought I had it when I joined these tables: SO_SalesOrderDetail to WO1_WorkOrderMaster on SO.SalesOrderNo = WO.MakeForOrderNumber and…

Sage HRMS uses Crystal Reports 2011, which is the latest version of HRMS from Sage. Sage 100 2018 uses Crystal Reports 2016. How can I get the crystal reports to work when both Sage products are installed on the same computer?

In the process of upgrading from 4.50 to 2018. My custom reports migrated to my 2018 installation and are in MAS90\MAS_XXX\Reports. However, when I run SYWFCU and specify this directory, I receive the following message "There are no custom reports found…

With Sage 100 2018, Crystal Reports Designer 2016 is now included. Sage warns us to uninstall all existing Crystal Reports Designer versions prior to installing CR 2016. This is the warning from a KB article: Caution : Avoid using incompatible versions…

Crystal Reports 2011 Export Error - Sage 100 Advanced V2016 PU5. Running custom Indented Bill of Material Report with subreports, and then exporting to tab-separated text (.ttx) file. This works fine on Windows 7 and Windows 8.1 workstations. New Windows…

Good day all, We have a system that uses Crystal report for .NET frame 4.0 it used to work fine on that computer. For instance, We normally filter by location, date, and other parameters report would bring up the correct information respectively.…

We run on a Citrix environment do I need to make the registry change on every users computer or just the Citrix servers? We're running Cyrstal Reports 2013 with Sage 100 in a Citrix environment. The users are logged into any one of 4 servers that connect…

We run just the Financials in our SQL version of Sage 100. Recently, none of my canned reports will run. The error: "The database login failed. Logon failed. Details [Database Vendor Code: 6]...Unable to connect: incorrect log on parameters..." This…

Installed Sage 100 2016 on workstation that already has Sage 100 2013. Sage 100 2016 is setup on a seperate server and database which it accesses just fine. When I go to print a SO or PO I get this error Any ideas on how to fix this?

When upgrading from 2013 to 2016 the AP Check form opens fine in Crystal Reports and you can verify the database without any error. When trying to print the AP Check in Sage 2016 I get the following error

Sage 2016 install and associated amyuni driver causes other crystal reports from another 3rd party to print mashed into the left margin. Does not matter which printer is default, toshiba, star and hp all happen. Uninstall 2016 all is right. Is there a…