FFA

Acceptance Criteria:¶

• The system should allow users to generate a Debtors Transaction Report displaying all outstanding and cleared invoices.
• Report Header:
  • Company Name, Logo, Address, Contact Info, VAT Registration Number
  • Report Title: "Debtors Transaction Report"
  • Reporting Period (clearly stated From - To dates)
• The report should include the following details and any other fields as per the sample reports provided.
  • Client Name / Business Name
  • Client Code
  • File Reference
  • Department
  • Invoice Number/Credit Note/Debit Note Number
  • Transaction Date
  • Transaction Amount
  • VAT Amount
  • Currency
  • Exchange Rate
  • Payment Status (Paid / Unpaid / Partially Paid)
  • Outstanding Amount
  • Payment Due Date
• The system should allow filtering by:
  • Date Range (From Date - To Date)
  • Client Name
  • Invoice Status (Paid, Unpaid, Partially Paid)
  • Currency
  • Business Registration Number (BRN)
  • Department
• The report should include a summary section displaying:
  • Total Outstanding Amount
  • Total Amount Paid
  • Total Amount Due
• Formatting and readability:
  • Clearly aligned numeric columns for easy readability.
  • Amounts formatted clearly to two decimal points.
• The system should allow exporting the report in:
  • PDF
  • Excel
• Permissions & Access Control
  • Provide user access control to restrict report generation based on roles (e.g., only Finance Managers can generate reports for all clients, while Salespersons can generate for their assigned clients).
• Footer
  • Page numbering (Page X of Y)
  • Printed by <user>
  • Report generation Date & Time
• Error Handling & Notifications

  • If no data is available for the selected date range, display a message:

    "No data found for the selected period."

  • If the report fails to generate, log an error and notify the user.

{width="873" height="1236"}