2653 rfd

From UG

(Difference between revisions)
Jump to: navigation, search
(Requirements and Solutions: intermediate stop)
(Requirements and Solutions: completed RFD)
 
(5 intermediate revisions not shown)
Line 12: Line 12:
** The report should also:
** The report should also:
*** Show '''Net Amount''' for each line. ''It is total invoiced amount excluding the VAT charges.''
*** 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.
+
*** Calculate total [[#Net Payable or Recoverable | '''Net of Payable''']] (Recoverable). ''It is difference between total VAT on Sales and total VAT on Purchases.
''
''
=== Summary ===
=== Summary ===
Line 26: Line 26:
=== Filters ===
=== Filters ===
-
* Date Type: (same as Acc > Reports > Profit/Loss for Multiple CT's)
+
* '''Date Type''' ''(same as Acc > Reports > Profit/Loss for Multiple CT's)'':
-
* Date: (same as Acc > Reports > Profit/Loss for Multiple CT's)
+
** [http://ct.jaguarfreight.com/wiki/Sailing_Date Sailing Date]
-
* 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.''
+
** Issuing Date ''(of Invoice)''
-
** '''question to BA about Brussels!!!'''
+
** [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 ===
=== 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 ==
== Architect Review ==

Current revision as of 14:35, 15 March 2011


Contents

[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):
  • 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

Personal tools