Project:
| View Revisions: Issue #27884 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0027884: New lines created in costing tab which should not be there | ||
| Revision | 2014-10-23 08:46 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order. Above means to receipt all quantity, that is 300 units. Complete the receipt. Go to process request window and run costing background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 15 Quantity 200. Total Qty 200. Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 100. Total Qty 300. Ending date 31-12-9999 Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for Spain and product Costing V11, for a total amount of 150 units. Complete shipment. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are three lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Ending date 31-12-9999 (this is not correct) Correct should be: Line 1 - inventory transaction V+ 20/10/2014 Cost 15 Quantity 200. Total Qty 200. Line 2 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 300. Ending date 31-12-9999 Go to purchase invoice window and create a new invoice dated on 24/10/2014 for Spain org. Create lines from order dated on 15/10/2014, that means 200 units at 15 €/unit. Change the price to 20 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are four lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Line 4 - no inventory transaction Cost 21.67 Total movement quantity 150. Ending date 31-12-2014 (this is not correct) Correct should be: Line 1 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 200. Line 2 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 300. Ending date 31-12-9999 |
||
| Revision | 2014-10-16 12:10 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order. Above means to receipt all quantity, that is 300 units. Complete the receipt. Go to process request window and run costing background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300. Ending date 31-12-9999 Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for Spain and product Costing V11, for a total amount of 150 units. Complete shipment. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are three lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Ending date 31-12-9999 (this is not correct) Correct should be: line 1 - inventory transaction V+ 20/10/2014 Cost 25 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 200. Total Qty 300. Ending date 31-12-9999 Go to purchase invoice window and create a new invoice dated on 24/10/2014 for Spain org. Create lines from order dated on 15/10/2014, that means 200 units at 15 €/unit. Change the price to 20 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are four lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Line 4 - no inventory transaction Cost 21.67 Total movement quantity 150. Ending date 31-12-2014 (this is not correct) Correct should be: line 1 - inventory transaction V+ 20/10/2014 Cost 25 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 200. Total Qty 300. Ending date 31-12-9999 |
||
| Revision | 2014-10-16 12:05 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order. Above means to receipt all quantity, that is 300 units. Complete the receipt. Go to process request window and run costing background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: line 1 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300 Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for Spain and product Costing V11, for a total amount of 150 units. Complete shipment. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: line 1 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150 (this is not correct) Correct should be: line 1 - inventory transaction V+ 20/10/2014 Cost 25 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 200. Total Qty 300 Go to purchase invoice window and create a new invoice dated on 24/10/2014 for Spain org. Create lines from order dated on 15/10/2014, that means 200 units at 15 €/unit. Change the price to 20 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: |
||
| Revision | 2014-10-16 11:36 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order. Above means to receipt all quantity, that is 300 units. Complete the receipt. Go to process request window and run costing background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: line 1 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300 Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for Spain and product Costing V11, for a total amount of 150 units. Complete shipment. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run costing background process. Go to product window, search the product and navigate to costing tab |
||
| Revision | 2014-10-16 11:26 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order. Above means to receipt all quantity, that is 300 units. Complete the receipt. Go to process request window and run costing background process. Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for a total amount of 150 units of the product. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run costing background process. Go to product window, search the product and navigate to costing tab |
||
| Revision | 2014-10-16 11:24 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders. Receipt all quantity, that means 300 units. Complete the receipt. Go to process request window and run costing background process. Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for a total amount of 150 units of the product. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run costing background process. Go to product window, search the product and navigate to costing tab |
||
| Revision | 2014-10-16 11:18 by psanjuan | ||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders. Receipt all quantity, that means 300 units. Complete the receipt. Go to process request window and run costing background process. Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for a total amount of 150 units of the product. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run costing background process. Go to product window, search the product and navigate to costing tab |
||
| Revision | 2014-10-16 11:06 by psanjuan | ||
| Steps To Reproduce | Go to Product window and create a new one named "Costing V11". Go to |
||
| Revision | 2014-10-16 10:59 by psanjuan | ||
| Steps To Reproduce | to detail | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |