"VER1.0","Articulos","Listado de articulos"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 0
0,0,0,0

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

;-----------------------------------------

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 15
0,"Pgina :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
0, "Rentabilidad por Artculos", 105, 7, "ARIAL",20, 0, 2, "1000"
1,"lineaH1",5,17,195,17,,,
0,"Codigo",5,18,"ARIAL",8,0,0,"1000"
0,"Descripcion",25,18,"ARIAL",8,0,0,"1000"
0,"PreCM",120,18,"ARIAL",8,0,1,"1000"
0,"T.Coste",135,18,"ARIAL",8,0,1,"1000"
0,"PreVM",150,18,"ARIAL",8,0,1,"1000"
0,"T.Venta",165,18,"ARIAL",8,0,1,"1000"
0,"Unidades.",180,18,"ARIAL",8,0,1,"1000"
0,"%Ren.",195,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,195,22,,,
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
5,0,"TotCo",135,0,"ARIAL", 8,0,1,"1000","Total"
5,0,"TotVe",165,0,"ARIAL", 8,0,1,"1000","Total"
0,"Rentabilidad Global", 130,5,"ARIAL",10,0,0,"1001"
8, "1", "DIV((CALCULO('TotVe')+CALCULO('TotCo')*-1)*100,CALCULO('TotVe'))", 195, 5, "ARIAL",8,0,1,"1001","##0.00;; "
[FIPEU]

[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodArticulo, Descripcion, PrecioCosteMedio "
"FROM Articulos"
""
[ORDENACIONS] 2
"CodArticulo", "Codigo Articulo", 3
"Descripcion", "Descripcin", 3

[CONDICIONS] 2
"CodArticulo", "Cod. Articulo", 0, 1
"Descripcion", "Descripcin", 0, 1

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
3,"CAB1","CodArticulo",5,0,"ARIAL",8,0,0,"0000",""
3,"CAB1","Descripcion",25,0,"ARIAL",8,0,0,"0000",""
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]
[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT FIRST(Articulos.CodArticulo) AS CodArticulo, FIRST(Articulos.Descripcion) AS Descripcion, FIRST(Articulos.PrecioCosteMedio) AS PrecioCosteMedio,
Sum(Cantidad) AS SCantidad, Sum(VenAlbaLin.Total) AS STotal, STotal/SCantidad AS PVM,  PrecioCosteMedio*SCantidad AS TCM"
"FROM Articulos LEFT JOIN
 (VenAlbaLin LEFT JOIN VenAlba ON (VenAlbaLin.CodCliente = VenAlba.CodCliente) AND (VenAlbaLin.NumAlbaran = VenAlba.NumAlbaran) AND (VenAlbaLin.Seccion = VenAlba.Seccion)) ON VenAlbaLin.CodArticulo = Articulos.CodArticulo"
""

[CONDICIONS] 3
"Articulos.CodArticulo","Codigo de Articulo",1,1,"CAB1","CodArticulo"
"FechaAlbaran","Fecha Albarn",0,2
"VenAlbaLin.Seccion","Seccin",0,1

[ORDENACIONS] 0

[CAPSALERA]
-5, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
;8, "1", "Campo('COS','STotal')/Campo('COS','SCantidad')", 135, 0, "ARIAL",9,0,1,"0000","Total"
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3,"CAB1","PrecioCosteMedio",120,0,"ARIAL",8,0,1,"0000","##0.00;; "
8, "1", "Campo('CAB1','PrecioCosteMedio')*Campo('COS','SCantidad')", 135, 0, "ARIAL",8,0,1,"0000","Total"
3,"COS","PVM",150,0,"ARIAL",8,0,1,"0000","##0.00;; "
3,"COS","STotal",165,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","SCantidad",180,0,"ARIAL",8,0,1,"0000","Cantidad"
8, "1", "DIV((Campo('COS','PVM')+Campo('CAB1','PrecioCosteMedio')*-1)*100,Campo('COS','PVM')*ABS(Campo('COS','PVM')<>0))", 195, 0, "ARIAL",8,0,1,"0000","##0.00;; "
[FICAP]
[FIGRUP]

[CALCULS] 2
"TotVe","COS","STotal","GENERAL"
"TotCo","COS","TCM","GENERAL"

[FIDOCUM]





