2653 rfd
From UG
(Difference between revisions)
(created RFD) |
(→Requirements and Solutions: intermediate stop) |
||
| 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 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) | ||
| + | * 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 === | ||
== Architect Review == | == Architect Review == | ||
Revision as of 00:08, 8 March 2011
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.
- The report should also:
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!!!
