Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0013495 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2010-06-01 16:39 | 2011-01-27 11:08 | |||
| Reporter | adrianromero | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 5d2a83efafc6 | ||||
| Projection | none | ETA | none | Target Version | 2.40MP13 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP12 | 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 | 0013495: 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 |
|
|
(0027862) adrianromero (manager) 2010-06-01 16:40 |
Backport required by GPS. The solution has been resolved in pi in the related issue. |
|
(0028310) hgbot (developer) 2010-06-11 16:09 |
Repository: erp/stable/2.40 Changeset: 7076c8328ca120f81d56ba575a5e6c6df4236ae6 Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Fri Jun 11 16:08:48 2010 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/7076c8328ca120f81d56ba575a5e6c6df4236ae6 [^] Fixes issue 0013495: 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 --- |
|
(0028311) adrianromero (manager) 2010-06-11 16:12 |
* Test the issue Follow the steps to test and verify that now the new tax is selected. * 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. |
|
(0028330) 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/c12f5119b43a [^] 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 [^] |
|
(0028352) hgbot (developer) 2010-06-14 11:38 |
Repository: erp/stable/2.40 Changeset: 5d2a83efafc665ecc76e40b59100d580f3d10b87 Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Mon Jun 14 11:37:12 2010 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/5d2a83efafc665ecc76e40b59100d580f3d10b87 [^] Fixes issue 0013495: 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 --- |
|
(0028507) adrianromero (manager) 2010-06-16 16:05 |
To test that the C_GETTAX function works properly generate a new tax with the same tax category as another tax, for example VAT 16%, modifying only the ValidFrom date, and check that the new tax is applied only when the invoice or order is created after the new tax date. |
|
(0033903) psarobe (manager) 2011-01-27 11:08 |
Works fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-06-01 16:39 | adrianromero | New Issue | |
| 2010-06-01 16:39 | adrianromero | Assigned To | => rafaroda |
| 2010-06-01 16:39 | adrianromero | Issue generated from | 0011948 |
| 2010-06-01 16:39 | adrianromero | Relationship added | related to 0011948 |
| 2010-06-01 16:40 | adrianromero | Status | new => scheduled |
| 2010-06-01 16:40 | adrianromero | Note Added: 0027862 | |
| 2010-06-01 16:40 | adrianromero | Assigned To | rafaroda => adrianromero |
| 2010-06-01 16:40 | adrianromero | fix_in_branch | => pi |
| 2010-06-11 15:47 | hgbot | Checkin | |
| 2010-06-11 15:47 | hgbot | Note Added: 0028309 | |
| 2010-06-11 15:47 | hgbot | Status | scheduled => resolved |
| 2010-06-11 15:47 | hgbot | Resolution | open => fixed |
| 2010-06-11 15:47 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c12f5119b43a741774b943801281b37f2b83fe6e [^] |
| 2010-06-11 15:54 | adrianromero | Note Deleted: 0028309 | |
| 2010-06-11 15:55 | adrianromero | Status | resolved => new |
| 2010-06-11 15:55 | adrianromero | Resolution | fixed => open |
| 2010-06-11 15:59 | adrianromero | Status | new => scheduled |
| 2010-06-11 15:59 | adrianromero | version | 2.50MP9 => 2.40MP12 |
| 2010-06-11 15:59 | adrianromero | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/c12f5119b43a741774b943801281b37f2b83fe6e [^] => |
| 2010-06-11 15:59 | adrianromero | fix_in_branch | pi => |
| 2010-06-11 16:09 | hgbot | Checkin | |
| 2010-06-11 16:09 | hgbot | Note Added: 0028310 | |
| 2010-06-11 16:09 | hgbot | Status | scheduled => resolved |
| 2010-06-11 16:09 | hgbot | Resolution | open => fixed |
| 2010-06-11 16:09 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/7076c8328ca120f81d56ba575a5e6c6df4236ae6 [^] |
| 2010-06-11 16:12 | adrianromero | Note Added: 0028311 | |
| 2010-06-12 22:49 | hudsonbot | Checkin | |
| 2010-06-12 22:49 | hudsonbot | Note Added: 0028330 | |
| 2010-06-14 11:38 | hgbot | Checkin | |
| 2010-06-14 11:38 | hgbot | Note Added: 0028352 | |
| 2010-06-14 11:38 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.40/rev/7076c8328ca120f81d56ba575a5e6c6df4236ae6 [^] => http://code.openbravo.com/erp/stable/2.40/rev/5d2a83efafc665ecc76e40b59100d580f3d10b87 [^] |
| 2010-06-16 16:05 | adrianromero | Note Added: 0028507 | |
| 2011-01-27 11:08 | psarobe | Note Added: 0033903 | |
| 2011-01-27 11:08 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |