Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011948 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2010-01-12 19:40 | 2010-06-22 14:09 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 44c5b03fcca1 | |||
| Projection | none | ETA | none | Target Version | 2.50MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP9 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011948: C_GETTAX doesn't order properly when there are more than one tax rates defined for one tax category | |||||||
| Description | I you define more than one tax rates for the same tax category setting different "Valid from date", when creating documents Tax set is not the correct one | |||||||
| Steps To Reproduce | 1. Financial Management || Accounting || Setup || Tax Rate || Tax : create a new record with *Valid from date= 01/01/2010 Sales/Purchase=both *Tax category=VAT 16 (already created for SmallBazar) 2. Sales Management || Transactions || Sales Order || Header : create new record with date > 01/01/2010 3. Create line with product=beer (which has Tax category=VAT 16) and realize that tax assigned is VAT16% ant not the new one | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0023504) hgbot (developer) 2010-01-18 14:58 |
Repository: erp/devel/pi Changeset: ad62f64f097e762d6250d32e6c87ee4262a681ea Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com> Date: Sun Jan 17 18:53:10 2010 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/ad62f64f097e762d6250d32e6c87ee4262a681ea [^] Fixes issue 11948 Modified C_GETTAX to select the newest valid tax. --- M src-db/database/model/functions/C_GETTAX.xml --- |
|
(0023505) rafaroda (developer) 2010-01-18 14:59 |
Steps to test the fix: 1) Navigate to Financial Management || Accounting || Setup || Tax Rate || Tax and create a new record. * Name = New 16% * Valid From = 01-01-2010 (this is important: tax selection among valid taxes must be based on this date, taking the newest one that may have been added because of a modification in the new tax policy) * Tax Category = VAT 16% * Sales/Purchase Type = Both * Rate = 16% 2) Navigate to Tax Zone tab and select From Country and To Country = Spain 3) Create a Sales Order. 4) Create a line for product Grand Beer (which has Tax Category = VAT 16%) In Tax drop-down list New 16% tax must be selected automatically. |
|
(0023597) arunkumar (reporter) 2010-01-20 08:35 |
Tested & Working fine |
|
(0023666) hudsonbot (developer) 2010-01-20 23:26 |
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/ad62f64f097e [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^] |
|
(0028312) hgbot (developer) 2010-06-11 16:13 |
Repository: erp/devel/pi Changeset: 2ad66893bab274a0ed112a8ab2f443612af78846 Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Fri Jun 11 16:13:19 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/2ad66893bab274a0ed112a8ab2f443612af78846 [^] Fixes issue 0011948: C_GETTAX doesn't order properly when there are more than one tax rates defined for one tax category The ORDER BY clause has been modified in order to take into account first the field Valid From Date --- M src-db/database/model/functions/C_GETTAX.xml --- |
|
(0028313) adrianromero (manager) 2010-06-11 16:15 |
* Test the issue Follow the steps to test and verify that now the new tax is selected. It has been added a new change set because the first changeset did not fixed the issue in all cases. When different Locations, or Business partner categories are involved it did not worked because the order by ValidFrom field must be in the first place of the ORDER BY clause. * Other areas affected All windows that call the C_GETTAX function are affected but only the behavior of what tax is selected first depending on the ValidFrom value is affected no other possibles changes can appear. |
|
(0028331) hudsonbot (developer) 2010-06-12 22:49 |
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/2ad66893bab2 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/0b85119b92bc [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17589.obx [^] |
|
(0028339) arunkumar (reporter) 2010-06-14 08:17 |
Tested working fine |
|
(0028351) hgbot (developer) 2010-06-14 11:31 |
Repository: erp/devel/pi Changeset: 44c5b03fcca1d1b7526a1171b52c4838e0fc5e2d Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Mon Jun 14 11:30:02 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/44c5b03fcca1d1b7526a1171b52c4838e0fc5e2d [^] Fixes issue 0011948: C_GETTAX doesn't order properly when there are more than one tax rates defined for one tax category Reverting last change it was incorrect --- M src-db/database/model/functions/C_GETTAX.xml --- |
|
(0028401) hudsonbot (developer) 2010-06-15 05:43 |
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/44c5b03fcca1 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f7644da65496 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17606.obx [^] |
|
(0028667) arunkumar (reporter) 2010-06-22 14:09 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-01-12 19:40 | networkb | New Issue | |
| 2010-01-12 19:40 | networkb | Assigned To | => rafaroda |
| 2010-01-13 10:49 | psarobe | Status | new => scheduled |
| 2010-01-13 10:49 | psarobe | fix_in_branch | => pi |
| 2010-01-18 14:58 | hgbot | Checkin | |
| 2010-01-18 14:58 | hgbot | Note Added: 0023504 | |
| 2010-01-18 14:58 | hgbot | Status | scheduled => resolved |
| 2010-01-18 14:58 | hgbot | Resolution | open => fixed |
| 2010-01-18 14:58 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ad62f64f097e762d6250d32e6c87ee4262a681ea [^] |
| 2010-01-18 14:59 | rafaroda | Note Added: 0023505 | |
| 2010-01-19 07:12 | arunkumar | Note Added: 0023547 | |
| 2010-01-19 07:12 | arunkumar | Status | resolved => new |
| 2010-01-19 07:12 | arunkumar | Resolution | fixed => open |
| 2010-01-19 11:06 | arunkumar | Status | new => scheduled |
| 2010-01-20 08:34 | rafaroda | Status | scheduled => resolved |
| 2010-01-20 08:34 | rafaroda | Resolution | open => fixed |
| 2010-01-20 08:35 | arunkumar | Note Added: 0023597 | |
| 2010-01-20 08:35 | arunkumar | Status | resolved => closed |
| 2010-01-20 08:35 | arunkumar | Fixed in Version | => 2.50MP11 |
| 2010-01-20 09:31 | rafaroda | Note Deleted: 0023547 | |
| 2010-01-20 23:26 | hudsonbot | Checkin | |
| 2010-01-20 23:26 | hudsonbot | Note Added: 0023666 | |
| 2010-01-21 00:00 | anonymous | sf_bug_id | 0 => 2935929 |
| 2010-06-01 16:39 | adrianromero | Issue cloned | 0013495 |
| 2010-06-01 16:39 | adrianromero | Relationship added | related to 0013495 |
| 2010-06-11 16:13 | hgbot | Checkin | |
| 2010-06-11 16:13 | hgbot | Note Added: 0028312 | |
| 2010-06-11 16:13 | hgbot | Status | closed => resolved |
| 2010-06-11 16:13 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/ad62f64f097e762d6250d32e6c87ee4262a681ea [^] => http://code.openbravo.com/erp/devel/pi/rev/2ad66893bab274a0ed112a8ab2f443612af78846 [^] |
| 2010-06-11 16:15 | adrianromero | Note Added: 0028313 | |
| 2010-06-12 22:49 | hudsonbot | Checkin | |
| 2010-06-12 22:49 | hudsonbot | Note Added: 0028331 | |
| 2010-06-14 08:17 | arunkumar | Note Added: 0028339 | |
| 2010-06-14 08:17 | arunkumar | Status | resolved => closed |
| 2010-06-14 08:17 | arunkumar | Fixed in Version | 2.50MP11 => |
| 2010-06-14 11:31 | hgbot | Checkin | |
| 2010-06-14 11:31 | hgbot | Note Added: 0028351 | |
| 2010-06-14 11:31 | hgbot | Status | closed => resolved |
| 2010-06-14 11:31 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/2ad66893bab274a0ed112a8ab2f443612af78846 [^] => http://code.openbravo.com/erp/devel/pi/rev/44c5b03fcca1d1b7526a1171b52c4838e0fc5e2d [^] |
| 2010-06-15 05:43 | hudsonbot | Checkin | |
| 2010-06-15 05:43 | hudsonbot | Note Added: 0028401 | |
| 2010-06-22 14:09 | arunkumar | Note Added: 0028667 | |
| 2010-06-22 14:09 | arunkumar | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |