2653 rfsa

From UG

Revision as of 21:41, 28 February 2011 by Tracie (Talk | contribs)
Jump to: navigation, search


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

File:Vat Report Location.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 ====
Personal tools