"VER1.0","Articulos","Listado de los albaranes de los pedidos"
;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] 6
3,"CABECERA","NombreComercial",10,0,"ARIAL",12,0,0,"1000",""
3,"CABECERA","Domicilio",10,4,"ARIAL",10,0,0,"1000",""
3,"CABECERA","Direc",10,8,"ARIAL",10,0,0,"1000",""
3,"CABECERA","Provincia",10,12,"ARIAL",10,0,0,"1000",""
3,"CABECERA","Tel",10,16,"ARIAL",10,0,0,"1000",""
3,"CABECERA","Nif",10,20,"ARIAL",10,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total General",160,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]
[FIGRUP]

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
0,"Listado de los albaranes de los pedidos",45,15,"ARIAL",15,0,0,"1001"
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",""
1,"linea2",5,24,200,24,,,
1,"linea1",5,29,200,29,,,
0,"Cod. Cliente",12,25,"ARIAL",8,0,0,"1000"
0,"Nombre Cliente",30,25,"ARIAL",8,0,0,"1000"
;0,"Precio 1",140,25,"ARIAL",8,0,1,"1000"
;0,"Precio 2",155,25,"ARIAL",8,0,1,"1000"
;0,"Precio 3",170,25,"ARIAL",8,0,1,"1000"
;0,"Precio 4",185,25,"ARIAL",8,0,1,"1000"
;0,"Precio+IVA",202,25,"ARIAL",8,0,1,"1000"
;0,"Codigo",5,25,"ARIAL",8,0,0,"1000"
;0,"Descripcion",30,25,"ARIAL",8,0,0,"1000"
;0,"Prov.",130,25,"ARIAL",8,0,0,"1000"
;0,"Familia",150,25,"ARIAL",8,0,0,"1000"
;0,"TipoIva",170,25,"ARIAL",8,0,0,"1000"
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total Acumulado",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
[GRUP]
2,"CAB2", #FALSE#
"SELECT VenPrev.CodCliente & ' - ' & VenAlba.NombreCliente & ' Pedido : ' & VenPrev.Numero & ' Fecha : ' & VenPrev.Fecha AS Titulo, VenAlba.NombreCliente, VenPrev.CodCliente, VenPrev.Fecha, VenPrev.Numero, Count(VenAlba.NumAlbaran) AS CuentaDeNumAlbaran"
"FROM VenPrev RIGHT JOIN VenAlba ON (VenPrev.Numero = VenAlba.NumPedido) AND (VenPrev.Fecha=VenAlba.FechaPedido)"
"GROUP BY VenAlba.NombreCliente, VenPrev.CodCliente, VenPrev.Fecha, VenPrev.Numero HAVING (((VenPrev.CodCliente)<>'') AND ((Count(VenAlba.NumAlbaran))>1))"

[ORDENACIONS] 0
"CodFamilia", "Codigo Familia", 3

[CONDICIONS] 3
"VenPrev.CodCliente", "Cod. Cliente", 0, 1
"Numero", "Nmero Pedido", 0, 0
"VenPrev.Fecha", "Fecha Pedido", 0, 2
;"Descripcion", "Descripcin", 0, 1

[CAPSALERA]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
3,"CAB2","Titulo",5,0,"ARIAL",10,0,0,"0001",""
0,"Num.Albaran",11,5,"ARIAL",8,0,0,"1000"
0,"Fecha",32,5,"ARIAL",8,0,0,"1000"
0,"NumFactura",50,5,"ARIAL",8,0,0,"1000"
0,"Total",80,5,"ARIAL",8,0,0,"1000"
0,"Vencimiento Recibo",95,5,"ARIAL",8,0,0,"1000"
0,"Importe",135,5,"ARIAL",8,0,0,"1000"
0,"Cobrado?",150,5,"ARIAL",8,0,0,"1000"

[FICAP]
[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total Proveedor",140,0,"ARIAL",10,0,0,"0001"
;5,0,"TotalP",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]
[FIGRUP]


;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenAlba.NumFactura, VenRecibos.NumFactura, VenAlba.*, VenPrev.*, VenRecibos.FechaVencimiento, VenRecibos.Importe, VenRecibos.Contabilizado"
"FROM (VenPrev RIGHT JOIN VenAlba ON (VenPrev.Numero = VenAlba.NumPedido) AND (VenPrev.Seccion = VenAlba.Seccion)) LEFT JOIN VenRecibos ON (VenAlba.Seccion = VenRecibos.Seccion) AND (VenAlba.NumFactura = VenRecibos.NumFactura)"
""

[CONDICIONS] 3
"VenPrev.CodCliente", "CodCliente", 1, 1, "CAB2", "CodCliente"
"VenPrev.FEcha", "CodCliente", 1, 2, "CAB2", "VenPrev.Fecha"
"Numero", "Numero", 1, 0, "CAB2", "Numero"

[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","NumAlbaran",12,0,"ARIAL",8,0,0,"0000",""
3,"COS","FechaAlbaran",30,0,"ARIAL",8,50,0,"0000",""
3,"COS","VenAlba.NumFactura",50,0,"ARIAL",8,0,0,"0000",""
3,"COS","VenAlba.Total",86,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","FechaVencimiento",115,0,"ARIAL",8,0,1,"0000",""
3,"COS","Importe",144,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Contabilizado",155,0,"ARIAL",8,0,1,"0000",""

[FICAP]
[FIGRUP]

[CALCULS] 0
;"TotalP","COS","PrecioCoste","CAB2"
;"Total","COS","PrecioCoste","GENERAL"

[FIDOCUM]


