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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012043
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-01-22 10:322010-02-01 17:53
ReporternetworkbView Statuspublic 
Assigned Torafaroda 
PriorityimmediateResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branchpiFixed in SCM revision49572b27b43a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP11SCM revision 
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
Summary

0012043: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0012062 closedrafaroda Error in Tax Payment when you try create a Vat Registers to diferent Organizations with the same date range. 

-  Notes
(0023734)
networkb (viewer)
2010-01-22 10:38

 It happens on 2.50 MP10 too.
(0023808)
hgbot (developer)
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 (viewer)
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 (viewer)
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 (viewer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-01-22 10:32 networkb New Issue
2010-01-22 10:32 networkb Assigned To => rafaroda
2010-01-22 10:32 networkb OBNetwork customer => Yes
2010-01-22 10:38 networkb Note Added: 0023734
2010-01-22 10:38 networkb version 2.50MP10 => 2.40MP11
2010-01-22 10:38 networkb Target Version 2.50MP12 =>
2010-01-22 10:38 networkb Proposed Solution updated
2010-01-25 16:48 psarobe Status new => scheduled
2010-01-25 16:48 psarobe Assigned To rafaroda => dalsasua
2010-01-25 16:48 psarobe fix_in_branch => pi
2010-01-26 11:01 rafaroda Assigned To dalsasua => rafaroda
2010-01-26 17:56 hgbot Checkin
2010-01-26 17:56 hgbot Note Added: 0023808
2010-01-26 17:56 hgbot Status scheduled => resolved
2010-01-26 17:56 hgbot Resolution open => fixed
2010-01-26 17:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/49572b27b43aa443dae293148770fcfdbbf9b7e7 [^]
2010-01-26 17:57 rafaroda Note Added: 0023809
2010-01-27 11:57 arunkumar Note Added: 0023818
2010-01-27 11:57 arunkumar Status resolved => closed
2010-01-27 11:57 arunkumar Fixed in Version => 2.50MP12
2010-01-28 00:00 anonymous sf_bug_id 0 => 2941299
2010-02-01 17:53 hudsonbot Checkin
2010-02-01 17:53 hudsonbot Note Added: 0023892

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker