Sage 300

For consolidated financials, how does the pop up box to choose the year determine which years to pull? We have a consolidated report that runs about 10 companies. One of those companies is currently in fiscal year 2024, where as the rest are calendar…

Using MyAssistant, I am trying to create an excel doc that contains the "Current Month" in the top row. If I go into JC and select File > Company Settings > JC Settings, I can see in the Accounting Date section the Current Month is "September" (even though…

I've tried all of google about this error on excel about report designer license required sage Intelligence. Anyone please help me. Sage 300 2022 Premium with Connector, designer, viewer and manager license. Microsoft excel 64 bit 365 office version…

When we generate a balance sheet using the Balance Sheet template in the layout generator, all of the period numbers are correct EXCEPT period 6. Period 6 is set at 1 for both the actuals and budget columns. I can't see any way to change that in the layout…

Designer not Licensed/Report Designer License Required Error in Excel on two workstations running Sage Intelligence Reports. There are another 2 workstations that can run the Sage Intelligence Reports with no Problems. Report Designer License Errors…

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…

I am having an issue with Report Designer where I have set up a Revised Budget under Budget set 2 but the revised budget is not being pulled into the Designer report. I can see the revised budget in the Budget Maintenance screen. I have reviewed the…