Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037104ModulesFIFO Costing Algorithmpublic2017-10-18 14:492017-10-23 10:59
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
Summary0037104: If negative stock is allowed and a return material receipt made after a goods shipment, cost of transactions is not calculated
DescriptionIf negative stock is allowed and a return material receipt made after a goods shipment, 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
   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 goods shipment and add one unit of the product in the modified storage bin
   Create a Return From Customer for that unit and the associated Return Material Receipt
   Launch the Costing Background process and check although it finishes successfully, the cost of the two transactions is pending to be calculated

   In FIFO Stacks tab, you could check there is one record for the input transaction and another one for the output transaction
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0037106 closed Triage Omni OMS If negative stock is allowed and a goods movement cost of transactions is not calculated 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-18 14:49ngarciaNew Issue
2017-10-18 14:49ngarciaAssigned To => Triage Finance
2017-10-18 14:49ngarciaResolution time => 1510095600
2017-10-18 14:49ngarciaIssue Monitored: networkb
2017-10-18 17:02ngarciaRelationship addedrelated to 0037106
2017-10-23 10:59dmiguelezNote Added: 0099986
2017-10-23 10:59dmiguelezStatusnew => closed
2017-10-23 10:59dmiguelezResolutionopen => no change required

Notes
(0099986)
dmiguelez   
2017-10-23 10:59   
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 no incoming transaction with cost has been registered in the system for this product yet.

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.