2653 rfsa
From UG
(→Report Filters) |
|||
Line 34: | Line 34: | ||
[[File:Vat Report Location.JPG]] | [[File:Vat Report Location.JPG]] | ||
[[File:VAT report generated.JPG]] | [[File:VAT report generated.JPG]] | ||
+ | |||
+ | ===Outputs=== | ||
+ | HTML output | ||
+ | Header should summarize filter options showing | ||
+ | |||
+ | Name of Report | ||
+ | |||
+ | CT sailed on Month: Full name of month or CT sailed on date from: day-month-year | ||
+ | |||
+ | CT sailed on Year: Full year displayed or CT sailed on date to: day-month-year | ||
+ | |||
+ | Offices: If selected. | ||
+ | |||
+ | ====HTML Output Example ==== |
Revision as of 21:41, 28 February 2011
Contents |
Info
0002653: (Acc Report: Misc) add feature to show total VAT charges separately
Accounting needs a report to show the VAT charges separately and the net amount (amount excluding the VAT charges) for both Sales Invoices and Purchase Invoices. The report should also calculate a total Net Payable or Recoverable.
The total VAT on Sales - total VAT on Purchases = Net Payable or Recoverable.
Business Requirement
The report should have two separate sections
- One section showing all Sales Invoices.
- total at the bottom of all Sales Invoices.
- One section showing all Purchase Invoices.
- total at the bottom of all Purchase Invoices.
Must be downloadable to excel. CT number and Invoice number should be hyperlinks
Report 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)
Example
Outputs
HTML output Header should summarize filter options showing
Name of Report
CT sailed on Month: Full name of month or CT sailed on date from: day-month-year
CT sailed on Year: Full year displayed or CT sailed on date to: day-month-year
Offices: If selected.
====HTML Output Example ====