Sage 300

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…

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…

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…

How can I filter AP vendor transaction report to get actual result with GL transaction report.

I have several custom reports (crystal reports). Now I want these reports to be also accessible via web screen. Which directory should I put my reports?

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…

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.

What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.

I am attempting to create an On-Time Shipping Report. I want to add a parameter to only show items shipped during a certain date range. I am using the same logic as the OE Sales Report, but my parameters are being ignored and I see all records. Any…

I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.

I have created a new container and report, but when I attempt to add a start date >= parameter, it will not show the calendar. The user has to enter the exact date. Any ideas?

I am consolidating 3 companies company 1 current year is 2019 company 2 current year is 2019 company 3 current year is 2020 (does have different fiscal year end - am not consolidating on a single worksheet) When I run the statements i only see…

Hi guys, I have an issue where I have created an actual vs budgeted financial report in Sage Intelligence however my actual figure is different from what is in the GL when I run the GL transaction listing. How can I fix this or where can I see where…

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…

I'm having an issue when running the missing accounts tool. On one report I've built, the tool will only show missing balance sheet accounts even though I know for certain there are missing income statement accounts. I even went so far as to build one…

We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…

Hi All, We have the designer license in place (shows YES in the license manager) yet standard reports fail to generate data and appears as "Designer License Required" instead. Sage 300 2018 PU1 Screenshots attached. Any issue with our licenses?

I've set a few criteria in optional field in Order Entry module, user will insert their data to each of the created optional field, now how can i show Optional Field data which have a few lines to reporting? It should showing all Order Confirmation although…

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…

Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.

I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?