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.
I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
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…
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…
We are upgrading to Sage 300 in a small environment aka 3 people. Or reseller is saying we need 32G RAM. The only document I found that might relate to this shows 3 deployment scenarios of Standard, Advanced and Premium. It doesn't elaborate as to what…
Description: You cannot upgrade because some of the features you currently use are not available in the Sage 300 Advanced. Years of Fiscal Sets. Contact your Certified Consultant for the correct product to upgrade your General Ledger data.
Source: 14…
We have Sage 300c installed and the Web Screens are accessible.
However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…
Hi, I installed a fresh copy of SAGE 300 2018 and loaded sample data. It is fine with everything. But after loading customer earlier version data and upgraded, I am missing with Administrative services (except data activation) and GL account folder. I…
Currently, SAGE is running on Windows server 2014 and IT is planning to upgrade the version 2016. This updates will not require any installation and uninstallation, It is straight forward version update. Does it have any impact with current running SAGE…
Hi,
We are testing an upgrade of a customer from Accpac v5.6 to Sage 300 2018 (v6.5). Everything straightforward but when running a Data Integrity I get a lot of errors just in Bank Services with this message : E: Bank Transaction Header. Invalid list…
Trying to customize the "Commitment Cost Status with Full Detail report to show invoices and check numbers on one row, instead of listing in separate rows. Not sure if this can be done.
My company is looking into the possibility of developing an ASP.Net MVC application to view custom reports that are designed & created by our users through Sage 300 ERP Suite. I believe there is the .Net library to integrate with Sage.
Can we develop…
Hi there,
After upgrading to sage 2016, we are losing the Users and have to enter them manually. Once they are entered the permissions reappear. Is it normal and is there a way to make sure the users upgrade as well?
Thanks
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…
Dear Friend,
My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code?
For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first…
To all Sage300 Report and/or Crystal Report gurus:
I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…
Hi,
i get this error when open BI Report Manager
I'm on Sage 2014 PU3
"The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : -
SELECT…
How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.
How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…
Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.