The amount of data organizations handles each year grows exponentially as their business expands, as does the number of users who require access to this data in the form of reports. The complexity of reports is also increasing as management at all levels demand access to up-to-the minute information on which to base business-critical decisions.
It is no wonder then that reporting is increasingly demanding more time and resources; and as a result, contributing additional costs to a business.
Organizations that embark on a custom developed system are in a unique position to ensure they get access to the essential reports they need to better manage their business. But often, although mentioned at the start of a project, the details surrounding reporting is not considered until the system is built. The consequence of this is that often the data required to produce these reports is not captured and the system requires additional work.
On this wiki page we will cover:
Workspaces in Dynamics 365 FO are a collection of commonly used links, tiles, lists and jobs that a specific user would perform in their role in the organization.
Inquiries; these are forms used for quickly and easily reporting transactions where the transactions are listed. Advanced filtration allows the facility to reduce the inquiry results to a number of specific results. If it is required that you show all the transactions, don't identify any filter.
Reports; can be defined simply as any static visualization of a structured data set. This may include transactional data presented in a tabular layout and advanced graphical views of aggregate information. To account for this broad definition, the application offers several tools to produce reports to satisfy complex business requirements. One of these tools is SQL Server Reporting Services.
Each workspace is geared toward and optimized for common roles within the organization. Workspaces are intended to be the single point of entry into the application and where the user will spend the majority of their time as they complete various tasks, monitor specific reports and KPIs, and manage their day to day responsibilities. In this article I’ll take you through all you need to know to take full advantage of this excellent productivity feature in Dynamics 365 Finance and Operations.
This inquiry provides a list of HSE and GRC actions displaying the site, department, location, source job plan, legal entity, and relevant dates. The graph provides a summary of the Actions status count and the Actions source count.
Graph legend:
Color
Referent
Red:
More than 15 days overdue
Yellow:
Between 5 and 15 days overdue
Green:
Between 0 and 5 days overdue
Blank:
Not overdue
The total amount of days overdue are displayed in the far-right hand side column
A flat list of all the open GRC actions can be accessed by following this path: GRC > All open Governance, Risk and Compliance actions
Before you create a user account for someone who will use the Vendor portal, you must set up the vendor to allow for Vendor portal collaboration. Use the Purchase order collaboration field on the General tab on the Vendors page.
Go to: Purchase ledger > Vendors > All vendors
Select the relevant Vendor
Under the General Fast tab, Under the Vendor collaboration Field group, select Yes to activate Vendor collaboration
External vendors that use the Vendor portal must have the following setup:
A Microsoft Azure Active Directory (AAD) user account must be registered for the vendor on the Users page in Dynamics 365.
The vendor must have the Vendor (external) security role, not the SystemUser role.
NOTE: The SystemUser role is automatically granted when you create a new user account in Dynamics 365. Therefore, you must remove that role and acknowledge the warning message that you receive.
The vendor user should not be granted permission to add additional fields from the PO tables to their view of the PO. On the Personalization tab, on the Users tab, set the Explicit personalization allowed option for the user to No.
The user account must be associated with a registered contact person. On the Users page, select a contact person in the Name field. The person that you select should have the Contact role for the relevant vendor.
If the same person requires access to the Vendor portal for multiple vendor accounts (for different legal entities, perhaps), each of that person's user accounts must be associated with the same registered contact person. The Vendor (external) role includes all the basic capabilities that are required in order to use the functionality that is available in the Vendor portal. This setup helps guarantee that the user interface that the external user sees, is focused on the intended scenario only.
If you want someone to have access to vendor collaboration, they first have to be added as a vendor collaboration contact. You may also want to add contacts for employees in your company who won't use vendor collaboration. For example, they could be the point of contact for other kinds of procurement information. New contacts are added on the All contacts page.
Go to: Vendor collaboration > Contacts > All contacts
On the Action pane, click New
On the Create contact persons dialog, enter the contact person details
Choose which legal entity they're representing in your company, and which legal entity they'll work within the company that they'll collaborate with. You do this by selecting a Legal entity in my company/Legal entity in customer company pair.
Click Create
It is only possible to delete the contacts that you have created
Opens the New license dialog from where a new license can be created
Vendor certifications:
The number on the tile indicates the number of vendor certificates that will expire in 30 days from the current date
Clicking on the tile opens up a list of all vendor certificates that will expire in 30 days from the current date
Licenses expiring in 30 days:
The number on the tile indicates the number of licenses that will expire in 30 days from the current date (If the status is not Expired)
Clicking on the tile opens up a list of licenses that will expire in 30 days from the current date (If the status is not Expired)
Scheduled meetings:
The number on the tile indicates the number of scheduled meetings
Clicking on the tile opens the All open scheduled meetings list page
Courses closing this month:
The number on the tile indicates the number of courses closing in the current month
Clicking on the tile opens the Courses list page and only the courses that will be closing in the current month are displayed
Checklists due in 1 week:
The number on the tile indicates the number of checklists that are due in 1 week from the current date
Clicking on the tile opens the All checklists list page and only the checklists that are due are displayed
Customer contracts renewable this month:
The number on the tile indicates the number of Customer contracts that are up for renewal in the current month
Clicking on the tile opens the Sales agreements list page and only the contracts/sales agreements that are up for renewal in this month are displayed
Vendor contracts renewable this month:
The number on the tile indicates the number of Vendor contracts that are up for renewal in the current month
Clicking on the tile opens the Purchase agreements list page and only the contracts/purchase agreements that are up for renewal in the current month, are displayed
Other contracts renewable this month:
The number on the tile indicates the number of other contracts that are up for renewal in the current month
Clicking on the tile opens the Policies, contracts and reports list page and only the records that are up for renewal in the current month, are displayed
Functions of the Documents that will expire in 30 days tabs:
Licenses: Displays all recorded licenses that will expire in 30 days
Courses: Displays all recorded courses that will expire in 30 days
Open checklists: Displays all open checklists that will expire in 30 days
Open meetings: Displays all open meetings that will expire in 30 days
Sales agreements: Displays all recorded sales agreements that will expire in 30 days
Purchase agreements: Displays all recorded purchase agreements that will expire in 30 days
Contract register: Has an additional filter for Document type
Vendor certificates: Displays all vendor certificates that will expire in 30 days
The user can choose to view all controls for either Enterprise risks, Operational risks, Environmental risks, or all the risk controls combined, for the selected” From accounting year” and/or selected “Site”.
Record new incident: Opens up the Report an incident form
Record new permit to work: Opens up the Record a new permit to work form
Create a new inspection: Opens up the Inspections form
All open reported incidents:
The number on the tile indicates the number of open reported incidents
Clicking on the tile opens the All open reported incidents list page
Open investigations:
The number on the tile indicates the number of open investigations
Clicking on the tile opens the Open investigations list page
Open permits to work:
The number on the tile indicates the number of open permits to work (Permit status = Recorded)
Clicking on the tile opens the Open permits to work list page
Functions of the Details tabs:
All incidents: Displays all recorded incidents
All closed incidents: Displays all closed incidents
Incidents reported by me: Displays all incidents reported by the logged in user
Incidents reported to authorities: Displays all incidents reported to the relevant authorities
Fatal incidents: Displays all incidents that were reported with fatalities
Nearmisses: Displays all recorded incidents that were near misses
Investigations where I am responsible: Displays all recorded investigations that the logged in user is responsible for
Inspections for me to complete: Displays all recorded inspections that the logged in user has to complete
Permits to work requested by me: Displays all recorded permits to work requested by the logged in user
Buttons under the Print Fast tab:
Three year injury stats: Displays stats for three years. The Year selected on the Parameters dialog will be the last year of tree displayed on the graph.
Incident graphs: The Near misses graph as well as the Vehicle incidents global graph, displays stats for three years. The Year selected on the Parameters dialog will be the last year of three displayed on the graphs.
Investigations graph: The Investigations graph is used to display the status of investigations.
The KPI name, Target, and Actual values as well as the Budget model used, is displayed in the grid. A detailed summary of the selected record is also displayed in the bottom section of the screen. Under Calculation, the formula that was used to calculate the selected KPI is displayed.
Specific results can be viewed on the Incident graph by clicking on/hovering over the required pillar. The table on the right-hand side displays the actual number of incidents per classification that are viewed on the graph.
Incidents – Takes the user to the incidents that are relevant to the selected site
Inspections - Takes the user to the inspections that are relevant to the selected site
Permits to work - Takes the user to the permits to work that are relevant to the selected site
Work orders - Takes the user to the list of open work orders created for the selected object
Risks – View the Risk registers associated with the object/location
View – Provides a dropdown list of the details that can be viewed for the selected site
Print - Provides a dropdown which gives the user the option to print either the Location safety report or the Object safety report for the selected site
This inquiry provides a complete view of all safety aspects for the selected location and related objects. This includes their hazards and risks, then by using the buttons as described below users can view reported incidents, inspection and permits to work.
Select the relevant Location/Object from the left-hand side of the form.
Expand the Fast tabs on the right-hand side of the form to view the graphs and details
The Risk register detail report provides a more detailed overview of a specific risk register. The inherent risk exposure and residual risk exposure, as well as their controls are displayed.
GRC > Risk > Reports and inquiries > Enterprise risk movement analysis report
Select the parameters and then click OK
It is important that the combination for Month and Year selected under the Period view field group, is correct. If there are no transactions for the selected period, the report will be empty.
The Risk analysis inquiry displays Inherent as well as Residual risks. Values are shown using percentages as well as colors to identify and evaluate risks.
A pivot template with the graphs can be created in Excel, for example, “Inherent exposure by profile”
GRC > Compliance > Reports and inquiries > Audit non conformance report
Select the parameters and then click OK
A non-conformance means that something went wrong – a problem has occurred and needs to be addressed. Non-conformances are addressed with corrective actions. The Audit non-conformance report gives a summary of the selected non-conformance which can be printed and signed by the parties involved.
This graph will display the Actual vs target values of a specific row in a graphical form as well as in a table form, for all twelve months of the fiscal year.
GRC > Operational & sustainability reporting > Reports and inquiries > Reporting area row target vs actual graph
Use the filters to select the data that you want to display
HSE > Safety and security > Reports and inquiries > Safety meetings graph
Select the parameters and then click OK
The above graph displays the adherence to scheduled meetings, as well as the attendance of the meetings. The data displayed can be filtered by year, site or department.
HSE > Hazards > Reports and inquiries > Hazards by classification report
Select the parameters and then click OK
After Hazards have been identified and recorded, and controls have been put in place to mitigate the possible realization of a hazard, users can view the listed hazards per category. This report will also flag if less than two controls are in place.
The Incident costs report summarizes the case with details of the case number, a short description of the incident and the amount that it cost the company.
When an Occupational Health and Safety incident or near miss has occurred, it is important that it is reported and managed properly in order to remedy the damage and prevent recurrence.
HSE > Incidents > Reports and Inquiries > Global incident report