2653 rfd

From UG

Contents 1 Info 2 Requirements and Solutions 2.1 Summary 2.2 Filters 2.3 Output 2.3.1 Header 2.3.2 Sections 2.3.3 Net Payable or Recoverable 3 Architect Review 4 Implementation Notes 5 QA Plan 6 History 7 Figures

[edit] Info

• mantis: 2653 ((Acc Report: Misc) add feature to show total VAT charges separately

[edit] Requirements and Solutions

• Task type: Feature (new report).
• Where: Accounting Reports.
• What: Report to show the VAT charges separately for both Sales Invoices and Purchase Invoices.
  • The report should also:
    • Show Net Amount for each line. It is total invoiced amount excluding the VAT charges.
    • Calculate total Net of Payable (Recoverable). It is difference between total VAT on Sales and total VAT on Purchases.

[edit] Summary

The report should have two separate sections:

• Sales Invoices - showing all Sales Invoices.
• Purchase Invoices - showing all Purchase Invoices.

Each section should have total line at the bottom. Totaled columns specified in Output.

• The report must be downloadable to Excel.
• CT number and Invoice number should be hyperlinks:
  • This can be mapped the same as Acc > Reports > Search Invoices.

[edit] Filters

• Date Type (same as Acc > Reports > Profit/Loss for Multiple CT's):
  • Sailing Date
  • Issuing Date (of Invoice)
  • Created Date (of CT)
  • Revenue Recognition Date
• Date (same as Acc > Reports > Profit/Loss for Multiple CT's):
  • Month and Year. Month dropdown, Year dropdown, Clear button.
  • Date Range. "From" datebox, "To" datebox, Clear button.
• Offices - So the operator can select one, multiple, or all (should be multiselect).

[edit] Output

[edit] Header

Header should summarize filter options showing:

• Name of Report: VAT Reporting
• Date of Report
• Date Range of Report:
  • if selected Month and Year:
    • CT sailed/issued/created on Month: Full name of month
    • CT sailed/issued/created on Year: Full year displayed
  • if selected Date Range:
    • CT sailed/issued/created on date from: day-month-year
    • CT sailed/issued/created on date to: day-month-year
• Offices: If selected.

[edit] Sections

Report has two self-titled sections: Sales Invoices and Purchases Invoices.

Each section contains the same set of columns for appropriated invoices:

• Issuing Office
• Invoice # (as Hyperlink)
• CT# (as Hyperlink)
• Invoice Date
• Reported Currency
• Net Amount (total invoiced amount - VAT = Net Amount)
• VAT Amount
• Total Billed (total invoiced amount)

Note: Net amount, VAT amount, and Total Billed Amount should be totaled at the bottom of the section

[edit] Net Payable or Recoverable

• This should display the value calculated by formula: total VAT in sales section - total VAT in purchase section.
• A negative number should be displayed using () - round brackets. Example, (128.64).

[edit] Architect Review

[edit] Implementation Notes

[edit] QA Plan

[edit] History

[edit] Figures