[List description] [Description] Text=Facturas Pendientes de Pagos por Proveedor FileVersion=7 Units=SCM-Units Metric=0 TextQuote.Start=1 TextQuote.End=1 RepresentationCode.CondStart=171 RepresentationCode.CondSep=166 RepresentationCode.CondEnd=187 RepresentationCode.Tab=247 RepresentationCode.Ret=182 RepresentationCode.PhantomSpace=2 RepresentationCode.LockNextChar=3 RepresentationCode.ExprSep=164 LCID=10 Created=08/01/2000, 05:08:03 CreatedByApp=PRU.EXE [] CreatedByDLL=CMBTL6.DLL [6.075] CreatedByUser= LastModified=17/06/08, 10:08:16 LastModifiedByApp=DOMINUSTPV.EXE [1.0.0.0] LastModifiedByDLL=CMLL12.DLL [12,6,0,0 (06-12-20 15:10)] LastModifiedByUser=Propietario on TECNICO1 CreatedByCallFrom=DominusTPV.exe [Layout] P1.Template= P2.Template= xOffset=0 yOffset=0 xSize=210100 ySize=296900 P1.xOffset=0 P1.yOffset=0 P1.xSize=210100 P1.ySize=296900 P2.xOffset=0 P2.yOffset=0 P2.xSize=210100 P2.ySize=296900 P1.nPaperFormat=9 P1.xPaperSize=210000 P1.yPaperSize=296900 P1.ForcePaperFormat=TRUE P2.nPaperFormat=9 P2.xPaperSize=210000 P2.yPaperSize=296900 P2.ForcePaperFormat=TRUE xGrid=1000 yGrid=1000 GridShow=TRUE GridSnap=TRUE PhysicalPage=TRUE P1.PhysicalPage=TRUE P2.PhysicalPage=TRUE Orientation=1 P1.Orientation=1 P2.Orientation=1 EnhancedExpressions=TRUE EnhancedOldExpressions=FALSE Decimals=2 DefFont={(0,0,0),8.000000,-13,0,0,0,400,0,0,0,0,3,2,1,34,Arial} HelpLines.Horizontal= HelpLines.Vertical= PDF.MaxOutlineDepth=2 ObjectCount=8 [UserSection] BASE vtopago ORDEN 1 RELACIONA provee POR CAMPO c_codigop RELACIONA facpro POR CAMPO c_codigop+c_nfacpr FINLST TITULO=Facturas Pendientes de Pagos por Proveedor * Says valores, filas y columnas TEXTOSAY=Desde Proveedor:,Hasta:,Desde Fecha Vto.:,Hasta:,Desde Serie:,Hasta:,¿Incluir Fta. Pagadas?: FILASAY=2,2,3,3,4,4,5 COLUMSAY=6,19,6,19,3,19,3 TAMFIJO=5 * Gets valores por defecto, tipos, pictures, valids y columnas VALORDEF=Space(9),"zzzzzzzzz",dPrimerdia(date()),date(),Space(2),"zz","S" VALORTIPO=c,c,d,d,c,c,c VALORPICT=XXXXXXXXX,,,,,,@! VALORVALID=nada,,,,,,siono, VALORNCOL=15,28,15,28,15,28,15 * Valor desde-hasta y clave para comparar VDESDE=aDef[1]+Space(10)+str(0,1) VHASTA=aDef[2]+Replicate("z",10)+str(9,1) VCLAVE=c_codigop+c_nfacpr+str(c_nvto,1) * Filtro para el listado FILTRO=if((aDef[5]="S".or.aDef[5]="S"),c_fvto>=aDef[3].and.c_fvto<=aDef[4],c_fvto>=aDef[3].and.c_fvto<=aDef[4].and.c_ptsvto-c_ptspagad#0) * ACUMULA= CONDACUM= RESUMEN= BLOQUES=oPublic:cVLcantidad,oPublic:cVLprecio,oPublic:cVLtlinea,oPublic:cCLcantidad,oPublic:cCLprecio,oPublic:cCLtlinea,oPublic:cTLdocVto,oPublic:cLAcumula QUERY=SELECT a.ffacpr,b.seriefac,b.numfac,a.codigop,a.rsocialp, a.tfacpro, b.ptscobra, b.ptspend FROM (SELECT tipodoc, seriefac, numfac, SUM(ptspend) AS ptspend, SUM(ptscobra) AS ptscobra FROM vencimientos WHERE (seriefac>='#5#' AND seriefac<='#6#') AND (CASE WHEN '#7#'='N' AND ptspend=0 THEN false ELSE true END ) GROUP BY tipodoc, seriefac, numfac) AS b, facpro a LEFT JOIN provee c ON( a.codigop=c.codigop) WHERE a.tipodoc='EC' AND a.tipodoc || a.seriefac || a.numfac = b.tipodoc || b.seriefac || b.numfac AND (a.codigop>='#1#' AND a.codigop<='#2#') AND (a.ffacpr>='#3#' AND a.ffacpr<='#4#') ORDER BY a.codigop, a.ffacpr RUPTURA= ACCIONRUPTURA= [SumVariables] Sum1=@Suma01;F;OMEMQUERY.ptspend Sum2=@Suma02;F;OMEMQUERY.tfacpro [Layer] Name=Base Condition= WorkspaceColor=(0,0,0) Visible=TRUE LayerID=0 [Layer] Name=Imprimir Líneas Condition= WorkspaceColor=(0,128,64) Visible=TRUE LayerID=1 [Layer] Name=Following Pages Condition=Page() <> 1 WorkspaceColor=(0,0,255) Visible=TRUE LayerID=2 [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=3 LinkToID=0 LinkMode=32 LinkTest=-31365 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=169600 Position/Top=9300 Position/Width=29000 Position/Height=5700 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=2 Adjusted=False Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Hoja Nº:"+Fstr$(Page(),"####") Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=24 LinkToID=0 LinkMode=32 LinkTest=-862 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=11500 Position/Top=28000 Position/Width=155500 Position/Height=8000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=20.0 Width=0 Bold=False Italic=True Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=True LineWrap=0 PageWrapAllowed=False SpaceOptimization=False Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Facturas Pendientes de Pago por Proveedor" Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=16 LinkToID=0 LinkMode=32 LinkTest=-22460 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=10000 Position/Top=9000 Position/Width=70000 Position/Height=6000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text=OMEM_PUBLICAS.FechaLetras Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=19 LinkToID=0 LinkMode=32 LinkTest=-23757 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=98000 Position/Top=9000 Position/Width=51000 Position/Height=6000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Empresa: " + OMEM_PUBLICAS.Empresa Tab=0 TabAlign=0 } } } [Object] ObjectID=5 ObjectName=Dibujo Locked=FALSE LinkID=22 LinkToID=0 LinkMode=32 LinkTest=-25304 LayerID=0 GroupID=0 Identifier= Condition=OMEM_PUBLICAS.Conlogo="S" UserLocked=False WrapBefore=False Position/Left=170000 Position/Top=17000 Position/Width=30000 Position/Height=20000 Direction=0 Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bIsotropic=True Mode=1 Filename= bRelPath=False Formula=Drawing(Left$(ProjectPath$(),1)+":\dominus\configur\"+OMEM_PUBLICAS.Nomlogo) Variablename= UserParameters= [Object] ObjectID=8 ObjectName=Elipse Locked=FALSE LinkID=30 LinkToID=0 LinkMode=32 LinkTest=-22375 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=8000 Position/Top=30000 Position/Width=2000 Position/Height=4000 Direction=0 bFrame=1 FgColor=RGB(0,0,0) Width=0 LineType=0 bFill=1 Raster=1 BkColor=RGB(255,0,0) BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 bForceCircle=True [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=1 LinkToID=0 LinkMode=32 LinkTest=-785 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=12000 Position/Top=38000 Position/Width=188000 Position/Height=10000 Direction=0 bFill=0 BkColor=RGB(255,255,255) Frame/Layout=0 Frame/Left/Line=False Frame/Top/Line=False Frame/Right/Line=False Frame/Bottom/Line=False bPageWrap=False bBottomAligned=False [@Lines] { [Lines] { [Line] { [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=6.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=False LineWrap=1 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Desde Proveedor: "+OMEM_ADEF.1_Desde_Proveedor_+" / "+OMEM_ADEF.2_Hasta_+" ¤ ,Desde Fecha: "+Date$(OMEM_ADEF.3_Desde_Fecha_Vto._,"%x")+" - " + Date$(OMEM_ADEF.4_Hasta_,"%x")+¤" ,¿Incluir Fras. Pagadas?: "+OMEM_ADEF.7__incluir_fta._pagadas__ Tab=0 TabAlign=0 } } } [Object] ObjectID=6 ObjectName=Tabla Locked=FALSE LinkID=5 LinkToID=0 LinkMode=32 LinkTest=-27629 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=10000 Position/Top=47000 Position/Width=191000 Position/Height=212000 Direction=0 bFooterOnBottom=False bFillBottom=False DefaultFont=default FgColor=RGB(0,0,0) bFill=False Raster=1 BkColor=RGB(255,255,255) BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 [@Tables] { [Tables] { [Table] { TableType=List TableID= RelationID= Identifier= [GroupHeaderLines] { bConcatDataLines=True } [GroupFooterLines] { bAlsoOnEmptyGroup=True } [DataLines] { bKeepTogether=True bSuppress=False bForceSumCalculation=False } ZebraPattern=0 [ZebraPattern] { Pattern=6 Color=LL.Color.Black Color2=LL.Color.White Color3=LL.Color.White Color.Alpha=50 } [FooterLines] { bKeepTogether=True } PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Body] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=7 [Column] { Width=28000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=7.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=Date$(OMEMQUERY.ffacpr,"%x") } [Column] { Width=15000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=OMEMQUERY.seriefac +" /"+ FStr$(OMEMQUERY.numfac,"######") } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=If(OMEMQUERY.tfacpro==0,"",FStr$(OMEMQUERY.tfacpro,OMEM_PICTURES.cTLdocvto)) } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=If(OMEMQUERY.ptscobra==0,"",FStr$(OMEMQUERY.ptscobra,OMEM_PICTURES.cTLdocvto)) } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=If(OMEMQUERY.ptspend==0,"",FStr$(OMEMQUERY.ptspend,OMEM_PICTURES.cLAcumula)) } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=If(@Suma02==0,"",FStr$(@Suma02,OMEM_PICTURES.cLAcumula)) } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=If(@Suma01==0,"",FStr$(@Suma01,OMEM_PICTURES.cLAcumula)) } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=10000 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),7.000000,-12,0,0,0,400,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Definición de línea 1 DisplayInDesigner=TRUE } } } } [Header] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=7 [Column] { Width=28000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Fec.Fra." } [Column] { Width=15000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Se/Nº Fra." } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Total Fra." } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Pagado" } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Pendiente" } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Acumulado" } [Column] { Width=27000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Pen Proveedor" } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=10000 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),8.000000,-13,0,0,0,700,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Definición de línea 1 DisplayInDesigner=TRUE } } } } [Footer] { } [GroupHeader] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=1 [Column] { Width=100000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=9.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Proveedor: "+OMEMQUERY.codigop+" "+OMEMQUERY.rsocialp } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=0 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),8.000000,-13,0,0,0,700,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Definición de línea 1 ResetSums=@Sum03; OnNewPage=False PrintRightAfterHeader=True GroupCondition=OMEMQUERY.codigop DisplayInDesigner=TRUE } } } } [GroupFooter] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=9 [Column] { Width=3000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=4000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=6000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=2000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=2000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=12000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="" } [Column] { Width=45000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=9.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text="Total Pendiente Proveedor: " } [Column] { Width=74000 Height=10000 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=9.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=OMEMQUERY.codigop+" "+OMEMQUERY.rsocialp } [Column] { Width=43000 Height=10000 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=-10000 VAlign=0 Adjusted=False LineWrap=0 bFill=False Raster=0 BkColor=LL.Color.Black BkColor2=LL.Color.White BkColor3=LL.Color.White BkColor.Alpha=50 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False [Frame] { Default=False Layout=1 [Left] { Spacing=1000 Line=False } [Top] { Spacing=500 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=500 Line=False } } [Font] { Default=False FaceName="Arial" GdiCharSet=0 Size=10.0 Width=0 Bold=True Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=If(@Suma01==0,"",FStr$(@Suma01,OMEM_PICTURES.cLAcumula)) } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=0 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont={(0,0,0),8.000000,-13,0,0,0,700,0,0,0,0,3,2,1,34,Arial} LCondition= IgnoreEmpty=TRUE Description=Definición de línea 1 ResetSums=@Sum01;@Sum03;@Suma01;@Suma02; TriggerNewPage=False GroupCondition=OMEMQUERY.codigop DisplayInDesigner=TRUE } } } } } } } [UserVariables] User1=@User01; User2=@User02; User3=@User03; User4=@User04; User5=@User05; User6=@User06; User7=@User07; User8=@User08; User9=@User09; User10=@User10; User11=@User11; User12=@User12; User13=@User13; User14=@User14; User15=@User15; User16=@User16; User17=@User17; User18=@User18; User19=@User19; User20=@User20; User21=@User21; User22=@User22; User23=@User23; User24=@User24; User25=@User25; User26=@User26; User27=@User27; User28=@User28; User29=@User29; User30=@User30; User31=@User31; User32=@User32; User33=@User33; User34=@User34; User35=@User35; User36=@User36; User37=@User37; User38=@User38; User39=@User39; User40=@User40; User41=@User41; User42=@User42; User43=@User43; User44=@User44; User45=@User45; User46=@User46; User47=@User47; User48=@User48; User49=@User49; User50=@User50; [Parameters] [@Parameters] { [Parameters] { LL.ProjectDescription=Facturas Pendientes de Pagos por Proveedor } } [UsedIdentifiers] Variables=OMEM_ADEF.1_desde proveedor_;OMEM_ADEF.2_hasta_;OMEM_ADEF.3_desde fecha vto._;OMEM_ADEF.4_hasta_;OMEM_ADEF.7_¿incluir fta. pagadas?_;OMEM_PUBLICAS.conlogo;OMEM_PUBLICAS.empresa;OMEM_PUBLICAS.fechaletras;OMEM_PUBLICAS.nomlogo Fields=OMEM_PICTURES.clacumula;OMEM_PICTURES.ctldocvto;OMEMQUERY.codigop;OMEMQUERY.ffacpr;OMEMQUERY.numfac;OMEMQUERY.ptscobra;OMEMQUERY.ptspend;OMEMQUERY.rsocialp;OMEMQUERY.seriefac;OMEMQUERY.tfacpro