• Reasons a macro would suddenly quit working on some Windows 10 devices and not others.

    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…
  • Microsoft Excel, or a 32 bit compatible version of Microsoft Excel is not installed

    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…
  • Import AP Invoice from own excel file failed

    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…
  • Provider cannot be found. It may not be properly installed

    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…
  • Error on Opening the xla macro

    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…
  • Sage 300 GL Financial reports error

    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…
  • How to create on-demand subreports caption into number value

    So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…
  • Error "Vendor cannot be blank" on Excel upload of A/P Invoices

    I have started to upload A/P Invoices using the Excel template provided with Sage 300. Whenever I upload a file, I get the error message "Vendor cannot be blank" despite the Vendor Number (IDVEND) being populated in the Excel file (in the "invoices…
  • Is Sage 300 2022 PU2 Compatible with MS Office 2021 32bit?

    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…
  • Sage 300 - Import items to populate quote

    I want to import items into an O/E quotation. I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in…
  • Financial Report UI is different between Microsoft 365 and older version of Office Excel

    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…
  • Filling up the GL-JE Import template in Excel

    Hi All, Trying to fill up an import template in Excel - As you can see in the screenshot, there are 4 transaction per journal entry but in some cases there are 5 - 6 transactions as well. I know that excel follows a 20-40-60-80 patter in the TRANSNBR…
  • FR stops working: error in running connectcomaddin in macro, Sage 300 2020 pU2, Office 2016

    We tested this feature a couple of weeks ago (financial reports) and it worked fine, we could run all financial reports. Now, after we went live, it stops working with the "Error in running connectcomaddin" in macro. I got it to work 2 days ago and…
  • FR View fails in Sage300 2017 & 2020. Screen just goes blank, no error

    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…
  • Issues with Excel using RemoteApp

    We have Sage 300 2019 PU1 installed on two Windows 2019 servers that publish Sage 300 apps in a collection. We push out the applications to their Start Menu via Group Policy. Our users have dual 4k monitors and initially we ran into issues with Sage 300…
  • G/L Inquiry with Income Statement Year End Income Statement Amounts

    FormerMember
    FormerMember
    Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…
  • Sage 300 2018 Error on export button

    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…
  • Importing Employee Transaction History from Excel

    We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…
  • Sage 300 2014/2018 with Microsoft Excel 2010 32 bit

    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 output using Report Manager and Gmail G-suite mail client

    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…
  • Excel crashes printing A/R invoices through VBA - MSVCR120.dll

    I have some macro code that is printing A/R Invoices to PDF files. The code works fine on my laptop, but on the client workstation, it crashes. Event Viewer identifies MSVCR120.DLL as the problem. The OS and Excel versions are identical on the workstation…
  • error code 3.3884.0 in import file to bring 256 employees into Sage 300 payroll using excel files.

    I have left the pay codes and taxes blank at this time. Any ideas where to look for my error (s) ?
  • Financial Report Writer blank screen, extremely long time to process issue..

    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…
  • The values of "Category" in timecard import sheets

    Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR
  • Integration between Sage and excel that works both ways

    We have created an app that pulls order information from Order Entry and populates a spreadsheet. We have optional fields that have been added to order entry that indicates one of our Buyers. The Manager opens the spreadsheet and assigns a buyer to each…