Projects:CashFlowForecastReport/Functional Documentation

Contents 1 Cash Flow Forecast Report for APRM - Functional Specifications 1.1 Overview 1.1.1 Purpose 1.2 Design Considerations 1.2.1 Dependencies 1.3 Glossary 1.4 Functional Requirements 1.4.1 User stories 1.4.2 User Interface Mockups

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

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

Category: Projects ERP