- 04 Jul 2024
- 4 Minutes to read
- Print
- DarkLight
- PDF
Custom Financial Reports page
- Updated on 04 Jul 2024
- 4 Minutes to read
- Print
- DarkLight
- PDF
This article describes the fields and controls on the Custom Financial Reports page. The R365 Financial Report Writer is an added R365 service allowing users to customize the content, layout, and look and feel of financial reports. For 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 Custom Financial Reports, in the Reports section of the left navigation menu, select Custom Financial Reports. |
Security
Permissions
The permissions listed here are associated with Custom Financial Reports. These permissions can be added to custom user roles or single users. Learn more about managing permissions and custom user roles here
Custom Financial Reports Permissions are found in the Permission Tree as follows:
Reporting
Custom Financial Reports
View All CFR Reports (Bypasses Report Role)
Manage Multi-Instance Financial Dashboard Views
Packages
Edit Custom Financial Report Packages
Create Custom Financial Report Packages
Delete Custom Financial Report Packages
Reports
Create/Edit Custom Financial Reports
Delete Custom Financial Reports
Templates
View/Create/Edit/Delete CFR Templates
The Permission Access report can be used to determine which user roles or users already have these permissions assigned.
Learn more about User Setup and Security here.
Viewing Custom Financial Reports
Report Roles
Custom Financial Reports must be added to a user's report roles in order to be viewed. Learn more about adding Custom Financial Reports to report roles here. To add Custom Financial Reports to a report role, the user must have the following permission:
Administration → Users → Report Roles → Create/Edit/Delete Report Roles
View All CFR Reports
Users with the following permission will be able to view all CFR Reports, regardless of which reports are included in their Report Role(s).
Reporting → Custom Financial Reports → View All CFR Reports (Bypasses Report Role)
Location Access
The locations that are assigned to each user on their user record determines which locations they can view data for when running reports. If a user does not have access to a specific location, they cannot view data for that location. Learn more about User Location Access here.
Custom Financial Reports list
Field | Description | |
---|---|---|
Templates / Reports / Packages | Allows the user to access different pages related to custom financial reports, including:
| |
Create Report | Opens the Create New Report prompt where users can build a new custom report from an existing template. | |
Search | Users can enter the name or partial name of an existing custom report in the search bar to filter the list. The list updates to display reports that match the search criteria. | |
Report Type tabs | Filters the report list to display only reports matching the selected report type. | |
Reports list | Displays a list of available reports. Each report row includes the following features:
|
Custom Financial Report side sheet
When a report is selected from the list, a side sheet appears. This side sheet can be used to adjust parameters and run the report.
Field | Description | |
---|---|---|
Report name | Name of the selected report. | |
Rename Report | Allows the user to edit the name of the report. | |
Manage Subscriptions | Opens the Subscriptions page, where users can create and manage report subscriptions. | |
Close | Closes the side sheet. | |
Template | Shows which template was used to create the report.
| |
Viewer Access | Users with the report role selected from this drop-down gain access to the report. For more information, see Assigning Reports. | |
Org Units tab | Organizational units selected on this tab are included in the generated report. | |
Filters tab | This tab is used to create and apply filters to the report. If filters are applied, the Filters Applied label appears next to the report name.
| |
Settings tab | This tab is used to view and update report settings. | |
Manage Org Units | Opens the Organization Structure tab of System Preferences, where users can make changes to the organization units. | |
Report Date(s) | The date range for the report, which corresponds to the Time Frame (TF) Column Type. If the TF Type is not set to Time Frame to Date, then the report date represents the entire time frame. If the TF Type is set to Time Frame to Date, then the column represents data up to the report date. | |
Cover Page | If an optional cover page is required for the report, this field is used to enter the title for the cover page in this field. The Data As Of (Time) indicates the most recent time that data was polled from the POS. | |
Save | Saves changes to the report settings. | |
Save & Run | Saves changes to the report settings and generates the report. | |
Run | Generates the report, which can then be downloaded to the user's device or emailed as a PDF or spreadsheet file. |