"VER1.0","Factura","Facturas de Proveedores (moderno)"
;Versio, Categoria, Descripcion


;Ampla, Llarg, [EspaiCos]
;MargenX, ,MargenY, EtiLin, EtiPag
[DOCUM]
 0, 0, 62
 0, 0, 0, 0
;-----------------------------------------


;Tipo, NomGrup, Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT *, CodigoPostal & ' - ' & Poblacion as Pueblo, Provincia & ' ' & Pais as  ProvPais"
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 14
2, "Anagrama.png", 8, 6, 60, 17
0, "FACTURA RECIBIDA", 8, 26, "ARIAL BLACK", 12, 0, 0, "0000"
3, "CABECERA", "NombreFiscal", 120, 5, "ARIAL", 10, 1, 0, "1000", ""
3, "CABECERA", "Domicilio", 120, 10, "ARIAL", 8, 0, 0, "0000", ""
0, "Tel. ", 120, 14, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Telefono1", 127,14, "ARIAL", 8, 0, 0, "0000", ""
0, "FAX. ", 150, 14, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Fax", 157, 14, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 120, 18, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 120, 22, "ARIAL", 8, 0, 0,"0000", ""
3, "CABECERA", "E-Mail", 120, 26, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Web", 120, 30, "ARIAL", 8, 0, 0,"0000", ""
0, "C.I.F. / N.I.F. :", 8, 32, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Nif", 30, 32, "ARIAL", 8, 0, 0, "0000", ""
[FICAP]

; En Impresos recomendable crear con valor PrintAll a True
[PEU]
0, 7, #TRUE#, 2, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3, "CABECERA", "RegistroMercantil", 100, 0, "ARIAL", 6, 0,2, "0000", ""
[FIPEU]
[FIGRUP]

;-----------------------------------------
;Tipo, NomGrup, Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""

;[ordenaciones] y [condiciones]

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 27
1, "lineaCab", 5, 34, 200, 34,,,
1, "CuadroAdreca", 113, 37, 200, 75, 1, 0,
0, "DATOS DEL PROVEEDOR", 116, 39, "ARIAL", 8, 1, 0, "0000"
1, "CuadroFact", 6, 37, 102, 58, 1, 0,
0, "DATOS DE LA FACTURA", 9, 39, "ARIAL", 8, 1, 0, "0000"
0,"Fecha",10,46,"ARIAL",9,0,0,"1000"
0,"Nº Factura",45,46,"ARIAL",9,0,0,"1000"
0,"C.I.F./N.I.F.",75,46,"ARIAL",9,0,0,"1000"
1, "CuadroOtros", 6, 59, 102, 75, 1, 0,
0, "REPRESENTANTE / CONTACTO", 9, 61, "ARIAL", 8, 1, 0, "0000"
0,"Representante",10,66,"ARIAL",9,0,0,"1000"
0,"Contacto",10,71,"ARIAL",9,0,0,"1000"
1, "CuadroCos", 0, 78, 200, -64, 1, 0,
1, "lineaH", 0, 84, 200, 84,,,
1, "lineaV", 182, 78, 182, -64,,,
1, "lineaV", 175, 78, 175, -64,,,
1, "lineaV", 165, 78, 165, -64,,,
1, "lineaV", 151, 78, 151, -64,,,
1, "lineaV", 137, 78, 137, -64,,,
1, "lineaV", 29, 78, 29, -64,,,
0,"Código",5,79,"ARIAL",8,1,0,"0000"
0,"Descripción",30,79,"ARIAL",8,1,0,"0000"
0,"Cantidad",150,79,"ARIAL",8,1,1,"0000"
0,"Precio",163,79,"ARIAL",8,1,1,"0000"
0,"Dto",173,79,"ARIAL",8,1,1,"0000"
0,"Iva",180,79,"ARIAL",8,1,1,"0000"
0,"Total",199,79,"ARIAL",8,1,1,"0000"
[FICAP]

[PEU]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
; release245: este pie ya no dibuja nada -- las 16 etiquetas y cajas que llevaba
; (Importe Bruto, TOTAL, Desglose de I.V.A./R.E., Base, %IVA...) se han movido al
; pie de "CAB 1" de más abajo, junto a los importes reales que representan. Ver
; el mismo comentario en FacCliDiv.txt y "Decisiones importantes", release245.
[FIPEU]

[FIGRUP]


;-----------------------------------------
[GRUP]
2,"CAB 1", #TRUE#
"SELECT ComFacturas.*, CodigoPostal & ' - ' & Poblacion AS Pueblo, ComFacturas.Provincia & ' - ' & ComFacturas.Pais AS Ciudad, Monedas.Decimales, Proveedores.*, Representantes.*, ComFacturas.Descuento1 AS Descuentos, ModoPago.Observaciones, ModoPago.Descripcion AS DescripcionPago, Nz(ComFacturas.TIva1,0)+Nz(ComFacturas.TIva2,0)+Nz(ComFacturas.TIva3,0) AS ImporteIvaTotal, Nz(ComFacturas.TRE1,0)+Nz(ComFacturas.TRE2,0)+Nz(ComFacturas.TRE3,0) AS ImporteReTotal"
"FROM (((ComFacturas LEFT JOIN Monedas ON ComFacturas.CodMoneda = Monedas.CodMoneda) LEFT JOIN Proveedores ON ComFacturas.CodProveedor = Proveedores.CodProveedor) LEFT JOIN Representantes ON Proveedores.CodRepresentante = Representantes.CodRepresentante) LEFT JOIN ModoPago ON ModoPago.CodPago = ComFacturas.CodFormaPago"
""

[CONDICIONS] 5
"ComFacturas.NumFactura","Número Factura",0,1
"ComFacturas.Seccion","Sección",0,1
"ComFacturas.FechaFactura","Fecha",0,2
"ComFacturas.NombreFiscal","Nombre Proveedor",0,1
"@COP", "Número Copias :", 9, "", ""

[ORDENACIONS] 1
"ComFacturas.NumFactura","Ordenacion1",3

[CAPSALERA]
0, 87, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 12
3,"CAB 1","ComFacturas.CodProveedor",120,42,"ARIAL",10,0,0,"0000",""
3,"CAB 1","ComFacturas.NombreFiscal",120,47,"ARIAL",10,1,0,"0000",""
3,"CAB 1","ComFacturas.Direccion",120,52,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Pueblo",120,57,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad",120,62,"ARIAL",10,0,0,"0000",""
3,"CAB 1","FechaFactura",10,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","ComFacturas.NumFactura",50,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","ComFacturas.NIF",75,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","Nombre",15,71,"ARIAL",8,0,0,"0000",""
3,"CAB 1","PersonaContacto",15,76,"ARIAL",8,0,0,"0000",""
0,"Página",75,66,"ARIAL",9,0,0,"1000"
6,"Pagina",75,71,"ARIAL",8,0,0,"0000",""
[FICAP]

[PEU]
0, 60, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 45
; release245: las 16 etiquetas/cajas que antes vivían en el pie de "GENERAL" se
; han traído aquí, al MISMO pie que ya dibuja los importes reales.
1, "CuadroBrut", 0, 0, 200, 16, 1, 0,#FALSE#
0, "Importe Bruto", 3, 1,"ARIAL",8,1,0,"0000"
0, "Dto.Comerc.", 45, 1,"ARIAL",8,1,1,"0000"
0, "Dto.P.Pago", 68, 1,"ARIAL",8,1,1,"0000"
0, "IRPF", 90, 1,"ARIAL",8,1,1,"0000"
0, "I.V.A.", 125, 1,"ARIAL",8,1,0,"0000"
0, "R.E.", 150, 1,"ARIAL",8,1,0,"0000"
0, "Portes", 168, 1,"ARIAL",8,1,1,"0000"
1, "CuadroTot", 173, 0, 200, 16, 1, 0,
0, "TOTAL", 178, 9,"ARIAL",10,1,0,"0000"
1, "CuadroFP", 0, 19, 102, 41, 1, 0,
0, "Condiciones de pago", 3, 20,"ARIAL",8,1,0,"0000"
1, "CuadroIva", 103, 19, 200, 41, 1, 0,
0, "Desglose de I.V.A. / R.E.", 106, 20,"ARIAL",8,1,0,"0000"
0, "Base", 118, 24,"ARIAL",7,0,0,"0000"
0, "%IVA  IVA    %RE   RE", 145, 24,"ARIAL",7,0,0,"0000"
; release246: cabeceras de columna subidas de y=26 a y=24, y las 3 filas de datos bajadas
; (27/32/37 -> 28/33/38) para dejar hueco real entre la cabecera y la primera fila -- antes
; quedaban a solo 1mm, prácticamente pegadas. Ver "Decisiones importantes", release246.
3, "CAB 1", "Total", 20, 10, "ARIAL", 10, 0, 0, "0000", "Total"
3, "CAB 1", "Descuentos", 45, 10, "ARIAL", 10, 0, 1, "0000",""
3, "CAB 1", "TDesCo", 62, 10, "ARIAL", 9, 0, 1, "0000","Total"
3, "CAB 1", "TDesPP", 78, 10, "ARIAL", 9, 0, 1, "0000","Total"
3, "CAB 1", "IRPF", 88, 5, "ARIAL", 8, 0, 1, "0000", ""
0, "%", 92, 5, "ARIAL", 7, 0, 0, "0000"
3, "CAB 1", "TIRPF", 97, 10, "ARIAL", 9, 0, 1, "0000","Total"
3, "CAB 1", "BaseImponible1", 118, 28, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Iva1", 133, 28,"ARIAL", 8, 0, 1, "0000", ""
3, "CAB 1", "Re1", 165, 28, "ARIAL", 8, 0, 1, "0000",  ""
3, "CAB 1", "BaseImponible2", 118, 33, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Iva2", 133, 33,"ARIAL", 8, 0, 1, "0000", ""
3, "CAB 1", "Re2", 165, 33, "ARIAL", 8, 0, 1, "0000",  ""
3, "CAB 1", "BaseImponible3", 118, 38, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Iva3", 133, 38,"ARIAL", 8, 0, 1, "0000", ""
3, "CAB 1", "Re3", 165, 38, "ARIAL", 8, 0, 1, "0000",  ""
0, "IVA total", 118, 5, "ARIAL", 8, 1, 0, "0000"
3, "CAB 1", "ImporteIvaTotal", 133, 5, "ARIAL", 9, 0, 1, "0000", "Total"
0, "R.E. total", 145, 5, "ARIAL", 8, 1, 0, "0000"
3, "CAB 1", "ImporteReTotal", 165, 5, "ARIAL", 9, 0, 1, "0000", "Total"
5,0,"PortesImporteTotalPro",180,5,"ARIAL",9,0,1,"0000",""
3, "CAB 1", "Total", 195, 9, "ARIAL", 12, 1, 1, "0000","Total"
0, "Nº Pedido origen", 3, 44, "ARIAL", 7, 0, 0, "1000"
3, "CAB 1", "DescripcionPago", 3, 24, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Observaciones", 3, 30, "ARIAL", 7, 0, 0, "0000", ""
0, "Total factura en letra:", 3, 48, "ARIAL", 6, 0, 0, "0000"
;--- Desglose IVA/RE encabezados repetidos junto a cada tramo, ver GENERAL ---
0, "1", 106, 28, "ARIAL", 7, 0, 0, "0000"
0, "2", 106, 33, "ARIAL", 7, 0, 0, "0000"
0, "3", 106, 38, "ARIAL", 7, 0, 0, "0000"
[FICAP]
[FIGRUP]


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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB 2", #FALSE#
; release247: revertido el intento de release246 de proteger NumAlbaran/FechaAlbaran con
; IIF(...Is Null,'',...) -- mezclaba un texto vacío con una columna NO de texto (entero/fecha)
; en el mismo CASE WHEN, el mismo tipo de fallo ya visto y corregido en release242 (IIF(Iva=0,'',Iva))
; -- pero aquí rompía la consulta ENTERA de "CAB 2" (0 filas) en vez de solo un valor, así que además
; de no arreglar "Num. Albarán" quitaba TODAS las líneas de la factura. Revertido a la forma original.
"SELECT *, 'Num. Albarán : ' & NumAlbaran & '    Fecha Albarán : ' & FechaAlbaran & IIF(NumPedido>0,'    Nº Pedido origen : ' & NumPedido,'') as NumyFecha "
"FROM ComAlba"
""

[ORDENACIONS] 1
"FechaAlbaran, NumAlbaran","Ordenacion1",3

[CONDICIONS] 2
"NumFactura","Número de Factura",1,1,"CAB 1","ComFacturas.NumFactura"
"Seccion","Número de Sección",1,1,"CAB 1","ComFacturas.Seccion"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB 2","NumyFecha",30,0,"ARIAL",8,1,0,"0000",""
[FICAP]

[PEU]
0, 5, #FALSE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[FIPEU]
[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CodProveedor, Total, Recargo, Iva, CodIVA, CodDescuento, Precio, NumAlbaran, Cantidad, NumLinea, LineaNeta, Seccion, CodAlmacen, Descripcion, CodArticulo, Descuento1 & ' ' & Descuento2 & ' ' & Descuento3 as Descuentos "
"FROM ComAlbaLin"
""

[ORDENACIONS] 1
"NumLinea","NumLinea",3

[CONDICIONS] 3
"NumAlbaran","Número de albarán",1,0,"CAB 2","NumAlbaran"
"Seccion","Número de albarán",1,1,"CAB 2","Seccion"
"CodProveedor","Número de albarán",1,1,"CAB 2","CodProveedor"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
3,"COS","CodArticulo",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",30,0,"ARIAL",8,105,0,"0000",""
<<<<<<< HEAD
3,"COS","Cantidad",150,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio",163,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Iva",180,0,"ARIAL",8,0,1,"0000",""
3,"COS","Descuentos",173,0,"ARIAL",8,0,1,"0000",""
3,"COS","Total",198,0,"ARIAL",8,0,1,"0000","SubTotal"
=======
3,"COS","Cantidad",150,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Precio",163,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Iva",180,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Descuentos",173,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Total",198,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
>>>>>>> 4d96b69 (a mitad de contabilidad analitica)
[FICAP]
[FIGRUP]

[CALCULS] 7
"PortesImporteTotalPro", "CAB 2", "ImportePorte", "CAB 1"
"MiTotal", "COS", "Total", "CAB 2"
"TotalBrut", "COS", "Total", "CAB 1"
"@CAM", "CAB 1", "Cambio", "CAB 1"
"@DEC", "CAB 1", "Decimales", "CAB 1"
"@COP", "CAB 1", "NumCopiasFra", "CAB 1"
"@DES", "CAB 1", "ComFacturas", "CAB 1"


[FIDOCUM]
