0027998: Negative Stock Correction cost adjustment is not properly created

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #27998		[ All Revisions ] [ Back to Issue ]
Summary	0027998: Negative Stock Correction cost adjustment is not properly created

Revision	2014-11-12 08:54 by aferraz
Steps To Reproduce	In "QA Testing" client: Create a new Product named "Costing V911" for Spain organization. Go to Price tab, select "Purchase" price list and enter a unit/list price of 15 €. Go to Costing tab and enter a new line for Spain organization, Average cost type, cost 25, starting date 01-01-2014 date and ending date 31-12-9999 Go to Purchase Invoice window and create a new invoice for Spain organization, product "Costing V911", invoice date 11-10-2014, quantity 500 and price 15. Complete the invoice and post it. Let's say this is invoice 10000037. Realize that the value posted to the ledger is 7,500.00 (500 units * 15 €/unit) Go to Goods Shipment window and create a new shipment dated on 15-10-2014, product "Costing V911", quantity 400, storage bin L01. Complete. Let's say this is shipment 500024. Navigate to Process Request window and run "Costing Background process". Go to shipment window and post the shipment 500024. Realize that the value posted to the ledger is 10,000.00 (400 units * 25 €/unit) Go to Goods Receipt window and create a new receipt dated on 20-10-2014. Click on Create Lines From, select invoice 10000037, select storage bin L01 and enter 200 units. Complete. Let's say this is receipt 10000034. Navigate to Process Request window and run "Costing Background process". Go to receipt window and post the receipt 10000034. Realize that the value posted to the ledger is 5,000.00 (200 units * 25 €/unit) Navigate to Process Request window and run "Price Correction Background". Go to Goods Receipt window and create a new receipt dated on 25-10-2014. Click on Create Lines From, select invoice 10000037, select storage bin L01 and enter 300 units. Complete. Let's say this is receipt 10000035. Navigate to Process Request window and run "Costing Background process". Go to receipt window and post the receipt 10000035. Realize that the value posted to the ledger is 4,500.00 (300 units * 15 €/unit) Navigate to Process Request window and run "Price Correction Background". Navigate to Product window, select "Costing V911" and go to Transaction tab, realize that there are 3 records: - Transaction 1: Trx Original Cost 10,000.00 - Total Cost 10,000.00 - Unit Cost 10,000.00 - Transaction 2: Trx Original Cost 5,000.00 - Total Cost 7,000.00 - Unit Cost -1,000.00 - Transaction 3: Trx Original Cost 4,500.00 - Total Cost 4,500.00 - Unit Cost 4,500.00 This is not correct, correct should be: - Transaction 1: Trx Original Cost 10,000.00 - Total Cost 10,000.00 - Unit Cost 10,000.00 - Transaction 2: Trx Original Cost 5,000.00 - Total Cost 7,000.00 - Unit Cost 3,000.00 - Transaction 3: Trx Original Cost 4,500.00 - Total Cost 4,500.00 - Unit Cost 4,500.00 Navigate to Cost Adjustment window, search the 3 last created records: - Cost adjustment 1 line 1: source process Price Difference Correction, adjusted amount -2,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 1 line 2: source process Price Difference Correction, adjusted amount 4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 2 line 1: source process Negative Stock Correction, adjusted amount -4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 2 line 2: source process Negative Stock Correction, adjusted amount 4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 3 line 1: source process Negative Stock Correction, adjusted amount 0.00, inventory transaction points to receipt 10000035. This is not correct, correct should be: - Cost adjustment 1 line 1: source process Price Difference Correction, adjusted amount -2,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 1 line 2: source process Negative Stock Correction, adjusted amount 4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 2 line 1: source process Negative Stock Correction, adjusted amount 0.00, inventory transaction points to receipt 10000035.

Revision	2014-11-12 08:52 by aferraz
Steps To Reproduce	In "QA Testing" client: Create a new Product named "Costing V911" for Spain organization. Go to Price tab, select "Purchase" price list and enter a unit/list price of 15 €. Go to Costing tab and enter a new line for Spain organization, Average cost type, cost 25, starting date 01-01-2014 date and ending date 31-12-9999 Go to Purchase Invoice window and create a new invoice for Spain organization, product "Costing V911", invoice date 11-10-2014, quantity 500 and price 15. Complete the invoice and post it. Let's say this is invoice 10000037. Realize that the value posted to the ledger is 7,500.00 (500 units * 15 €/unit) Go to Goods Shipment window and create a new shipment dated on 15-10-2014, product "Costing V911", quantity 400, storage bin L01. Complete. Let's say this is shipment 500024. Navigate to Process Request window and run "Costing Background process". Go to shipment window and post the shipment 500024. Realize that the value posted to the ledger is 10,000.00 (400 units * 25 €/unit) Go to Goods Receipt window and create a new receipt dated on 20-10-2014. Click on Create Lines From, select invoice 10000037, select storage bin L01 and enter 200 units. Complete. Let's say this is receipt 10000034. Navigate to Process Request window and run "Costing Background process". Go to receipt window and post the receipt 10000034. Realize that the value posted to the ledger is 5,000.00 (200 units * 25 €/unit) Navigate to Process Request window and run "Price Correction Background". Go to Goods Receipt window and create a new receipt dated on 25-10-2014. Click on Create Lines From, select invoice 10000037, select storage bin L01 and enter 300 units. Complete. Let's say this is receipt 10000035. Navigate to Process Request window and run "Costing Background process". Go to receipt window and post the receipt 10000035. Realize that the value posted to the ledger is 4,500.00 (300 units * 15 €/unit) Navigate to Process Request window and run "Price Correction Background". Navigate to Product window, select "Costing V911" and go to Transaction tab, realize that there are 3 records: - Transaction 1: Trx Original Cost 10,000.00 - Total Cost 10,000.00 - Unit Cost 10,000.00 - Transaction 2: Trx Original Cost 5,000.00 - Total Cost 7,000.00 - Unit Cost -1,000.00 - Transaction 3: Trx Original Cost 4,500.00 - Total Cost 4,500.00 - Unit Cost 4,500.00 This is not correct, correct should be: - Transaction 1: Trx Original Cost 10,000.00 - Total Cost 10,000.00 - Unit Cost 10,000.00 - Transaction 2: Trx Original Cost 5,000.00 - Total Cost 7,000.00 - Unit Cost 7,000.00 - Transaction 3: Trx Original Cost 4,500.00 - Total Cost 4,500.00 - Unit Cost 4,500.00 Navigate to Cost Adjustment window, search the 3 last created records: - Cost adjustment 1 line 1: source process Price Difference Correction, adjusted amount -2,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 1 line 2: source process Price Difference Correction, adjusted amount 4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 2 line 1: source process Negative Stock Correction, adjusted amount -4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 2 line 2: source process Negative Stock Correction, adjusted amount 4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 3 line 1: source process Negative Stock Correction, adjusted amount 0.00, inventory transaction points to receipt 10000035. This is not correct, correct should be: - Cost adjustment 1 line 1: source process Price Difference Correction, adjusted amount -2,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 2 line 1: source process Negative Stock Correction, adjusted amount 4,000.00, inventory transaction points to receipt 10000034. - Cost adjustment 3 line 1: source process Negative Stock Correction, adjusted amount 0.00, inventory transaction points to receipt 10000035.