[List description] [Description] Text=Artículos sin moviminetos por descripción 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=02/06/2020, 20:24:10 LastModifiedByApp=TOUCHDOMINUSSCALE.EXE [1.0.0.0] LastModifiedByDLL=CMLL12.DLL [12,15,0,0 (07-08-07 09:10)] LastModifiedByUser=Carlos on WIN10-CARLOS CreatedByCallFrom=TouchDominusScale.exe [Layout] P1.Template= P2.Template= xOffset=0 yOffset=0 xSize=210000 ySize=296900 P1.xOffset=0 P1.yOffset=0 P1.xSize=210000 P1.ySize=296900 P2.xOffset=0 P2.yOffset=0 P2.xSize=210000 P2.ySize=296900 P1.nPaperFormat=9 P1.xPaperSize=210000 P1.yPaperSize=297000 P1.ForcePaperFormat=TRUE P2.nPaperFormat=9 P2.xPaperSize=210000 P2.yPaperSize=297000 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 DefaultSize.Objecttype1=(0,0,192000,10000) DefaultSize.Objecttype6=(0,0,190000,248000) DefaultSize.Objecttype8=(0,0,2000,4000) ObjectCount=8 [UserSection] BASE articu ORDEN 2 FINLST TITULO=Informe Artículos sin movimiento por Descripción * Says valores, filas y columnas TEXTOSAY=Desde el Nombre del Artículo:,Hasta:,Hasta qué fecha la última venta: FILASAY=2,3.5,5 COLUMSAY=1,1,1 TAMFIJO= * Gets valores por defecto, tipos, pictures, valids y columnas VALORDEF=space(50),"zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz",date() VALORTIPO=c,c,d VALORPICT=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX,, VALORVALID=nada,, VALORNCOL=17.5,17.5,17.5 * Valor desde-hasta y clave para comparar VDESDE=aDef[1] VHASTA=aDef[2] VCLAVE=c_descart * Filtro para el listado FILTRO=c_ufventa<=aDef[3] * ACUMULA= CONDACUM= BLOQUES=oPublic:cVLcantidad,oPublic:cVLprecio,oPublic:cVLtlinea,oPublic:cCLcantidad,oPublic:cCLprecio,oPublic:cCLtlinea,oPublic:cTLdocVto,oPublic:cLAcumula QUERY=select a.codart,a.descart,a.pvp1,a.pvp2,a.pvp3,a.pmp, a.iva, a.ivainc,s.stock , f.ufventa FROM articu a, vstockarticu s, varticupmp f WHERE a.codart=s.codart AND a.codart=f.codart AND (a.descart>='#1#' AND a.descart<='#2#') AND f.ufventa<='#3#' ORDER BY a.descart RUPTURA= ACCIONRUPTURA= NETIQUETA= [SumVariables] [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=24 LinkToID=0 LinkMode=32 LinkTest=-26579 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=11500 Position/Top=19800 Position/Width=146900 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="Listado de Artículos sin movimiento " Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=16 LinkToID=0 LinkMode=32 LinkTest=-648 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=-31850 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=-27849 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 (OMEM_PUBLICAS.fullnamelogo) Variablename= UserParameters= [Object] ObjectID=8 ObjectName=Elipse Locked=FALSE LinkID=30 LinkToID=0 LinkMode=32 LinkTest=-8554 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=8000 Position/Top=22100 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=8 LinkToID=0 LinkMode=32 LinkTest=-6812 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=12000 Position/Top=30700 Position/Width=192000 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=8.0 Width=0 Bold=False Italic=False Underline=False Strikeout=False Color=LL.Color.Black PitchAndFamily=34 OutPrecision=3 } Align=0 Adjusted=False Uneraseable=True LineWrap=1 PageWrapAllowed=False SpaceOptimization=False Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Desde el Artículo: " +OMEM_ADEF.1_Desde_el_Nombre_del_Artículo_+ " / Hasta:"+OMEM_ADEF.2_Hasta_¤ Tab=0 TabAlign=0 } [Line] { [Font] { Default=True } Align=0 Adjusted=False Uneraseable=True LineWrap=1 PageWrapAllowed=False SpaceOptimization=False Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text="Hasta el dia: "+Date$(OMEM_ADEF.3_Hasta_qué_fecha_la_última_venta_,"%x")+" ,Ordenado por Descripción" Tab=0 TabAlign=0 } } } [Object] ObjectID=6 ObjectName=Tabla Locked=FALSE LinkID=4 LinkToID=0 LinkMode=32 LinkTest=-1204 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=14000 Position/Top=41000 Position/Width=190000 Position/Height=248000 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= [GroupHeaderLines] { bConcatDataLines=True } [GroupFooterLines] { bAlsoOnEmptyGroup=False } [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=4 [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=True } OutputFormatter= Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 Condition=True Text=OMEMQUERY.codart } [Column] { Width=99000 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.descart } [Column] { Width=37000 Height=10000 bIsotropic=False PlainTextFormat=True Align=1 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=Date$(OMEMQUERY.ufventa,"%x") } [Column] { Width=15000 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=FStr$(DateToJulian(OMEM_ADEF.3_Hasta_qué_fecha_la_última_venta_)-DateToJulian(OMEMQUERY.ufventa),"---,---,---") } } [Options] { [Frame0] { SpaceOut=0 } [Frame1] { SpaceOut=0 } [Frame2] { SpaceOut=0 } [Frame3] { SpaceOut=0 } LFont=default LCondition= IgnoreEmpty=TRUE Description= DisplayInDesigner=TRUE } } } } [Header] { [Options] { } [Lines] { [Line] { LineID=0 [Columns] { Columns=4 [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="Código" } [Column] { Width=99000 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="Descripción de artículo" } [Column] { Width=37000 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="Última fecha de Venta" } [Column] { Width=15000 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="Días" } } [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= DisplayInDesigner=TRUE } } } } [Footer] { } [GroupHeader] { } [GroupFooter] { } } } } [Object] ObjectID=1 ObjectName=Texto Locked=FALSE LinkID=2 LinkToID=0 LinkMode=32 LinkTest=-16456 LayerID=0 GroupID=0 Identifier= Condition=True UserLocked=False WrapBefore=False Position/Left=173900 Position/Top=9300 Position/Width=28000 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=True Uneraseable=False LineWrap=0 PageWrapAllowed=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True Text=Atrim$("Página "+Page$()+" de "+TotalPages$()) Tab=0 TabAlign=0 } } } [UserVariables] User1=@User01;If(OMEMQUERY.ivainc="S",OMEMQUERY.pvp1/(1+(OMEMQUERY.iva/100)),OMEMQUERY.pvp1) 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=Artículos sin moviminetos por descripción } } [UsedIdentifiers] Variables=OMEM_ADEF.1_desde el nombre del artículo_;OMEM_ADEF.2_hasta_;OMEM_ADEF.3_hasta qué fecha la última venta_;OMEM_PUBLICAS.conlogo;OMEM_PUBLICAS.empresa;OMEM_PUBLICAS.fechaletras;OMEM_PUBLICAS.fullnamelogo Fields=OMEM_ADEF.3_hasta qué fecha la última venta_;OMEMQUERY.codart;OMEMQUERY.descart;OMEMQUERY.iva;OMEMQUERY.ivainc;OMEMQUERY.pvp1;OMEMQUERY.ufventa