FFA

Generate a detailed Credit Note Report clearly listing all credit note transactions issued within a given date range, categorised by client, invoice reference, and charges (such as Freight, Unstuffing, Documentation, etc.).

Acceptance Criteria:

1. Credit Note Report Screen:

• Search and Filter Criteria:
  • Date Range (mandatory)
  • Client Name/Code
  • Invoice Number
  • Credit Note Number
  • Service (Freight, clearing, etc.)
  • Charge Type (Freight, Documentation, etc.)

2. Report Details:

• Report Header displays:
  • Company Name, Address, Contact Information, VAT Registration
  • Department
  • Report Title ("Credit Note Report")
  • Date range selection (From Date – To Date)
• Report Body includes clearly presented columns:
  • Date (Transaction Date of the Credit Note)
  • Credit Note Number (Reference of Credit Note)
  • Original Invoice Number (Associated Invoice Number)
  • Customer Code + Name (Clear identification of debtor receiving credit)
  • Charge Type (Charges Description. e.g. Freight, Documentation, Unstuffing, etc)
  • Charges Amount (Amount credited related to the charges, exclusive of VAT)
    • Note for this one, as per the sample report, some charges are displayed as a column in it, and the remaining charges are classified as others. Would it be possible to give a Total by each charge at the end of the report?
  • VAT Amount (VAT associated with credited charges)
  • Net Amount Credited (Total credited amount after VAT)
• Grouping & Subtotals:
  • A grand total summary at the end of the report.
• Summary of Charges by Type (end of report):
  • A separate clearly formatted table summarising each charge type across all credit notes for the report period. Refer to the summary proposed below, "Charge Type Summary for Period".
• Export & Printing:
  • Ability to export the report clearly in PDF or Excel formats.
  • Printable with clear formatting, ensuring readability.
• Formatting and readability:
  • Clearly aligned numeric columns for easy readability.
  • Amounts formatted clearly to two decimal points.
• 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.

Client's Sample report:

{width="629" height="444"}

Proposed report format:

Followed by this summary:

Charge Type Summary for Period: 01/03/2024 - 31/03/2024¶