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

View Revisions: Issue #30689 Back to Issue ]
Summary 0030689: Wrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice
Revision 2015-08-28 09:52 by psanjuan
Steps To Reproduce For F&B US create a product.
Product A
In lines tab enter a unit/list price = 25.00
Create a purchase order for that product and F&B US dated on today's date.
Enter 580 units. Book the order.

Go to Goods Receipt window and receipt just 80 units, on today's date + 6 days.

Once costing background process has been run cost for the transaction is calculated 2000.00 and for the product. The average cost of the product so far is 25.00.

Go to Purchase Invoice window and create a new one dated on today's date + 3 days by using "Create Lines From" function and select the receipt.

Go to lines and change the quantity to 580 and the price to 20,00.

Complete and post the invoice.

Once the costing background process and the price correction background process have been run, navigate to Product window. Search for product A and navigate to "Transaction" tab.

Realize that the goods receipt transaction of 80 units has been adjusted on 9600.00 which implies a total cost of 11600.00

Above means that the 80 units receipt have been valued at the cost of 11600/80=145, which is not correct, as correct cost should have been adjusted to 20.00








Revision 2015-08-28 09:41 by psanjuan
Description Wrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice
Revision 2015-08-28 09:41 by psanjuan
Steps To Reproduce For F&B US create a product.
Product A
In lines tab enter a unit/list price = 25.00
Create a purchase order for that product and F&B US dated on today's date.
Enter 580 units. Book the order.

Go to Goods Receipt window and receipt just 80 units, on today's date + 6 days.

Once costing background process has been run cost for the transaction is calculated 2000.00 and for the product. The average cost of the product so far is 25.00.

Go to Purchase Invoice window and create a new one dated on today's date + 3 days by using "Create Lines From" function and select the receipt.

Go to lines and change the quantity to 580 and the price to 20,00.




Revision 2015-08-27 14:31 by psanjuan
Steps To Reproduce to be included
Revision 2015-08-27 14:31 by psanjuan
Description Wrong average cost calculation in case of partial shipments


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker