Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032388
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Multi Dimensional Tax Report Cash VATmajoralways2016-03-02 13:242016-05-06 15:32
ReportermaiteView Statuspublic 
Assigned Toaferraz 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc332bbd2aa88
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tovmromanos
Support ticket40887
OBNetwork customerOBPS
Regression introduced in release
Summary

0032388: Wrong Settlement Date when invoice date is in 2014 (so manual settlement is in 2015) and payment date in 2016

DescriptionWrong Settlement Date when invoice date is in 2014 (so manual settlement is in 2015) and payment date in 2016
Steps To Reproduce1. Register Sales Invoice set as "Cash vat" and with date in 2014. Add any line. Process and post invoice
2. According with the law, vat settlement for this invoice should be done at the end of 2015 (http://wiki.openbravo.com/wiki/Cash_VAT_Management/User_Documentation_Spanish#Liquidaci.C3.B3n_manual_del_IVA_de_Caja [^])
3. Register Payment In for this invoice with payment date in 2016. Process payment
4. Run Multidimensional Tax Report Cash VAT for 2016 year and realize that invoice appears with Settlement Date in 2016 when should be in 2015
TagsNo tags attached.
Attached Filespng file icon Issue_32388.png [^] (119,784 bytes) 2016-03-02 15:40

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0084659)
psanjuan (viewer)
2016-03-02 15:21
edited on: 2016-03-03 11:46

 Scenario 1

Issue a sales invoice set as "Cash VAT" for any BP located in Spain, with below setup:
- Invoice Date = Accounting Date = 20-11-2014
Add any line by making sure that the tax used is for instance: "Entregas IVA 21% IVA de Caja".
Complete and post the invoice.
Add a payment in of half of the invoice amount dated on 20-12-2015 for instace.
Navigate to Tax tab, Cash VAT tab and make sure below data is shown:
Payment Date = 20-12-2015
Percentage = 41.32
Taxable Amount = 12.396
Tax Amount = 2.603.16
Payment = 1000068 - 20-12-2015 - 15000.00€

Go to "Manual Cash Vat Settlement" window and create a new record for the org by entering below data:
Starting Date = 01-01-2014
Ending Date = 31-12-2014
Accounting Date = 31-12-2015

Click on "Pick Lines&Complete".

Check that the sales invoice created is shown in there, showing a 58.68% (remaining %). Select the invoice and click on Complete.
Post it.

Go back to the sales invoice and check there is a new line in Cash VAT setup with below data:
Payment Date = (empty)
Percentage = 58.68
Taxable Amount =17604.00
Tax Amount = 3696.84
Payment = (empty)
Manual Settlement = Yes
Manual Cash VAT Settlement line = 1000333..etc
Manual Cash VAT Settlement Date = 31-12-2015

Add a new payment to the invoice for the rest of the amount dated on 02-03-2016.

Take note of the invoice, in our case it is sales invoice 1000083.

Run Multidimensional Tax Report Cash VAT with below data:

Show details info selected
From Date = 01-01-2014
To Date = 30-03-2016
Organization = select the Organization
Business Partner = select the BP used.
Tax selected
Sales/Receipt transactions selected

Press HTML format.

Search the section related to the tax "Entregas IVA 21% IVA de Caja".

Check that only one line is shown there for invoice 1000083, the one related to the payment in dated on 20-12-2015. See image attached (Issue_32388)

Proposed Solution:

There should be another line with the VAT settled dated on 30-12-2015, with below information:
Name = Entregas IVA 21% IVA de Caja
Rate = 21%
Doc No = 1000083
Doc type = AR Invoice
Doc Date = 20-11-2014
Acc date = 20-11-2014
Settl date = 31-12-2015
Business Partner = Customer Nacional
Tax Base = 30000.00
Tax Amount = 6300.00
Tax Base Sett = 17604.00
Tax Settlem. = 3696.84

Scenario 2

Issue a sales invoice set as "Cash VAT" for any BP located in Spain, with below setup:
- Invoice Date = Accounting Date = 03-03-2014
Add any line by making sure that the tax used is for instance: "Entregas IVA 21% IVA de Caja".
Complete and post the invoice. (i.e Invoice number 1000085)

Go to "Manual Cash Vat Settlement" window and create a new record for the org by entering below data:
Starting Date = 01-01-2014
Ending Date = 31-12-2014
Accounting Date = 31-12-2015

Click on "Pick Lines&Complete".

Check that the sales invoice created is shown in there, showing a 100% pending to be settled. Select the invoice and click on Complete.
Post it.

Go back to the sales invoice and check there is a new line in Cash VAT setup with below data:
Payment Date = (empty)
Percentage = 100
Taxable Amount =11000.00
Tax Amount = 2310.00
Payment = (empty)
Manual Settlement = Yes
Manual Cash VAT Settlement line = 100034..etc
Manual Cash VAT Settlement Date = 31-12-2015

Add a payment to the invoice dated on 03-03-2016.

Run Multidimensional Tax Report Cash VAT with below data:

Show details info selected
From Date = 01-01-2014
To Date = 30-03-2016
Organization = select the Organization
Business Partner = select the BP used.
Tax selected
Sales/Receipt transactions selected

Press HTML format.

Search the section related to the tax "Entregas IVA 21% IVA de Caja".

Check that there is one line shown in there for invoice 1000085 with no info about the VAT Settled dated on 31-12-2015

Proposed Solution:

There should be a line with the VAT settled dated on 30-12-2015, with below information:
Name = Entregas IVA 21% IVA de Caja
Rate = 21%
Doc No = 1000085
Doc type = AR Invoice
Doc Date = 03-03-2014
Acc date = 03-03-2014
Settl date = 31-12-2015
Business Partner = Customer Nacional
Tax Base = 11000.00
Tax Amount = 2310.00
Tax Base Sett = 11000.00
Tax Settlem. = 2310.00
(0086270)
psanjuan (viewer)
2016-05-06 13:43
edited on: 2016-05-06 14:59

 Test Plan above verified

Additional Test Plan:

Invoice dated on 2014 - do not paid in 2014 - report launched for 2014 = Invoice is shown in the report do not settled.

Invoice dated on 2014 - totally paid in 2014 - report launched for 2014 = Invoice is shown in the report 100% settled dated on 2014 payment date.

Invoice dated on 2014 - totally paid in 2015 - report launched for 2015 = Invoice is shown in the report 100% settled dated on 2015 payment date

Invoice dated on 2014 - do not paid in 2014 + manual settlement in 2015 - report launched for 2015 = Invoice is shown in the report 100% settled dated on Manual Settlement date 30-12-2015

Invoice dated on 2014 - do not paid in 2014 + manual settlement in 2015 (30-12-2015) + payment in 2015 (31-12-2015) - report launched for 2015 = Invoice is shown in the report only once 100% settled dated on Manual Settlement date 30-12-2015

Invoice dated on 2014 - do not paid in 2014 + manual settlement in 2015 + payment in 2016 - report launched for 2015 = Invoice is shown in the report only once 100% settled dated on Manual Settlement date 31-12-2015

Invoice dated on 2014 - do not paid in 2014 + manual settlement in 2015 + payment in 2016 - report launched for 2016 = Invoice is not shown.

Invoice dated on 2014 - partially paid in 2015 + manual settlement in 2015 - report launched for 2015 = Invoice is shown twice, one line showing as settlement date 2015 payment date (30-05-2015) and the tax base and tax settled and the other one showing manual settlement date (31-12-2015) and the tax base and tax settled.

Sales order dated on 2014 prepaid on 2014 (invoice created from the order dated on 2014) + invoice partially paid in 2015 + Manual Cash VAT Settlement in 2015 - launch report for 2015 - Invoice is shown twice one for the 2015 payment and second one for the manual settlement.

Repeat same test as above for corrective invoices.

Repeat same test as above for purchase orders/invoices.
(0086271)
psanjuan (viewer)
2016-05-06 15:15

 Test plan above verified.

Issue can be code reviewed and closed.
(0086272)
hgbot (developer)
2016-05-06 15:26

 Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat
Changeset: c332bbd2aa880459577ec58814d763a8e1e413ee
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu May 05 19:39:20 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/c332bbd2aa880459577ec58814d763a8e1e413ee [^]

Fixes issue 32388:Wrong settlement date in Multidimensional Tax Report Cash VAT

Include settlement date in invoices settled by Manual Cash VAT Settlement in getInvoicePayments method and exclude invoices settled by Manual Cash VAT Settlement in getInvoicesWithoutPayments method.

---
M src/org/openbravo/module/invoiceTaxReportEnhanced30/cashvat/ad_reports/OBMTRCVInvoiceTaxReportDao.java
A src-db/database/model/functions/OBMTRCV_GETMANUALSETTLDATE.xml
A src/org/openbravo/module/invoiceTaxReportEnhanced30/cashvat/databaseProcess/OBMTRCVGetSettlementDate.java
---
(0086273)
hgbot (developer)
2016-05-06 15:26

 Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat
Changeset: 98f08769ca6bed8606c14bb7d4d6944c8b8c73b6
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu May 05 19:39:38 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/98f08769ca6bed8606c14bb7d4d6944c8b8c73b6 [^]

Related to issue 32388: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0086274)
aferraz (viewer)
2016-05-06 15:32

 Code review OK done by vmromanos

- Issue History
Date Modified Username Field Change
2016-03-02 13:24 maite New Issue
2016-03-02 13:24 maite Support ticket => 40887
2016-03-02 13:24 maite OBNetwork customer => Yes
2016-03-02 13:25 maite Resolution time => 1459634400
2016-03-02 13:25 maite Issue Monitored: networkb
2016-03-02 15:21 psanjuan Note Added: 0084659
2016-03-02 15:24 psanjuan Note Edited: 0084659 View Revisions
2016-03-02 15:35 psanjuan Note Edited: 0084659 View Revisions
2016-03-02 15:39 psanjuan Note Edited: 0084659 View Revisions
2016-03-02 15:40 psanjuan Note Edited: 0084659 View Revisions
2016-03-02 15:40 psanjuan File Added: Issue_32388.png
2016-03-02 15:42 psanjuan Note Edited: 0084659 View Revisions
2016-03-03 11:26 psanjuan Note Edited: 0084659 View Revisions
2016-03-03 11:26 psanjuan Note Edited: 0084659 View Revisions
2016-03-03 11:46 psanjuan Note Edited: 0084659 View Revisions
2016-04-21 18:35 dmitry_mezentsev Assigned To => Triage Finance
2016-04-21 18:57 aferraz Assigned To Triage Finance => AtulOpenbravo
2016-04-25 07:58 AtulOpenbravo Status new => scheduled
2016-04-25 14:48 aferraz Assigned To AtulOpenbravo => aferraz
2016-05-06 13:43 psanjuan Note Added: 0086270
2016-05-06 13:53 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:15 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:22 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:34 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:40 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:49 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:50 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:54 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 14:59 psanjuan Note Edited: 0086270 View Revisions
2016-05-06 15:15 psanjuan Note Added: 0086271
2016-05-06 15:26 hgbot Checkin
2016-05-06 15:26 hgbot Note Added: 0086272
2016-05-06 15:26 hgbot Status scheduled => resolved
2016-05-06 15:26 hgbot Resolution open => fixed
2016-05-06 15:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/c332bbd2aa880459577ec58814d763a8e1e413ee [^]
2016-05-06 15:26 hgbot Checkin
2016-05-06 15:26 hgbot Note Added: 0086273
2016-05-06 15:32 aferraz Review Assigned To => vmromanos
2016-05-06 15:32 aferraz Note Added: 0086274
2016-05-06 15:32 aferraz Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker