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.
Good morning,
We use the Sage-300 office connector to pull GL balances into an excel file using the "TSGLAmount" function. My question is related to the Amount Type argument within the formula. The default is "Balance" which pulls the balance for entries…
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…
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…
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…
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…
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…
Hi there,
We're on Sage 2014/ Excel 2003 and this is what we have when we do the import in GL Budget Maintenance:
"Account fiscal set invalid list choice put to field "Currency type"
Any clue?
Thanks for the help.
Hi,
I am having a hard time importing transaction on AR module, this notif. keeps on prompting while i keep on trying. I have searched some trouble shoot for this but still I can't proceed to what I am doing.
Any help? Please!
Thanks,
B…
When the report is printed to an Excel File and you open it, the file opens at the bottom of the report. This report is several pages long and is emailed to management and people dont like to have to scroll up to the top all the time. Can something be…
Recently upgraded to 2014 300 Advanced
Version 6.0 functionality for exporting a previewed report to Excel included a dialog box where column sizing could be based on header, details, or other choices. That dialog no longer appears and the exported…