Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #28113 All Revisions ] Back to Issue ]
Summary 0028113: [Costing] wrong negative stock correction adjustment
Revision 2014-12-02 13:30 by umartirena
Steps To Reproduce In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 6000 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

Go to process request window and launch price correction background process.

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)
4 - Vendor receipt dated on 22/10/2014 - Set as Negative Stock Correction- Adj Amount -315 - this last adjustment is not correct.

Correct negative stock correction adjustment should be: -450 = (2250+750-9000-3000+6000+1350+3000+X)/50 = 18

Go to the product window, search the product and navigate to costing tab. Realize that there are two lines.

Line 1 related to Vendor receipt 19/10/2014 inventory transaction - Cost 20 - total mov quantity - 150 - this is correct

Line 2 related to Vendor receipt 22/10/2014 inventory transaction - Cost 20.7 - total mov quanity - 50 - this is NOT correct as it should have a cost of 18.00




Revision 2014-11-12 19:33 by aferraz
Steps To Reproduce In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 600 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

Go to process request window and launch price correction background process.

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)
4 - Vendor receipt dated on 22/10/2014 - Set as Negative Stock Correction- Adj Amount -315 - this last adjustment is not correct.

Correct negative stock correction adjustment should be: -450 = (2250+750-9000-3000+6000+1350+3000+X)/50 = 18

Go to the product window, search the product and navigate to costing tab. Realize that there are two lines.

Line 1 related to Vendor receipt 19/10/2014 inventory transaction - Cost 20 - total mov quantity - 150 - this is correct

Line 2 related to Vendor receipt 22/10/2014 inventory transaction - Cost 20.7 - total mov quanity - 50 - this is NOT correct as it should have a cost of 18.00




Revision 2014-11-07 11:49 by psanjuan
Steps To Reproduce In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 600 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

Go to process request window and launch price correction background process.

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)
4 - Vendor receipt dated on 22/10/2014 - Set as Negative Stock Correction- Adj Amount -315 - this last adjustment is not correct.

Correct negative stock correction adjustment should be: 2550 = (2250+750-9000-3000+6000+1350+X)/50 = 18

Go to the product window, search the product and navigate to costing tab. Realize that there are two lines.

Line 1 related to Vendor receipt 19/10/2014 inventory transaction - Cost 20 - total mov quantity - 150 - this is correct

Line 2 related to Vendor receipt 22/10/2014 inventory transaction - Cost 20.7 - total mov quanity - 50 - this is NOT correct as it should have a cost of 18.00




Revision 2014-11-07 11:46 by psanjuan
Steps To Reproduce In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 600 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

Go to process request window and launch price correction background process.

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)
4 - Vendor receipt dated on 22/10/2014 - Set as Negative Stock Correction- Adj Amount -315 - this last adjustment is not correct.

Correct negative stock correction adjustment should be:


Go to the product window, search the product and navigate to costing tab. Realize that there are two lines.

Line 1 related to Vendor receipt 19/10/2014 inventory transaction - Cost 20 - total mov quantity - 150 - this is correct

Line 2 related to Vendor receipt 22/10/2014 inventory transaction - Cost 20.7 - total mov quanity - 50 - this is NOT correct as it should have a cost of 18.00




Revision 2014-11-07 11:38 by psanjuan
Steps To Reproduce In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 600 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

Go to process request window and launch price correction background process.

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)
4 - Vendor receipt dated on 22/10/2014 - Set as Negative Stock Correction- Adj Amount -315 - this last adjustment is not correct.

Go to the product window, search the product and navigate to costing tab. Realize that there are two lines.

Line 1




Revision 2014-11-07 11:32 by psanjuan
Steps To Reproduce In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 600 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

Go to process request window and launch price correction background process.

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)




Revision 2014-11-07 09:20 by psanjuan
Steps To Reproduce to be defined


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker