"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] 4
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,20,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"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] 14
0,"Pgina :",170,0,"ARIAL",8,0,0,"1000"
6,"Pagina",200,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",170,5,"ARIAL",8,0,0,"1000"
6,"Fecha",200,5,"ARIAL",8,0,1,"1000",""
0, "Listado de inventario + cartera albaranes", 100, 3, "ARIAL", 12, 0, 2, "1000"
1, "lineaH1", 5, 17, 200, 17,,,
0,"Codigo",5,18,"ARIAL",8,0,0,"1000"
0,"Descripcion",35,18,"ARIAL",8,0,0,"1000"
0,"Permanente",140,18,"ARIAL",8,0,1,"1000"
0,"Cartera",155,18,"ARIAL",8,0,1,"1000"
0,"Stock",170,18,"ARIAL",8,0,1,"1000"
0,"P.Unidad",185,18,"ARIAL",8,0,1,"1000"
0,"Importe",200,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 5, 22, 200, 22,,,
[FICAP]

[PEU]
0, 25, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total",160,0,"ARIAL",12,0,1,"1000"
5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
;" FROM (Stocks INNER JOIN Articulos ON Stocks.CodArticulo = Articulos.CodArticulo) INNER JOIN (VenAlba INNER JOIN VenAlbaLin ON (VenAlba.Seccion = VenAlbaLin.Seccion) AND (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran) AND (VenAlba.CodCliente = VenAlbaLin.CodCliente)) ON Stocks.CodArticulo = VenAlbaLin.CodArticulo "
[GRUP]
3,"COS", #FALSE#
" SELECT Articulos.PrecioCoste, Articulos.CodArticulo, Articulos.Descripcion, first(Stocks.StockActual) AS TotalStock, Sum(VenAlbaLin.Cantidad) AS Totalalbaranes , totalStock + totalalbaranes as Suma, PrecioCoste*Suma as Importe "
" FROM (Stocks INNER JOIN Articulos ON Stocks.CodArticulo = Articulos.CodArticulo) LEFT JOIN (VenAlbaLin LEFT JOIN VenAlba ON (VenAlba.Seccion = VenAlbaLin.Seccion) AND (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran) AND (VenAlba.CodCliente = VenAlbaLin.CodCliente)) ON Stocks.CodArticulo = VenAlbaLin.CodArticulo "
" GROUP BY Articulos.CodArticulo, Articulos.Descripcion, Articulos.PrecioCoste "

[CONDICIONS] 4
"Articulos.CodArticulo","Codigo",0,1
; 3/11 (auditoria de listados): campo cualificado; sin la tabla, Access no sabe de cual de las del FROM es y la consulta fallaba al filtrar.
"Articulos.Descripcion","Descripcion",0,1
" (Stocks.CodAlmacen IN ('1','01')) ","",4
" (Facturado = false )  ","",4
;"Facturado", "Facurado(S/N)",0,5
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"
;"Stocks.CodAlmacen","Cod Almacen",0,1

[ORDENACIONS] 2
"Articulos.CodArticulo","Codigo artculo",3
"Articulos.Descripcion","Descripcion",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
3,"COS","CodArticulo",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",35,0,"ARIAL",8,100,0,"0000",""
3,"COS","TotalStock",140,0,"ARIAL",8,100,1,"0000",""
3,"COS","TotalAlbaranes",155,0,"ARIAL",8,100,1,"0000",""
3,"COS","Suma",170,0,"ARIAL",8,100,1,"0000",""
3,"COS","PrecioCoste",185,0,"ARIAL",8,100,1,"0000",""
3,"COS","Importe",200,0,"ARIAL",8,100,1,"0000",""
[FICAP]
[FIGRUP]

[CALCULS] 1
"Total","COS","PrecioCoste","GENERAL"

[FIDOCUM]



