"VER1.0","Albara","Facturas de Proveedores (moderno)"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiCos]
;MargenX, MargenY, EtiLin, EtiPag
; 0, 152, 30
[DOCUM]
V, 9, 22
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] 16
2, "Anagrama.png", 8, 8, 70, 20
0, "ALBARÁN PROVEEDOR", 85, 10, "ARIAL BLACK", 15, 0, 0, "0000"
3, "CABECERA", "NombreFiscal", 8, 33, "ARIAL", 11, 1, 0, "1000", ""
0, "Tel. ", 8, 39, "ARIAL", 7, 0, 0, "0000"
3, "CABECERA", "Telefono1", 15, 39, "ARIAL", 7, 0, 0, "0000", ""
0, "FAX. ", 60, 39, "ARIAL", 7, 0, 0, "0000"
3, "CABECERA", "Fax", 68, 39, "ARIAL", 7, 0, 0, "0000", ""
3, "CABECERA", "Domicilio", 8, 43, "ARIAL", 7, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 90, 43, "ARIAL", 7, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 8, 47, "ARIAL", 7, 0, 0,"0000", ""
0, "C.I.F. / N.I.F. :", 90, 47, "ARIAL", 7, 0, 0, "0000"
3, "CABECERA", "Nif", 109, 47, "ARIAL", 7, 0, 0, "0000", ""
0, "eMail:", 8, 51, "ARIAL", 7, 0, 0, "0000"
3, "CABECERA", "e-Mail", 17, 51, "ARIAL", 7, 0, 0, "0000", ""
0, "Web:", 90, 51, "ARIAL", 7, 0, 0, "0000"
3, "CABECERA", "Web", 99, 51, "ARIAL", 7, 0, 0, "0000", ""
[FICAP]

; En Impresos recomendable crear con valor PrintAll a True
[PEU]
0, 5, #TRUE#, 2, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[FIPEU]
[FIGRUP]

;--------------------------------------------------------------------------
;Tipo, NomGrup, Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
[CAPSALERA]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 20
1, "lineaCab", 5, 55, 202, 55,,,
1, "CuadroAdreca", 115, 58, 202, 83, 1, 0,
0, "DATOS DEL PROVEEDOR", 118, 60, "ARIAL", 8, 1, 0, "0000"
1, "CuadroAlbaran", 5, 58, 105, 83, 1, 0,
0, "DATOS DEL ALBARÁN", 8, 60, "ARIAL", 8, 1, 0, "0000"
1, "CuadroCos", 5, 90, 202, -52, 1, 0,
0,"Cod. Articulo",10,91,"ARIAL",8,1,0,"0000"
0,"Descripción",35,91,"ARIAL",8,1,0,"0000"
0,"Cant.",128,91,"ARIAL",8,1,1,"0000"
0,"Precio",147,91,"ARIAL",8,1,1,"0000"
0,"Descuento",168,91,"ARIAL",8,1,1,"0000"
0,"Iva",180,91,"ARIAL",8,1,1,"0000"
0,"Total",200,91,"ARIAL",8,1,1,"0000"
1, "lineaH", 5, 96, 202, 96,,,
1, "lineaV", 31, 90, 31, -52,,,
1, "lineaV", 111, 90, 111, -52,,,
1, "lineaV", 131, 90, 131, -52,,,
1, "lineaV", 151, 90, 151, -52,,,
1, "lineaV", 172, 90, 172, -52,,,
1, "lineaV", 182, 90, 182, -52,,,

[FICAP]

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

;--------------------------------------------------------------------------
;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB 1", #TRUE#
"SELECT iif(ImportePorte>0,'+ ' & ImportePorte,'') as Port, ComAlba.*, CodigosPostales.CodPostal & ' - ' & CodigosPostales.Ciudad as Ciudad1, Provincias.Provincia & '  ' &  Paises.Pais as ProPais, Monedas.Decimales, Monedas.ValorVenta as Cambio "
"FROM (((ComAlba LEFT JOIN CodigosPostales ON (ComAlba.CodPostal = CodigosPostales.CodPostal) AND (ComAlba.CodPais = CodigosPostales.CodPais)) LEFT JOIN Provincias ON (CodigosPostales.CodPais = Provincias.CodPais) AND (CodigosPostales.CodProvincia = Provincias.CodProvincia)) LEFT JOIN Paises ON ComAlba.CodPais = Paises.CodPais) LEFT JOIN Monedas ON ComAlba.CodMoneda = Monedas.CodMoneda"
""
[CONDICIONS] 4
"NumAlbaran","Número Albarán",0,0
"Seccion","Sección",0,1
"FechaAlbaran","Fecha",0,2
"NombreProveedor","Nombre Proveedor",0,1

[CAPSALERA]
0, 56, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 16
0,"Página",60,68,"ARIAL",9,0,0,"1000"
6,"Pagina",75,68,"ARIAL",9,0,0,"0000",""
3,"CAB 1","NombreProveedor",118,63,"ARIAL",10,1,0,"0000",""
3,"CAB 1","Direccion",118,68,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad1",118,73,"ARIAL",10,0,0,"0000",""
3,"CAB 1","ProPais",118,78,"ARIAL",10,0,0,"0000",""
0,"Nº Albarán",8,63,"ARIAL",9,1,0,"1000"
3,"CAB 1","NumAlbaran",35,63,"ARIAL",9,0,0,"0000",""
0,"Fecha",8,68,"ARIAL",9,1,0,"1000"
3,"CAB 1","FechaAlbaran",35,68,"ARIAL",9,0,0,"0000",""
3,"CAB 1","NIF",118,58,"ARIAL",8,0,0,"0000",""
0,"Cod. Proveedor", 8, 73, "ARIAL", 9, 1, 0, "1000"
3,"CAB 1","CodProveedor",35,73,"ARIAL",9,0,0,"0000",""
0,"Nº Pedido origen", 8, 78, "ARIAL", 9, 1, 0, "1000"
3,"CAB 1","NumPedido",35,78,"ARIAL",9,0,0,"0000",""
0, "Portes", 90, 78, "ARIAL", 8, 0, 0, "1000"
[FICAP]

[PEU]
0, 45, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 20
1, "CuadroPeu", 5, 2, 202, 20, 1, 0,
1, "CuadroObser", 5, 22, 202, 30, 1, 0,
0,"OBSERVACIONES :", 12, 24,"ARIAL",9,0,0,"0000"
3, "CABECERA", "LineaObsAutomatica", 45, 24, "ARIAL", 9, 0, 0,"0000", ""
0, "Base imponible", 8, 4, "ARIAL", 8, 1, 1, "1000"
0, "IVA", 88, 4, "ARIAL", 8, 1, 1, "1000"
0, "R.E.", 118, 4, "ARIAL", 8, 1, 1, "1000"
0, "Portes", 148, 4, "ARIAL", 8, 1, 1, "1000"
0, "TOTAL", 195, 4, "ARIAL", 9, 1, 1, "1000"
5, 0, "TotalBrut", 28, 10, "ARIAL", 9, 0, 1, "1000","Total"
5, 0, "IvaTotalAlbPro", 108, 10, "ARIAL", 9, 0, 1, "1000","Total"
5, 0, "RETotalAlbPro", 138, 10, "ARIAL", 9, 0, 1, "1000","Total"
3,"CAB 1","ImportePorte",161,10,"ARIAL",9,0,1,"1000","Total"
5, 0, "TotalConImpuestosAlbPro", 200, 10, "ARIAL", 10, 1, 1, "1000","Total"
1, "lineaV1", 78, 2, 78, 20,,,
1, "lineaV2", 108, 2, 108, 20,,,
1, "lineaV3", 138, 2, 138, 20,,,
1, "lineaV4", 168, 2, 168, 20,,,
0, "(*) Los portes se suman al total de líneas con impuestos", 8, 16, "ARIAL", 6, 0, 0, "0000"
3,"CAB 1","Port",200,16,"ARIAL",7,0,1,"0000",""

[FIPEU]
[FIGRUP]

;--------------------------------------------------------
;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CodProveedor, Total, Total*Iva/100 as ImporteIvaLinea, Total*Recargo/100 as ImporteReLinea, Total+(Total*Iva/100)+(Total*Recargo/100) as TotalConImpuestosLinea, NumPedido, 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 1","NumAlbaran"
"Seccion","Número de albarán",1,1,"CAB 1","Seccion"
"CodProveedor","Número de albarán",1,1,"CAB 1","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",10,45,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",35,45,"ARIAL",8,80,0,"0000",""
<<<<<<< HEAD
3,"COS","Cantidad",127,45,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio",147,45,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Descuentos",155,45,"ARIAL",8,0,0,"0000",""
3,"COS","Iva",180,45,"ARIAL",8,0,1,"0000",""
3,"COS","Total",201,45,"ARIAL",8,0,1,"0000","SubTotal"
=======
3,"COS","Cantidad",127,45,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Precio",147,45,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Descuentos",155,45,"ARIAL",8,0,0,"0000","","CodArticulo<>"
3,"COS","Iva",180,45,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Total",201,45,"ARIAL",8,0,1,"0000","","CodArticulo<>"
>>>>>>> 4d96b69 (a mitad de contabilidad analitica)
[FICAP]
[FIGRUP]

[CALCULS] 4
"TotalBrut","COS","Total","CAB 1"
"IvaTotalAlbPro","COS","ImporteIvaLinea","CAB 1"
"RETotalAlbPro","COS","ImporteReLinea","CAB 1"
"TotalConImpuestosAlbPro","COS","TotalConImpuestosLinea","CAB 1"

[FIDOCUM]
