"VER1.0","Albaranes","Listado de Facturas"
;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,8,"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]

[CONDICIONS] 1
"@PAG", "Nmero Pagina :", 9, "", ""

[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 16
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, "Facturas con gastos", 95, 3, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,265,17,,,
0,"NOrden",17,18,"ARIAL",8,0,1,"1000"
0,"Fecha",25,18,"ARIAL",8,0,0,"1000"
0,"N Fac.",45,18,"ARIAL",8,0,0,"1000"
0,"Nombre",70,18,"ARIAL",8,0,0,"1000"
0,"Base Imp.",139,18,"ARIAL",8,0,1,"1000"
0,"IVA",150,18,"ARIAL",8,0,1,"1000"
0,"IRPF",162,18,"ARIAL",8,0,1,"1000"
0,"Cta.Gasto",190,18,"ARIAL",8,0,1,"0000"
0,"Total",175,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,265,22,,,
;0,"I%",149,18,"ARIAL",8,0,1,"1000"
;0,"NIF",139,18,"ARIAL",8,0,0,"1000"
;0,"IRPF",235,18,"ARIAL",8,0,1,"1000"
;0,"RE",215,18,"ARIAL",8,0,1,"1000"
;0,"%RE",155,18,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 5
0,"Totales:",5,2,"ARIAL",8,0,0,"1000"
5,0,"TBI", 135,2,"ARIAL",8,0,1,"1000","Total"
5,0,"TIVA", 150,2,"ARIAL",8,0,1,"1000","Total"
5,0,"T",185,2,"ARIAL",9,0,1,"1000","Total"
5,0,"TTIRPF", 165,2,"ARIAL",8,0,1,"1000","Total"
;5,0,"TRE", 219,2,"ARIAL",8,0,1,"1000","Total"

[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
;"SELECT *, BaseImponible + iif(Iva is null,0,Iva)+iif(Re is null,0,Re) as TotalL "
[GRUP]
3,"COS", #FALSE#
; 3/11 (auditoria de listados): la consulta guardada gastosfacturas no existe en ninguna empresa (ningun .dbq
; la crea y su definicion no se ha conservado), asi que el listado salia vacio. Se rehace aqui: una fila por
; cada apunte de gasto (cuenta 6 o mayor) del asiento de cada factura de compra. Base = el importe de ese
; apunte; IVA, IRPF y Total = los de la factura repartidos en proporcion a esa base, para que una factura
; cargada a dos cuentas de gasto sume su IVA y su total una sola vez.
"SELECT F.NOrden, F.FechaFactura, F.NumFactura, F.NombreFiscal, F.Seccion, F.CodProveedor, F.FechaAsiento, Apuntes.CodCuenta, SubCuentas.Titulo, CCur(Apuntes.CantidadD - Apuntes.CantidadH) AS BaseImponible, CCur((Apuntes.CantidadD - Apuntes.CantidadH) * F.IvaF / IIF(F.BaseF = 0, 1, F.BaseF)) AS IVA, CCur((Apuntes.CantidadD - Apuntes.CantidadH) * F.IrpfF / IIF(F.BaseF = 0, 1, F.BaseF)) AS TIRPF, CCur((Apuntes.CantidadD - Apuntes.CantidadH) * F.TotalF / IIF(F.BaseF = 0, 1, F.BaseF)) AS Total"
"FROM ((SELECT NOrden, FechaFactura, NumFactura, NombreFiscal, Seccion, CodProveedor, FechaAsiento, Asiento, Nz(BaseImponible1,0) + Nz(BaseImponible2,0) + Nz(BaseImponible3,0) AS BaseF, Nz(TIva1,0) + Nz(TIva2,0) + Nz(TIva3,0) AS IvaF, Nz(TIRPF,0) AS IrpfF, Nz(Total,0) AS TotalF FROM ComFacturas) AS F INNER JOIN Apuntes ON (F.FechaAsiento = Apuntes.FechaAsiento) AND (F.Asiento = Apuntes.Asiento)) LEFT JOIN SubCuentas ON Apuntes.CodCuenta = SubCuentas.CodCuenta"
""

[CONDICIONS] 7
"F.Seccion","Seccin",0,1
"F.CodProveedor","Cdigo Proveedor",0,1,-10
"F.NOrden","Numero de Orden",0,0
"F.FechaFactura","Fecha Natural",0,2
"F.FechaAsiento","Fecha Contable",0,2
"Apuntes.CodCuenta","Cdigo Gasto Contable",0,1,-10
" ((Apuntes.CodCuenta)>='6000000000') ","",4

[ORDENACIONS] 2
" VAL(Apuntes.CodCuenta) ","Codigo de Cuenta",3
" VAL(F.NOrden) ","Numero de Orden",3




[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
3, "COS", "NOrden", 17,0,"ARIAL",8,0,1,"0000",""
3, "COS", "FechaFactura", 25,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NumFactura", 45,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NombreFiscal", 70,0,"ARIAL",8,58,0,"0000",""
3, "COS", "BaseImponible", 137,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "IVA", 150,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Titulo", 180,0,"ARIAL",8,0,0,"0000",""
3, "COS", "TIRPF", 162,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Total", 175,0,"ARIAL",8,0,1,"0000","Total"
;3, "COS", "Nif", 139,0,"ARIAL",8,0,0,"0000",""
;3, "COS", "IVAP", 149,0,"ARIAL",8,0,1,"0000",""
;3, "COS", "ReP", 205,0,"ARIAL",8,0,1,"0000",""
;3, "COS", "Re", 219,0,"ARIAL",8,0,1,"0000","Total"
;3, "COS", "TIRPF", 235,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 5
"TBI","COS","BaseImponible","GENERAL"
"TIVA","COS","Iva","GENERAL"
"TRE","COS","Re","GENERAL"
"TTIRPF","COS","TIRPF","GENERAL"
"T","COS","Total","GENERAL"

[FIDOCUM]




