Openbravo Issue Tracking System - Modules
View Issue Details
0030840ModulesValued Stock Enhancedpublic2015-09-16 17:012015-09-16 17:03
dmiguelez 
Triage Omni OMS 
normalmajoralways
newopen 
20Community Appliance
 
 
0030840: Show records with 0 Stock in Enhanced Valued Stock Report
In Enhanced Valued Stock Report, by default, if a Product has no Stock in a Warehouse, no information about it is shown.

But, it is possible that, due to some operations, even if the Stock is 0, it can have some Stock Valuation value there, and it would be interesting to give the user the option to see it.

For example, if there is a Legal Entity A, with two Warehouses below it, 1 and 2 and the Warehouse Rule applied to A does not differentiate between Warehouses.
It can happen that we introduce Stock in Warehouse 1 with an Average Cost of, for example, 10€.
Then, some other operations are performed against Warehouse 2 that modifies the Average Cost to 5€.
If at that point we remove Stock from Warehouse 1, it will be removed valued at 5€ in average, so the Stock will be 0 but the valuation will be >0

This scenario matches with accounting data, but is not possible to identify in this report until we have the ability to show 0 Stock records.
In Enhanced Valued Stock Report, by default, if a Product has no Stock in a Warehouse, no information about it is shown.

But, it is possible that, due to some operations, even if the Stock is 0, it can have some Stock Valuation value there, and it would be interesting to give the user the option to see it.

For example, if there is a Legal Entity A, with two Warehouses below it, 1 and 2 and the Warehouse Rule applied to A does not differentiate between Warehouses.
It can happen that we introduce Stock in Warehouse 1 with an Average Cost of, for example, 10€.
Then, some other operations are performed against Warehouse 2 that modifies the Average Cost to 5€.
If at that point we remove Stock from Warehouse 1, it will be removed valued at 5€ in average, so the Stock will be 0 but the valuation will be >0

This scenario matches with accounting data, but is not possible to identify in this report until we have the ability to show 0 Stock records.
No tags attached.
png Screenshot from 2015-09-16 13:22:04.png (117,079) 2015-09-16 17:03
https://issues.openbravo.com/file_download.php?file_id=8449&type=bug
png
Issue History
2015-09-16 17:01dmiguelezNew Issue
2015-09-16 17:01dmiguelezAssigned To => Triage Finance
2015-09-16 17:03dmiguelezNote Added: 0080435
2015-09-16 17:03dmiguelezFile Added: Screenshot from 2015-09-16 13:22:04.png

Notes
(0080435)
dmiguelez   
2015-09-16 17:03   
There is an screenshot attached of what it would look like with F&B data