Odoo model ·
stock.lot
Stock Lot
Everything the Oddll AI Brain can read and reason about on your stock.lot records — safely, and only what the signed-in user is allowed to see.
Library / Stock Lot
Part of:
Products Expiration Date
Purchase Stock
Quality
Repairs
Sales and Warehouse Management
Inventory
WMS Accounting
Questions about Stock Lot
- How many Stock Lot records are there?
- Show the most recent Stock Lot records
- How many Stock Lot records were created this month?
- Break down Stock Lot records by month
- What is the total Avg Cost on Stock Lot this month?
- Which Stock Lot records have the highest Avg Cost?
- Break down Stock Lot records by Currency
- Which Currency has the most Stock Lot records?
- Break down Stock Lot records by Company
- Which Company has the most Stock Lot records?
- How many Stock Lot records are marked Display Complete?
- Break down Stock Lot records by Partner
- Which Partner has the most Stock Lot records?
- Break down Stock Lot records by Location
- Which Location has the most Stock Lot records?
- How many Stock Lot records are marked Product Expiry Alert?
- How many Stock Lot records are marked Product Expiry Reminded?
- Break down Stock Lot records by Product
- Which Product has the most Stock Lot records?
- Break down Stock Lot records by Uom
- Which Uom has the most Stock Lot records?
- What is the total Standard Price on Stock Lot this month?
- Which Stock Lot records have the highest Standard Price?
- What is the total Total Value on Stock Lot this month?
- Which Stock Lot records have the highest Total Value?
- How many Stock Lot records are marked Use Expiration Date?
Fields on this model
| Field | Type | Relates to |
|---|---|---|
alert_date |
datetime | — |
avg_cost |
monetary | — |
company_currency_id |
many2one |
res.currency
|
company_id |
many2one |
res.company
|
delivery_count |
integer | — |
delivery_ids |
many2many |
stock.picking
|
display_complete |
boolean | — |
expiration_date |
datetime | — |
in_repair_count |
integer | — |
last_delivery_partner_id |
many2one |
res.partner
|
location_id |
many2one |
stock.location
|
lot_properties |
properties | — |
name |
char | — |
note |
html | — |
product_expiry_alert |
boolean | — |
product_expiry_reminded |
boolean | — |
product_id |
many2one |
product.product
|
product_qty |
float | — |
product_uom_id |
many2one |
uom.uom
|
purchase_order_count |
integer | — |
purchase_order_ids |
many2many |
purchase.order
|
quality_alert_qty |
integer | — |
quality_check_qty |
integer | — |
quant_ids |
one2many |
stock.quant
|
quantity_svl |
float | — |
ref |
char | — |
removal_date |
datetime | — |
repair_line_ids |
many2many |
repair.order
|
repair_part_count |
integer | — |
repaired_count |
integer | — |
sale_order_count |
integer | — |
sale_order_ids |
many2many |
sale.order
|
standard_price |
float | — |
stock_valuation_layer_ids |
one2many |
stock.valuation.layer
|
total_value |
monetary | — |
use_date |
datetime | — |
use_expiration_date |
boolean | — |
value_svl |
float | — |
Ask it in your own Odoo
The answer comes from your database — private, permission-checked, and audited. Oddll AI Brain never stores your business data.
Get Odoo + AI tips