Project:
| View Revisions: Issue #28301 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0028301: [Costing] Cost not properly calculated after booking two backdated transactions | ||
| Revision | 2014-11-27 13:19 by psanjuan | ||
| Steps To Reproduce | In QA testing client go to Product window. Create a new product named KDK01 for Spain org. Navigate to price tab and select purchase price list. Enter a unit/list price of 10.00 € Go to purchase order and create a new one dated on 19-11-2014. PO 1. Select Spain org and vendor A. Enter 200 units. Book the order. Go to goods receipt window and create a new one dated on 19-11-2014 by selecting purchase order above. GR 01. Receipt 200 units. Enter an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the goods receipt and get it posted. Realize that value posted is 2000 (200 units * 10 €/unit) Go to purchase order window and create a new one for Spain org, KDK01 product, vendor A, dated on 20-11-2014. PO 2. Enter 300 units a 10.00 price. Book the order and leave it there. Create a new purchase order for all the same dated on 26-11-2014. PO 3. Enter 400 units and change the price to 12. Book the order. Go to goods receipt and create a new one dated on 26-11-2014. Use create lines from and select purchase order PO3 dated on 26-11-2014. Receipt 380 units. Complete. Go to process request window and run costing background process. Go back to goods receipt and get it posted. Realize that value posted is 4560.00 (380 units * 12 €/unit) Navigate to product window, search product KDK01 and go to costing tab. Realize that there are two cost related lines. Line related to inventory trans dated on 19-11-2014 - cost 10 units 200 Line related to inventory trans dated on 26-11-2014 - cost 11.3103 units 580 Go to goods receipt window and create a new one dated on 17-11-2014. Use create lines from and select purchase order PO2 dated on 20-11-2014. Receipt 100 units. Go to process request window and run costing background process. Go back to goods receipt and get the one dated on 17-11-2014 posted. Realize that value posted is 1000 (100 units x 10 €/unit) Go to product window, search by product KDK01 and navigate to costing tab. Realize that there are 3 lines. Line related to inventory trans dated on 17-11-2014 - cost 10 units 680 Line related to inventory trans dated on 19-11-2014 - cost 10 units 200 Line related to inventory trans dated on 26-11-2014 - cost 11.3103 units 580 (A backdated transaction has been created in cost adjustment window dated on 17-11-2014 window which is correct, for an amount = 0.00) Go to goods receipt window and create a new one dated on 02-11-2014, use create lines from and select PO 3 dated on 26-11-2014. Receipt 10 units. Complete. Run costing background process. Go back to goods receipt dated on 02-11-2014 and get it posted. Realize that value posted is 120 (10 units x 12 €/unit) Go to product window and search KDK01 product, navigate to costing tab. There are 5 lines there which is not correct. See image KDK01_Cost_before Landed Cost Line related to inventory trans 02-11-2014 - cost 12 - units 690 - correct Line related to inventory trans 17-11-2014 - cost 10.1818 - units 680 - correct Line related to inventory trans 19-11-2014 - cost 10.0645 - units 200 - correct Line related to inventory trans 26-11-2014 - cost 11.1304 - units 580 - this one is not correct because the cost is not correct. And a Line related to no inventory trans - cost 11.1304 - net unit price 11.13 - this is not correct. This line should not be there. Enter now a landed cost dated on 26-11-2014. Navigate to Cost tab and select two landed cost :Fees for an amount of 200 € and Transportation Cost for an amount of 950€. Total 1150. Go to Receipt tab and select the receipt dated on 26-11-2014. Process. A cost adjustment is created for the product and for an amount of 1150. Go to product window, search the product and navigate to costing tab. There are 6 lines there which is not correct. See image KDK01_Cost_after Landed Cost Line related to inventory trans 02-11-2014 - cost 12 - units 690 - correct Line related to inventory trans 17-11-2014 - cost 10.1818 - units 680 - correct Line related to inventory trans 19-11-2014 - cost 10.0645 - units 200 - correct Line related to inventory trans 26-11-2014 - cost 12.7971 - net unit price 15.03 - units 580 - this one is not totally correct net unit price should be 12 Line related to no inventory trans - cost 11.1304 - net unit price 11.13 - this is not correct. This line should not be there. Line related to no inventory trans - cost 12.7971 - net unit price 12.80 - this one is not correct. this line should not be there. |
||
| Revision | 2014-11-27 13:13 by psanjuan | ||
| Steps To Reproduce | In QA testing client go to Product window. Create a new product named KDK01 for Spain org. Navigate to price tab and select purchase price list. Enter a unit/list price of 10.00 € Go to purchase order and create a new one dated on 19-11-2014. PO 1. Select Spain org and vendor A. Enter 200 units. Book the order. Go to goods receipt window and create a new one dated on 19-11-2014 by selecting purchase order above. GR 01. Receipt 200 units. Enter an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the goods receipt and get it posted. Realize that value posted is 2000 (200 units * 10 €/unit) Go to purchase order window and create a new one for Spain org, KDK01 product, vendor A, dated on 20-11-2014. PO 2. Enter 300 units a 10.00 price. Book the order and leave it there. Create a new purchase order for all the same dated on 26-11-2014. PO 3. Enter 400 units and change the price to 12. Book the order. Go to goods receipt and create a new one dated on 26-11-2014. Use create lines from and select purchase order PO3 dated on 26-11-2014. Receipt 380 units. Complete. Go to process request window and run costing background process. Go back to goods receipt and get it posted. Realize that value posted is 4560.00 (380 units * 12 €/unit) Navigate to product window, search product KDK01 and go to costing tab. Realize that there are two cost related lines. Line related to inventory trans dated on 19-11-2014 - cost 10 units 200 Line related to inventory trans dated on 26-11-2014 - cost 11.3103 units 580 Go to goods receipt window and create a new one dated on 17-11-2014. Use create lines from and select purchase order PO2 dated on 20-11-2014. Receipt 100 units. Go to process request window and run costing background process. Go back to goods receipt and get the one dated on 17-11-2014 posted. Realize that value posted is 1000 (100 units x 10 €/unit) Go to product window, search by product KDK01 and navigate to costing tab. Realize that there are 3 lines. Line related to inventory trans dated on 17-11-2014 - cost 10 units 680 Line related to inventory trans dated on 19-11-2014 - cost 10 units 200 Line related to inventory trans dated on 26-11-2014 - cost 11.3103 units 580 (A backdated transaction has been created in cost adjustment window dated on 17-11-2014 window which is correct, for an amount = 0.00) Go to goods receipt window and create a new one dated on 02-11-2014, use create lines from and select PO 3 dated on 26-11-2014. Receipt 10 units. Complete. Run costing background process. Go back to goods receipt dated on 02-11-2014 and get it posted. Realize that value posted is 120 (10 units x 12 €/unit) Go to product window and search KDK01 product, navigate to costing tab. There are 5 lines there which is not correct. See image KDK01_Cost_before Landed Cost Line related to inventory trans 02-11-2014 - cost 12 - units 690 - correct Line related to inventory trans 17-11-2014 - cost 10.1818 - units 680 - correct Line related to inventory trans 19-11-2014 - cost 10.0645 - units 200 - correct Line related to inventory trans 26-11-2014 - cost 11.1304 - units 580 - this one is not correct Line related to no inventory trans - cost 11.1304 - net unit price 11.13 - this is not correct. This line should not be there. Enter now a landed cost dated on 26-11-2014. Navigate to Cost tab and select two landed cost :Fees for an amount of 200 € and Transportation Cost for an amount of 950€. Total 1150. Go to Receipt tab and select the receipt dated on 26-11-2014. Process. A cost adjustment is created for the product and for an amount of 1150. Go to product window, search the product and navigate to costing tab. There are 6 lines there which is not correct. See image KDK01_Cost_after Landed Cost Line related to inventory trans 02-11-2014 - cost 12 - units 690 - correct Line related to inventory trans 17-11-2014 - cost 10.1818 - units 680 - correct Line related to inventory trans 19-11-2014 - cost 10.0645 - units 200 - correct Line related to inventory trans 26-11-2014 - cost 11.1304 - units 580 - this one is not correct Line related to no inventory trans - cost 11.1304 - net unit price 11.13 - this is not correct. This line should not be there. |
||
| Revision | 2014-11-27 13:09 by psanjuan | ||
| Steps To Reproduce | In QA testing client go to Product window. Create a new product named KDK01 for Spain org. Navigate to price tab and select purchase price list. Enter a unit/list price of 10.00 € Go to purchase order and create a new one dated on 19-11-2014. PO 1. Select Spain org and vendor A. Enter 200 units. Book the order. Go to goods receipt window and create a new one dated on 19-11-2014 by selecting purchase order above. GR 01. Receipt 200 units. Enter an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the goods receipt and get it posted. Realize that value posted is 2000 (200 units * 10 €/unit) Go to purchase order window and create a new one for Spain org, KDK01 product, vendor A, dated on 20-11-2014. PO 2. Enter 300 units a 10.00 price. Book the order and leave it there. Create a new purchase order for all the same dated on 26-11-2014. PO 3. Enter 400 units and change the price to 12. Book the order. Go to goods receipt and create a new one dated on 26-11-2014. Use create lines from and select purchase order PO3 dated on 26-11-2014. Receipt 380 units. Complete. Go to process request window and run costing background process. Go back to goods receipt and get it posted. Realize that value posted is 4560.00 (380 units * 12 €/unit) Navigate to product window, search product KDK01 and go to costing tab. Realize that there are two cost related lines. Line related to inventory trans dated on 19-11-2014 - cost 10 units 200 Line related to inventory trans dated on 26-11-2014 - cost 11.3103 units 580 Go to goods receipt window and create a new one dated on 17-11-2014. Use create lines from and select purchase order PO2 dated on 20-11-2014. Receipt 100 units. Go to process request window and run costing background process. Go back to goods receipt and get the one dated on 17-11-2014 posted. Realize that value posted is 1000 (100 units x 10 €/unit) Go to product window, search by product KDK01 and navigate to costing tab. Realize that there are 3 lines. Line related to inventory trans dated on 17-11-2014 - cost 10 units 680 Line related to inventory trans dated on 19-11-2014 - cost 10 units 200 Line related to inventory trans dated on 26-11-2014 - cost 11.3103 units 580 (A backdated transaction has been created in cost adjustment window dated on 17-11-2014 window which is correct, for an amount = 0.00) Go to goods receipt window and create a new one dated on 02-11-2014, use create lines from and select PO 3 dated on 26-11-2014. Receipt 10 units. Complete. Run costing background process. Go back to goods receipt dated on 02-11-2014 and get it posted. Realize that value posted is 120 (10 units x 12 €/unit) Go to product window and search KDK01 product, navigate to costing tab. There are 5 lines there which is not correct. See image KDK01_Cost_before Landed Cost Line related to inventory trans 02-11-2014 - cost 12 - units 690 - correct Line related to inventory trans 17-11-2014 - cost 10.1818 - units 680 - correct Line related to inventory trans 19-11-2014 - cost 10.0645 - units 200 - correct Line related to inventory trans 26-11-2014 - cost 11.1304 - units 580 - this one is not correct Line related to no inventory trans - cost 11.1304 - net unit price 11.13 - this is not correct. This line should not be there. |
||
| Revision | 2014-11-27 12:55 by psanjuan | ||
| Steps To Reproduce | In QA testing client go to Product window. Create a new product named KDK01 for Spain org. Navigate to price tab and select purchase price list. Enter a unit/list price of 10.00 € Go to purchase order and create a new one dated on 19-11-2014. PO 1. Select Spain org and vendor A. Enter 200 units. Book the order. Go to goods receipt window and create a new one dated on 19-11-2014 by selecting purchase order above. GR 01. Receipt 200 units. Enter an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the goods receipt and get it posted. Realize that value posted is 2000 (200 units * 10 €/unit) Go to purchase order window and create a new one for Spain org, KDK01 product, vendor A, dated on 20-11-2014. PO 2. Enter 300 units a 10.00 price. Book the order and leave it there. Create a new purchase order for all the same dated on 26-11-2014. PO 3. Enter 400 units and change the price to 12. Book the order. Go to goods receipt and create a new one dated on 26-11-2014. Use create lines from and select purchase order PO3 dated on 26-11-2014. Receipt 380 units. Complete. Go to process request window and run costing background process. Go back to goods receipt and get it posted. Realize that value posted is 4560.00 (380 units * 12 €/unit) Navigate to product window, search product KDK01 and go to costing tab. Realize that there are two cost related lines. Line 1 dated on 19-11-2014 - cost 10 units 200 Line 2 dated on 26-11-2014 - cost 11.3103 units 580 Go to goods receipt window and create a new one dated on 17-11-2014. Use create lines from and select purchase order PO2 dated on 20-11-2014. Receipt 100 units. Go to process request window and run costing background process. Go back to goods receipt and get the one dated on 17-11-2014 posted. Realize that value posted is 1000 (100 units x 10 €/unit) Go to product window, search by product KDK01 and navigate to costing tab. Realize that there are 3 lines. Line 1 dated on 17-11-2014 - cost 10 units 680 Line 2 dated on 19-11-2014 - cost 10 units 200 Line 3 dated on 26-11-2014 - cost 11.3103 units 580 (A backdated transaction has been created in cost adjustment window dated on 17-11-2014 window which is correct, for an amount = 0.00) Go to goods receipt window and create a new one dated on 02-11-2014, use create lines from and select PO 3 dated on 26-11-2014. Receipt 10 units. Complete. Run costing background process. Go back to goods receipt dated on 02-11-2014 and get it posted. Realize that value posted is 120 (10 units x 12 €/unit) Go to product window and search KDK01 product, navigate to costing tab. There are 5 lines there which is not correct. See image KDK01_Cost_before Landed Cost |
||
| Revision | 2014-11-27 12:49 by psanjuan | ||
| Steps To Reproduce | In QA testing client go to Product window. Create a new product named KDK01 for Spain org. Navigate to price tab and select purchase price list. Enter a unit/list price of 10.00 € Go to purchase order and create a new one dated on 19-11-2014. PO 1. Select Spain org and vendor A. Enter 200 units. Book the order. Go to goods receipt window and create a new one dated on 19-11-2014 by selecting purchase order above. GR 01. Receipt 200 units. Enter an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the goods receipt and get it posted. Realize that value posted is 2000 (200 units * 10 €/unit) Go to purchase order window and create a new one for Spain org, KDK01 product, vendor A, dated on 20-11-2014. PO 2. Enter 300 units a 10.00 price. Book the order and leave it there. Create a new purchase order for all the same dated on 26-11-2014. PO 3. Enter 400 units and change the price to 12. Book the order. Go to goods receipt and create a new one dated on 26-11-2014. Use create lines from and select purchase order PO3 dated on 26-11-2014. Receipt 380 units. Complete. Go to process request window and run costing background process. Go back to goods receipt and get it posted. Realize that value posted is 4560.00 (380 units * 12 €/unit) Navigate to product window, search product KDK01 and go to costing tab. Realize that there are two cost related lines. Line 1 dated on 19-11-2014 - cost 10 units 200 Line 2 dated on 26-11-2014 - cost 11.3103 units 580 Go to goods receipt window and create a new one dated on 17-11-2014. Use create lines from and select purchase order PO2 dated on 20-11-2014. Receipt 100 units. Go to process request window and run costing background process. Go back to goods receipt and get the one dated on 17-11-2014 posted. Realize that value posted is 1000 (100 units x 10 €/unit) Go to product window, search by product KDK01 and navigate to costing tab. Realize that there are 3 lines. Line 1 dated on 17-11-2014 - cost 10 units 680 Line 2 dated on 19-11-2014 - cost 10 units 200 Line 3 dated on 26-11-2014 - cost 11.3103 units 580 |
||
| Revision | 2014-11-27 12:46 by psanjuan | ||
| Steps To Reproduce | In QA testing client go to Product window. Create a new product named KDK01 for Spain org. Navigate to price tab and select purchase price list. Enter a unit/list price of 10.00 € Go to purchase order and create a new one dated on 19-11-2014. PO 1. Select Spain org and vendor A. Enter 200 units. Book the order. Go to goods receipt window and create a new one dated on 19-11-2014 by selecting purchase order above. GR 01. Receipt 200 units. Enter an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the goods receipt and get it posted. Realize that value posted is 2000 (200 * 10) Go to purchase order window and create a new one for Spain org, KDK01 product, vendor A, dated on 20-11-2014. PO 2. Enter 300 units a 10.00 price. Book the order and leave it there. Create a new purchase order for all the same dated on 26-11-2014. PO 3. Enter 400 units and change the price to 12. Book the order. Go to goods receipt and create a new one dated on 26-11-2014. Use create lines from and select purchase order PO3 dated on 26-11-2014. Receipt 380 units. Complete. Go to process request window and run costing background process. Go back to goods receipt and get it posted. Realize that value posted is 4560.00 (380*12) Navigate to product window, search product KDK01 and go to costing tab. Realize that there are two cost related lines. Line 1 dated on 19-11-2014 - cost 10 units 200 Line 2 dated on 26-11-2014 - cost 11.3103 units 580 Go to goods receipt window and create a new one dated on 17-11-2014. Use create lines from and select purchase order PO2 dated on 20-11-2014. Receipt 100 units. Go to process request window and run costing background process. Go back to goods receipt and get the one dated on 17-11-2014 posted. Realize that value posted is 1000 (100 units x 10 €/unit) |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |