Sage 300

I downloaded the Sage Intelligence Report Utility and installed the PJC reports for Sage 300. When I try to run the reports on a database, I get the following Execution Error Description : It was not possible to connect to the database. The error returned…

Recently upgraded my standalone workstation version of Crystal Reports to the 64 bit variety. Now I get the "u2lcapw.dll" error on all Sage 300 Crystal reports (2023 PU1). I've done all the usual copying of the u2* files from both c:\windows\crystal and…

We just upgraded a client to Sage 300 2023 on their existing server. After the upgrade, printing their customized PO form prompts to enter SQL name and password. Even when I enter the correct credentials, it fails with "login failed" message. I thought…

We have created a report using the trees - which works Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc Non organic 12,18,32,etc How can I drag all the trees into…

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…

This formula is checking ok but I am not getting the results if the mid function has several variables ie CL, DU etc but the GE and AF seem to work ok. . I have tried a bunch of formatting but still no working. Any suggestions would be greatly appreciated…

My client has 3 standard consolidation reports connected to 3 different containers which they want to put together in a union report. The reason there are 3 different containers and associated reports is because there are different modules activated…

I would like to export the opening balance sheet in Sage 300 but without including the other entries for the entire month, just the opening balances. The same would like to do for the closing balance sheet.

*Some future speculation on the future of Financial Reporter - not a support/help request* On my test system I have Sage 300 2023 PU1 installed where I noticed under the *\Online\Web\App_Data\FinancialReporter folder there are three files including…

Hi, We are considering using Aatrix for goverment payroll reporting. Are there any situations we should be aware of? Thanks.

I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

Hi all, Looking for your expertise here. I need to create a budget to actual report under the PJC module. I understand both budget and actual numbers can be found under the PMBUDD table but the trick is each contract can varied in length (months). For…

Sage 300 with RDP session to server. User cannot add report object. Select Object > New or R-Click > New, and it stops there. All option including Report are greyed out. No problem with ADMIN or other users.

Hi, does anyone have information on this? How long is Sage going to develop and support this product for Sage 300? Ty.

Sales Intelligence reports stops at "Running Add-In PLPluga.A.ExtendFormula" the "there's already data here, do u want to replace it" comes up.

I keep getting this excel error message when I run the sage intelligence report. How do I fix this?

Does Sage Business Intelligence in Sage 300 Require Excel to be 32-bit? Sage 300 v2022

Hi there, I would like to create a Revenue and Expense statement for budget purpose, that shows current year YTD, Last year Annual Auctual, and the year before Annual Actual, what is the FR function I need to use? I also would like to create a…

Sage 300 How would I get a .csv file of all vendor payments made during a calendar year by vendor by expense type(account)?

Hello Everyone. How do I print the totals for a range of accounts for the whole year using FRPOST function?.(I'm using FRPOST because of the Transnational Optional fields). The current formula ' =FRPOST("TRANSAMT","2400:2400ZMA","(T.ACTIVITIES LIKE…

- report launches from Sage web client and functions fine with paramater set to a certain department - Add a runtime paramater for department report works fine from classic client - report will not run from Web client Unexpected Error: A problem…

Hi We are using Sage 2017 version, Please advise how to change the report format. All report comes with the name who left our company. Our sage cannot be opened via web browser (becouse of no cloud version?) and ther are no "setting" botton on my…

Sage 2023 has not been officially released in Australia yet so I have not checked in the install iteself. In relation to this thread https://www.sagecity.com/us/sage300_erp/f/sage-300-announcements/190585/important-information-regarding-sage-intelligence…

while trying to run sage intelligence report under report manager, hit the following error. error occurred trying to refresh excel's links to its installed addins. the error was [unable to set the installed property of the addin class}. the report will…

Hi, Using Sage 2022 on Windows 2019 server. I am facing a problem with running PJC canned reports in Intelligence reporting. This is with the dates in the filter screen that comes up as soon as I run the report. Please note that I am using European…