2653 rfd
From UG
(Difference between revisions)
(created RFD) |
(→Requirements and Solutions: completed RFD) |
||
(6 intermediate revisions not shown) | |||
Line 9: | Line 9: | ||
* '''Task type:''' Feature (new report). | * '''Task type:''' Feature (new report). | ||
* '''Where:''' [http://ct.jaguarfreight.com/wiki/Category:AccReps Accounting Reports]. | * '''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 == | == 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.
- The report should also:
[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
- if selected Month and 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).