DynamicsGP 2018 Reporte: Kardex de inventario
Reporte Kardex de inventario, el movimiento que tiene un ítem dentó de empresa (Transferencias, ventas, devoluciones, ingresos, ajustes). Parámetros: Nombre del ítem Lugar del moviente SELECT DISTINCT a1.TRXSORCE, a1.DOCNUMBR, CAST(a1.DOCDATE AS DATE) as DOCDATE , a1.DOCTYPE, CASE WHEN a1.DOCTYPE=1 THEN 'Ajustes' ELSE CASE WHEN a1.DOCTYPE=2 THEN 'Varianza' ELSE CASE WHEN a1.DOCTYPE=3 THEN 'Transferencia' ELSE CASE WHEN a1.DOCTYPE=4 THEN 'Recibido' ELSE CASE WHEN a1.DOCTYPE=5 THEN 'Devoluciones' ELSE CASE WHEN a1.DOCTYPE=6 THEN 'Ventas' ELSE CASE WHEN a1.DOCTYPE=7 THEN 'Ensamblaje' END END END END END END END AS DOCTYPEDes, TRIM(a3.ITEMDESC) as ITEMDESC, TRIM(a3.ITMSHNAM) as ITMSHNAM, TRIM(a1.ITEMNMBR) as ITEMNMBR, a1.UOFM, a5.cantIngTrans, a5.cantEgreTrans, a1.UNITCOST,a7.UNITPRCE, a1.EXTDCOST, TRIM(a1.TRXLOCTN) as TRXLOCTN, TRIM(a1.TRNSTLOC) as TRNSTLOC, a1.DE
