http://w.cidesa.com.ve/index.php?action=history&feed=atom&title=Como_Detectar_Comprobantes_Descuadrados_en_wiki 2026-07-13T13:30:25Z Historial de revisiones para esta página en el wiki MediaWiki 1.16.2 http://w.cidesa.com.ve/index.php?title=Como_Detectar_Comprobantes_Descuadrados_en_wiki&diff=1749&oldid=prev 2008-07-10T18:01:28Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Revisión anterior</td> <td colspan='2' style="background-color: white; color:black;">Revisión de 18:01 10 jul 2008</td> </tr><tr><td colspan="2" class="diff-lineno">Línea 1:</td> <td colspan="2" class="diff-lineno">Línea 1:</td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2">&nbsp;</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''COMPROBANTES DESCUADRADOS EN EL MES DE ENERO'''</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''COMPROBANTES DESCUADRADOS EN EL MES DE ENERO'''</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td colspan="2" class="diff-lineno">Línea 15:</td> <td colspan="2" class="diff-lineno">Línea 14:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SUM(case when a.debcre='C' then A.MONASI else 0 end)::numeric</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SUM(case when a.debcre='C' then A.MONASI else 0 end)::numeric</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/pre&gt;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/pre&gt;</div></td></tr> <tr><td colspan="2">&nbsp;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">--[[Usuario:Pablosilva|Pablosilva]] 14:01 10 jul 2008 (VET)</ins></div></td></tr> </table>

Pablosilva http://w.cidesa.com.ve/index.php?title=Como_Detectar_Comprobantes_Descuadrados_en_wiki&diff=1748&oldid=prev 2008-07-10T14:32:19Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Revisión anterior</td> <td colspan='2' style="background-color: white; color:black;">Revisión de 14:32 10 jul 2008</td> </tr><tr><td colspan="2" class="diff-lineno">Línea 1:</td> <td colspan="2" class="diff-lineno">Línea 1:</td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">COMPROBANTES DESCUADRADOS EN EL MES DE ENERO</del></div></td><td colspan="2">&nbsp;</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td colspan="2">&nbsp;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">'''COMPROBANTES DESCUADRADOS EN EL MES DE ENERO'''</ins></div></td></tr> <tr><td colspan="2">&nbsp;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&nbsp;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">&lt;pre&gt;</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT &nbsp;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT &nbsp;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>A.NUMCOM,</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>A.NUMCOM,</div></td></tr> <tr><td colspan="2" class="diff-lineno">Línea 12:</td> <td colspan="2" class="diff-lineno">Línea 14:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>having SUM(case when a.debcre='D' then A.MONASI else 0 end)::numeric&lt;&gt;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>having SUM(case when a.debcre='D' then A.MONASI else 0 end)::numeric&lt;&gt;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SUM(case when a.debcre='C' then A.MONASI else 0 end)::numeric</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SUM(case when a.debcre='C' then A.MONASI else 0 end)::numeric</div></td></tr> <tr><td colspan="2">&nbsp;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">&lt;/pre&gt;</ins></div></td></tr> </table>

Pablosilva http://w.cidesa.com.ve/index.php?title=Como_Detectar_Comprobantes_Descuadrados_en_wiki&diff=1747&oldid=prev 2008-07-10T14:29:41Z

<p>New page: COMPROBANTES DESCUADRADOS EN EL MES DE ENERO SELECT A.NUMCOM, SUM(case when a.debcre=&#39;D&#39; then A.MONASI else 0 end)::numeric as TOTDEB, SUM(case when a.debcre=&#39;C&#39; then A.MONASI else 0 en...</p> <p><b>Página nueva</b></p><div>COMPROBANTES DESCUADRADOS EN EL MES DE ENERO<br /> <br /> SELECT <br /> A.NUMCOM,<br /> SUM(case when a.debcre='D' then A.MONASI else 0 end)::numeric as TOTDEB, <br /> SUM(case when a.debcre='C' then A.MONASI else 0 end)::numeric as TOTCRE <br /> FROM CONTABC1 A,CONTABC B <br /> WHERE <br /> A.NUMCOM=B.NUMCOM AND <br /> TO_CHAR(A.FECCOM,'MM')='01'<br /> GROUP BY A.NUMCOM <br /> having SUM(case when a.debcre='D' then A.MONASI else 0 end)::numeric&lt;&gt;<br /> SUM(case when a.debcre='C' then A.MONASI else 0 end)::numeric</div>

Pablosilva