View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001581 | Módulo 2Reports | [All Projects] Bug | public | 2022-05-12 18:06 | 2022-06-27 18:15 |
| Reporter | jmenent | Assigned To | hpuig | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Product Version | 15.0.0 | ||||
| Target Version | 16.0.0 | Fixed in Version | 16.0.0 | ||
| Summary | 0001581: Informe alertas Stock no saca productos con stock 0 | ||||
| Description | Solucion: cambiar la consulta SQL por: SELECT p.ref ref, e.ref almacen, p.seuil_stock_alerte alerta_stock, IF(w.reel, w.reel, 0) stock, e.rowid rowid, p.rowid prodid FROM llx_product p LEFT JOIN llx_product_stock w ON w.fk_product = p.rowid LEFT JOIN llx_entrepot e ON w.fk_entrepot = e.rowid WHERE 1 = 1 AND p.entity=1 AND (p.seuil_stock_alerte>w.reel OR (w.reel is null AND p.seuil_stock_alerte > 0)) ORDER BY p.ref ASC; | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-05-12 18:06 | jmenent | New Issue | |
| 2022-05-12 18:06 | jmenent | Status | new => assigned |
| 2022-05-12 18:06 | jmenent | Assigned To | => hpuig |
| 2022-05-26 13:11 | hpuig | Description Updated | View Revisions |
| 2022-05-26 17:14 | hpuig | Status | assigned => resolved |
| 2022-05-26 17:14 | hpuig | Fixed in Version | => next |
| 2022-06-27 18:15 | hpuig | Fixed in Version | next => 16.0.0 |
| 2022-06-27 18:15 | hpuig | Target Version | next => 16.0.0 |
