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

View Revisions: Issue #31202 All Revisions ] Back to Issue ]
Summary 0031202: Wrong cost calculation while stocks gets into 0 due to remaining valuation
Revision 2015-10-22 10:49 by aferraz
Steps To Reproduce Make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance. Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.

Create a shipment of the 3 units so you get into 0 stock. Complete the shipment and run costing background process.

Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a new purchase order of 1 unit of the product, this time change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Revision 2015-10-22 10:45 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance. Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.

Create a shipment of the 3 units so you get into 0 stock. Complete the shipment and run costing background process.

Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a new purchase order of 1 unit of the product, this time change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Revision 2015-10-22 10:38 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance. Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.

Create a shipment of the 3 units so you get into 0 stock. Complete the shipment and run costing background process.

Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a new purchase order of 1 unit of the product, this time change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Go to Inventory Amount Update window and create a new one for the product.
Check that the current unit cost shown is 7.01. Enter a Unit Cost = 7.
Process it. Run costing background process.

Go to Product Window and check that the cost is 6.34, that is not correct as it should have been 7.00

Go to Transactions tab and realize that the closing inventory transaction has been valued at 7.67 and that is not correct, as it should have been valued as 7.01. There is a difference in both cases of 0.66

Revision 2015-10-22 10:36 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 3 units, by shipping 1 unit of each of the 3 storage bin with positive stock.
Complete the shipment and run costing background process.
Revision 2015-10-21 15:53 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00. total value = 21.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Check that a negative stock correction adjustment for an amount of -11.01 has been created. (21-9.99)

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. do not process it but just check that quantity on hand shown is 0 as well as current unit cost, same as inventory amount = 0. This is correct.

Create a new purchase order for the product, 5 units at a new price = 8. Receipt 5 units of the product. Run costing background process and check that the new cost of the product is 8 and no new adjustment has been created. This is correct, seems that no remaining value remains.

Enhanced value stock report is also correct.
Revision 2015-10-21 15:49 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Check that a negative stock correction adjustment for an amount of -11.01 has been created. (21-9.99)

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. do not process it but just check that quantity on hand shown is 0 as well as current unit cost, same as inventory amount = 0. This is correct.

Create a new purchase order for the product, 5 units at a new price = 8. Receipt 5 units of the product. Run costing background process and check that the new cost of the product is 8 and no new adjustment has been created. This is correct, seems that no remaining value remains.

Enhanced value stock report is also correct.
Revision 2015-10-21 15:48 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Check that a negative stock correction adjustment for an amount of -11.01 has been created. (21-9.99)

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. do not process it but just check that quantity on hand shown is 0 as well as current unit cost, same as inventory amount = 0. This is correct.

Create a new purchase order for the product, 5 units at a new price = 8. Receipt 5 units of the product. Run costing background process and check that the new cost of the product is 8 and no new adjustment has been created. This is correct, seems that no remaining value remains.

Revision 2015-10-21 15:46 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Check that a negative stock correction adjustment for an amount of -11.01 has been created. (21-9.99)

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. Check that regardless quantity on hand shown is 0 as well as current unit cost, same as inventory amount = 0. This is correct.

Create a new purchase order for the product, 5 units at a new price = 8. Receipt 5 units of the product. Run costing background process and check that the new cost of the product is 8 and no new adjustment has been created. This is correct.

Revision 2015-10-21 15:45 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Check that a negative stock correction adjustment for an amount of -11.01 has been created. (21-9.99)

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. Check that regardless quantity on hand shown is 0 as well as current unit cost, same as inventory amount = 0. This is correct.



Revision 2015-10-21 15:29 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Check that a negative stock correction adjustment for an amount of -11.01 has been created.

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. Check that regardless quantity on hand shown is 0 as well as current unit cost, same as inventory amount = 0. This is correct.



Revision 2015-10-21 15:15 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group), and make sure you have enabled the preference: Enable Negative Stock Corrections for F&B España.

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. Check that regardless quantity on hand shown is 0 as well as current unit cost, there is a remaining inventory amount = 11.01. This is not correct.

A negative stock corrections cost adjustment needs to be created when the stock gets into 0, therefore 0 stocks means 0 value so the remaining inventory amount is removed.


Revision 2015-10-21 15:13 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group).

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Go to Inventory Amount Update window and create a new one for this product. Check that regardless quantity on hand shown is 0 as well as current unit cost, there is a remaining inventory amount = 11.01. This is not correct.

A negative stock corrections cost adjustment needs to be created when the stock gets into 0, therefore 0 stocks means 0 value so the remaining inventory amount is removed.


Revision 2015-10-21 15:10 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group).

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Go to product window, costing tab and check that cost remains as 3.3333, shipment transactions have been valued at 3.33 (1 unit) and 10 (3 additional units).

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00

Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that there is a line in the costing tab with the same cost 3.3333

Revision 2015-10-21 15:03 by psanjuan
Steps To Reproduce Make sure you allow Negative Stock at client level (F&B International Group).

Rest of steps are executed on F&B España, costing rule "Average", Warehouse dimension = NO.

Go to product window and create a new product named "Product Rounding 31202" for instance
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Go to Inventory Amount Update window and create a new one for the product.
Check that the current unit cost shown is 7.01. Enter a Unit Cost = 7.
Process it. Run costing background process.

Go to Product Window and check that the cost is 6.34, that is not correct as it should have been 7.00

Go to Transactions tab and realize that the closing inventory transaction has been valued at 7.67 and that is not correct, as it should have been valued as 7.01. There is a difference in both cases of 0.66
Revision 2015-10-21 15:02 by psanjuan
Steps To Reproduce Go to product window and create a new product named "Product Rounding 31202" for instance.
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, by shipping 1 unit of each of the 3 storage bin with positive stock and a new shipment line of 3 units taken from RN-Dev storage bin. Product turns into negative stock.
Complete the shipment and run costing background process.

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Go to Inventory Amount Update window and create a new one for the product.
Check that the current unit cost shown is 7.01. Enter a Unit Cost = 7.
Process it. Run costing background process.

Go to Product Window and check that the cost is 6.34, that is not correct as it should have been 7.00

Go to Transactions tab and realize that the closing inventory transaction has been valued at 7.67 and that is not correct, as it should have been valued as 7.01. There is a difference in both cases of 0.66
Revision 2015-10-21 13:45 by psanjuan
Steps To Reproduce Go to product window and create a new product named "Product Rounding 31202" for instance.
Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a goods shipment of 6 units, therefore this product turns into negative stock. Complete the shipment and run costing background process.

Create a new purchase order of 3 unit of the product, therefore stock turns into 0. Change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Go to Inventory Amount Update window and create a new one for the product.
Check that the current unit cost shown is 7.01. Enter a Unit Cost = 7.
Process it. Run costing background process.

Go to Product Window and check that the cost is 6.34, that is not correct as it should have been 7.00

Go to Transactions tab and realize that the closing inventory transaction has been valued at 7.67 and that is not correct, as it should have been valued as 7.01. There is a difference in both cases of 0.66
Revision 2015-10-21 13:41 by psanjuan
Steps To Reproduce Go to product window and create a new product named "Product Rounding 31069" for instance. Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a new purchase order of 1 unit of the product, this time change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Go to Inventory Amount Update window and create a new one for the product.
Check that the current unit cost shown is 7.01. Enter a Unit Cost = 7.
Process it. Run costing background process.

Go to Product Window and check that the cost is 6.34, that is not correct as it should have been 7.00

Go to Transactions tab and realize that the closing inventory transaction has been valued at 7.67 and that is not correct, as it should have been valued as 7.01. There is a difference in both cases of 0.66
Revision 2015-10-21 13:29 by psanjuan
Steps To Reproduce Scenario 2 - Remaining cost caused by rounding issues fixed after processing an Inventory Amount Update.

Go to product window and create a new product named "Product Rounding 31069" for instance. Go to price tab and select "Tarifa Bebidas Alegres", enter a unit/list price = 4
Create a purchase order for that product, org F&B España, of 1 unit. Book the order
Create another purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.
Create a third purchase order for that product, org F&B España, 1 unit. This time change the price to 3.00. Book the order.

Go to Goods Receipt window and create 3 different receipts, one for each order. Select the same warehouse in all the 3 for instance Warehouse = España Norte, but a different storage bin each. Complete the 3 receipts and run costing background process.

Go to product window and check that the cost of this product is 3.3333.
Check also that each shipment transaction, in the transaction tab, has been valued at a cost of 3.33

Create a new purchase order of 1 unit of the product, this time change the price to 7.00
Receipt that unit in España Norte WH in a storage bin. Complete the receipt and run costing background process.

Go to product window and check that the new average cost for the product is 7.01 while it should have been 7.00

Go to Inventory Amount Update window and create a new one for the product.
Check that the current unit cost shown is 7.01. Enter a Unit Cost = 7.
Process it. Run costing background process.

Go to Product Window and check that the cost is 6.34, that is not correct as it should have been 7.00

Go to Transactions tab and realize that the closing inventory transaction has been valued at 7.67 and that is not correct, as it should have been valued as 7.01. There is a difference in both cases of 0.66
Revision 2015-10-21 13:28 by psanjuan
Steps To Reproduce Wrong cost calculation while stocks gets into 0 due to remaining valuation


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker