Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012062Openbravo ERP09. Financial managementpublic2010-01-22 10:322010-01-29 07:02
Reporternetworkb 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target VersionFixed in Version2.40MP12 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012062: Error in Tax Payment when you try create a Vat Registers to diferent Organizations with the same date range.
DescriptionIf you have created and processed a Tax Payment to the Organization A with Starting Date: 01-01-2009 and Ending Date: 31-12-2009 and you want to create a new Tax Payment to the Organization B with the same date range appears this error:

Records that are within the same date range already exist, therefore VAT register cannot be created.
Steps To Reproduce(NOTE 1: Should exist a Tax Register Type to a Tax(IE: 16%))
(NOTE 2: Should exist sales invoices for the Bussines Partner in the date range with Tax = 16%)

-As Openbravo Admin and the Tax Register Type created, go to Financial Management || Receivables & Payables || Transactions || Tax Payment

-Create a new record:
   -Organization A.
   -Starting Date: 01-01-2009.
   -Ending Date: 31-12-2009.
   -Bussines Partner: (A BP with invoices in this date range)
-Click 'Create Vat Registers' and process.

-Create a new record:
   -Organization B.
   -Starting Date: 01-01-2009.
   -Ending Date: 31-12-2009.
-Click 'Create Vat Registers'.

-Appears this error: Records that are within the same date range already exist, therefore VAT register cannot be created.
Proposed SolutionIt could be possible create Vat Registers with the same date range to different organizations.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0012043 closed rafaroda Error in Tax Payment when you try create a Vat Registers to diferent Organizations with the same date range. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-25 16:48psarobeTypedefect => backport
2010-01-25 16:48psarobefix_in_branch => 2.40
2010-01-26 18:13hgbotCheckin
2010-01-26 18:13hgbotNote Added: 0023811
2010-01-26 18:13hgbotStatusscheduled => resolved
2010-01-26 18:13hgbotResolutionopen => fixed
2010-01-26 18:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/c191946580dfd1b6af827673f33f448732d69a03 [^]
2010-01-26 18:13rafarodaNote Added: 0023812
2010-01-29 07:02arunkumarNote Added: 0023853
2010-01-29 07:02arunkumarStatusresolved => closed
2010-01-29 07:02arunkumarFixed in Version => 2.40MP12

Notes
(0023811)
hgbot   
2010-01-26 18:13   
Repository: erp/stable/2.40
Changeset: c191946580dfd1b6af827673f33f448732d69a03
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Jan 22 20:53:11 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/c191946580dfd1b6af827673f33f448732d69a03 [^]

Fixes issue 12062 Create VAT Registers process takes now multi-organization into account.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters.java
M src/org/openbravo/erpCommon/ad_actionButton/TaxPayment.xsql
---
(0023812)
rafaroda   
2010-01-26 18:13   
Steps to test the fix:
* Create a new register type in Financial Management || Receivables & Payables || Setup || Tax Register Type:
** Organization = A
** Name = Payment of 16% VAT of Sales AR Invoices Org A
** Sales Transaction = Y
* Navigate to Lines tab:
** Tax = VAT 16%
** Document Type = AR Invoice
* Create a new register type:
** Organization = A
** Name = Payment of 16% VAT of Purchase AP Invoices Org A
** Sales Transaction = N
* Navigate to Lines tab:
** Tax = VAT 16%
** Document Type = AP Invoice
* Create a new register type:
** Organization = B
** Name = Payment of 16% VAT of Sales AR Invoices Org B
** Sales Transaction = Y
* Navigate to Lines tab:
** Tax = VAT 16%
** Document Type = AR Invoice
* Create a new register type:
** Organization = B
** Name = Payment of 16% VAT of Purchase AP Invoices Org B
** Sales Transaction = N
* Navigate to Lines tab:
** Tax = VAT 16%
** Document Type = AP Invoice
* Create a Sales Invoice in Sales Management || Transactions || Sales Invoice:
** Organization = A
** Transaction Type = AR Invoice
** Business Partner = Millman
* Navigate to Lines tab:
** Product = Hammer
** Tax = VAT 16%
* Navigate back to the sales invoice header and complete it.
* Create a new Sales Invoice:
** Organization = B
** Transaction Type = AR Invoice
** Business Partner = Sailor
* Navigate to Lines tab:
** Product = Screwdriver
** Tax = VAT 16%
* Navigate back to the sales invoice header and complete it.
* Create a new tax payment in Financial Management || Receivables & Payables || Transactions || Tax Payment:
** Organization = A
** Name = Payment VAT 16% Org A BP Millman 2010
** Business Partner = Millman
** Starting date = 01-01-2010
** Ending date = 31-12-2010
* Click on Create VAT Registers button.
* Navigate to Tax Register Header and check that there are two lines.
* Navigate back to Tax Payment header and click on process button.
* Create a new tax payment:
** Organization = B
** Name = Payment VAT 16% Org A BP Sailor 2010
** Business Partner = Sailor
** Starting date = 01-01-2010
** Ending date = 31-12-2010
* Click on Create VAT Registers button.
* Navigate to Tax Register Header and check that there are two lines.
* Navigate back to Tax Payment header and click on process button.
* Create a new tax payment:
** Organization = B
** Name = Payment VAT 16% Org A BP Sailor 2010
** Business Partner = Sailor
** Starting date = 01-01-2010
** Ending date = 31-12-2010
* Click on Create VAT Registers button.
* Error message displays, which is correct: Records that are within the same date range already exist, therefore VAT register cannot be created
(0023853)
arunkumar   
2010-01-29 07:02   
Tested & Working fine.