Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012043Openbravo ERP09. Financial managementpublic2010-01-22 10:322010-02-01 17:53
Reporternetworkb 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target VersionFixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012043: 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
depends on backport 0012062 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-22 10:32networkbNew Issue
2010-01-22 10:32networkbAssigned To => rafaroda
2010-01-22 10:38networkbNote Added: 0023734
2010-01-22 10:38networkbversion2.50MP10 => 2.40MP11
2010-01-22 10:38networkbTarget Version2.50MP12 =>
2010-01-22 10:38networkbProposed Solution updated
2010-01-25 16:48psarobeStatusnew => scheduled
2010-01-25 16:48psarobeAssigned Torafaroda => dalsasua
2010-01-25 16:48psarobefix_in_branch => pi
2010-01-26 11:01rafarodaAssigned Todalsasua => rafaroda
2010-01-26 17:56hgbotCheckin
2010-01-26 17:56hgbotNote Added: 0023808
2010-01-26 17:56hgbotStatusscheduled => resolved
2010-01-26 17:56hgbotResolutionopen => fixed
2010-01-26 17:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/49572b27b43aa443dae293148770fcfdbbf9b7e7 [^]
2010-01-26 17:57rafarodaNote Added: 0023809
2010-01-27 11:57arunkumarNote Added: 0023818
2010-01-27 11:57arunkumarStatusresolved => closed
2010-01-27 11:57arunkumarFixed in Version => 2.50MP12
2010-01-28 00:00anonymoussf_bug_id0 => 2941299
2010-02-01 17:53hudsonbotCheckin
2010-02-01 17:53hudsonbotNote Added: 0023892

Notes
(0023734)
networkb   
2010-01-22 10:38   
It happens on 2.50 MP10 too.
(0023808)
hgbot   
2010-01-26 17:56   
Repository: erp/devel/pi
Changeset: 49572b27b43aa443dae293148770fcfdbbf9b7e7
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Jan 22 20:47:45 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/49572b27b43aa443dae293148770fcfdbbf9b7e7 [^]

Fixes issue 12043 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
---
(0023809)
rafaroda   
2010-01-26 17:57   
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
(0023818)
arunkumar   
2010-01-27 11:57   
Now it is possible to create Vat Registers with the same date range to different organizations.

Tested & Working fine.
(0023892)
hudsonbot   
2010-02-01 17:53   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/49572b27b43a [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3d5bd712a24b [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16007.obx [^]