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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028148

Openbravo ERP

04. Warehouse management

public

2014-11-12 10:04

2014-12-30 23:26

Reporter

aferraz

Assigned To

umartirena

Priority

normal

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

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

Description

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

Steps To Reproduce

In "QA Testing" client:

Create a new Product named "Costing LC2" for Spain organization.
Go to Price tab, select "Purchase" price list and enter a unit/list price of 120 €.

Go to Purchase Order window and create a new order for Spain organization, product "Costing LC2", order date 07-11-2014, quantity 1500 and price 120.
Book the order. Let's say this is order 801370.

Go to Goods Receipt window and create a new receipt dated on 08-11-2014. Click on Create Lines From, select order 801370, select storage bin L01 and enter 320 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.
Realize that the value posted to the ledger is 38,400.00 (320 units * 120 €/unit)

Go to Goods Receipt window and create a new receipt dated on 09-11-2014. Click on Create Lines From, select order 801370, select storage bin L01 and enter 180 units. Complete. Let's say this is receipt 10001796.

Navigate to Process Request window and run "Costing Background process".

Go to receipt window and post the receipt 10001796.
Realize that the value posted to the ledger is 21,600.00 (180 units * 120 €/unit)

Go to Goods Receipt window and create a new receipt dated on 10-11-2014. Click on Create Lines From, select order 801370, select storage bin L01 and enter 300 units. Complete. Let's say this is receipt 10001797.

Navigate to Process Request window and run "Costing Background process".

Go to receipt window and post the receipt 10001797.
Realize that the value posted to the ledger is 36,000.00 (300 units * 120 €/unit)

Go to Purchase Invoice window and create a new invoice for Spain organization, invoice date 07-11-2014, financial invoice line true, account Fees, quantity 3 and unit price 95. Complete the invoice and post it. Let's say this is invoice 10000923.
Realize that the value posted to the ledger is 285.00 (3 units * 95 €/unit)

Go to Purchase Invoice window and create a new invoice for Spain organization, invoice date 07-11-2014, financial invoice line false, product Transportation Cost, quantity 3 and unit price 105. Complete the invoice and post it. Let's say this is invoice 10000924.
Realize that the value posted to the ledger is 346.50 (3 units * 105 €/unit + (3 units * 105 €/unit * 0.10 tax))

Go to Landed Cost window and create a new landed cost for Spain organization, reference date 07-11-2014. Move to Cost tab and add a new line with landed cost type Fees and invoice line the line of invoice 10000923. Add another line with landed cost type Transportation Cost and invoice line the line of invoice 10000924. Move to Receipt tab and add a new line with goods receipt 10001795. Add another line with goods receipt 10001796. Add another line with goods receipt 10001797. Click on Process button.

Navigate to Product window, select Costing LC2 and go to Transaction tab. Realize that there are 3 records:

- Transaction 1: Movement Quantity 320 - Transaction Receipt 10001795

- Transaction 2: Movement Quantity 180 - Transaction Receipt 10001796

- Transaction 3: Movement Quantity 300 - Transaction Receipt 10001797

Navigate to Cost Adjustment window and select the last created record. Move to Line tab and realize that there are 3 records. These records should always be created in the same order than the related transactions, but they are not.

The correct order should be:

- Line 1: Adjustment Amount 240.00 - Transaction Receipt 10001795

- Line 2: Adjustment Amount 135.00 - Transaction Receipt 10001796

- Line 3: Adjustment Amount 225.00 - Transaction Receipt 10001797

Proposed Solution

The query which inserts new lines of type Landed Cost in Cost Adjustment Line, should have an orderBy clause to insert these lines in the same order which related inventory transaction was created.

Additional Information