• 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…
  • 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…
  • 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 Income Statement in comparison by Segment (Branches)

    We have a database for Company A with 10 branches and another database for Company B with 6 branches. Both using the same COA with Segment-1 as GL Code and Segment-2 as Branches. We need an Income Statement to show the comparison of branches in one…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • Financial Reporter - equivalent SQL statement of FRAMTA("BALP")

    Hi, Does someone written and willing to share a SQL statement that is an equivalent of FRAMTA("BALP") from the Financial Reporter? I am trying to figure out how our GL Inventory account is calculated. I read one of the discussions to run trial balance…
  • initializing fr error (30) or initializing fr error (3)

    Was just doing a new installation of Sage 2018 on Windows 10 machine and kept getting this error. (error 30 if trying to start statement designer and error 3 if trying to print financial statement) Tried all the usual fixes and nothing worked. Even had…
  • FR Reporter - Excel sudden weird behavior.

    Hi, A client has been printing an FR Report for many months now but then she suddently started to receive an error message this week: "Initializing FR Error (12) : Fail in starting Print Financial Statements" I tried a few of the usual MS-Excel…
  • FR View

    Good day, I have a problem with my FRView and I am desperate for help. FRView does not function properly on one of my Servers. The specifications are: Server 2012 R2 8 Virtual CPUs 16GB RAM 200GB virtual HDD When an FRView report is…
  • Financial Reporter

    Client is currently revisiting their chart of accounts as it is making report writing impossible. They are also moving to sage intelligence but I had a quick query. They are trying to insert ”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545…