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 everyone, I have an issue that I haven't been able to find a good fix for.
Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…
Fresh install of Sage 100. I ran the installer as domain admin as well as the WksUpdate Standard file. I have already tried reinstalling the software over 5 times and verified all necessary files were present in the C Drive file path. Is there any other…
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…
Hello,
We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…
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 am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…
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…
Since moving my client from a Server 2008 Terminal Server to individual workstations, printing reports of any kind are now taking over 5-10 mins to print 5 pages. This includes just running print preview.
I'm currently running Mas 100 ERP version 5…
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…