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…

Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?

Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…

Hi Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300 Regards

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…

Good Day Sage 300 PU4 Client recently upgraded to above. The FR report runs successfully but is no longer suppressing zero value lines even though this is defined in column c. I have tested on 32bit Excel and it works correctly. The client uses 64bit…

The full story is that our client of over 20 years has had to move their system from their local server to an Azur server at short notice. Everything is working fine except when they print the AR invoice form, both the customized form and the default…

Sage300 v6.0 using RDP. only one user has problem. FR Preview is normal. When generate report by print destination as file. a blank error message open. the file select screen's capture is adnormal If ok, it will hanged. Any hints?

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.

Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…

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.

As part of a user access review, Support have asked if we can provide a “last signed on” field either with the user details or in a separate report. Is this data available?

Hi Everyone, We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along with the…

Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.

I am getting the following error when trying to run any government report: The procedure entry point ?selectNodes@CAXMLNode@@QAE?$shared-ptr@VXCAMLNodeList@@std@@PBD_N@Z could not be located in the dynamic link library d:\Sage Accpac\Taxfiling\aatrixforms…

Is there a report or something to identify what user approved a credit limit overide

Just upgraded to Microsoft Azure. Same version of Sage300 and crystal reports. If you print preview a report fonts are crazy and look strange on screen . Export and view in Adobe font is as specified in the report layout. Arial font is loaded on server…

Reports do not print from the Sage 300 Web Screens. No error message or warning is displayed. I tried to open on server and on client.

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…

Hi, The scenario is like this: The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how…