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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0030689
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2015-08-27 14:312015-08-28 09:52
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Omni WMS 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0030689: Wrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice

DescriptionWrong average cost calculation in case of partial shipments whenever all quantity is included in the invoice
Steps To ReproduceFor 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








Proposed SolutionRegardless 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-08-27 14:31 psanjuan New Issue
2015-08-27 14:31 psanjuan Assigned To => Triage Finance
2015-08-27 14:31 psanjuan Modules => Core
2015-08-27 14:31 psanjuan Triggers an Emergency Pack => No
2015-08-28 09:41 psanjuan Summary Wrong 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:41 psanjuan Description Updated View Revisions
2015-08-28 09:41 psanjuan Steps to Reproduce Updated View Revisions
2015-08-28 09:52 psanjuan Steps to Reproduce Updated View Revisions
2015-08-28 09:52 psanjuan Proposed Solution updated


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker