"VER1.0","Albaranes","Listado de Albaranes Mes"
;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)
;0,"Fecha",10,18,"ARIAL",8,0,0,"1000"
;0,"Asiento",40,18,"ARIAL",8,0,1,"1000"
[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, "Descuadre de asientos", 105, 7, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"Apunte",10,18,"ARIAL",8,0,0,"1000"
0,"Cuenta",40,18,"ARIAL",8,0,1,"1000"
0,"Titulo",50,18,"ARIAL",8,0,0,"1000"
0,"Descripcin",100,18,"ARIAL",8,0,0,"1000"
0,"Debe",180,18,"ARIAL",8,0,1,"1000"
0,"Haber",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] 0
;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
;"SELECT FechaAsiento & ' - Asiento ' & Asiento AS Titulo, Apuntes.FechaAsiento, Apuntes.Asiento, Apuntes.Seccion, Apuntes.Divisa, Apuntes.Cambio, Sum(Apuntes.CantidadD) AS SumaDeCantidadD, Sum(Apuntes.CantidadH) AS SumaDeCantidadH, [SumaDeCantidadD]-[SumaDeCantidadH] AS Descuadre "
;"FROM Apuntes "
;"GROUP BY Apuntes.FechaAsiento, Apuntes.Asiento, Apuntes.Seccion, Apuntes.Divisa, Apuntes.Cambio HAVING (((Sum([Apuntes].[CantidadD])-Sum([Apuntes].[CantidadH]))<>0)) "
[GRUP]
2,"CAB1", #FALSE#
"SELECT FechaAsiento & ' - Asiento ' & Asiento AS Titulo, Apuntes.FechaAsiento, Apuntes.Asiento, Apuntes.Seccion, Sum(Apuntes.CantidadD) AS SumaDeCantidadD, Sum(Apuntes.CantidadH) AS SumaDeCantidadH, [SumaDeCantidadD]-[SumaDeCantidadH] AS Descuadre "
"FROM Apuntes "
"GROUP BY Apuntes.FechaAsiento, Apuntes.Asiento, Apuntes.Seccion HAVING (((Sum([Apuntes].[CantidadD])-Sum([Apuntes].[CantidadH]))<>0)) "

[CONDICIONS] 2
"FechaAsiento","Fecha",0,2
"Seccion","Seccion",0,1

[ORDENACIONS] 0
;"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] 1
3, "CAB1", "Titulo", 10,0,"ARIAL",11,0,0,"1001","Mmmm \del yyyy"
[FICAP]

[PEU]
0, 15, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
1, "lineaH3",145,0,200,0,,,
0, "Total ",100,0,"ARIAL",10,0,0,"1000"
0, "Descuadre",100,8,"ARIAL",10,0,0,"1000"
5, 0, "TotalDebe", 180, 0,"ARIAL",8,0,1,"0000","Total"
5, 0, "TotalHaber", 200, 0,"ARIAL",8,0,1,"0000","Total"
5, 0, "TotalCuadre", 200, 8,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
;, SUM(CantidadD) AS TotalD, SUM(CantidadH) as TotalH 
[GRUP]
3,"COS", #FALSE#
"SELECT Apuntes.*, Titulo, CantidadD-CantidadH as Cuadre "
"FROM Apuntes LEFT JOIN SubCuentas ON SubCuentas.CodCuenta = Apuntes.CodCuenta"
""
[CONDICIONS] 3
"Asiento", "Asiento", 1, 0, "CAB1", "Asiento"
"Seccion", "Seccion", 1, 1, "CAB1", "Seccion"
"FechaAsiento", "FechaAsiento", 1, 2, "CAB1", "FechaAsiento"

[ORDENACIONS] 1
"Apunte","Apunte",0

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;5, 6, "TD", 34,0,"ARIAL",8,115,1,"0000",""
;3, "COS", "FechaAsiento", 10,0,"ARIAL",8,0,0,"0000",""
;3, "COS", "Asiento", 40,0,"ARIAL",8,115,1,"0000",""
[CAMPS] 6
3, "COS", "Apunte", 14,0,"ARIAL",8,0,1,"0000",""
3, "COS", "CodCuenta", 40,0,"ARIAL",8,0,1,"0000",""
3, "COS", "Titulo", 45,0,"ARIAL",8,0,0,"0000",""
3, "COS", "Descripcion", 100,0,"ARIAL",8,0,0,"0000",""
3, "COS", "CantidadD", 180,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "CantidadH", 200,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 3
"TotalDebe","COS","CantidadD","CAB1"
"TotalHaber","COS","CantidadH","CAB1"
"TotalCuadre","COS","Cuadre","CAB1"
[FIDOCUM]





