2653 rfd
From UG
(Difference between revisions)
(→Output: first filling of section) |
m (→Filters: offices filter still incomplete) |
||
Line 28: | Line 28: | ||
* 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) | * 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.'' | + | * Offices - So the operator can select one, multiple, or all (should be multiselect). |
+ | ** ''Check boxes have been suggested because it is only 4 choices: London, Paris, New York, Hong Kong.'' | ||
** '''question to BA about Brussels!!!''' | ** '''question to BA about Brussels!!!''' | ||
Revision as of 14:01, 10 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 (should be multiselect).
- 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).