"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] 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)
[CAMPS] 16
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, "Bienes de Inversion", 95, 7, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"N Fac.",5,18,"ARIAL",8,0,0,"1000"
0,"Cliente",23,18,"ARIAL",8,0,0,"1000"
0,"Fecha",96,18,"ARIAL",8,0,1,"1000"
0,"NIF",99,18,"ARIAL",8,0,0,"1000"
0,"Base Imp.",135,18,"ARIAL",8,0,1,"1000"
0,"%IVA %RE",150,18,"ARIAL",8,0,1,"1000"
0,"IVA",165,18,"ARIAL",8,0,1,"1000"
0,"RE",180,18,"ARIAL",8,0,1,"1000"
0,"Total",200,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,200,22,,,
;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,0,"ARIAL",8,0,0,"1000"
5,0,"TBI", 135,0,"ARIAL",8,0,1,"1000","Total"
5,0,"TIVA", 165,0,"ARIAL",8,0,1,"1000","Total"
5,0,"TRE", 180,0,"ARIAL",8,0,1,"1000","Total"
5,0,"T",200,10,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
" SELECT *, BaseImponible + iif(Iva is null,0,Iva)+iif(re is null,0,re) as TotalL "
; 3/11 (auditoria de listados): la consulta guardada _DiarioIvasCompras no existe en ninguna empresa; va aqui
; como subconsulta (la misma que el Diario de IVA de compras). Solo las facturas cuyo asiento toca una
; cuenta 20 a 22 (inmovilizado), por la condicion fija de abajo.
" FROM (SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodProveedor, NIF, FechaAsiento, Asiento, NOrden, TIRPF AS IrpfFactura, TIRPF, BaseImponible1 AS BaseImponible, Iva1 AS IvaP, TIva1 AS Iva, RE1 AS ReP, TRE1 AS Re, Total FROM ComFacturas WHERE BaseImponible1 <> 0 OR TIva1 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodProveedor, NIF, FechaAsiento, Asiento, NOrden, TIRPF, 0, BaseImponible2, Iva2, TIva2, RE2, TRE2, 0 FROM ComFacturas WHERE BaseImponible2 <> 0 OR TIva2 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodProveedor, NIF, FechaAsiento, Asiento, NOrden, TIRPF, 0, BaseImponible3, Iva3, TIva3, RE3, TRE3, 0 FROM ComFacturas WHERE BaseImponible3 <> 0 OR TIva3 <> 0) AS DIC INNER JOIN Apuntes ON (DIC.FechaAsiento = Apuntes.FechaAsiento) AND (DIC.Asiento = Apuntes.Asiento)"
""

[CONDICIONS] 3
"Apuntes.Seccion","Seccin",0,1
"DIC.FechaFactura","Fecha",0,2
" Apuntes.CodCuenta>='2000000000' AND Apuntes.CodCuenta<='2299999999' ","",4


[ORDENACIONS] 1
"DIC.FechaFactura, DIC.NumFactura","Fecha Factura",3
;"FechaFactura","Fecha",3



[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 10
3, "COS", "NumFactura", 5,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NombreFiscal", 23,0,"ARIAL",8,85,0,"0000",""
3, "COS", "FechaFactura", 96,0,"ARIAL",8,115,1,"0000",""
3, "COS", "Nif", 99,0,"ARIAL",8,115,0,"0000",""
3, "COS", "BaseImponible", 135,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "IVAP", 140,0,"ARIAL",8,0,1,"0000",""
3, "COS", "REP", 145,0,"ARIAL",8,0,1,"0000",""
3, "COS", "IVA", 165,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "RE", 180,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "TotalL", 200,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 4
"TBI","COS","BaseImponible","GENERAL"
"TIVA","COS","Iva","GENERAL"
"TRE","COS","RE","GENERAL"
"T","COS","TotalL","GENERAL"

[FIDOCUM]




