0028266: [Costing] "Parent Cost Adjustment Line" field in Cost Adjustment Line should always be assigned in the same order

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028266

Openbravo ERP

04. Warehouse management

public

2014-11-24 17:50

2014-12-30 23:26

Reporter

aferraz

Assigned To

Sandrahuguet

Priority

high

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Professional Appliance

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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.

Additional Information

Tags

No tags attached.

Relationships

related to

feature request

0028148

closed

umartirena

Cost Adjustment Lines of type Landed Cost should always be created in the same order

Attached Files