This article is part of the R365 Financial Report Writer training on Building Reports. Click here for more information on Building Reports and click here for more information on R365 Financial Report Writer.



The 'Custom Financial Reports' list located in the 'Reports' subsection in both the Accounting and Operations modules is where you can view, create, and edit Reports for your Custom Financial Reports.  


The R365 Financial Report Writer includes several example Templates and Reports that can be ran 'out-of-the-box' once the service has been enabled and provisioned. Reports exist in a direct relationship with a Template and allow the User the ability to save a specific set of parameters as a Report from each Template. By default, when a new Template is created, a corresponding Report is also created, which can be easily modified at a later date if needed. Click here for more information on Templates.


This article will describe the following:

  • View your list of Reports and see which Template is used on a particular Report
  • Create a New Report - based off of an existing Template
  • Modify a Report Name
  • Open, Edit or Delete a Report
  • Templates, Template Rows and Template Columns will not be described in this article.  Click here for more information on Templates, Template Rows and Template Columns


Click here to learn more about Combination Reports.


Reports List


When the 'Custom Financial Reports' list is first loaded, the 'Reports' tab will be selected by default.  On this tab you can view your list of existing Reports, as well as create new Reports, or modify existing Reports.



1) Templates / Reports Tab Selector - The options for Custom Financial Reports. The 'Reports' tab will be selected by default

2) Create Report Button - This will open a prompt where a new report can be created

3) Search - Reports can be searched for by Name in this field

4) Quick Filters - The Report Category of the report. Click here to learn more about Combination Reports

5) Reports List - Reports that are included in the selected Template Category / Search Results will be displayed in this list

6) Default Indicator - This indicates that the Report is part of the Default or Example Reports that are provided with the R365 Financial Report Writer

7) Filters Applied Indicator - This indicates that filters were applied to this report from the 'Filters' tab

  • Note: Review the applied filters to ensure that the selected report returns the correct data 

8) Quick Parameters - Expand the arrowicon to view and set Quick Parameters before clicking Run to run the report

9) Run Button - The Run button will run the report as-is, without adjusting any other parameters, and either export or email the report as a PDF or Excel file



10) Favorite Report - This will mark the Report as a Favorite. The star icon on a Favorited Report will become filledand the report will appear in the 'Favorites' sub-list that appears after the first report is marked as a 'Favorite'

11) Hide - This button will hide a report from a User's view. Once hidden, a report can be found at the bottom of 'All Reports' or its designated Report Category under 'Hidden Reports'. A report can be hidden or unhidden at any time by clicking the hidden symbol

12) Edit / Delete Actions - Th Edit icon will edit the Report Title. The Delete icon will delete the report

13) Linked Template - The linked Template for the Report. Users with the following permission can click through this link to open the Financial Report Writer and view (and for non Default Templates) edit the Template

  • Reporting → Custom Financial Reports → Templates → View/Create/Edit/Delete CFR Templates

14) Viewer Access - A drop-down menu of all Report Roles. Once a Report Role is clicked, it enables specific Users access to that selected report. View more information on Viewer Access and Assigning Reports here

15) Organization Units - All Organization Units, which should have the necessary units checked to include them in the Report when it is ran.  Refer to the 'Creating Reports' section below for more information

16) Filters - The filters that will be used on the Report. When filters are set, the 'Filters Applied' indicator (#7) will appear next to the report name



17) Settings - The settings for the report. Update the following Report Settings prior to running the Report



18) Manage Org Units - If the Organization Units need to be updated, click this to navigate directly to the 'Organization Structure' tab of System Preferences and make the necessary changes

19) Report Multiple Organization Units As - This selection will determine how the report is created. Options include:

  • Individual Reports - This will create an individual report for each Org Unit selected. This is the default option
  • Consolidated Report - This will pull the data for all of the Org Units selected into one single report 
  • Consolidated + Individual Reports - This will create one consolidated report and an individual report for each Org Unit selected

20) As Of - Run the Report as of the desired Time Frame Type selected in the Report Columns. By default, the current Date will be loaded. This can also be set in the Quick Parameters (#7)

21) Report Date - This date directly connects to the time range represented in the Time Frame (TF) Column Type. If the TF Type is not set to 'Time Frame to Date', then the selected date will represent the entire time frame. If the TF Type is set to 'Time Frame to Date', then the column will represent data up to the selected Report Date

22) Cover Page Title and Data As Of (Time) - If an optional Cover Page is required for the Report, enter the Text that will serve as the title of the Cover Page in this field. When the Report is ran, a simple Cover Page with the entered title will be the first page that is generated. The Data As Of (Time) indicates the most recent time that data was polled from the POS

23) Save Options - Three options are presented for saving the report:

  • Save - Save the updated non-default Report Parameters
  • Save & Run - Save the updated non-default Report Parameters and run the Report
  • Run - Run the Report with the Parameters (Organization Units, Filters, and Settings) in place and can either export or email the report as a PDF or Excel file

24) Close - Close the selected Report and return to the full list of Reports. This hides the full parameters pane


Creating a Report


 

Each Template you create will also automatically create a corresponding Report. Alternatively, you can manually create a Report by clicking 'Create Report' on the Template list.


 

Upon doing so, the 'Create new report' prompt will appear where you will select which Template the new Report will be based on.



Once you select an option, the prompt will close and the Parameters Pane will appear next to the Reports list. The 'Report Name' line will appear with the Name of the Template you selected followed by a Number in parenthesis.


Update the Report Name to the desired value, then proceed to update the remaining parameters in the Parameters Pane, which are described below.

  • Note: While you have the option to update these Parameters and save them as a Unique Report, you also have the ability to change the Report Parameters after you run the Report.  This will be described in further detail in the Running Reports article.



Organization Units



By default, 'All' Org Units will be checked when you create a new Report. Expand the selection if you want to set specific parameters and proceed to check each Organization Unit that will be included in the Report when it is ran, as shown above. A Search Bar is also listed to help navigate to the desired Locations easily.

  • Note: A 'Select all children' line will appear when hovering over an Organizational Unit, which will check off that parent and all of the children of that parent when clicked.


In addition to this, decide how you want your report to run based on Org Units. Options include:

  • Individual Reports - This will create an individual report for each Org Unit selected. This is the default option
  • Consolidated Report - This will pull the data for all of the Org Units selected into one single report 
  • Consolidated + Individual Reports - This will create one consolidated report and an individual report for each Org Unit selected



Filters



Next, set any additional Filters that will be used by default when the Report is ran.



Settings


The final step is to update the additional Report Settings. Click here to learn more about Report Settings.


To complete the Report Creation process, click the Save button.  Your New Report will now be listed in alphabetical order in the Reports list: