View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001470 | Módulo 2Reports | [All Projects] Evolución | public | 2021-05-13 09:49 | 2021-05-13 09:49 |
| Reporter | fmarcet | Assigned To | fmarcet | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Product Version | |||||
| Target Version | next | Fixed in Version | |||
| Summary | 0001470: INFORME DE PRODUCTOS FABRICADOS | ||||
| Description | A sugerencia de Federico García Patiño: SELECT mo.ref mo_ref, p.ref product_ref, e.ref warehouse_ref, prod.qty, pl.batch, pl.eatby, prod.date_creation FROM llx_mrp_production prod inner join llx_mrp_mo mo on mo.rowid = prod.fk_mo inner join llx_entrepot e on e.rowid = prod.fk_warehouse inner join llx_product p on p.rowid = prod.fk_product left join llx_product_lot pl on pl.fk_product = p.rowid and pl.batch = prod.batch WHERE prod.role = 'produced'; | ||||
| Tags | No tags attached. | ||||
