Modificar el Informe de Cierre de Caja

GoogleCodeExporter commented 8 years ago

Es necesario modificar el reporte de cierre de caja para que sea mas legible 
para el cliente y un poco mas similar a lo que se acostumbra en Colombia.

Original issue reported on code.google.com by javier.p...@setsoftware.net on 27 Sep 2013 at 4:14

GoogleCodeExporter commented 8 years ago

[deleted comment]

GoogleCodeExporter commented 8 years ago

Se modifico el reporte y la consulta del mismo el reporte se agrego una nueva 
categoria que los separa lo que es efectivo y de lo que no es efectivo se 
afecto el archivo 
reports.com.openbravo.reports.closepos.bs
reports.com.openbravo.reports.clospos.jrxml

SELECT 
                    CLOSEDCASH.HOST, 
                    CLOSEDCASH.HOSTSEQUENCE, 
                    CLOSEDCASH.MONEY, 
                    CLOSEDCASH.DATESTART, 
                    CLOSEDCASH.DATEEND,
                    PAYMENTS.PAYMENT, 
                    (SELECT IF(PAYMENTS.PAYMENT= 'debtpaid', SUM(-PAYMENTS.TOTAL), SUM(PAYMENTS.TOTAL))) AS TOTAL, 
                    (SELECT MIN( TICKETID ) FROM  `tickets` WHERE  `TICKETTYPE` =0 AND DUEDATE >= CLOSEDCASH.DATESTART AND DUEDATE <= CLOSEDCASH.DATEEND) AS MINFRA, 
                    (SELECT MAX( TICKETID ) FROM  `tickets` WHERE  `TICKETTYPE` =0 AND DUEDATE >= CLOSEDCASH.DATESTART AND DUEDATE <= CLOSEDCASH.DATEEND) AS MAXFRA, 
                    (SELECT MIN( TICKETID ) FROM  `tickets` WHERE  `TICKETTYPE` =1 AND DUEDATE >= CLOSEDCASH.DATESTART AND DUEDATE <= CLOSEDCASH.DATEEND) AS MINNFRA, 
                    (SELECT MAX( TICKETID ) FROM  `tickets` WHERE  `TICKETTYPE` =1 AND DUEDATE >= CLOSEDCASH.DATESTART AND DUEDATE <= CLOSEDCASH.DATEEND) AS MAXNFRA,
                    (SELECT IF((PAYMENTS.PAYMENT ='paperin' OR PAYMENTS.PAYMENT ='magcard' OR PAYMENTS.PAYMENT ='free' OR PAYMENTS.PAYMENT ='debt' OR PAYMENTS.PAYMENT ='cheque'  ), 0, 1)) as TYPEPAYMENT
                    FROM CLOSEDCASH, PAYMENTS, RECEIPTS
                    WHERE CLOSEDCASH.MONEY = RECEIPTS.MONEY AND PAYMENTS.RECEIPT = RECEIPTS.ID
                    GROUP BY CLOSEDCASH.HOST, CLOSEDCASH.HOSTSEQUENCE, CLOSEDCASH.MONEY, CLOSEDCASH.DATESTART, CLOSEDCASH.DATEEND, PAYMENTS.PAYMENT
                    ORDER BY CLOSEDCASH.HOST, CLOSEDCASH.HOSTSEQUENCE;

Original comment by sopor...@setsoftware.net on 17 Oct 2013 at 10:03

Attachments:

chafarleston / setpos

Modificar el Informe de Cierre de Caja #3