Project:
| View Revisions: Issue #28192 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0028192: [Costing] Net Unit Price field in Costing tab is not properly calculated | ||
| Revision | 2014-12-04 15:03 by psanjuan | ||
| Steps To Reproduce | In QA Testing client create a new product named "Costing GM12". Select a purchase price list. Enter a unit/list price of 11.00 Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order. Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt Go to process request window and launch costing background process. Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit) Go to Goods Movement Window and create a new one dated on 13/11/2014 Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement. Go to process request window and launch costing background process. Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit) Go to product window and search by the product. Go to transaction tab. Select Movement From transaction and press the button "Manual Cost Adjustment". In total cost field enter a total cost amount = -400. Enter 18/11/2014 as accounting date, select the flag "Incremental" but do not select the flag "Unit Cost". Press Done/OK. After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit). Go to process request window and run price correction background process. Go to product window and search by the product. Go to Transaction tab and realize that there are 3 lines: - Transaction 1: Movement Quantity 820 - Transaction Original Cost 9,020.00 - Total Cost 12,300.00 - Unit Cost 12,300.00 - Transaction 2: Movement Quantity -400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 6,000.00 - Transaction 3: Movement Quantity 400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 5,600.00 Go to Costing tab and realize that there are 3 lines: - Line 1: Cost 15 - Net Unit Price 15.00 - Original Cost 11 - Line 2: Cost 14 - Net Unit Price 14.00 - Original Cost 11 - Line 3: Cost 15.9524 - Net Unit Price 6.00 - Original Cost 11.9524 Line 3 is not correct. It should be: - Line 3: Cost 15.9524 - Net Unit Price 15.95 (because that is the cost of the Movement From transacton) - Original Cost 11.9524 |
||
| Revision | 2014-12-01 12:16 by umartirena | ||
| Steps To Reproduce | In QA Testing client create a new product named "Costing GM12". Select a purchase price list. Enter a unit/list price of 11.00 Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order. Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt Go to process request window and launch costing background process. Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit) Go to Goods Movement Window and create a new one dated on 13/11/2014 Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement. Go to process request window and launch costing background process. Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit) Go to product window and search by the product. Go to transaction tab. Select Movement From transaction and press the button "Manual Cost Adjustment". In total cost field enter a total cost amount = -400. Enter 18/11/2014 as accounting date, select the flag "Incremental" but do not select the flag "Unit Cost". Press Done/OK. After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit). Go to process request window and run price correction background process. Go to product window and search by the product. Go to Transaction tab and realize that there are 3 lines: - Transaction 1: Movement Quantity 820 - Transaction Original Cost 9,020.00 - Total Cost 12,300.00 - Unit Cost 12,300.00 - Transaction 2: Movement Quantity -400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 6,000.00 - Transaction 3: Movement Quantity 400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 5,600.00 Go to Costing tab and realize that there are 3 lines: - Line 1: Cost 15 - Net Unit Price 15.00 - Original Cost 11 - Line 2: Cost 14 - Net Unit Price 14.00 - Original Cost 11 - Line 3: Cost 15.9524 - Net Unit Price 6.00 - Original Cost 11.9524 Line 3 is not correct. It should be: - Line 3: Cost 15.9524 - Net Unit Price 15.00 (because it should be the price entered in the purchase invoice) - Original Cost 11.9524 |
||
| Revision | 2014-11-18 11:18 by umartirena | ||
| Steps To Reproduce | In QA Testing client create a new product named "Costing GM12". Select a purchase price list. Enter a unit/list price of 11.00 Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order. Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt Go to process request window and launch costing background process. Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit) Go to Goods Movement Window and create a new one dated on 13/11/2014 Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement. Go to process request window and launch costing background process. Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit) Go to product window and search by the product. Go to transaction tab. Select Movement From transaction and press the button "Manual Cost Adjustment". In total cost field enter a total cost amount = 4000. Enter 18/11/2014 as accounting date, select the flag "Incremental" but do not select the flag "Unit Cost". Press Done/OK. After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit). Go to process request window and run price correction background process. Go to product window and search by the product. Go to Transaction tab and realize that there are 3 lines: - Transaction 1: Movement Quantity 820 - Transaction Original Cost 9,020.00 - Total Cost 12,300.00 - Unit Cost 12,300.00 - Transaction 2: Movement Quantity -400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 6,000.00 - Transaction 3: Movement Quantity 400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 5,600.00 Go to Costing tab and realize that there are 3 lines: - Line 1: Cost 15 - Net Unit Price 15.00 - Original Cost 11 - Line 2: Cost 14 - Net Unit Price 14.00 - Original Cost 11 - Line 3: Cost 15.9524 - Net Unit Price 6.00 - Original Cost 11.9524 Line 3 is not correct. It should be: - Line 3: Cost 15.9524 - Net Unit Price 15.00 (because it should be the price entered in the purchase invoice) - Original Cost 11.9524 |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |