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.
Hi Team
I have installed Sage Intelligence for Sage300 Cloud 2024 PU1 when i run the program it comes back with and error
Server execution failed. please assist if anyone has come across this
Failed to retrieve data from the database error is received from Sage user interface when running a custom report created when client bought sage. Report works on sage 2014, 2019, 2020 and 2022 environments but doesnt on 2023 version. At crystal level…
V2024
logged Sage 300 as Administrator, when run any reports, we get above error, even when firewall is off.
Everything else in Sage in fine.
Please help.
Our client has the issue when trying to print their financial statements to file using the Print Financial Statements Icon (Sage 300 2023.4)
The report generates no problem to Preview.
We have
Checked there are no other excel add-ins ticked…
While working on the Bank reconciliation of previously January 2024 and lately February 2024, I am facing issues in the Sage Intelligence Reporting module. The bank statement figures do not match at all with the A/R and A/P entries. The Income statement…
hi when running a item valuation report i get a column that has actual cost / most recent cost and last cost. Which column represents my total value of inventory? Other question is can i pull out a value of inventory from a prior date? If so how would…
I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300.
/resized-image/__size/640x480/__key/communityserver-discussions-components…
Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output:
1. Opening balance on account at every point in time the report is printed ie yearly or monthly,
2. outstanding invoices unpaid…
Hi,
Did anyone encountered the same error code when print Financial Statements in Sage 300 2024?
After clicked OK button, the report still works fine. Why is there an error code shown after click Preview button?
Client is using Microsoft Excel…
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…
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…