• Sage 300 2023 pu 5 Printing ODBC reports shows Failed to open the Connection

    I have just upgraded a client to Sage 300 ERP 2023 pu5 When I print a pipe delimited report or form to preview it works fine, but when I print an ODBC based report it shows "Failed to open the connection". It doesn't matter if it is a custom report…
  • Cost Codes last used

    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?
  • FR Report not suppressing zeros

    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…
  • financial reporter

    I would like to sort the results of the report for a rage of accounts based upon the values produced. for instance: cost of sales accounts, detailed by d(acct) for 4 separate columns from J, K, M, N and then SORT THEM by column M in decreasing values…
  • Web Screens: export to pdf gives "a problem occurred while generating the report" error.

    Upgraded to Sage 300 2023 PU1. Web screens work fine except cannot export to pdf. Gives the above error. Have tried changing the app default for *.pdf
  • When printing an invoice in Sage 300 2017 the user is always asked for a password

    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…
  • FR Drilldown only working on first line

    I have a fairly basic FR Financial using the FRTRNA function and it's only showing drilldown information on the first detail row. Any suggestions?
  • Budget Vs Actual Report - Financial Reporter

    Hello , i am running the Budget vs actual report on financial reporter. our fiscal period is April to march but when i run the report lets say on December it shows budget only up to December, is there a way i can run the reports any months and it compares…
  • object reference not set to instance of an object - BI Add in

    on a system that had been successfully funning BI for months i am suddenly recieving the error object reference not set to instance of an object when trying to run a BI report. It doesn't matter what report I run even a sample report. In fact if I just…
  • Crystal Report Printing Error

    I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…
  • Error Message with a Crystal Report

    We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…
  • Sage 300 GL Financial reports error

    I have several customized GL financials (Excel) that I used to run successfully for years. Once I converted my data from V2022 to V2023, all of these financials come up with errors >> Invalid account reference in cell A45. They all deal with column A…
  • Payroll Year to date listing by employee

    I am often asked for a list of employees with year to date earnings, one per line with a column for gross, tips and taxes. I can get the report this way for each quarter using Quarterly Wage Report by Employee but would like to get it year to date. I…
  • Tables used in POPJRCP dll

    Does anyone know what tables are being used in the POPJRCP dll report?
  • Automating the generation of a report in PDF and sending it to an e-mail address

    Hi, can someone please help. I have created a report and placed it on the SAGE desktop in OE reports folder. When I manually print and send this report to a particular email it works just fine. However, the recipient wants to receive this report automatically…
  • Suppress rows in Financial Reporter when printing to file

    When printing an FR report to file, it always adds two or more blank rows to the top of the worksheet regardless of the spec and print settings. It must be coded in there somewhere. Does anyone have any ideas? Client wants the file title to be the first…
  • Sage 300 always prompt SQL login database when Custom Report from Crystal Report is printed

    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…
  • Installing Excel Sage BI Tools on Local computer

    Good day We have Sage 300 set up on a remote server. However, when Sage 300 outputs a report, it populates in excel on my local computer. Is there any way to install the Sage 300 BI tools on my local computer with the sage 300 files being set up remotely…
  • Accpac ComAPI asking for parameters

    Hi, I have written a console app in C# to export Purchase Orders to PDF. When using the standard Crystal file that ships with Sage 300 (POPOR01.rpt), the export works perfectly fine without requiring user intervention. If, however, i change to the…
  • AP Invoice Date and Check Date Report

    I am having trouble finding any AP report that I can range/condition to display both the check date, not payment date, and the original invoice date. The payment date is prefilled when the invoice is entered, so that data is meaningless, the actual check…
  • T5018 (CPRS) Print Form Option No Longer Available To User.

    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…
  • Print Conditions

    Can I set a Print Condition on a LOOKUP Formula? I successfully added a LOOKUP formula to my report. When I go to set a Print Condition based on that field, I get the never ending spinning circle.
  • Sage 300 - FR - Microsoft Compatibility checker?

    Hello, When I generate a Financial Statement in Sage 300 I now get a MS Excel Compatibility Checker warning. When I generate numerous reports at once I now have to sit there and push 'okay' for the process to continue. This did not happen until last…
  • Antregrate Custom made piped Crystal Report / existincg Exe in Sage 300 Web Screen

    Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.
  • sage 300 Retail (RMS) error: crystal reports: f(20728)

    I am trying to print an invoice, in retail POS, but I am getting the error above.