2653 rfd

From UG

Revision as of 18:54, 8 March 2011 by Andrei (Talk | contribs)
Jump to: navigation, search


Contents

Info

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

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.

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.

Filters

  • Date Type: (same as Acc > Reports > Profit/Loss for Multiple CT's)
  • Date: (same as Acc > Reports > Profit/Loss for Multiple CT's)
  • Offices - So the operator can select one, multiple, or all. Check boxes have been suggested because it is only 4 choices: London, Paris, New York, Hong Kong.
    • question to BA about Brussels!!!

Output

Header

Header should summarize filter options showing:

  • Name of Report: VAT Reporting
  • Date of Report
  • Date Range of Report: need to re-write --Andrei 13:54, 8 March 2011 (EST)
    • CT sailed/issued/created on Month: Full name of month or CT sailed on date from: day-month-year
    • CT sailed/issued/created on Year: Full year displayed or CT sailed on date to: day-month-year
  • Offices: If selected.

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

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).

Architect Review

Implementation Notes

QA Plan

History

Figures

Personal tools