Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0030689Openbravo ERP04. Warehouse managementpublic2015-08-27 14:312015-08-28 09:52
psanjuan 
Triage Omni WMS 
urgentmajoralways
newopen 
20Ubuntu 8.04.1
 
 
Core
No
0030689: Wrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice
Wrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice
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








Regardless all units have been invoiced at final price, only some units have been received, therefore units received are the ones to take into account in the cost adjustment.
No tags attached.
Issue History
2015-08-27 14:31psanjuanNew Issue
2015-08-27 14:31psanjuanAssigned To => Triage Finance
2015-08-27 14:31psanjuanModules => Core
2015-08-27 14:31psanjuanTriggers an Emergency Pack => No
2015-08-28 09:41psanjuanSummaryWrong average cost calculation in case of partial shipments => Wrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice
2015-08-28 09:41psanjuanDescription Updatedbug_revision_view_page.php?rev_id=9282#r9282
2015-08-28 09:41psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9284#r9284
2015-08-28 09:52psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9285#r9285
2015-08-28 09:52psanjuanProposed Solution updated

There are no notes attached to this issue.