0027888: Two lines with 31-12-9999 ending date created in Costing tab.

Description

Two lines with 31-12-9999 ending date created in Costing tab.

Steps To Reproduce

In QA testing Client, create a new legal entity named China. Do not include accounting, but create it as Legal with Accounting.

In the organization window, search China org, allow period control, select a fiscal calendar and EUR General Ledger configuration. Enter EUR as currency.
Set it as ready.

Go to Costing Rule and create a new one by do NOT selecting Warehouse Dimension. Starting date 01-01-2014. Validate the costing rule.

Create a product for China org. Go to price tab and select "Purchase" Price list, enter unit and list price equal to 100.

Create a Goods Receipt for China org and that product of 50 units. Date 16/10/2014. Complete and Post it once costing background process has been run.

Go to product window, search by the product and in the Costing tab verify that the cost shown is 5.000 (50 units x 100 e/unit).

Go to Costing Rule and create a new one by selecting Warehouse Dimension. Validate the costing rule.
Take into account that starting date should be the same one as receipt, in this example 16/10/2014.

Navigate to product window, search the product created and go to "Transaction" tab, realize that besides the receipt, there are two additional transactions caused by costing rule opening and closing.

Closing one cost is same as receipt one. Opening one does not have a cost.

Go to landed cost window and create a new one for China organization dated on 16/10/2014 (previously you should have created a landed cost type for China org).
In Cost tab enter a landed cost type related to a product. Amount 200 EUR.
In Receipt tab select the good receipt just created.

Go to header and process the landed cost.

Navigate to product window, transaction cost and realize that the amount of 200 is being considered in the columns "Total Cost" and "Unit Cost", therefore an amount of 5.200 is shown.

Besides that, a cost adjustment has been created for the opening inventory transaction, go there and post it.

Go back to product window, search the product. Navigate to costing tab and realize that there are two lines having 31-12-9999 as ending date and that should not be the case. See image atached.

Proposed Solution

There should be two lines:

Line 1 - inventory transaction V+ - Costing 104 - Starting date 16/10/2014 Ending Date 31-12-9999
Line 2 - inventory transaction I+ - Costing 100 - Starting date 16/10/2014 Ending date 16/10/2014

Tags

No tags attached.

Attached Files

Cost Adj issue 27888.png [^] (95,414 bytes) 2014-10-16 14:59

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0071188) umartirena (reporter) 2014-10-27 11:54	Unable to Reproduce the issue

Issue History
Date Modified	Username	Field	Change
2014-10-16 14:58	psanjuan	New Issue
2014-10-16 14:58	psanjuan	Assigned To	=> dmiguelez
2014-10-16 14:58	psanjuan	Modules	=> Core
2014-10-16 14:58	psanjuan	Triggers an Emergency Pack	=> No
2014-10-16 14:59	psanjuan	File Added: Cost Adj issue 27888.png
2014-10-16 15:08	psanjuan	Steps to Reproduce Updated	View Revisions
2014-10-16 15:08	psanjuan	Proposed Solution updated
2014-10-23 11:10	psanjuan	Steps to Reproduce Updated	View Revisions
2014-10-27 11:54	umartirena	Review Assigned To	=> umartirena
2014-10-27 11:54	umartirena	Note Added: 0071188
2014-10-27 11:54	umartirena	Status	new => closed
2014-10-27 11:54	umartirena	Resolution	open => unable to reproduce
2014-10-27 11:54	umartirena	Fixed in Version	=> pi