Cambiar los pagos del cliente en el reporte

[GoogleCodeExporter]

que los pago de los clientes no se refleje en forma negativa en el reporte

Original issue reported on code.google.com by sopor...@setsoftware.net on 11 Oct 2013 at 6:51

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Nota: los mismos archivos del issues 3 

Se modifica la consulta del reporte para no modifcar el cliente y se cambia el 
valor cuando es un pago de cliente entra en positivo y cuando es un pago de 
proveedor se cambia a negativo

reports.com.openbravo.reports.closepos.bs
reports.com.openbravo.reports.clospos.jrxml

la consulta se modifica las consulta tanto del reporte y del codigo.

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:14

Attachments:

• closedpos.bs
• closedpos.jrxml