View source | Discuss this page | Page history | Printable version   

Modules:Invoice Tax Report

Contents

Invoice Tax Report - User documentation

Overview

Purpose

This module provides two reports:

Displaying the differences per document and comparing theoretic tax value (coming from Expense/Revenue accounts once applied tax rate) and real tax booked in the ledger.

The aim is to show possible discrepancies coming from invoice documents .

It also allows to retrieve the information in different formats as html, .pdf or .xls.

Source

The source of the information for this report is accounting. This way we can obtain the info in one single currency and as of date.


Reports

Two menu entries are created. One for Sales Invoices, called Sales Invoice Tax Report, and another one for Purchase Invoices, Purchase Invoice Tax Report.

These two reports can be found in the following application path: Financial Management // Receivables & Payables // Analysis Tools

Filters

As this report is based on accounting information, it will display information affecting tax accounts in the ledger, even if those do not come from an invoice. Following filters are used to include/exclude information coming from other documents than invoice (Payments, Financial Account Transactions, Reconciliations and GL Journals). These documents may generate postings using tax accounts into the ledger and with these flags that info can be excluded.


FiltersInvoiceTaxReport.png

HTML/PDF output

Sales Invoice Tax Report

It should Display a report grouped by invoice showing (Similar for Purchase Invoice Tax Report):


OutputInvoiceTaxReport.png

PDF and Excel output

The above output can be displayed in PDF or spreadsheet formats.

Retrieved from "http://wiki.openbravo.com/wiki/Modules:Invoice_Tax_Report"

This page has been accessed 1,778 times. This page was last modified on 5 February 2014, at 17:20. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.