2653 rfd

From UG

(Difference between revisions)

Jump to: navigation, search

Revision as of 18:54, 8 March 2011

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

@@ Line 32: / Line 32: @@
 === Output ===
+==== Header ====
+Header should summarize filter options showing:
+*'''Name of Report''': VAT Reporting
+*'''Date of Report'''
+*'''Date Range of Report''': need to re-write --[[User:Andrei|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 ==