"VER1.0","Articulos","Listado movimiento articulos y stock"
;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] 3
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Domicilio",10,8,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Direc",10,11,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Provincia",10,14,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Tel",10,17,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Nif",10,20,"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] 13
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 artculos", 105, 0, "ARIAL", 22, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"Codigo Art.",5,18,"ARIAL",8,0,0,"1000"
0,"Descripcion",30,18,"ARIAL",8,0,0,"1000"
0,"C. Compras",110,18,"ARIAL",8,0,0,"1000"
0,"C. Ventas",130,18,"ARIAL",8,0,0,"1000"
0,"STOCK",150,18,"ARIAL",8,0,0,"1000"
0,"Almacen",170,18,"ARIAL",8,0,0,"1000"
1,"lineaH2",5,22,200,22,,,
;0,"Familia",150,18,"ARIAL",8,0,0,"1000"
[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
[GRUP]
3,"COS", #FALSE#
; 3/11 (auditoria de listados): la consulta guardada _ConsultaMovimientosArticulos no existe en ninguna empresa y el
; listado salia vacio. Va aqui como subconsulta MV (la definicion vieja _ConsultaMovimientosArticulos1, arreglada):
; una fila por linea de albaran de venta y de compra, con el stock de ESE almacen; aqui se suman por articulo
; y almacen. La vieja unia la venta con el stock de todos los almacenes y repetia filas.
"SELECT MV.CodArticulo, First(MV.PrimeroDeDescripcion) AS PrimeroDePrimeroDeDescripcion, Sum(MV.CantidadCompras) AS SumaDeCantidadCompras, Sum(MV.Ventas) AS SumaDeVentas, Min(MV.FechaAlbaran) AS PrimeroDeFechaAlbaran, MV.CodAlmacen, MV.PrimeroDeCodFamilia, First(MV.StockActual) AS PrimeroDeStockActual"
"FROM (SELECT VenAlbaLin.CodArticulo, VenAlbaLin.Descripcion AS PrimeroDeDescripcion, 0 AS CantidadCompras, VenAlbaLin.Cantidad AS Ventas, VenAlba.FechaAlbaran, VenAlbaLin.CodAlmacen, Articulos.CodFamilia AS PrimeroDeCodFamilia, Stocks.StockActual FROM ((VenAlbaLin INNER JOIN VenAlba ON (VenAlbaLin.NumAlbaran = VenAlba.NumAlbaran) AND (VenAlbaLin.Seccion = VenAlba.Seccion) AND (VenAlbaLin.CodCliente = VenAlba.CodCliente)) INNER JOIN Articulos ON VenAlbaLin.CodArticulo = Articulos.CodArticulo) LEFT JOIN Stocks ON (VenAlbaLin.CodArticulo = Stocks.CodArticulo) AND (VenAlbaLin.CodAlmacen = Stocks.CodAlmacen) UNION ALL SELECT ComAlbaLin.CodArticulo, ComAlbaLin.Descripcion, ComAlbaLin.Cantidad, 0, ComAlba.FechaAlbaran, ComAlbaLin.CodAlmacen, Articulos.CodFamilia, Stocks.StockActual FROM ((ComAlbaLin INNER JOIN ComAlba ON (ComAlbaLin.NumAlbaran = ComAlba.NumAlbaran) AND (ComAlbaLin.Seccion = ComAlba.Seccion) AND (ComAlbaLin.CodProveedor = ComAlba.CodProveedor)) INNER JOIN Articulos ON ComAlbaLin.CodArticulo = Articulos.CodArticulo) LEFT JOIN Stocks ON (ComAlbaLin.CodArticulo = Stocks.CodArticulo) AND (ComAlbaLin.CodAlmacen = Stocks.CodAlmacen)) AS MV"
"GROUP BY MV.CodArticulo, MV.CodAlmacen, MV.PrimeroDeCodFamilia"

[CONDICIONS] 2
"FechaAlbaran", "Fecha Albaran", 0, 2
"CodArticulo","Codigo",0,1
;"Descripcion","Descripcion",0,1


[ORDENACIONS] 1
"CodArticulo","Codigo artculo",3
;"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] 6
3,"COS","CodArticulo",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","PrimeroDePrimeroDeDescripcion",30,0,"ARIAL",8,60,0,"0000",""
3,"COS","SumaDeCantidadCompras",110,0,"ARIAL",8,0,0,"0000",""
3,"COS","SumaDeVentas",130,0,"ARIAL",8,100,0,"0000",""
3,"COS","PrimeroDeStockActual",150,0,"ARIAL",8,0,1,"0000",""
3,"COS","CodAlmacen",170,0,"ARIAL",8,0,0,"0000",""
;3,"COS","PrimeroDeCodFamilia",150,0,"ARIAL",8,0,0,"0000",""
;3,"COS","PrimeroDeFechaAlbaran",180,0,"ARIAL",8,0,0,"0000",""


[FICAP]
[FIGRUP]



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

[FIDOCUM]

