• Sage Intelligence - Server execution failed error (2024 PU1)

    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
  • Sage 300 2024 Encountered Error Code: 5 during FR Financial Statements Printing

    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…
  • 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…
  • FR Reporter

    need to take you back i have an FR report in the typical Vertical format with departments coming one after the other Admin Electrical Engineering i want this in horizontal format, the departments next to each other, column H, I, J for example…
  • Sage300 GL Financial Report print to file error

    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?
  • AP vendor transaction report preview

    How can I filter AP vendor transaction report to get actual result with GL transaction report.
  • How can I configure/place custom reports for web screen?

    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?
  • Sage 300 Financial Reporter Web API - hint at the future?

    *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…
  • What is the proper report to use to view orders invoiced but not shipped?

    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.
  • Financial report and Microsoft 365

    Hi all, its 2023, can we generate the Financial report with Microsoft Excel 365 now? I remembered last time, it only works on Office 2010. Thank you
  • 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…
  • Financial Reporter will not Preview

    We have a customer that is having an issue on 1 workstation only with the financial reporter. It will not generate in preview, but they can print to file. The same statement works from other workstations. It is Sage 300 2021 with the latest Produce…
  • Is Sage 300 2022 PU2 Compatible with MS Office 2021 32bit?

    Hi, One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2? They need to run FR, but encounters the following errors: Description: PrintReport…
  • Sage 300 Employee Information report crash

    We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…
  • Sage 300 v2022 and excel 64bit, balance sheet runs correctly in FR designer view, when printing financial statement using FR print icon does not balance.

    balance sheet does not balance, primarily problem with Net income accts not totaling correctly. No errors, just out of balance. installed 64bit addin correctly. Again, when running in designer no issues, running under print Financial statement icon…
  • Report of Additional Costs

    We add inbound freigh as an additional cost on our inventory purchases. How can I pull a report that tells me how much I'm spending on inbound freight?
  • Sage 300 FR formula

    Hi there, I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column? Thanks, Zia
  • PO wont display amount

    When I print my PO to PDF the amount is displayed by #### symbols. Is this a formatting error? I attached a snapshot of what it looks like. Thanks!
  • Sage 300 financial reporter

    Hi there, Can someone help me out an FR function here. I am new to the FR designer. I am using a report template that was created before me, function is below, but it returns the date format like 5/31/2021 =FR("PERIOD")&" Months Ended "&FR("END…
  • Code with leading zeros in FR report

    Hi, In an FR report, I have a heading like 00123 but in the output, it shows as 123. I have tried '00123 and formatting the cell as text but the output still comes out as 123. How do I preserve the leading zeros ? I need the leading zeros as these…
  • Criteria in function and column B of FR report

    Hi, I have an FR report where there is a criteria in column B and also in the FRAMT function third parameter in the default row. It seems that when I use the third parameter of FRAMT to set criteria, it ignores the criteria in column B. Is there a way…
  • Paid customer and job remain on AR Aging Detail reports (not crystal)

    Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
  • Is there a way to build a Purchase Order Report to include the "Ship to" name?

    We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…
  • Error in File OELABEL ... The table could not be found

    Hi Citiers, I have searched around and and followed all the tips found here there there with no uck. I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error. We got an Windows Server…
  • Crystal report Issue

    Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…