Using Microsoft Business Solutions for Analytics-FRx you learn advanced report design including linking to external worksheet data, linking row formats, multi company consolidations, currency translation reporting and cash flow. A combination of instructor guided exercises and practice tutorials allow students to master their report design skills. A thorough understanding of these topics allows users to easily design and maintain standard and essential reports that organizations need to understand their financial position.
F32 file Defining the active spec set in the Company Information settings Navigation in the Specification Sets window Learn to "save as" between spec sets Learn to export and import between spec sets Lab : Saving between Spec Sets Lab : Export and Import between Spec Sets After completing this chapter, students will be able to: Assign a specification set to a company Create a new spec set Move building blocks between spec sets Module What we Know This chapter allows students to review the concepts learned so far by taking a concept quiz and modifying an existing report.
Lessons Review basic report design concepts Lab : Modify Building Blocks After completing this chapter, students will be able to: Modify an existing report Module Balance Sheets This chapter focuses on Balance Sheet design, another primary financial report. Students learn about Account Sets and how to create them, as well as functionality designed to keep Balance Sheets in balance.
Common uses of relational reporting include percentage of sales and percentage of total expenses, however this concept may be used for any report that requires reporting on a relationship between elements.
This chapter gives students an opportunity to correct a report containing some basic report design flaws. Lessons Importing a. Lessons Rebuilding the GL Index. Report Launcher is a separate Microsoft FRx component that allows users to generate reporting catalogs that have been created with FRx Report Designer. Based on student needs, this appendix is optional for classroom presentation. After completing this course, students will be able to: Understand basic navigation and report creation in Microsoft FRx Drill down, analyze, print and export from FRx Drilldown Viewer Efficiently create and distribute many financial reports including: Trial balances Balance Sheets Transaction detail reporting Trended reports Side-by-side presentation Relational reporting Actual vs.
Budget Rolling quarters Know some tips and tricks for increasing speed and accuracy of month-end close Create presentation quality reports Understand security settings within Microsoft FRx Understand many ways to improve your company's financial reporting package.
This class is intended for: Novice Microsoft FRx users Intermediate and experienced Microsoft FRx users who would like to refresh their skills or develop broader product proficiency FRx Software Corporation product resellers and consultants.
Materials Available:. Our Partners. Multiple Student Promotion. Government Promotion. HiTech Alumni Membership. Six Sigma Six Sigma Certifications. Six Sigma Training. About Project Management Institute. Thanks for the reply. When I double click, the account numbers appear, but no account description.
Anyway to get that to show up too in the Viewer? And they show up correctly in Excel? Is your Column Layout identical to mine in the second screenshot above?
Especially column B? Under Help About FRx. A wider column width in Column B got them to show up. I really appreciate your help. Victoria, We have a scenario where we are trying to show 2 GL accounts from the same compay side-by-side e. I would like to show revenue in one column and expense in another and then calc gross profit in the 3rd column.
This will help us list various programs in multiple rows and show revenue and expenese like we would in Excel. Not sure how to print the second column- is this another GL link in the row format-tried this, but could not get it to print.. I believe you should be able to do this with creating non-printing rows for the accounts, then using TOT columns and specifying what column to show which total in.
All users can access FRx reports on a specific machine except the TB report. But the same report can be accessed on other machines with FRx. Once the NP option is removed in the Column layout, the report prints.
As mentioned, only those machine s have a issue in printing the TB. We have never come across something like this before. FRx version for all machines: 6. I have not run into this particular issue, but there may be a few different things going on here. You mention that you have a Windows 7 machine running FRx 6. If this is for the report I am describing in this blog post, you could delete and recreate it pretty quickly.
If the new report works fine everywhere, then chalk it up to something having gone wrong with that one report. If this starts happening for multiple reports, you may want to try compacting the FRx databases to see if that helps. Well, I have a requirement of getting the output in XL, and in a specific number format, can it be possible in any of the settings? If you mean Microsoft Excel, you could either export from FRx and change the formatting as needed or create a report in Excel that goes directly against the SQL data.
The second option is a lot more work, but could produce a refreshable Excel report in the format you want that end users can run on their own. We have setup as our first year. This would automatically roll forward the Balance Sheet account balances to and close out the Income Statement accounts to Retailed Earnings.
FRx then is able to recognize and report on both the ending balances and the beginning balances correctly. Again, I do not know if MAS works similarly or, if so, whether you still have the option of re-doing this. I would consult with your MAS partner or support to determine the best approach for handling this. We are coming from QuickBooks and it was easy to change JEs so that the account balances would reconcile.
We did not want to post, because we knew that our books are still under audit, and there is always a possibility of an audit adjustment. We can also make additional BB entries if there adjustments, and we will have accurate beginning balances. Thanks for sharing this. Glad you were able to finally get this resolved. I was wondering if there is a way to create a two dimensional report in FRx. I have a group of companies that roll up into a parent company and I want to display the trial balance first by account and then by company.
Using Reporting Trees, I was able to create a Trial Balance by account that can be broken down by company if you drill down into one of the lines. However, I was hoping to have this information all displayed on the same report so it can be printed without drilling down. So in your case instead of having one column with a balance, you would have 3 of them. Thanks for you help. This would result in more columns than would fit on the report. Is there a way to do this that would display the information for each company in diferrent rows instead of different columns?
I was hoping for an easier way. Is there any way to suppress one row based on the values of another? I have the report setup, but when I suppress all empty rows the corresponding format rows remain in view. Thanks again for your help. You can only suppress rows that are bringing in GL accounts.
Not description rows or calculation rows. You may want to try posting the FRx newsgroup see the link under Newsgroups on the right side of this blog to see if anyone has other ideas for you. Instead, could you format the report to display the account balance in either a debit or credit column, depending ont he balance?
I am not aware of a way to do this in FRx. I have tried a few things, but have not been successful. I know I can do it easily in Excel once the data is there. The FRx team monitors it and will help if they can. Published: Monday, July 20, […]. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account.
You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email.
0コメント