//ReportID: 10231 //TipeID: 10 //LastChanged: 19.03.2015 14:22:26 //Description: Stampa MP racuna //LinkRepID: 114 //BrojKolona: 0 //BrojRedova: 0 QRMPRacun(TQuickRep)=qryStavka&poPortrait@A4[2100x2970,60x90]Comic Sans MS»8@10[]1#1{1}!|\?/^0000/0&1@psSolid« qryStavka(TpFIBDataSet)=620[IBMastData.FIBDataBase]{110} { SELECT S.VRSTA, S.ROBAID, R.KATBR, R.KATBRPRO, R.JM, S.KOLICINA, S.PRODAJNACENA, S.PRODCENABP, S.NAZIV, S.RABAT, S.POREZ, S.ZVEZDICA, S.MAGACINID, S.AKCIZA, S.TAKSA, ROUND2(ROUND2(S.PRODAJNACENA * (100.00 - S.RABAT)/100.00) * S.KOLICINA) - ROUND2(ROUND2(S.PRODAJNACENA * (100.00 - S.RABAT)/100.00) * S.POREZ / (100.00 + S.POREZ) * S.KOLICINA) AS VREDBEZPOREZA, ROUND2(ROUND2(S.PRODAJNACENA * (100.00 - S.RABAT)/100.00) * S.POREZ / (100.00 + S.POREZ) * S.KOLICINA) AS VREDPOREZA, ROUND2(ROUND2(S.PRODAJNACENA * (100.00 - S.RABAT)/100.00) * S.KOLICINA) AS PROVREDNOST, ROUND2(S.PRODAJNACENA * S.KOLICINA) AS UKUPPRODVREDNOST FROM STAVKA S, ROBA R WHERE S.VRDOK = :VRDOK AND S.BRDOK = :BRDOK AND S.ROBAID = R.ROBAID ORDER BY S.VRSTA, S.STAVKAID } Footer(TQRBand)=rbSummary[240]Arial»8@10[]0$16777215{000011}!frmDocMPRacun.FooterBeforePrint^0000/0&1@psSolid« Zaglavlje(TQRBand)=rbPageHeader[280]Arial»8@10[]0$16777215{000011}!^0000/0&1@psSolid« GrVrstaFoo(TQRBand)=rbGroupFooter[25]Arial»-2147483640@10[]0$16777215{00000}!frmDocMPRacun.GrVrstaFooBeforePrint^0000/&@« DetailBand(TQRBand)=rbDetail[15]Arial»@10[]${00001}frmDocMPRacun.StavkeAfterPrint!frmDocMPRacun.StavkeBeforePrint^0000/0&1@psSolid« GrVrstaHe(TQRGroup)=GrVrstaFoo[23]Arial»8@10[]0#qryStavka.VRSTA$16777215{000000}!^0000/0&1@psSolid« ChildBand(TQRChildBand)=DetailBand[16]${000001}!frmDocMPRacun.ChildStavkaBeforePrint^0000/0&1@psSolid« ChildFooter(TQRChildBand)=Footer[93]${000011}!^0000/0&1@psSolid« shCrta(TQRShape)=Footer@0,2[737x4]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid« lblUkupno(TQRLabel)=Footer@508,7[98x18]Arial»@[]#taRightJustify${00101}Vrednost:!frmDocMPRacun.lblPrint^0000/0&1@psSolid« lblKomentar(TQRLabel)=Footer@5,122[69x19]#taLeftJustify${10101}Komentar : !QRF.QRDoclblKomentarPrint^0000/0&1@psSolid« memKomentar(TQRMemo)=Footer@78,122[344x74]#taLeftJustify${01101}!^0000/0&1@psSolid« dbtNapomena(TQRDBText)=Footer@5,8[460x19]#taLeftJustify${00101}frmDocMPRacun.qryDokument%kupac!^0000/0&1@psSolid« dbtKupac2(TQRDBText)=Footer@84,25[381x19]#taLeftJustify${00100}frmDocMPRacun.qryDokument%KUPAC!^0000/&@« OkvirZaUplatu11(TQRShape)=Zaglavlje@2,152[729x67]16119285&@#16119285&$qrsRectangle{00011}!^0000/0&1@psSolid« OkvirKupac(TQRShape)=Zaglavlje@349,127[370x103]4194368&@#16777215&$qrsRectangle{00011}!^0000/0&1@psSolid« lblKupac2(TQRLabel)=Footer@5,26[75x19]#taLeftJustify${10100}Otpremljeno:!^0000/0&1@psSolid« lblUkupRabat(TQRLabel)=Footer@508,26[99x18]Arial»@[]#taRightJustify${00101}Ukupan popust!frmDocMPRacun.lblPrint^0000/0&1@psSolid« lblUkupanPorez(TQRLabel)=Footer@508,64[99x18]Arial»@[]#taRightJustify${00101}Ukupan PDV:!frmDocMPRacun.lblPrint^0000/0&1@psSolid« dbtUkupanPDV(TQRDBText)=Footer@611,64[103x18]Arial»@[]#taRightJustify${00101}frmDocMPRacun.qryDokument%POREZ!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« ExpUkupRabat(TQRLabel)=Footer@611,26[103x18]Arial»@[]#taRightJustify${00101}0!frmDocMPRacun.lblPrint^0000/0&1@psSolid« lblMP(TQRLabel)=ChildFooter@392,1[30x19]#taCenter${00101}M.P.!^0000/0&1@psSolid« dbtLinija(TQRDBText)=Footer@5,44[460x19]#taLeftJustify${00111}frmDocMPRacun.qryDokument%TEKST!^0000/0&1@psSolid« dbtFax(TQRDBText)=Zaglavlje@39,91[237x17]#taLeftJustify${00101}IBMastData.Firma%FAX!^0000/0&1@psSolid« lblZiro(TQRLabel)=Zaglavlje@4,108[63x17]#taLeftJustify${00101}Ziro racun:!^0000/0&1@psSolid« dbtZiro(TQRDBText)=Zaglavlje@70,108[350x17]#taLeftJustify${00101}IBMastData.Firma%ZIRORACUN!^0000/0&1@psSolid« dbtFirma(TQRDBText)=Zaglavlje@4,0[346x19]Arial»@13[fsBold]238#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid« dbtAdresa(TQRDBText)=Zaglavlje@4,39[272x17]»@9[]238#taLeftJustify${00101}IBMastData.Firma%ADRESA!^0000/0&1@psSolid« dbtTelefon(TQRDBText)=Zaglavlje@39,73[237x17]#taLeftJustify${00101}IBMastData.Firma%TELEFON!^0000/0&1@psSolid« lblTelefon(TQRLabel)=Zaglavlje@4,73[33x17]#taLeftJustify${00101}Tel:!^0000/0&1@psSolid« lblFax(TQRLabel)=Zaglavlje@4,91[33x17]#taLeftJustify${00101}Fax:!^0000/0&1@psSolid« dbtIntBroj(TQRDBText)=Zaglavlje@616,87[106x20]Arial»8@13[fsItalic]0#taLeftJustify${00100}frmDocMPRacun.qryDokument%INTBROJ!QRF.QRDocIntBrojPrint^0000/0&1@psSolid« dbtDatum(TQRDBText)=Zaglavlje@562,35[89x17]Arial»@9[]#taLeftJustify${00101}frmDocMPRacun.qryDokument%DATUM!^0000/0&1@psSolid« dbtKupac(TQRDBText)=Zaglavlje@404,133[303x32]»@9[fsBold]238#taLeftJustify${00111}frmDocMPRacun.qryPP%NAZIVZASTAMPU!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtMestoKupca(TQRDBText)=Zaglavlje@404,165[150x18]»@9[]238#taLeftJustify${00111}frmDocMPRacun.qryPP%MESTOID!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtDatumValute(TQRDBText)=Zaglavlje@562,52[89x17]Arial»@9[]#taLeftJustify${00101}frmDocMPRacun.qryDokument%DATROKA!^0000/0&1@psSolid« lblDatumValute(TQRLabel)=Zaglavlje@476,52[84x17]Arial»@9[]#taRightJustify${00101}Datum valute:!^0000/0&1@psSolid« dbtAdresaKupca(TQRDBText)=Zaglavlje@404,183[303x18]»@9[]238#taLeftJustify${00111}frmDocMPRacun.qryPP%ADRESA!^0000/0&1@psSolid« imgLogo(TQRImage)=Zaglavlje@700,2[50x88]#${01110}!^0000/0&1@psSolid« dbtKatBr(TQRDBText)=ChildBand@27,0[120x14]Arial»@8[]#taLeftJustify${00001}qryStavka%KATBR!^0000/0&1@psSolid« dbtNaziv(TQRDBText)=DetailBand@61,0[178x14]Arial»@8[]238#taLeftJustify${01001}qryStavka%NAZIV!^0000/0&1@psSolid« dbtKol(TQRDBText)=DetailBand@240,0[38x14]Arial»@8[]#taRightJustify$###,###,##0.####{00101}qryStavka%KOLICINA!^0000/0&1@psSolid« dbtJM(TQRDBText)=DetailBand@280,0[30x14]Arial»@8[]#taLeftJustify${00101}qryStavka%JM!^0000/0&1@psSolid« dbtCena(TQRDBText)=DetailBand@310,0[79x14]Arial»@8[]#taRightJustify$###,###,##0.00{00101}qryStavka%PRODAJNACENA!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtRabat(TQRDBText)=DetailBand@391,0[35x14]Arial»@8[]#taRightJustify$##0.##%{00101}qryStavka%RABAT!^0000/0&1@psSolid« lblTacka(TQRLabel)=DetailBand@22,0[4x15]Arial»8@8[]0#taLeftJustify${10101}.!^0000/0&1@psSolid« expNo(TQRExpr)=DetailBand&QRMPRacun@1,0[20x14]Arial»@8[]#taRightJustify${001001}COUNT!^0000/0&1@psSolid« dbtZvezdica(TQRDBText)=DetailBand@717,0[12x14]Arial»@8[]#taCenter${00001}qryStavka%ZVEZDICA!^0000/0&1@psSolid« dbtKatbrPro(TQRDBText)=ChildBand@92,0[62x14]Arial»@8[]#taLeftJustify${00000}qryStavka%KATBRPRO!^0000/0&1@psSolid« dbtRobaUsluga(TQRDBText)=GrVrstaHe@7,1[82x17]#taLeftJustify${00101}qryStavka%VRSTA!QRFFaktura.FakturadbtRobaUslugaPrint^0000/0&1@psSolid« LinijaGrupa(TQRShape)=GrVrstaFoo@472,1[265x4]#$qrsHorLine{00011}!^0000/0&1@psSolid« lblVrednostGrupe(TQRLabel)=GrVrstaFoo@475,5[78x17]Arial»-2147483640@10[]1#taLeftJustify${00101}Vrednost:!^0000/0&1@psSolid« dbtVrednostGrupe(TQRDBText)=GrVrstaFoo@619,5[94x17]#taRightJustify$###,###,##0.00{00101}qryStavka%VRSTA!frmDocMPRacun.dbtPrint^0000/&@« dbtTelefonKupca(TQRDBText)=Zaglavlje@557,165[150x18]»@9[]#taLeftJustify${00111}frmDocMPRacun.qryPP%TELEFON!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtVredBezPoreza(TQRDBText)=DetailBand@427,0[80x14]Arial»@8[]#taRightJustify$###,###,##0.00{00101}qryStavka%VredBezPoreza!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtPorez(TQRDBText)=DetailBand@510,0[35x14]Arial»@8[]#taRightJustify$##0.##%{00101}qryStavka%POREZ!^0000/0&1@psSolid« dbtVredPoreza(TQRDBText)=DetailBand@546,0[76x14]Arial»@8[]#taRightJustify$###,###,##0.00{00101}qryStavka%VredPoreza!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtProVrednost(TQRDBText)=DetailBand@625,0[90x14]Arial»@8[]#taRightJustify$###,###,##0.00{00101}qryStavka%ProVrednost!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« lblUkupnaVrednost(TQRLabel)=Footer@508,82[99x18]Arial»@[fsBold]#taRightJustify${00101}Iznos sa PDV:!frmDocMPRacun.lblPrint^0000/0&1@psSolid« dbtUkupnoSaPDV(TQRDBText)=Footer@611,82[103x18]Arial»@[fsBold]#taRightJustify${00101}frmDocMPRacun.qryDokument%POTRAZUJE!frmDocMPRacun.dbtPrint^0000/0&1@psSolid« dbtPIBKupca(TQRDBText)=Zaglavlje@404,202[304x18]Arial»@10[fsBold]#taLeftJustify${00111}frmDocMPRacun.qryPP%PIB!^0000/0&1@psSolid« lblPIBKupca(TQRLabel)=Zaglavlje@357,202[42x18]Arial»@10[fsBold]#taLeftJustify${10111}PIB:!frmDocMPRacun.lblPrint^0000/0&1@psSolid« dbtPIB(TQRDBText)=Zaglavlje@40,57[89x16]»@10[fsBold]#taLeftJustify${00101}IBMastData.Firma%PIB!^0000/0&1@psSolid« dbtCenaBP(TQRDBText)=ChildBand@310,0[79x14]Arial»@8[]#taRightJustify$###,###,##0.00{00101}qryStavka%PRODCENABP!^0000/0&1@psSolid« dbtFirma1(TQRDBText)=Zaglavlje@4,20[346x18]Arial»@10[]238#taLeftJustify${00101}IBMastData.Firma%NAZIV2!^0000/0&1@psSolid« expBezPoreza(TQRExpr)=Footer&Stavke@611,7[103x18]Arial»@[]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.UKUPPRODVREDNOST)!^0000/0&1@psSolid« lblOsnovicaPDV(TQRLabel)=Footer@490,44[117x18]Arial»@[]#taRightJustify${00101}Osnovica za PDV!frmDocMPRacun.lblPrint^0000/0&1@psSolid« expUkOsnovicaPDV(TQRExpr)=Footer&Stavke@611,44[103x18]Arial»@[]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.VREDBEZPOREZA)!^0000/0&1@psSolid« lblDatumMesto(TQRLabel)=ChildFooter@4,1[378x19]Arial»@8[]#taLeftJustify${00101}Datum i mesto prometa dobara: !frmDocMPRacun.lblPrint^0000/0&1@psSolid« lblBrojFiskalnog(TQRLabel)=Zaglavlje@356,70[204x17]Arial»@9[]#taRightJustify${00100}Broj fiskalnog isecka:!^0000/0&1@psSolid« dbtBrojFiskalnog(TQRDBText)=Zaglavlje@562,70[62x17]Arial»@9[]#taLeftJustify${00100}frmDocMPRacun.qryDokument%FAKTDOBIZV!^0000/0&1@psSolid« lblAvRacun(TQRLabel)=Footer@437,131[170x35]Arial»8@8[]1#taLeftJustify${00100}Uplaceno po avansnom racunu:!^0000/0&1@psSolid« expAvRacun(TQRExpr)=Footer&IznosiBand@610,147[103x17]Arial»8@8[]1#taRightJustify$###,###,##0.00{001010}!frmDocMPRacun.expPrint^0000/0&1@psSolid« lblOstajeZaUplatu(TQRLabel)=Footer@437,169[170x17]Arial»8@8[fsBold]1#taLeftJustify${00100}OSTAJE ZA UPLATU:!^0000/0&1@psSolid« expOstajeZaUplatu(TQRExpr)=Footer&IznosiBand@610,169[103x17]Arial»8@8[fsBold]1#taRightJustify$###,###,##0.00{001010}!frmDocMPRacun.expPrint^0000/0&1@psSolid« lblOLSviPodaci(TQRLabel)=ChildFooter@257,44[242x47]Arial»8@8[]1#taLeftJustify${01101}!QRF.QRDocOLSviPodaci^0000/0&1@psSolid« dbtRefSviPodaci(TQRDBText)=ChildFooter@507,44[202x47]Arial»0@8[]238#taLeftJustify${01101}frmDocMPRacun.qryDokument%REFID!QRF.QRDocRefSviPodaci^0000/0&1@psSolid« lblVrednostUValuti(TQRLabel)=Footer@5,63[453x29]Arial»8@8[fsBold]1#taLeftJustify${01100}Vrednost ovog računa na dan iznosi: (Kurs: 1 = ). U slučaju neblagovremenog plaćanja zaračunavamo kursne razlike.!frmDocMPRacun.lblPrint^0000/0&1@psSolid« memOperacije(TQRMemo)=ChildBand@398,0[300x14]#taLeftJustify${01011}!^0000/0&1@psSolid« lblPIB(TQRLabel)=Zaglavlje@4,57[34x16]Arial»8@10[fsBold]1#taLeftJustify${00111}PIB:!^0000/0&1@psSolid« lblMaticniBroj(TQRLabel)=Zaglavlje@130,57[41x16]Arial»8@10[fsBold]238#taRightJustify${00101}; MB:!^0000/0&1@psSolid« dbtMaticniBroj(TQRDBText)=Zaglavlje@180,57[128x16]Arial»8@10[fsBold]1#taLeftJustify${00101}IBMastData.Firma%MBROJ!^0000/0&1@psSolid« OkvirZaUplatu1(TQRShape)=Zaglavlje@352,0[378x34]16119285&@#16119285&$qrsRectangle{00011}!^0000/0&1@psSolid« lblNaslov(TQRLabel)=Zaglavlje@356,6[204x23]Arial»8@13[fsBold]238#taLeftJustify${10111}MP RAČUN BROJ:!^0000/0&1@psSolid« dbtBRDOK(TQRDBText)=Zaglavlje@561,6[113x23]Arial»8@13[fsBold]0#taLeftJustify${00111}frmDocMPRacun.qryDokument%BRDOK!QRF.QRDocBrDokPrint^0000/0&1@psSolid« lblDatum(TQRLabel)=Zaglavlje@512,35[48x17]Arial»@9[]#taRightJustify${00101}Datum:!^0000/0&1@psSolid« LinijaZaUplatu1(TQRShape)=Zaglavlje@2,236[729x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid« OkvirZaUplatu12(TQRShape)=Zaglavlje@2,239[729x34]16119285&@#16119285&$qrsRectangle{00011}!^0000/0&1@psSolid« LinijaZaUplatu11(TQRShape)=Zaglavlje@2,273[729x3]&@#&$qrsHorLine{00011}!^0000/0&1@psSolid« lblNo(TQRLabel)=Zaglavlje@9,254[16x15]Arial»@8[]#taLeftJustify${00111}RB!^0000/0&1@psSolid« lblKatBr(TQRLabel)=Zaglavlje@27,240[48x15]»@8[]#taLeftJustify${00110}Kat.broj!^0000/0&1@psSolid« lblNaziv(TQRLabel)=Zaglavlje@61,254[110x15]Arial»@8[]#taLeftJustify${00111}Naziv artikla!^0000/0&1@psSolid« lblKatBrPro(TQRLabel)=Zaglavlje@92,240[61x15]»@8[]#taLeftJustify${00110}Kat.br.pro!^0000/0&1@psSolid« lblKol(TQRLabel)=Zaglavlje@240,254[38x15]Arial»@8[]#taRightJustify${00111}Kol.!^0000/0&1@psSolid« lblJM(TQRLabel)=Zaglavlje@280,254[30x15]Arial»@8[]#taLeftJustify${00111}JM!^0000/0&1@psSolid« lblCena(TQRLabel)=Zaglavlje@310,241[79x29]Arial»@8[]#taRightJustify${00111}Cena po jedinici (sa PDV)!^0000/0&1@psSolid« lblRabat(TQRLabel)=Zaglavlje@391,254[35x15]Arial»@8[]#taRightJustify${00111}Popust!^0000/0&1@psSolid« lblVredBezPoreza(TQRLabel)=Zaglavlje@427,241[80x29]Arial»@8[]#taRightJustify${00111}Osnovica za PDV!^0000/0&1@psSolid« lblPorez(TQRLabel)=Zaglavlje@510,241[35x29]Arial»@8[]#taRightJustify${00111}Stopa PDV!^0000/0&1@psSolid« lblVredPoreza(TQRLabel)=Zaglavlje@546,254[76x15]Arial»@8[]#taRightJustify${00111}PDV!^0000/0&1@psSolid« lblVrednost(TQRLabel)=Zaglavlje@625,254[90x15]Arial»@8[]#taRightJustify${00111}Ukupna naknada!^0000/0&1@psSolid« lblCenaBP(TQRLabel)=Zaglavlje@715,238[60x31]»@8[]#taRightJustify${00110}Cena bez PDV!^0000/0&1@psSolid« lblArtID(TQRLabel)=Zaglavlje@29,254[30x15]Arial»@8[]#taLeftJustify${00111}ArtID!^0000/0&1@psSolid« dbtArtID(TQRDBText)=DetailBand@29,0[32x14]Arial»@8[]#taLeftJustify${01001}qryStavka%ROBAID!^0000/0&1@psSolid« OkvirSummary(TQRShape)=ChildFooter@2,20[728x4]&@#16777215&$qrsHorLine{00011}!^0000/0&1@psSolid« OkvirIzdaoFakturisao(TQRShape)=ChildFooter@2,24[728x18]15461355&@#15461355&$qrsRectangle{00011}!^0000/0&1@psSolid« lblRobuUzeo(TQRLabel)=ChildFooter@4,26[87x16]Arial»8@8[]238#taLeftJustify${00111}Robu primio:!^0000/0&1@psSolid« lblFakturisao1(TQRLabel)=ChildFooter@257,26[150x15]Arial»8@8[]238#taLeftJustify${00111}Robu izdao:!^0000/0&1@psSolid« lblFakturisao(TQRLabel)=ChildFooter@507,26[140x15]Arial»8@8[]238#taLeftJustify${00111}Za ILNOR d.o.o.:!^0000/0&1@psSolid« OkvirIzdaoFakturisao1(TQRShape)=Footer@2,101[728x21]11053224&@#11053224&$qrsRectangle{00011}!^0000/0&1@psSolid« lblPlacanje(TQRLabel)=Footer@276,103[72x17]Arial Black»16777215@10[fsBold]238#taLeftJustify${00111}Plaćeno:!^0000/16777215&1@psSolid« dbtNacinPlacanja(TQRDBText)=Footer@349,103[271x17]Arial Black»16777215@10[fsBold]#taLeftJustify${00111}frmDocMPRacun.qryDokument%NUID!frmDocMPRacun.dbtPrint^0000/16777215&1@psSolid« lblKomentar1(TQRLabel)=Footer@2,197[729x19]Arial»@10[fsUnderline]238#taCenter${00001}U CENU JE URAČUNAT PREVOZ / DOSTAVA NA ADRESU KUPCA.!^0000/0&1@psSolid« lblKomentar11(TQRLabel)=Footer@2,216[729x19]Arial»@10[]238#taCenter${00001}DOSTAVA NA ADRESU KUPCA BIĆE IZVRŠENA NAJKASNIJE U ROKU OD 3 (TRI) DANA.!^0000/0&1@psSolid«