0.4cm true true true true 0.4cm 7.499999cm =Globals!PageNumberInSection & "(" & Globals!TotalPagesInSection & ")" 11.5cm 196mm BandedList 1.5cm 17.9cm 11.49229cm DataSet1 =Fields!invoiceID.Value true true 0.4cm 13cm 11mm =Fields!FakturaNr.Value 3cm 1 2.38cm FitProportional External =Fields!Logga.Value 8.37cm 2 3.4cm 2.5mm true TextBox18 0.4cm 1mm 1mm Beställare: 3cm true TextBox18 1.7cm 1mm 5mm =Fields!CustomerAddressField.Value 8.3cm true TextBox18 0.4cm 0.1cm 2.2cm Kontaktperson: =iif(Trim$(Fields!customerContact.Value)="",True,False) 3cm 1 true TextBox18 0.7cm 0.1cm 2.6cm =Fields!customerContact.Value 8.3cm 2 2.9cm 8.5cm 1 3.4cm 9cm 2.5mm true TextBox18 0.4cm 1mm 1mm Fakturaadress: 3cm true TextBox18 1.7cm 1mm 5mm =Fields!InvoiceAddressField.Value 8.3cm true TextBox18 0.7cm 0.1cm 2.6cm =Fields!customerReference.Value 8.3cm 2 true TextBox18 0.4cm 0.1cm 2.2cm Fakturareferens: =iif(Trim$(Fields!customerReference.Value)="",True,False) 3cm 2.9cm 8.5cm 1 true 0.4cm 8.4cm Art.nr 2cm 3 true 0.4cm 2cm 8.4cm Beskrivning 6.75cm 4 true 0.4cm 8.75cm 8.4cm Period 5cm 5 true 0.4cm 13.75cm 8.4cm Antal 1cm 6 true 0.4cm 14.75cm 8.4cm Moms 1cm 7 true 0.4cm 15.75cm 8.4cm Belopp 1.75cm 8 0cm 8.8cm 175mm 9 true 6mm 9.1cm =Fields!InvoiceTitle.Value 40mm 10 true TextBox18 0.4cm 9.1cm 7mm Fakturadatum: 3cm true TextBox18 0.4cm 13cm 7mm Fakturanummer: 3cm true TextBox2 0.4cm 9.1cm 11mm =Fields!created.Value 3cm 1 true TextBox2 0.4cm 9.1cm 2cm =Fields!Kundnr.Value 3cm 1 true TextBox18 0.4cm 9.1cm 1.6cm Kundnummer: 3cm true TextBox2 0.4cm 13cm 2cm =Fields!FaktKundOrg.Value 3cm 1 true TextBox18 0.4cm 13cm 1.6cm Orgnummer: =iif(Trim$(Fields!FaktKundOrg.Value)="",True,False) 3cm true TextBox18 0.4cm 0.1cm 6.400001cm Vår referens: 3cm 1 true TextBox18 0.4cm 5.4cm 6.400001cm Märkning: =iif(Trim$(Fields!po_number.Value)="",True,False) 3cm 1 true TextBox2 0.4cm 0.1cm 6.8cm =Fields!ourReference.Value 5cm 1 true TextBox2 0.4cm 5.3cm 6.8cm =Fields!po_number.Value 3.1cm 1 true TextBox18 0.4cm 9.1cm 6.400001cm Betalningsvillkor: 3cm 1 true TextBox18 0.4cm 13cm 6.400001cm Betala senast: 3cm 1 true TextBox2 0.4cm 9.1cm 6.8cm =Fields!BetVillkor.Value 3.7cm 1 true TextBox2 0.4cm 13cm 6.8cm =Fields!BetalaSenast.Value 4.3cm 1 true TextBox18 0.4cm 0.1cm 7.3cm Jobbnummer: =iif(Trim$(Fields!jobnr.Value)="",True,False) 3cm 1 true TextBox18 0.4cm 3.1cm 7.3cm Jobbeskrivning: =iif(Trim$(Fields!jobbet.Value)="",True,False) 3cm 1 true TextBox2 0.4cm 0.1cm 7.7cm =Fields!jobnr.Value 3cm 1 true TextBox2 0.4cm 3.1cm 7.7cm =Fields!jobbet.Value 14.2cm 1 =Fields!invoiceID.Value 0.9cm 0.2cm 2.5mm true 0.4cm 0.7999998cm Momspliktigt belopp: 2.6cm true 4mm 0.3cm 0.4cm =Fields!FaktTotal.Value 3.1cm 1 true TextBox18 0.4cm 5cm Momsbelopp: 2.6cm 2 true TextBox18 0.4cm 9cm Fakturaavgift: 2.6cm true TextBox18 0.4cm 14cm Att betala: 2.6cm true TextBox19 4mm 4.5cm 0.4cm =Fields!FaktVat.Value 3.1cm 1 true TextBox19 4mm 8.5cm 0.4cm =Fields!FaktAvgift.Value 3.1cm 3 true TextBox19 4mm 13.5cm 0.4cm =Fields!FaktTotalVat.Value 3.1cm 3 0.5cm 175mm =Fields!grpreservation.Value true true 0.4cm BOKNING =iif(Fields!cntBookings.Value=1,True,False) 1.7cm true true 4mm 1.7cm =Fields!grpreservation.Value & ":" =iif(Fields!cntBookings.Value=1,True,False) 3cm 1 true true 0.4cm 15.75cm =Sum(Fields!ArtTotal.Value) =iif(Fields!cntBookings.Value=1,True,False) 1.8cm true true 0.4cm 13.7cm DELSUMMA: =iif(Fields!cntBookings.Value=1,True,False) 2.1cm 1 =Fields!grpoccation.Value true 0.4cm =Fields!ArtNr.Value 2cm 10 true 0.4cm 2cm =Fields!ArtBeskr.Value 6.75cm 9 true 0.4cm 8.75cm =Fields!RadPeriod.Value 5cm 8 true 0.4cm 13.75cm =Fields!ArtAntal.Value 1cm 7 true 0.4cm 14.75cm =Fields!ArtMoms.Value 1cm 6 true 0.4cm 15.75cm =Fields!ArtTotal.Value 1.8cm 5 0cm true true 8.89cm true False 1.402292cm False 0.4cm true 0.4cm true False 0cm true False

0.4cm

2.5cm true true 1.8cm 1.5cm true 4mm 2mm =Parameters!companyName.Value 5.3cm true TextBox20 4mm 0.6cm =Parameters!companyAddress.Value 5.3cm true TextBox20 4mm 0.9999999cm =Parameters!companyCityZip.Value 5.3cm true TextBox20 4mm 1.4cm =Parameters!companyEmail.Value 5.3cm true TextBox20 4mm 5.3cm 0.2cm Telefonnummer: 3cm true TextBox20 4mm 5.3cm 0.6cm =Parameters!companyPhone.Value 3cm true TextBox20 4mm 5.3cm 1.4cm =Parameters!companySite.Value 6cm true TextBox20 4mm 8.4cm 0.2cm Faxnummer: 3cm true TextBox20 4mm 11.4cm 0.2cm Orgnummer: 3cm true TextBox20 4mm 8.4cm 0.6cm =Parameters!companyFax.Value 3cm true TextBox20 4mm 11.4cm 1cm VAT-nummer: 3cm true TextBox20 4mm 11.4cm 1.4cm =Parameters!companyVatNo.Value 3cm true TextBox20 4mm 14.4cm 1cm Bankgiro: =iif(Trim$(Parameters!companyBG.Value)="",True,False) 3cm true true TextBox20 4mm 14.4cm 0.6cm =Parameters!companyPG.Value =iif(Trim$(Parameters!companyPG.Value)="",True,False) 3cm true TextBox20 4mm 14.4cm 1.4cm =Parameters!companyBG.Value =iif(Trim$(Parameters!companyBG.Value)="",True,False) 3cm 1 true TextBox20 4mm 11.4cm 0.6cm =Parameters!companyOrgNo.Value 3cm true true TextBox20 4mm 14.4cm 0.2cm Plusgiro: =iif(Trim$(Parameters!companyPG.Value)="",True,False) 3cm 0.2cm 17.5cm 2 21cm Integer authorid 725 Integer invoiceids true 42344 43730 28824 16992 43759 true String true companyName true DataSet1 COMP COMP true String true companyAddress true DataSet1 CompAddr CompAddr true String true companyCityZip true DataSet1 CompOrt true String true companyEmail true DataSet1 CompEmail true String true companyPhone true DataSet1 CompPhone true String true companyFax true DataSet1 CompFax true String true companySite true DataSet1 CompSite true String true companyOrgNo true DataSet1 CompORG true String true companyVatNo true DataSet1 CompVAT true String true companyPG true DataSet1 CompPG true String true companyBG true DataSet1 CompBG data source=150.0.0.123;initial catalog=legaonline; SQL Please enter your username and password. InvoiceTitle Logga InvoiceAddressField CustomerAddressField customerContact customerContactLabel customerReference customerReferenceLabel ourReference po_number poNumberLabel ourReferenceLabel Kundnr ArtNr FaktKundOrg created BetVillkor BetalaSenast FakturaNr jobnr Jobbet ArtAntal ArtMoms ArtTotal RadPeriod ArtBeskr cntBookings COMP CompAddr CompOrt CompBG CompPG CompORG CompVAT CompPhone CompEmail CompFax CompFskatt CompSite FaktTotal FaktTotalVat FaktVat FaktAvgift invoiceID grpoccation grpreservation DECLARE @UseInvoiceCustomerid varchar(3) SET @UseInvoiceCustomerid = LOWER(dbo.UDF_GetCompanySetting(@authorid,40)) SELECT -- FAKTURAHUVUD dbo.UDF_GetInvoiceTitle(ih.totalSumInkVat) InvoiceTitle, dbo.UDF_GetLogo(@authorid) Logga, dbo.UDF_IH_GetInvoiceAddress(ih.invoiceID) InvoiceAddressField, dbo.UDF_IH_GetCustomerAddress(ih.invoiceID) CustomerAddressField, dbo.UDF_GetCustomerContact(res.customerContactID) customerContact, dbo.UDF_LabelOrNot('Kontaktperson',dbo.UDF_GetCustomerContact(res.customerContactID)) customerContactLabel, ih.customerReference, dbo.UDF_LabelOrNot('Fakturareferens:',ih.customerReference) customerReferenceLabel, ih.ourReference, ih.po_number, dbo.UDF_LabelOrNot('Märkning:',ih.po_number) poNumberLabel, dbo.UDF_LabelOrNot('Vår referens:',ih.ourReference) ourReferenceLabel, CASE @UseInvoiceCustomerid WHEN 'yes' THEN ( CASE LEN(RTRIM(ISNULL(c.customerNumber,''))) WHEN 0 THEN CAST(ih.invoicecustomerid AS varchar) ELSE c.customerNumber END ) ELSE CAST(ih.invoicecustomerid AS varchar) END Kundnr, ir.itemNr ArtNr, ih.invoiceOrgNr FaktKundOrg, ih.created created, CAST(DATEDIFF(DAY,ih.created,ih.[expireDate]) AS VARCHAR)+' dagar' BetVillkor, CONVERT(varchar(10),ih.expireDate,120) BetalaSenast, CASE LEN(LTRIM(CAST(ISNULL(ih.orderNumber,'') AS varchar))) WHEN 0 THEN CAST(ih.invoiceID AS varchar) ELSE CAST(ih.orderNumber AS varchar) END FakturaNr, ISNULL(j.jobnr,j.jobid) jobnr, j.description Jobbet, -- FAKTURARAD ISNULL(ir.quantity,1) ArtAntal, ISNULL(ir.vat,0)/100 ArtMoms, ir.total ArtTotal, CONVERT(varchar(16),ir.periodStart,120) + ' - ' + CONVERT(varchar(16),ir.periodEnd,120) RadPeriod, ir.objectName ArtBeskr, -- VISA DELTOTAL BASERAT PÅ ANTAL BOKNINGAR PER FAKTURA (SELECT COUNT(tmporderid) FROM orderinvoicelnk WHERE invoiceID = ih.invoiceID) cntBookings, -- FAKTURAFOT ISNULL(au.legalName, au.fullname) COMP, ISNULL(au.address1,'') CompAddr, ISNULL(dbo.UDF_FormatAdressSE('','','',au.zipcode,au.city),'') CompOrt, ISNULL(au.bankgiro,'') CompBG, ISNULL(au.postalgiro,'') CompPG, ISNULL(au.orgnr,'') CompORG, ISNULL('SE'+REPLACE(au.orgnr,'-','')+'01','') CompVAT, ISNULL(dbo.UDF_FormatPhoneSE(au.phone),'') CompPhone, ISNULL(au.email,'') CompEmail, ISNULL(dbo.UDF_FormatPhoneSE(au.fax),'') CompFax, ISNULL(au.legalName+' har F-skattesedel','') CompFskatt, ISNULL(au.website,'') CompSite, ih.totalSum FaktTotal, ih.totalSumInkVat FaktTotalVat, ih.vatFixed FaktVat, ih.invoiceFee FaktAvgift, --GRUPPERING ih.invoiceID, orr.occationID grpoccation, res.reservationID grpreservation FROM invoicehead ih INNER JOIN Customer c ON c.customerID = ih.invoicecustomerid INNER JOIN invoicerow ir ON ir.invoiceid = ih.invoiceid LEFT JOIN accountusers au ON au.userid = ih.authorid LEFT JOIN job j ON j.jobid = ih.jobid LEFT JOIN OrderRow orr ON orr.tmpRowID = ir.tmpRowID LEFT JOIN Reservation res ON res.tmpOrderID = orr.tmpOrderID LEFT JOIN Occation occ ON occ.occationID = orr.occationID WHERE ih.invoiceid IN (@invoiceids) AND ih.authorid = @authorid AND ih.obliterated IS NULL ORDER BY ih.invoiceid,res.reservationID,orr.sortindex DataSource1 =Parameters!authorid.Value =Parameters!invoiceids.Value