124 lines
13 KiB
XML
124 lines
13 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<report:Report xmlns:rtl="http://www.4js.com/2004/RTL" xmlns:report="http://www.4js.com/2007/REPORT" xmlns="http://www.4js.com/2004/PXML" gstVersion="31409" version="6.00">
|
|
<report:Settings RWPageWidth="letterwidth" RWPageLength="letterlength" RWLeftMargin="1.3cm" RWTopMargin="1.3cm" RWRightMargin="1.3cm" RWBottomMargin="1.3cm">
|
|
<report:FormatList>
|
|
<report:Format-SVG/>
|
|
<report:Format-PDF/>
|
|
<report:Format-image/>
|
|
</report:FormatList>
|
|
</report:Settings>
|
|
<report:Data RWDataLocation="../cpdir/cpprrp011.rdd" RWFglReportName="cuenta_ft"/>
|
|
<report:Conflicts>
|
|
<report:Conflict nodeName="Table Row" message="Node was in trigger "OnEveryRow [0; unbounded]", but trigger was removed during schema update"/>
|
|
<report:Conflict nodeName="Separator1_2" message="Node was in trigger "Group codigo_sp [0; unbounded]", but trigger was removed during schema update"/>
|
|
<report:Conflict nodeName="MiniPage2" message="Node was in trigger "Group codigo_sp [0; unbounded]", but trigger was removed during schema update"/>
|
|
</report:Conflicts>
|
|
<rtl:stylesheet>
|
|
<PXML>
|
|
<rtl:match name="Report" nameConstraint="Report" minOccurs="1" maxOccurs="1">
|
|
<MINIPAGE name="Page Root" width="max" length="max">
|
|
<LAYOUTNODE name="Page Header" width="max" length="min" port="anyPageHeader">
|
|
<MINIPAGE name="StripeLayouter3" width="min" length="max" layoutDirection="leftToRight">
|
|
<rtl:input-variable name="p_companias.nombre" type="FGLString" expectedLocation="expectedAhead"/>
|
|
<WORDBOX name="Report Title" x="0" y="max/2" anchorX="0" anchorY="0.5" alignment="baseline" fontSize="25" baselineType="leftleft" floatingBehavior="enclosed" text="{{p_companias.nombre.trim()}}"/>
|
|
<PAGENOBOX name="PageNoBox" x="1.23857" y="max" anchorX="0" anchorY="1" alignment="baseline" baselineType="leftleft" floatingBehavior="enclosed" textAlignment="right"/>
|
|
<WORDBOX name="WordBox38" floatingBehavior="enclosed" text="cpprrp011"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="MiniPage" width="min" length="max" fontBold="true" layoutDirection="leftToRight">
|
|
<WORDBOX name="WordBox" y="8cm" floatingBehavior="enclosed" text="Sistema Cuentas Por Pagar"/>
|
|
<WORDBOX name="WordBox1" x="0.5cm" y="7cm" floatingBehavior="enclosed" text="Validacion Cuentas Afectadas Por Facturacion"/>
|
|
<rtl:input-variable name="fecha1" type="FGLString" expectedLocation="expectedAhead"/>
|
|
<rtl:input-variable name="fecha2" type="FGLString" expectedLocation="expectedAhead"/>
|
|
<WORDBOX name="WordBox2" x="1cm" y="9cm" floatingBehavior="enclosed" text="{{" Del "+fecha1+" AL "+fecha2}}"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="Table Header" class="grwTableHeader" width="min" length="max" fontSize="10" layoutDirection="leftToRight">
|
|
<WORDBOX name="Spacer" alignment="baseline" baselineType="leftleft" port="itemSeparator" text=" "/>
|
|
<WORDBOX name="WordBox3" floatingBehavior="enclosed" text="Suplidor"/>
|
|
<WORDBOX name="WordBox4" y="6.3cm" floatingBehavior="enclosed" text="Factura"/>
|
|
<WORDBOX name="WordBox5" y="8.4cm" floatingBehavior="enclosed" text="Fecha"/>
|
|
<WORDBOX name="WordBox6" y="10cm" floatingBehavior="enclosed" text="Valor Fact."/>
|
|
<WORDBOX name="WordBox7" y="12cm" floatingBehavior="enclosed" text="Cuenta"/>
|
|
<WORDBOX name="WordBox8" y="14cm" floatingBehavior="enclosed" text="Dpto."/>
|
|
<WORDBOX name="WordBox9" y="16cm" floatingBehavior="enclosed" text="Debe"/>
|
|
<WORDBOX name="WordBox10" y="18cm" alignment="center" floatingBehavior="enclosed" text="Haber"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="Separator" width="1" length="max" bgColor="#000000" layoutDirection="leftToRight"/>
|
|
</LAYOUTNODE>
|
|
<rtl:match name="Group codigo_sp" nameConstraint="Group" minOccurs="0" maxOccurs="unbounded">
|
|
<rtl:match name="Group factura" nameConstraint="Group" minOccurs="0" maxOccurs="unbounded">
|
|
<rtl:match name="OnEveryRow" nameConstraint="OnEveryRow" minOccurs="0" maxOccurs="unbounded">
|
|
<MINIPAGE name="Table Row" class="grwTableRow" width="min" length="max" fontSize="8" layoutDirection="leftToRight">
|
|
<WORDBOX name="Spacer_1" alignment="baseline" baselineType="leftleft" port="itemSeparator" text=" "/>
|
|
<rtl:input-variable name="codigo_sp" type="FGLString" expectedLocation="expectedHere"/>
|
|
<rtl:input-variable name="x.nom_sp" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="nombreCliente" width="width("M")*26" alignment="baseline" floatingBehavior="enclosed" text="{{codigo_sp+" "+x.nom_sp.trim()}}"/>
|
|
<rtl:input-variable name="x.factura" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox12" y="6.6cm" width="1.1cm" floatingBehavior="enclosed" text="{{x.factura.trim()}}"/>
|
|
<rtl:input-variable name="x.fecha" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox13" y="8.7cm" width="1.5cm" floatingBehavior="enclosed" text="{{x.fecha.trim()}}"/>
|
|
<rtl:input-variable name="x.valor_fac" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox14" y="10.2cm" width="1.5cm" floatingBehavior="enclosed" textAlignment="right" text="{{x.valor_fac.format("#,###,###.##")}}"/>
|
|
<rtl:input-variable name="x.cuenta_no" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox15" y="11.7cm" width="1.5cm" baselineType="rightright" floatingBehavior="enclosed" textAlignment="right" text="{{x.cuenta_no.trim()}}"/>
|
|
<rtl:input-variable name="x.departamento" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox16" y="14cm" width="1cm" floatingBehavior="enclosed" text="{{x.departamento.format("####")}}"/>
|
|
<rtl:input-variable name="x.debito" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox17" y="15cm" width="2cm" floatingBehavior="enclosed" textAlignment="right" text="{{x.debito.format("###,###,###.##")}}"/>
|
|
<rtl:input-variable name="x.credito" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox18" y="17cm" width="2cm" floatingBehavior="enclosed" textAlignment="right" text="{{x.credito.format("###,###,###.##")}}"/>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
<MINIPAGE name="MiniPage2_1" width="min" length="min" layoutDirection="leftToRight">
|
|
<rtl:input-variable name="total_d" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox45" y="15cm" width="2cm" alignment="baseline" fontSize="8" floatingBehavior="enclosed" text="{{total_d.format("###,###,###.##")}}"/>
|
|
<rtl:input-variable name="total_c" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox46" y="17cm" width="2cm" alignment="baseline" fontSize="8" floatingBehavior="enclosed" text="{{total_c.format("###,###,###.##")}}"/>
|
|
<WORDBOX name="WordBox47" fontBold="true" floatingBehavior="enclosed" text="TOTAL POR FACTURA"/>
|
|
<MINIPAGE name="Separator1_3" width="1" length="max" bgColor="#000000" layoutDirection="leftToRight"/>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
<MINIPAGE name="Separator1_2" width="1" length="max" bgColor="#000000" layoutDirection="leftToRight"/>
|
|
<MINIPAGE name="MiniPage2" width="min" length="min" layoutDirection="leftToRight">
|
|
<rtl:input-variable name="total_sp_d" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox39" y="15cm" width="2cm" alignment="baseline" fontSize="8" floatingBehavior="enclosed" text="{{total_sp_d.format("###,###,###.##")}}"/>
|
|
<rtl:input-variable name="total_sp_c" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox40" y="17cm" width="2cm" alignment="baseline" fontSize="8" floatingBehavior="enclosed" text="{{total_sp_c.format("###,###,###.##")}}"/>
|
|
<WORDBOX name="WordBox41" fontBold="true" floatingBehavior="enclosed" text="TOTAL POR SUPLIDOR"/>
|
|
<MINIPAGE name="Separator1_1" width="1" length="max" bgColor="#000000" layoutDirection="leftToRight"/>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
<rtl:match name="OnLastRow" nameConstraint="OnLastRow" minOccurs="0" maxOccurs="1">
|
|
<rtl:match name="Foreach" nameConstraint="Foreach" minOccurs="1" maxOccurs="1">
|
|
<MINIPAGE name="Separator2" width="1" length="max" bgColor="#000000" layoutDirection="leftToRight"/>
|
|
<MINIPAGE name="MiniPage1" width="min" length="min" layoutDirection="leftToRight">
|
|
<WORDBOX name="WordBox34" fontBold="true" floatingBehavior="enclosed" text="{{"TOTAL DEBITO Y CREDITO "}}"/>
|
|
<rtl:input-variable name="t_debito" type="FGLNumeric" expectedLocation="expectedWayAhead"/>
|
|
<WORDBOX name="WordBox35" y="15cm" width="2cm" alignment="baseline" fontSize="8" floatingBehavior="enclosed" textAlignment="right" text="{{t_debito.format("###,###,###.##")}}"/>
|
|
<rtl:input-variable name="t_credito" type="FGLNumeric" expectedLocation="expectedWayAhead"/>
|
|
<WORDBOX name="WordBox36" y="17cm" width="2cm" fontSize="8" floatingBehavior="enclosed" textAlignment="right" text="{{t_credito.format("###,###,###.##")}}"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="Separator1" width="1" length="max" bgColor="#000000" layoutDirection="leftToRight"/>
|
|
<WORDBOX name="WordBox33" fontSize="12" fontBold="true" floatingBehavior="enclosed" text="Cuentas"/>
|
|
<rtl:match name="ForeachItem" nameConstraint="ForeachItem" minOccurs="0" maxOccurs="unbounded">
|
|
<MINIPAGE name="Table Row1" class="grwTableRow" width="min" length="max" fontSize="8" layoutDirection="leftToRight">
|
|
<WORDBOX name="Spacer_2" alignment="baseline" baselineType="leftleft" port="itemSeparator" text=" "/>
|
|
<rtl:input-variable name="reg_final.cuenta_no" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox27" width="2cm" floatingBehavior="enclosed" text="{{reg_final.cuenta_no.trim()}}"/>
|
|
<rtl:input-variable name="reg_final.departamento" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox28" width="1.5cm" alignment="baseline" floatingBehavior="enclosed" text="{{reg_final.departamento.format("##")}}"/>
|
|
<rtl:input-variable name="reg_final.num_doc" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox30" width="1.5cm" baselineType="rightright" floatingBehavior="enclosed" textAlignment="right" text="{{reg_final.num_doc.trim()}}"/>
|
|
<rtl:input-variable name="reg_final.debito" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox31" floatingBehavior="enclosed" text="{{reg_final.debito.format("###,###,###.##")}}"/>
|
|
<rtl:input-variable name="reg_final.credito" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<WORDBOX name="WordBox32" floatingBehavior="enclosed" textAlignment="right" text="{{reg_final.credito.format("###,###,###.##")}}"/>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
</rtl:match>
|
|
</rtl:match>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
</PXML>
|
|
</rtl:stylesheet>
|
|
</report:Report>
|