Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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 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?
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?
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…
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…
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…
User says that reports were printing normally on this workstation until today when this error occurred and now cannot print or preview any reports. Has uninstalled and reinstalled MAS client (Autorun - run as administrator) but still gets the error message…
We are utilizing Sage ERP 100 premium 5.10.40. I have one workstation that keeps getting the following error any time they try to print or run a report: "The database login failed. Could not load file or assembly 'System.data.dll' or one of its dependencies…