¶ Introduction
As organizations grow, the volume of data they handle each year increases exponentially. The number of users who require access to this data in the form of reports also grows, and the complexity of these reports is rising due to demand from management at all levels for up-to-the-minute information to make crucial business decisions.
It is not surprising that reporting requires more time and resources, resulting in additional costs for businesses.
Organizations that opt for a custom-developed system have the opportunity to ensure they have access to critical reports that enable them to manage their business more effectively. However, the reporting aspect is often not given enough consideration until after the system has been built, despite being mentioned at the start of the project. As a result, the necessary data to generate these reports is often not captured, and additional work is required to integrate the reporting system.
This wiki page will provide information on Workspaces, Inquiries, and Reports.
- Workspaces are interactive dashboards that provide a customizable, role-based user interface for accessing and analyzing data. They display a collection of related information and tasks, such as data lists, charts, and reports.
- Inquiries allow users to retrieve and view specific data in a table format. They are often used to perform ad hoc queries, analyze data trends, and identify patterns. Inquiries can also be customized to show specific data fields and filter information based on certain criteria.
- Reports provide a more structured and formal way of presenting data. Reports can be created using Microsoft Power BI or other third-party reporting tools and can be customized to meet specific business needs. Reports can be run on-demand or scheduled to run automatically on a regular basis. They can also be distributed in a variety of formats, including PDF, Excel, or HTML.
¶ Navigation
¶ Workspaces
Workspaces in Microsoft Dynamics 365 Finance and Operations are designed and optimized for common roles within an organization. They serve as the primary access point for the application, where users can complete various tasks, monitor specific reports and KPIs, and manage their day-to-day responsibilities. Workspaces can be tailored to the needs of different departments or job functions, making it easier for users to find the information they need and complete their tasks quickly.
This article will guide you through everything you need to know to fully leverage this highly productive feature.
¶ Investment management workspace
Go to: Treasury > Workspaces > Investment management
The following tabs can be used:
- My work
- Non-cash investments
- Investment funds
- Investment portfolio and
- Daily investment balances
¶ My work tab will display the following summary:
- tiles on the left for Open cash investments, Open non-cash investments, Create New Cash investment, New Non-cash investment and New investment portfolio.
- in the centre all cash investments will display in blocks with more detail inside.
- The balance for the specific cash investment, or all investments will display in a graph for Week, Month, Year, 5 years or all
¶ Investment Profile
- A graph for a selected Investment will display
¶ Daily investment balances
- Daily investment balances will display a list page of all the daily balances for Cash investments
¶ Loan management workspace
- Go to Treasury>Workspaces>Loan management
- There are five areas in the loan workspace:
- My work
- Loan profile
- Loan analysis
- Loans per group
- Daily loan balances
¶ My work tab
¶ Summary FastTab
- The Summary FastTab contains tiles of loans and users can filter on a specific Payable or Receivable loans, or Inter-company loans.
- All group loans can also be viewed.
- All of this has a drill down functionality which will direct the user to those loans. Alternatively a new loan can be created from here.
¶ Loans FastTab
- Payable and Receivable loans can be viewed in alphabetical order. Users can filter on one specific loan.
- The transaction type for these loans will be Actual
¶ Balance FastTab
- The third FastTab on “My work” tab is called Balance. A graph will be displayed
¶ Loan profile tab
- This workspace page contains information about the loan provider or receiver, as well as a visualization of the Interest, Payment and Capital amounts for a specific loan selected.
¶ The Loans analysis tab
The Loans analysis tab display the following graphs:
- Active loans (count) per status
- a count of all loans summarised, per loan status
- Active loans (amount) per type
- Loans per currency, per loan amount and per loan type
- Active loans (count) per currency
- a loan count per currency
- Active loans (amount) per month
- the current amount, per month, and for a specific currency
¶ Loans per group tab
- Contains a chart of all the loan types and amounts of loans for each type of loan
¶ Daily loan balances tab
- View results of a periodic job for daily balances after it has been run. It recalculates the balances as at today’s date.
¶ Facility management workspace
The facility management workspaces can be accessed by navigating to:
The workspace consists of the following areas:
- My work
- Dashboard
- Pledged position
- Bank utilization
- Cost of borrowing
¶ My work tab
¶ Summary FastTab
- Contains a summary FastTab, which displays the count of Credit facilities. The user can also create a new facility from this section.
¶ Facilities FastTab
- The second FastTab is called Facilities. This contains tiles of Active and Other facilities, sorted by number. Active facilities will have a Start date and Valid until date.
¶ Currency balances FastTab
- The third FastTab displays graph for the Currency balances for the facility that is selected on the tile in the middle of the workspace. The graph shows the Facility amount, Utilized amount and Remaining amounts
¶ Dashboard tab
Dashboard of the following:
- Banking limits:
- total of utilized facilities
- total of available (not used) facilities
- displayed as a percentage of total facilities
- Borrowing profile
- total of short-term facilities utilized
- total of long-term facilities utilised
- both displayed as a percentage of total facilities utilized
- Currency profile
- total of facilities utilized, per currency
- expressed as a percentage of total facilities
- adjusted for currency exchange rates
- Repayment of loan instalments over 7 years
- Amounts expressed in millions
- Source is Redemption amounts as per projected loan statements
- X-axis is years
- Y-axis is Total of repayment amounts in company currency
- Pledged securities position
- amount of assets pledged against total assets
- pledged percentage is Total of market value of all securities pledged against facilities, as a percentage of total assets
- available percentage is Total of assets less total of market value of pledged securities, as a percentage of total assets
- Repayments in next 12 months
- Based on loans, but filter out inter-company loans (only bank loans)
- Repayment totals for 12 months
- As a percentage of total payments, on all loans
- Total asset value
¶ Pledged position tab
- Pledged position graph
- Bank account summary
- Bank account summary
- Bank account
- Currency
- Requirement
- Pledged amount
- Variance
¶ Bank utilization tab
- Long term graph:
- Display balances linked to long term facilities
- Amounts rounded to thousands
- Totals per bank
- Per bank, broken into facilities available / utilised
- Total facilities per bank
- Total for facilities still available
- All balances linked to facilities (loans, bank, other)
- Keeping into account that limit may be fixed or floating
- Short term / overdraft graph:
- Same as long term, but only display facilities marked as short-term
¶ Cost of borrowing tab
- Dashboard indicating total % of cost of funding
- Show calculation for most recent quarter
- Bank rate to be captured in interest rate table, with selection to choose relevant rate.
¶ Loans Inquiries and Reports
¶ 1. Bank borrowings repayment plan
- Treasury>Loans>Inquiries and reports>Bank borrowings repayment plan
¶ 2. Cost of borrowing
- Treasury>Loans>Inquiries and reports>Cost of borrowing
¶ 3. Finance lease instalments report
The Finance lease instalments report will detail finance lease instalments per loan, number of monthly instalments remaining and the remaining period.
- Treasury>Loans>Inquiries and reports>Finance lease instalments report
¶ 4. Instalment adjutment report
The Instalment Adjustment report will detail differences between proposed instalments (split between interest and capital) and actual instalments
- Treasury>Loans>Inquiries and reports>Instalment adjutment report
¶ 5. Intercompany loan enquiry
- Treasury>Loans>Inquiries and reports>Intercompany loan enquiry
¶ 6. Intercompany reconciliation report
- Treasury>Loans>Inquiries and reports>Intercompany reconciliation report
¶ 7. Interest accrual report
- Treasury>Loans>Inquiries and reports>Interest accrual report
¶ 8. Interest outstanding
- Treasury>Loans>Inquiries and reports>Interest outstanding
¶ 9. Interest payments
- Treasury>Loans>Inquiries and reports>Interest payments
¶ 10. Interest rates report
The Interest rates report will detail the current interest rate applicable to each loan
- Treasury>Loans>Inquiries and reports>Interest rates report
¶ 11. Interest report
- Treasury>Loans>Inquiries and reports>Interest report
¶ 12. Interest variance enquiry
- Treasury>Loans>Inquiries and reports>Interest variance enquiry
¶ 13. Invested loans view report
The Invested Loans view report will display the value of investments that’s been made with the funds originating from specific loans
- Treasury>Loans>Inquiries and reports>Invested loans view report
¶ 14. Lag analysis report
Treasury>Loans>Inquiries and reports>Lag analysis report
¶ 15. Loan advice
The Loan Advice report shows the loan application details
- Treasury>Loans>Inquiries and reports>Loan advice
¶ 16. Loan aging enquiry
- Treasury>Loans>Inquiries and reports>Loan aging enquiry
¶ 17. Loan instalment in next 12 months
- Treasury>Loans>Inquiries and reports>Loan instalment in next 12 months
¶ 18. Loan Instalment Term Split
Current versus Long-term Loan Balances will be displayed on this inquiry. At the top of the inquiry page, there are selection boxes for both a date and a future date. By utilizing these dates, the report calculates both the current loan balance and the long-term loan balance. This report can easily be exported to Excel.
- Navigate to: Treasury > Loans > Inquiries and Reports > Loan Instalment Term Split
- The enquiry consists of the following columns:
- Loan number
- Company
- Customer account
- Start date
- Currency
- Original loan amount
- Ending principal balance
- Current loan balance
- The current loan balance incorporates the next 12 months of principal payments from the report's date.
- It differs from the installment amount as it excludes interest.
- Long-term loan balance
- This figure represents the ending principal balance subtracted from the current loan balance as of the selected report generation date.
¶ 19. Loan aging report
- Treasury>Loans>Inquiries and reports>Loan aging report
¶ 20. Loan margin
The Loan Margin will show the Cover ratio, Outstanding balance, Pledged amount, and Variance per loan type
- Treasury>Loans>Inquiries and reports>Loan margin
¶ 21. Loan past due report
- Treasury>Loans>Inquiries and reports>Loan past due report
¶ 22. Loan payment due enquiry
Treasury>Loans>Inquiries and reports>Loan payment due enquiry
¶ 23. Loan payment due report
The Loan Payments due report will indicate the listing of instalments and due dates per loan. Can utilise this report to inquire on payments due within a certain date period. The report provides a listing of all loan payments due, withing specific period.
On the Loan payments due report, there is a validation to ensure the “From date” is never dated before the current date (today’s date), because the Loan payment due report looks at the Projected loan statement amounts.
- Treasury>Loans>Inquiries and reports>Loan payment due report
¶ 24. Loan repayment report
The Loan Repayment report is a remittance to the bank for loan repayments
- Treasury>Loans>Inquiries and reports>Loan repayment report
¶ 25. Loan repayment request report
The Loan Repayment Request report is an instruction to the bank for loan advances to third parties
- Treasury>Loans>Inquiries and reports>Loan repayment request report
¶ 26. Expected credit loss enquiry
- Treasury>Loans>Inquiries and reports>Expected credit loss enquiry
¶ 27. Loan report
The Loan report provides a summary of all loans where the loan start date is within a specified date range
- Treasury>Loans>Inquiries and reports>Loan report
¶ 28. Loan settlement report
The Loan Settlement report will produce a letter to the bank with instruction for final settlement
- Treasury>Loans>Inquiries and reports>Loan settlement report
¶ 29. Loan trace table
- Treasury>Loans>Inquiries and reports>Loan trace table
¶ 30. Loan transactions report
- Treasury>Loans>Inquiries and reports>Loan transactions report
¶ 31. Loans hedged report
The Loan hedged report reflects the loans that have been designated as a hedging item in a hedging relationship.
- Treasury>Loans>Inquiries and reports>Loans hedged report
¶ 32. Loans per loan group - Current amount report
The Loans per loan group – Current amount report will display the balance per loan, summarised per loan group.
- Treasury>Loans>Inquiries and reports>Loans per loan group - Current amount report
¶ 33. Monthly finance lease report
The Monthly finance lease report will indicate the average instalment amount and number of instalments remaining
- Treasury>Loans>Inquiries and reports>Monthly finance lease report
¶ 34. Original vs projected report
- Treasury>Loans>Inquiries and reports>Original vs projected
¶ 35. Payment journal error log
- Treasury>Loans>Inquiries and reports>Payment journal error log
¶ 36. Statement of interest for loans
- Treasury>Loans>Inquiries and reports>Statement of interest for loans
¶ 37. Year wise repayment schedule
- Treasury>Loans>Inquiries and reports>Year wise repayment schedule
¶ Investments Inquiries and reports
¶ 1. Investment report
Treasury>Investments>Inquiries and reports>Investment report
¶ 2. Cash investment interest report
Treasury>Investments>Inquiries and reports>Cash investment interest report
¶ 3. Cash investments due report
Treasury>Investments>Inquiries and reports>Cash investments due report
¶ 4. Investment cash flow forecast report
Treasury>Investments>Inquiries and reports>Investment cash flow forecast report
¶ 5. Investment summary report
Treasury>Investments>Inquiries and reports>Investment summary report
¶ 6. Movement of funds report
Treasury>Investments>Inquiries and reports>Movement of funds report
¶ 7. Cash investment detail report
Treasury>Investments>Inquiries and reports>Cash investment detail report
¶ 8. Cash investment per type graph
Treasury>Investments>Inquiries and reports>Cash investment per type graph
¶ Registers Inquiries and reports
¶ 1. Guarantee contracts
Treasury>Registers>Inquiries and reports>Guarantee contracts
¶ 2. Surety/Loan link
Treasury>Registers>Inquiries and reports>Surety/Loan link
¶ 3. Facility margin
Treasury>Registers>Inquiries and reports>Facility margin
¶ 4. Facility trace table
Treasury>Registers>Inquiries and reports>Facility trace table
¶ 5. Facility transactions
Treasury>Registers>Inquiries and reports>Facility transactions
The Facility transactions report will indicate the movement against a facility. The report list all the transactions, with additional information regarding the interest rate. Date range, Facility number and Customer account can be filtered.
¶ Common Inquiries and reports
¶ 1. Daily balances
For a quick look at daily balances,
- in the navigation pane, go to: Modules>Treasury>Common>Inquiries and reports>Daily balances
- The Object type will indicate if the balance is a Loan, Cash-, or Non-Cash investment
- The Loan number ID can be seen in the Reference field
- Date indicates the day on which the Daily balance was revised
- Daily balance amounts will be shown in Transaction, Reporting, and Accounting currencies
Transactions in a financial system are typically recorded in a transaction currency, which is the currency in which the transaction took place. The reporting currency is the currency in which financial reports are prepared and presented, and the accounting currency is the currency in which a company's financial statements are kept and recorded.
Having the ability to view the daily balance amounts in all three currencies allows for a comprehensive view of the financial information and helps in effective financial management and analysis. The transaction currency provides a clear picture of the financial activity in the currency it took place, while the reporting and accounting currencies help in presenting the financial information in a manner that is easily understood and comparable across different periods and with other companies
¶ 2. Broker
Treasury>Common>Inquiries and reports>Broker
¶ 3. Cost of borrowing
Treasury>Common>Inquiries and reports>Cost of borrowing
- Choose a grouping between Bank institution, or Facility/Loan
- Select the period by clicking one of the following:
- Monthly
- Quarterly
- Yearly
- This will display a summary per bank institution.
