Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0028266 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] 04. Warehouse management | minor | have not tried | 2014-11-24 17:50 | 2014-12-30 23:26 | |||
| Reporter | aferraz | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 51adc29c2514 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | aferraz | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0028266: [Costing] "Parent Cost Adjustment Line" field in Cost Adjustment Line should always be assigned in the same order | |||||||
| Description | "Parent Cost Adjustment Line" field in Cost Adjustment Line should always be assigned in the same order | |||||||
| Steps To Reproduce | In "QA Testing" client: Create a new Product named "Costing LC101" for Spain organization, "Purchase" price list and a unit/list price of 150 €. Create a new Product named "Costing LC201" for Spain organization, "Purchase" price list and a unit/list price of 185 €. Go to Goods Receipt window and create a new receipt dated on 30-11-2014. Create a new line with product "Costing LC101" and quantity 100 units. Create another line with product "Costing LC201" and quantity 200 units. Complete. Let's say this is receipt 10001795. Navigate to Process Request window and run "Costing Background process". Go to receipt window and post the receipt 10001795. Go to Landed Cost window and create a new landed cost for Spain organization, reference date 30-11-2014. Move to Cost tab and add a new line with landed cost type Fees and amount 535 EUR. Add another line with landed cost type Transportation Cost and amount 105 EUR. Add another line with landed cost type USD Cost and amount 20 USD. Move to Receipt tab and add a new line with goods receipt 10001795. Click on Process button. Navigate to Cost Adjustment window and select the last created record. Move to Line tab and realize that there are 4 records: - Line 1: Adjustment Amount: 5.77 - Transaction: Receipt 10001795 line 10 - Parent Cost Adjustment Line: null - Line 2: Adjustment Amount: 14.23 - Transaction: Receipt 10001795 line 20 - Parent Cost Adjustment Line: null - Line 3: Adjustment Amount: 184.62 - Transaction: Receipt 10001795 line 10 - Parent Cost Adjustment Line: Cost Adjustment Line 10 - Line 4: Adjustment Amount: 455.38 - Transaction: Receipt 10001795 line 20 - Parent Cost Adjustment Line: Cost Adjustment Line 20 The field "Parent Cost Adjustment Line" should always have these values in this order, but it has not. | |||||||
| Proposed Solution | The query which assigns the "Parent Cost Adjustment Line" field in Cost Adjustment Line, should have an orderBy clause to assign the field in the same order which related inventory transaction was created (this is well done), and another orderBy clause to assign the field ordering the lines by amount (asc) if the transaction date is the same. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  1.png [^] (43,967 bytes) 2014-11-24 17:54
2.png [^] (44,111 bytes) 2014-11-24 17:54
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0072292) hgbot (developer) 2014-12-04 20:51 |
Repository: erp/devel/pi Changeset: 51adc29c2514d9f39a0f43b4fde23b65b64778af Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> Date: Mon Dec 01 16:54:02 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/51adc29c2514d9f39a0f43b4fde23b65b64778af [^] Fixes bug 28266 ParentCostAdjustmentLine should always be assigned in the same order In order to help JUnit tests assert Cost Adjustment lines, an orderBy clause has been added when assigning the field "Parent Cost Adjustment Line" to follow always the same order --- M src/org/openbravo/costing/CostAdjustmentProcess.java --- |
|
(0073178) hudsonbot (viewer) 2014-12-30 23:26 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-11-24 17:50 | aferraz | New Issue | |
| 2014-11-24 17:50 | aferraz | Assigned To | => Sandrahuguet |
| 2014-11-24 17:50 | aferraz | OBNetwork customer | => No |
| 2014-11-24 17:50 | aferraz | Modules | => Core |
| 2014-11-24 17:50 | aferraz | Triggers an Emergency Pack | => No |
| 2014-11-24 17:54 | aferraz | File Added: 1.png | |
| 2014-11-24 17:54 | aferraz | File Added: 2.png | |
| 2014-11-24 17:55 | aferraz | Relationship added | related to 0028148 |
| 2014-12-04 20:51 | hgbot | Checkin | |
| 2014-12-04 20:51 | hgbot | Note Added: 0072292 | |
| 2014-12-04 20:51 | hgbot | Status | new => resolved |
| 2014-12-04 20:51 | hgbot | Resolution | open => fixed |
| 2014-12-04 20:51 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/51adc29c2514d9f39a0f43b4fde23b65b64778af [^] |
| 2014-12-04 20:54 | aferraz | Review Assigned To | => aferraz |
| 2014-12-04 20:54 | aferraz | Status | resolved => closed |
| 2014-12-30 23:26 | hudsonbot | Checkin | |
| 2014-12-30 23:26 | hudsonbot | Note Added: 0073178 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |