Closed VicenteCool closed 4 years ago
se tendria que cuadrar las oitw
revisar en que sucursales paso, y replicar existencias
DEVOLUCION NO CUADRA CANTIDAD CON KARDEX.xlsx select t0.U_SO1_FOLIO, t2.U_SO1_FECHA, t2.U_SO1_VERSIONR1, sum(t0.U_SO1_CANTIDAD) as Dev, sum(t1.U_SO1_CANTIDADENTRAD) as Inv from "@SO1_01DEVOLUCIONDET" t0 inner join "@SO1_01DEVOLUCION" t2 on t0.U_SO1_FOLIO=t2.Name inner join "@SO1_01MOVINVENTARIO" t1 on t0.U_SO1_FOLIO=t1.Name and t0.U_SO1_NUMEROARTICULO=t1.U_SO1_NUMEROARTICULO where t0.U_SO1_AFECTAINVETARI='Y' group by t0.U_SO1_FOLIO, t2.U_SO1_FECHA, t2.U_SO1_VERSIONR1 having sum(t0.U_SO1_CANTIDAD) <> sum(t1.U_SO1_CANTIDADENTRAD) order by t2.U_SO1_FECHA
U_SO1_FOLIO | U_SO1_FECHA | U_SO1_VERSIONR1 | Dev | Inv |
---|---|---|---|---|
005056DE4529 | 00:00.0 | 3.10.0.47 | 1 | 2 |
009070DE4288 | 00:00.0 | 3.10.0.47 | 1 | 2 |
018136DE148 | 00:00.0 | 3.10.0.47 | 3 | 4 |
015114DE4119 | 00:00.0 | 3.10.0.49 | 1 | 2 |
005057DE4640 | 00:00.0 | 3.10.0.56 | 1 | 2 |
004052DE10676 | 00:00.0 | 3.10.0.58 | 1 | 2 |
007068DE9780 | 00:00.0 | 3.10.0.58 | 2 | 4 |
012092DE5078 | 00:00.0 | 3.10.0.58 | 1 | 2 |
015113DE4294 | 00:00.0 | 3.10.0.58 | 1 | 2 |
005057DE4745 | 00:00.0 | 3.10.0.60 | 2 | 4 |
006062DE5494 | 00:00.0 | 3.10.0.60 | 3 | 7 |
013100DE1978 | 00:00.0 | 3.10.0.60 | 1 | 2 |
003045DE21880 | 00:00.0 | 3.10.0.61 | 1 | 2 |
009074DE4722 | 00:00.0 | 3.10.0.62 | 1 | 2 |
012092DE5342 | 00:00.0 | 3.10.0.62 | 2 | 3 |
018136DE314 | 00:00.0 | 3.10.0.62 | 1 | 2 |
015113DE4600 | 00:00.0 | 3.10.0.65 | 2 | 6 |
014102DE3523 | 00:00.0 | 3.10.0.67 | 11 | 12 |
003045DE22569 | 00:00.0 | 3.10.0.70 | 1 | 2 |
013100DE2177 | 00:00.0 | 3.10.0.70 | 1 | 2 |
015114DE4825 | 00:00.0 | 3.10.0.70 | 1 | 2 |
011082DE1458 | 00:00.0 | 3.5.0.28 | 4 | 0 |
012088DE1296 | 00:00.0 | 3.5.0.28 | 4 | 3 |
011082DE1618 | 00:00.0 | 3.5.0.53 | 3 | 0 |