Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0027260Localization Pack: SpainMulti Dimensional Tax Report Cash VATpublic2014-08-01 13:492014-08-01 13:49
psanjuan 
jonalegriaesarte 
urgentmajoralways
newopen 
20Ubuntu 8.04.1
 
 
0027260: 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.
Issue History
2014-08-01 13:49psanjuanNew Issue
2014-08-01 13:49psanjuanAssigned To => jonalegriaesarte
2014-08-01 13:49psanjuanIssue generated from0027257

There are no notes attached to this issue.