Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Version: 10 Community
module: stock_account
model: stock.history (report)
Tried:
<filter name="positive" string="Positive" domain="[('inventory_value', '>', 0.0)]"/>but inventory_value is calculated field and cannot use it in filter
<filter name="positive" string="Positive" domain="[('quantity', '>', 0.0)]"/>is wrong because it needs to be the SUM of quantity > 0
domain="[('qty', '>', 0.0)]"
Just update domain with Qty instead of value. Cost won't be negative. If the qty is negative then you will get inventory value negative.If so there is default filter named possitive
well I tried this already but it is wrong because the quantity is the sum of all the quantities from all the moves belonging to the product (sum of all negative and positive quants). So this filter will remove the negatives and so the resulting quantity will be wrong. As I said you need the SUM of the qty to be > 0
Please note that this is about "Inventory at Date" report and not the "Inventory valuation" where you have predefined Positive and Negative filters but the data is pulled in a different way so "qty>0" works there
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
May 24
|
9520 | ||
|
0
Sep 24
|
121 | ||
|
2
Sep 24
|
178 | ||
|
2
Jun 24
|
3022 | ||
|
0
May 23
|
1042 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Give store=True for the field and see