Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back.
Open Excel, select "File" from the toolbar, then "Options…
I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…
Can someone please assist.
I think there are few companies still running systems on 64 bit Excel.
Why can't I run or create my ODBC queries on Excel 64 bit? Who would want to downgrade to get results?
Is there another way arround this issue please…
Anyone come across the excel button in GL Transaction being greyed out? All of the other exports work, but the GL screen is greyed out, even when i have a transaction highlighted.
Hello,
We are attempting to export all invoices for a specific customer from the Invoices tab of A/R Customer Inquiry using the Excel button. However, the output in Excel produces a date in the Amount column for all invoices. How can we fix this issue…
Hola,
Hemos de atender un requerimiento de la AEAT de entregar copia de facturas recibidas con numeración correlativa (número de asiento en este caso).
Históricamente, tenemos las facturas escaneadas y guardadas con nombre de fichero que incluye fecha…
What are some reasons a Sage 300 macro would suddenly quit working in Windows 10? We have five Windows 10 clients, and the macro has quit working on four of the five clients. Sage 300 itself still works fine. We don't know when it broke given, we only…
Recently my workstation was upgraded from Windows 10 to Windows 11, shortly thereafter I started experiencing issues importing excel files into Ship Orders (Tairox). Whenever I try to import an excel file into ship orders I get the error "Microsoft Excel…
Hello fellow Sagers!
Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
Problem:
Financial Reporter Web Excel configuration error. The version of Microsoft Excel on the server may not be compatible. contact your administrator for assistance.
when clicking on any of the icon on webscreen FR.
Cause :
Incorrect version…
We have several individual companies in SAGE. I would like to export the general ledger detail from each company, at once, into one large excel file. Currently, I go into each company and export the data manually and it is very time consuming.
Is…
Hi all.
I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below.
However, copy pasting the content to an exported excel file seems to works fine.
The issue is: I am going…
Getting this error when trying to export our vendors object to Excel 2007: Description: Provider cannot be found. It may not be properly installed. I have Access Runtime 2019 (x86) installed along with Office 2019 (x86). Access Runtime provides Access…
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…
When exporting to Excel, SAGE currently applies an odd and deceptive number formatting.
#,##0.00;-#,##0.00;* ??
This formatting makes zero values appear empty when they are not. This leads to some confusion as there is a huge difference between an…
Users who do online sales and do not create customer record for every single sale rely on sales orders to help identify transactions that need to be processed into sage. The payment tab in SO is used to process those payments. Now the bank feeds has its…
How do I activate this option? We have excel on workstations, but not on server where BV runs, and cannot export data files to excel (see "grayed" Excel option in pic).
Thanks for any help.
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…
Does anyone know if Sage is planning on supporting Sage Intelligence with O365 Cloud? I have several clients having issues with not being able to use SI with O365 Cloud and needing to install Excel locally.
Thanks!
Hi,
Sage X3 version: v12p33 (latest)
Possible for Sage X3 to support latest `.xlsx` format currently used by Excel : ?
When I check the Destinations setup, I only notice the Excel format export is up to 2000 and using `.xls` format.
Limitation…
Allow ODBC connection or connection via sage report designer to the table that holds the data of reocurring invoices, including frequency, value, start date, invoice item lines etc. This would allow us to audit the reocurring invoices setup in our software…
Hi,
We are having trouble exporting reports and Listings to Excel, because it opens a unlicenced excel. We recently changed to 32 bit, but didn't help.
Anyone can help?