• 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…
  • General Ledger Budgets

    Is Creating a Budget in General Ledger a useful tool or is it better to create the budgets in Excel and export the data from GL?
  • 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?
  • Sage 300 2024 - FR Web Screens

    Hi, I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade. When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine. Sage 300 2024…
  • Some Invoices Number not show in A/R -> Aged Trial Balance

    After User creates an invoice and posts it in the Order Entry module, the invoice should appear in the A/R -> Aged Trial Balance. but the invoice does not appear. then I checked the A/R module -> Posting Errors. And it turns out, the invoices had an error…
  • 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…
  • 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
  • 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 web API Financial Reporter

    Sage web API Financial Reporter how can I retrieve the EBITDA using the web API
  • 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…
  • Statetement designer - not updating current year figures

    Hello, I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs…
  • 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
  • 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…
  • Financial Reporter - Legal Name

    Hi We have difference details input in "Doing Business As" and "Legal Name" in the Company Profile. And we wanted to add these 2 field in our FR. But the field name "CoName" from FR Paste is linked to "Doing Business As". I can't hardcode this…
  • Monthly Trail balance for Prior year

    Hi I am creating a trial balance report to breakdown all the month balance for current year and prior year in one report. Our year end closing is on 30 June of each year. The information show correctly for all the months of the current year with…
  • Financial Reports Formula to get a total from multiple range in a single line

    Hi, refer to the below, row 193 is the total from row 194 & 195 What formula should I put in cell A193 if I want to sum the range as show in row 194 & 195 and it will not show or print when it is Zero? Same goes to A203. Any advice?
  • FR stops working: error in running connectcomaddin in macro, Sage 300 2020 pU2, Office 2016

    We tested this feature a couple of weeks ago (financial reports) and it worked fine, we could run all financial reports. Now, after we went live, it stops working with the "Error in running connectcomaddin" in macro. I got it to work 2 days ago and…
  • FR cannot get results for branches by Account Group

    Hi Above the FR was working fine with comparison for Current Year & Last Year in Column H & J. But we want to add in the balance for each branch - J001, J002, J003 & J004. which using the segment 2 before the Current year. So I have tested with…
  • Roll up Parent Child Relationship

    Hi all, I am making custom financial report. How do I check if an account is Rollup, Both, Member, or No as in COA Screen? Is there any function to display Parent-Child Relationship? Thank you.
  • Columns and rows is cut off

    Hi All, I am making a new Financial Report. After 1st FR View, all the columns and rows lets say column A-E, row 1 to 5, are showing. Then I add more columns (F-H) and row (6-10), the new columns and rows are not showing after FR View. IT even remove…