Projects:CashFlowForecastReport/Functional Documentation
Contents |
Cash Flow Forecast Report for APRM - Functional Specifications
Overview
Purpose
The purpose of this project is to make a report for Advanced Payables and Receivables Management module. This report shows the position of a Financial Account due to expected deposits and withdrawals within a selected period in the future.
Design Considerations
The filter side of this report should show the information below.
- Financial Account (Optional. If no one is selected all Financial Accounts will be displayed as result)
- Date Planned (Mandatory)
- "Break by Date" check-box
And should Display the following data
- Summary info
- Financial Account
- Current Balance
- Forecast
- Income: Sum of income amount expected to be deposited in the Financial Account.
- Payment: Sum of payment amount expected to be withdrawn in the Financial Account.
- Ending Balance: Resultant amount on the given Date Planned
- Detailed info (broken by Financial Account)
- Financial Account
- Current Balance
- Ending Balance
- Expected Movements
- Income
- Date Planned
- Date Invoiced
- Invoice No. (As a link to invoice plan)
- Business Partner
- Payment No. (As a link to payment)
- Amount
- Payment
- Date Planned
- Date Invoiced
- Invoice No. (As a link to invoice plan)
- Business Partner
- Payment No. (As a link to payment)
- Amount
- Income
Other considerations
- When printing the pdf file the first page must show the filters.
- When there is an Invoice Number value, this value must be a link to the payment plan.
- When there is a Payment Number value, this value must be a link to the payment.
Dependencies
Dependant on Advanced Payables and Receivables Management.
Glossary
- Income: Refers to any invoice plan or payment expected to be deposited within selected period.
- Payment: Refers to any invoice plan or payment expected to be withdrawn within selected period
Functional Requirements
User stories
Bob, the accountant of a food delivery company, wants to know the position of his bank accounts on Friday next week. This way he can avoid paying interest for any of his accounts in case there are not enough funds in any of them. He enters Friday next week as Date planned and runs the report.
There he finds out Account A is going to have a negative value due to some payments he has planned to do against it.
Thanks to this valuable info he decides to move some funds from account B to Account A before this negative value takes place ensuring there will be no additional cost associated.
User Interface Mockups
Html search view.
Exporting to .pdf (Filtering criteria missing. To be added in final report)
Exporting to .xls.
Not Available