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...
