Welcome to the Sage 300 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.
Hi,
We have encountered an issue whereby we are receiving the following error messages:
1. PrintReport: Error on opening the xla macro
2. Problem is found in running Financial Reporter Addin
We do not have application support in-house and have…
I have several customized GL financials (Excel) that I used to run successfully for years. Once I converted my data from V2022 to V2023, all of these financials come up with errors >> Invalid account reference in cell A45. They all deal with column A…
Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…
Hi,
One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2?
They need to run FR, but encounters the following errors:
Description: PrintReport…
Hi everyone,
Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
Hi all,
my customer is generating financial report from Sage 300 web app as excel file and open it on Microsoft 365. However, the alignment is wrong. All the debit values in red color appears in Credit column.
When opening it on old version of Office…
Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error....
Automation error The object involved has disconnected from its client.
This only seems to happen for specific user. When logged…
Hello,
I am new to using Sage 300 and I have a problem with printing. When I select any of the Print Destination options and check Data Integrity, a log file should be printed (or opened in another window for Print Preview). However, the check is performed…
Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?
We're trying to determine:
1) How many commitments were…
I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…
In Sage 2017 & 2020 the FR View Fails but gives no error.
Below is the update I uninstalled. It breaks the variance report on newer Windows versions, but not on older versions.
Security Update for Microsoft Excel 2016 (KB4484338) 32-Bit Edition…
I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report.
Any & all help is greatly…
Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages .
As soon they click on export button the following error is received. generally user tends to run the…
Installed sage 2018 Premium with PU2 on a server. migrated a customer from sage accpac v6.0. Data upgraded fine but if i try and print any report to preview the UI container error comes on.
Windows Server 2016 with SQL Server 2014.
Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018.
When trying to print preview any default sage reports get error message.
Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
Is there a work around or fix available for FR Reporter not working or playing up for sage 2014/2018 versions with Excel 32 bit office 2010.
Get the error below when executing reports "PrintReport: Error on opening the xla macro.
Have received…
Unable to auto send XLS or XLSX output using Report Manager and Gmail G-suite mail client. I AM able to successfully schedule and send PDF reports. XLS and XLSX reports are generated and placed into output directory but no evidence of email having been…
When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines.
Appreciate if anyone has seen this before and has a solution…
I have searched the knowledgebase and i have not seen the answer.
The Print Financial Statement suddenly stopped working on my workstation. The other workstations are ok.
I get this error whenever I click "Print" and when Excel tries to run the report…
Accpac 2016, PU1, Excel 2016 32 bit. Excel add-on for financial report writer IS added to Excel. Excel is part of Office 365 on the workstation..
When you run the print financial statements function, Excel comes up and it appears to run through all…
When we print a customer statement in the end of every month, those amount on the bottom do not match the total amount, it always missing one day. There is no current amount show. Is there any way we can change "1-30 days" to "0-30 day"?
Thanks so much…
I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal.
Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…
