"VER1.0","Articulos","Listado de Movimientos 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] 3
3,"CABECERA","NombreComercial",10,2,"ARIAL",22,0,0,"1000",""
0,"Condiciones : ",10,21,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,21,"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] 12
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, "Diferencias Stocks y Movimientos", 105, 3, "ARIAL", 18, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"Codigo",5,18,"ARIAL",10,0,0,"1000"
0,"Descripcion",35,18,"ARIAL",10,0,0,"1000"
0,"Stock",150,18,"ARIAL",10,0,1,"1000"
0,"Movimiento",175,18,"ARIAL",10,0,1,"1000"
0,"Diferencia",195,18,"ARIAL",10,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] 0
;0,"Total",170,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]
2,"CAB1", #FALSE#
"SELECT CodAlmacen & ' - ' & Descripcion as Titulo,*"
"FROM Almacenes"
""
[CONDICIONS] 1
"CodAlmacen","CodAlmacen",0,1

[ORDENACIONS] 1
"CodAlmacen","Codigo Almacn",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB1","Titulo",10,0,"ARIAL",10,0,0,"1001",""
[FICAP]

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

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT Articulos.CodArticulo, Descripcion, StockActual "
"FROM (Articulos INNER JOIN Stocks ON Stocks.CodArticulo = Articulos.CodArticulo)"
""
[CONDICIONS] 3
"Articulos.CodArticulo","Codigo",0,1
"Descripcion","Descripcion",0,1
"CodAlmacen","Almacen",1,1,"CAB1","CodAlmacen"

[ORDENACIONS] 0
;"CodArticulo","Codigo artculo",3
;"Descripcion","Descripcion",3

[CAPSALERA]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
3,"CAB2","CodArticulo",5,0,"ARIAL",10,0,0,"0000",""
3,"CAB2","Descripcion",35,0,"ARIAL",10,100,0,"0000",""
3,"CAB2","StockActual",150,0,"ARIAL",10,0,1,"0000","Cantidad"
[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
;0,"Total : ",100,0,"ARIAL",12,0,0,"1000"
;5, 0,"Total1",180,0,"ARIAL",12,0,1,"1000","Cantidad"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
;"SELECT CodArticulo, SUM(Cantidad) AS Cant "
[GRUP]
3,"COS", #FALSE#
"SELECT SUM(Cantidad) AS Cant "
"FROM _MovimientosArticulos "
""
;" GROUP BY CodArticulo"

[CONDICIONS] 3
"CodArticulo","Codigo",1,1,"CAB2","CodArticulo"
"CodAlmacen","Almacen",1,1,"CAB1","CodAlmacen"
"Fecha", "Fecha", 0, 2
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 0

[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,"COS","Cant",175,0,"ARIAL",10,0,1,"0000","Cantidad"
8, "1", "Campo('CAB2','StockActual')+(Campo('COS','Cant')*-1) ", 195, 0, "ARIAL", 10, 0, 1, "0000", "Cantidad"
;5, 0,"Total1",195,0,"ARIAL",10,0,1,"0000","Cantidad"
[FICAP]
[FIGRUP]


[CALCULS] 0
;"Total1","COS","Cant","CAB1"
[FIDOCUM]

