Overview


The R365 Financial Report Writer is an added R365 service designed to give you the ability to customize the content, layout, and look and feel of your financial reports.  This article will provide an overview of the R365 Financial Report Writer.  


If you would like more information on the R365 Financial Report Writer, please reach out to your R365 Sales or CSM Representative or R365 Support 



Navigation


To access the R365 Financial Report Writer and your Custom Financial Reports, navigate to the 'Custom Financial Reports' subsection that will appear below 'My Reports'


  • Custom Financial Reports - 'Custom Financial Reports' are added to the 'Reports' subsection of each Module.  This is where you will create and access your Custom Financial Reports that are created via the R365 Financial Report Writer



Security


Security Roles


The following Security Roles have been created for use with the R365 Financial Report Writer:

  • Financial Report Builder - This is the administrative role for the R365 Financial Report Writer.  Users that are assigned this role will have the ability to create (or build) new Custom Financial Reports and Templates.  They will also have the ability to edit or modify existing Templates and Reports.  This role should only be given to Users that need these capabilities.  Users with the Financial Report Builder role will also be able to run and view Custom Financial Reports, and do not need the 'Financial Report Viewer' security role.
    • The 'Create Report' button will be visible for Users with this security role


    • All Template hyperlinks (used to open the Financial Report Writer to edit the Template) are clickable

    • The 'Financial Report Builder' is a secondary role and should only be assigned to Users with the following Primary security roles, to enabled their ability to build, run and view these reports:
      • Accounting Manager
      • Accounting Clerk

  • Financial Report Viewer - This is the usage role that should be assigned to each User that will be viewing existing reports in the 'Custom Financial Reports' list.  
    • The 'Create Report' button will not be visible for users with this security role
    • All Template hyperlinks (used to open the Financial Report Writer to edit the Template) are not clickable
    • The 'Financial Report Viewer' is a secondary role and should be assigned to Users with the following Primary security roles to enable their ability to run and view these reports:
      • Accounting Manager
      • Accounting Clerk
      • Restaurant Manager
      • Read Only Executive
      • Read Only Operations


Click here for more information on Assigning Security Roles, and here for more information on Security Role Descriptions


Location Access


The Locations that are assigned to each User on their User record will determine which Locations they will be able to view data for when running Custom Financial Reports.  If a User does not have access to a specific Location, they will not be able to view any data for that Location when running Custom Financial Reports.  Click here for more information on User Location Access


P&L Cutoff Security Considerations


In addition to the specific Security Roles that must be assigned in order to run Custom Financial Reports, a User's Report Roles (utilized primarily in 'My Reports') also determine what Custom Financial Reports and data the Users will be able to see and access.  


If a User has a Report Role that has a 'P&L Cutoff' that is set to 'Controllable' or 'Prime Cost', any Custom Financial Reports that contain GL Accounts outside of the scope of those Cutoff settings will not appear in the Custom Financial Reports list and will not be available for that User to run.  If the report is essential to the job function of that User, you may create a copy of the Template and remove the GL Accounts that are outside the scope of their Report Role.  They would then have access to the Report and be able to run it as needed.  Click here for more information on P&L Cutoff on Report Roles


To further illustrate this concept, please review the following hypothetical scenarios:


Scenario 1


User NameFrank Abignale
Report Role P&L CutoffPrime Cost
Custom Financial Report Contains GL Accounts in 'Operating Expense' GL Type?Yes
GL Accounts Outside Scope of Report Role?Yes
Can the User see/run the Custom Financial Report?No


Scenario 2


User NameMarty McFly
Report Role P&L CutoffControllable
Custom Financial Report Contains GL Accounts in 'Operating Expense' GL Type?Yes
GL Accounts Outside Scope of Report Role?No
Can the User see/run the Custom Financial Report?Yes


Scenario 3


User NameEdmond Dantès
Report Role P&L CutoffFull
Custom Financial Report Contains GL Accounts in 'Operating Expense' GL Type?Yes
GL Accounts Outside Scope of Report Role?No
Can the User see/run the Custom Financial Report?Yes




Initial Setup


The initial setup of the R365 Financial Report Writer requires the following:


  1. Your R365 Sales representative or R365 CSM enables the R365 Financial Report Writer
  2. You submit a request to provision your R365 Database for use with the R365 Financial Report Writer
  3. A user with the 'User Setup' security role accesses System Preferences and sets up Organizational Units for reporting purposes
  4. A User with the 'Financial Report Builder' security role builds and customizes your financial reports


Click here to be taken through each step of the R365 Financial Report Writer: Initial Setup



System Preferences: Organization Structure


The R365 Financial Report Writer allows you additional reporting capabilities through the creation of your own custom Organization Structure.  This means you will create your desired organizational hierarchy for reporting purposes.  Click here for more information on Setting up Your Organization Structure


Building Reports


Building Reports in the R365 Financial Report Writer requires you to Create Templates and utilize Row and Column Layouts within those Templates.  Finally when the Template and its contents are completed, you can build the Reports off of the Template.  Click here for more information on Building Reports, or use the direct links below to jump right to the desired topic in the Building process:


Running Reports


Once Custom Financial Reports have been created in your organization, any User with either the 'Financial Report Builder' or 'Financial Report Viewer' security roles will have the ability to run those Reports.  Click here for more information on Running Reports