2653 rfd

From UG

(Difference between revisions)

Jump to: navigation, search

Current revision as of 14:35, 15 March 2011

[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

@@ Line 9: / Line 9: @@
 * '''Task type:''' Feature (new report).
 * '''Where:''' [http://ct.jaguarfreight.com/wiki/Category:AccReps Accounting Reports].
-* '''What:''' Report to show the VAT charges separately for both Sales Invoices and Purchase Invoices.
+* '''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 Payable or Recoverable | '''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 |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)'':
+** [http://ct.jaguarfreight.com/wiki/Sailing_Date Sailing Date]
+** Issuing Date ''(of Invoice)''
+** [http://ct.jaguarfreight.com/wiki/CT#Created_On_Date Created Date] ''(of CT)''
+** [http://ct.jaguarfreight.com/wiki/Revenue_Recognition_Date 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 [http://ct.jaguarfreight.com/wiki/Reports_Filters#Multiselect multiselect]).
+=== Output ===
+==== 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.
+==== 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 ==