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 | — |
Related models
Res Currency
Res Company
Stock Picking
Res Partner
Stock Location
Product Product
Uom Uom
Purchase Order
Stock Quant
Repair Order
Sale Order
Stock Valuation Layer
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