Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0027257Localization Pack: SpainMulti Dimensional Tax Reportpublic2014-08-01 13:212014-08-01 13:49
psanjuan 
jonalegriaesarte 
urgentmajoralways
newopen 
20Ubuntu 8.04.1
 
 
No
0027257: There should be a Grand-Total per MTR section
There should be a Grand-Total per MTR section and tax type (purchase & sales)
Create only one purchase invoice in a period (for instance July 2014)

Enter 8 lines having below listed purchase taxes:

Adquisiciones Exentas
Adquisiciones IVA 10%
Adquisiciones IVA 21%
Adquisiciones IVA 4%
Prestación servicios exenta
Prestación servicios 10%
Prestación servicios 21%
Prestación servicios 4%

Navigate to "Multidimensional Tax Report" window and enter below data:

    From date: 01-07-2014
    To Date: 31-07-2014
    Organization: (your organization)

Unmark the check fields :

    "Show Details Info"
    "Group by Business Partner".

Mark the check fields:

    "Tax"
    "Purchase/Payments transactions".

Click on "Export to Excel" button at the top.

You will get a file similar that the one attached.

Realize that there is no a Grad-total of the purchase Tax Amount that for this invoice should be the sum of:

Summary per Tax Category section (472.50+444.55+84.15+25.80+6.44+35.74)
Summary per Tax/Withholding % section (42.18+109.95+917.05)
There should be a Grand-total per section

Summary per Tax Category section
Summary per Tax/Withholding % section
No tags attached.
xls TC7767-MultidimensionalTaxReport.jrxml.xls (15,872) 2014-08-01 13:23
https://issues.openbravo.com/file_download.php?file_id=7117&type=bug
Issue History
2014-08-01 13:21psanjuanNew Issue
2014-08-01 13:21psanjuanAssigned To => jonalegriaesarte
2014-08-01 13:21psanjuanOBNetwork customer => No
2014-08-01 13:22psanjuanFile Added: TC7767-MultidimensionalTaxReport.jrxml.xls
2014-08-01 13:23psanjuanFile Deleted: TC7767-MultidimensionalTaxReport.jrxml.xls
2014-08-01 13:23psanjuanFile Added: TC7767-MultidimensionalTaxReport.jrxml.xls
2014-08-01 13:49psanjuanIssue cloned0027260

There are no notes attached to this issue.