Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037106ModulesFIFO Costing Algorithmpublic2017-10-18 17:022017-10-23 10:58
Reporterngarcia 
Assigned ToTriage Omni OMS 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0037106: If negative stock is allowed and a goods movement cost of transactions is not calculated
DescriptionIf negative stock is allowed and a goods movement cost of transactions is not calculated
Steps To ReproduceAs group admin role:
   Validate a new costing rule for F&B US, Inc. with FIFO Costing Algorithm. Do not select Warehouse Dimension
   Create a new product and add a purchase price list to it
   Change the Inventory Status to Undefined-Overissue for a storage bin of US West coast warehouse (in order to accept negative stock)
   Create a physical inventory and add 3 units of the product in the East Coast warehouse (Movement date: today)
   Create a Goods Shipment with 1 unit of the product from West Coast warehouse (Movement date: today+2)
   Create a Goods Movement of 3 units from east coast to west coast (Movement Date: today+1)
   Launch the Costing Background process and check although it finishes successfully, the cost of the two movement transactions is pending to be calculated
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0037104 closed Triage Omni OMS If negative stock is allowed and a return material receipt made after a goods shipment, cost of transactions is not calculated 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-18 17:02ngarciaNew Issue
2017-10-18 17:02ngarciaAssigned To => Triage Finance
2017-10-18 17:02ngarciaRelationship addedrelated to 0037104
2017-10-18 17:03ngarciaIssue Monitored: networkb
2017-10-23 10:58dmiguelezNote Added: 0099985
2017-10-23 10:58dmiguelezStatusnew => closed
2017-10-23 10:58dmiguelezResolutionopen => no change required

Notes
(0099985)
dmiguelez   
2017-10-23 10:58   
This is not an Issue, FIFO is working as expected.

The problem here is that there is no cost to be assigned to the output transactions yet.

When an incoming transaction with cost is created in the system, FIFO stores it's cost in the stack.
When an outgoing transaction is created in the system, FIFO calculates it's cost based on the cost stored in the stack.

In this scenario, there is not enough cost to be assigned to all the transactions (due to the temporal negative stock)
This happens because goods movements are dependant on the cost of other incoming transactions.

As soon as any incoming transaction with cost is registered in the system, the goods movement's cost will be calculated and this situation will be solved.