//ReportID: 10212
//TipeID: 10
//LastChanged: 07.10.2014 15:28:51
//Description: Stampa MP racuna
//LinkRepID: 142
//BrojKolona: 0
//BrojRedova: 0
QRMPRacun(TQuickRep)=qryStavka&poPortrait@A4[2100x2970,60x90]Comic Sans MS»8@10[]1#1{1}!|<frmDocMPRacun.QRFormBeforePrint>\?/^0000/0&1@psSolid«
qryStavka(TpFIBDataSet)=531[IBMastData.FIBDataBase]{110}
{
SELECT S.VRSTA, S.ROBAID, R.KATBR, R.KATBRPRO, R.JM, S.KOLICINA,  cpd.prodajnacena, round2(cpd.prodajnacena / (1.00 + s.porez/100.00)) as PRODCENABP,
       S.NAZIV, 0 AS RABAT, S.POREZ,  S.ZVEZDICA, S.MAGACINID, S.AKCIZA, S.TAKSA,
   ROUND2(ROUND2(cpd.PRODAJNACENA ) * S.KOLICINA)
      - ROUND2(ROUND2(cpd.PRODAJNACENA ) * S.POREZ / (100.00 + S.POREZ) * S.KOLICINA) AS VREDBEZPOREZA,
   ROUND2(ROUND2(cpd.PRODAJNACENA) * S.POREZ / (100.00 + S.POREZ) * S.KOLICINA) AS VREDPOREZA,
   ROUND2(ROUND2(cpd.PRODAJNACENA) * S.KOLICINA) AS PROVREDNOST,
   ROUND2(cpd.PRODAJNACENA * S.KOLICINA) AS UKUPPRODVREDNOST
FROM STAVKA S
  left join dokument d on s.vrdok = d.vrdok and s.brdok = d.brdok
  left join roba r on s.robaid = r.robaid
  left join cene_pre_dok(s.magacinid, s.robaid, d.datum, d.linked) cpd on 1=1
WHERE S.VRDOK = :vrdok AND S.BRDOK = :brdok
ORDER BY S.VRSTA, S.STAVKAID
}
Footer(TQRBand)=rbSummary[170]Arial»8@10[]0$16777215{000011}!frmDocMPRacun.FooterBeforePrint^0000/0&1@psSolid«
Zaglavlje(TQRBand)=rbPageHeader[235]Arial»8@10[]0$16777215{00001}!^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]${00001}!^0000/0&1@psSolid«
ChildFooter(TQRChildBand)=Footer[85]${00001}!^0000/0&1@psSolid«
shCrta(TQRShape)=Footer@0,2[737x4]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblUkupno(TQRLabel)=Footer@508,7[98x18]#taRightJustify${00101}Vrednost:!frmDocMPRacun.lblPrint^0000/0&1@psSolid«
lblRobuUzeo(TQRLabel)=ChildFooter@4,20[87x16]Arial»8@8[]238#taLeftJustify${00101}Robu preuzeo:!^0000/0&1@psSolid«
lblKomentar(TQRLabel)=Footer@5,93[69x19]#taLeftJustify${10101}Komentar : !QRF.QRDoclblKomentarPrint^0000/0&1@psSolid«
memKomentar(TQRMemo)=Footer@78,93[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/&@«
lblKupac2(TQRLabel)=Footer@5,26[75x19]#taLeftJustify${10100}Otpremljeno:!^0000/0&1@psSolid«
lblUkupanPorez(TQRLabel)=Footer@508,64[99x18]#taRightJustify${00101}Ukupan PDV:!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,56[237x17]#taLeftJustify${00101}IBMastData.Firma%FAX!^0000/0&1@psSolid«
lblZiro(TQRLabel)=Zaglavlje@4,73[63x17]#taLeftJustify${00101}Ziro racun:!^0000/0&1@psSolid«
dbtZiro(TQRDBText)=Zaglavlje@70,73[350x17]#taLeftJustify${00101}IBMastData.Firma%ZIRORACUN!^0000/0&1@psSolid«
dbtFirma(TQRDBText)=Zaglavlje@4,0[600x19]Arial»@13[fsBold]238#taLeftJustify${00101}IBMastData.Firma%NAZIV!^0000/0&1@psSolid«
dbtAdresa(TQRDBText)=Zaglavlje@4,39[272x17]#taLeftJustify${00101}IBMastData.Firma%ADRESA!^0000/0&1@psSolid«
dbtTelefon(TQRDBText)=Zaglavlje@315,56[237x17]#taLeftJustify${00101}IBMastData.Firma%TELEFON!^0000/0&1@psSolid«
lblTelefon(TQRLabel)=Zaglavlje@280,56[33x17]#taLeftJustify${00101}Tel:!^0000/0&1@psSolid«
lblFax(TQRLabel)=Zaglavlje@4,56[33x17]#taLeftJustify${00101}Fax:!^0000/0&1@psSolid«
lblNaslov(TQRLabel)=Zaglavlje@4,114[281x20]Arial»8@13[fsBold]0#taLeftJustify${10101}Maloprodajni racun kao ponuda br:!^0000/0&1@psSolid«
dbtBRDOK(TQRDBText)=Zaglavlje@287,114[62x20]Arial»8@13[fsBold]0#taLeftJustify${00101}frmDocMPRacun.qryDokument%BRDOK!QRF.QRDocBrDokPrint^0000/0&1@psSolid«
dbtIntBroj(TQRDBText)=Zaglavlje@350,114[64x20]Arial»8@13[fsItalic]0#taLeftJustify${00101}frmDocMPRacun.qryDokument%INTBROJ!QRF.QRDocIntBrojPrint^0000/0&1@psSolid«
lblDatum(TQRLabel)=Zaglavlje@4,159[48x17]#taLeftJustify${00101}Datum:!^0000/0&1@psSolid«
dbtDatum(TQRDBText)=Zaglavlje@70,159[89x17]#taLeftJustify${00101}frmDocMPRacun.qryDokument%DATUM!^0000/0&1@psSolid«
lblKupac(TQRLabel)=Zaglavlje@376,90[42x19]#taLeftJustify${10101}Kupac:!frmDocMPRacun.lblPrint^0000/0&1@psSolid«
dbtKupac(TQRDBText)=Zaglavlje@423,90[303x32]»@[]238#taLeftJustify${00101}frmDocMPRacun.qryPP%NAZIVZASTAMPU!frmDocMPRacun.dbtPrint^0000/0&1@psSolid«
shCrtaZ(TQRShape)=Zaglavlje@2,230[737x4]&2@#&$qrsHorLine{00011}!^0000/0&1@psSolid«
lblNo(TQRLabel)=Zaglavlje@9,215[8x15]#taLeftJustify${00101}#!^0000/0&1@psSolid«
lblKatBr(TQRLabel)=Zaglavlje@27,199[48x15]»@8[]#taLeftJustify${00100}Kat.broj!^0000/0&1@psSolid«
lblNaziv(TQRLabel)=Zaglavlje@27,215[110x15]»@8[]#taLeftJustify${00101}Naziv artikla!^0000/0&1@psSolid«
lblKol(TQRLabel)=Zaglavlje@240,215[38x15]»@8[]#taRightJustify${00101}Kol.!^0000/0&1@psSolid«
lblJM(TQRLabel)=Zaglavlje@280,215[30x15]»@8[]#taLeftJustify${00101}JM!^0000/0&1@psSolid«
lblRabat(TQRLabel)=Zaglavlje@391,215[35x15]»@8[]#taRightJustify${00101}Popust!^0000/0&1@psSolid«
lblCena(TQRLabel)=Zaglavlje@310,199[79x31]»@8[]#taRightJustify${00101}Cena po jedinici (sa/bez PDV)!^0000/0&1@psSolid«
lblVrednost(TQRLabel)=Zaglavlje@625,210[90x19]»@8[]#taRightJustify${00101}Ukupna naknada!^0000/0&1@psSolid«
dbtMestoKupca(TQRDBText)=Zaglavlje@423,122[150x18]#taLeftJustify${00101}frmDocMPRacun.qryPP%MESTOID!frmDocMPRacun.dbtPrint^0000/0&1@psSolid«
dbtDatumValute(TQRDBText)=Zaglavlje@253,159[89x17]#taLeftJustify${00101}frmDocMPRacun.qryDokument%DATROKA!^0000/0&1@psSolid«
lblDatumValute(TQRLabel)=Zaglavlje@166,159[84x17]#taRightJustify${00101}Datum valute:!^0000/0&1@psSolid«
dbtAdresaKupca(TQRDBText)=Zaglavlje@423,140[298x18]#taLeftJustify${00101}frmDocMPRacun.qryPP%ADRESA!^0000/0&1@psSolid«
imgLogo(TQRImage)=Zaglavlje@700,2[50x88]#${01110}!^0000/0&1@psSolid«
lblPlacanje(TQRLabel)=Zaglavlje@4,177[58x17]#taLeftJustify${00101}Placanje:!^0000/0&1@psSolid«
dbtNacinPlacanja(TQRDBText)=Zaglavlje@70,177[271x17]#taLeftJustify${00101}frmDocMPRacun.qryDokument%NUID!frmDocMPRacun.dbtPrint^0000/0&1@psSolid«
lblKatBrPro(TQRLabel)=Zaglavlje@92,199[61x15]»@8[]#taLeftJustify${00100}Kat.br.pro!^0000/0&1@psSolid«
dbtKatBr(TQRDBText)=ChildBand@27,0[120x14]Arial»@8[]#taLeftJustify${00001}qryStavka%KATBR!^0000/0&1@psSolid«
dbtNaziv(TQRDBText)=DetailBand@27,0[210x14]Arial»@8[]#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@576,122[150x18]#taLeftJustify${00101}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«
lblVredBezPoreza(TQRLabel)=Zaglavlje@427,199[80x31]»@8[]#taRightJustify${00101}Osnovica za PDV!^0000/0&1@psSolid«
lblPorez(TQRLabel)=Zaglavlje@510,199[35x31]»@8[]#taRightJustify${00101}Stopa PDV!^0000/0&1@psSolid«
lblVredPoreza(TQRLabel)=Zaglavlje@546,215[76x15]»@8[]#taRightJustify${00101}PDV!^0000/0&1@psSolid«
lblUkupnaVrednost(TQRLabel)=Footer@508,82[99x18]»@[fsBold]#taRightJustify${00101}Iznos sa PDV:!frmDocMPRacun.lblPrint^0000/0&1@psSolid«
dbtPIBKupca(TQRDBText)=Zaglavlje@423,158[298x18]#taLeftJustify${00101}frmDocMPRacun.qryPP%PIB!^0000/0&1@psSolid«
lblPIBKupca(TQRLabel)=Zaglavlje@376,158[42x18]#taLeftJustify${10101}PIB:!frmDocMPRacun.lblPrint^0000/0&1@psSolid«
lblPIB(TQRLabel)=Zaglavlje@4,90[63x17]#taLeftJustify${00101}PIB:!^0000/0&1@psSolid«
dbtPIB(TQRDBText)=Zaglavlje@70,90[140x17]#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«
lblCenaBP(TQRLabel)=Zaglavlje@715,199[60x31]»@8[]#taRightJustify${00100}Cena bez PDV!^0000/0&1@psSolid«
dbtFirma1(TQRDBText)=Zaglavlje@4,20[600x18]Arial»@10[]1#taLeftJustify${00101}IBMastData.Firma%NAZIV2!^0000/0&1@psSolid«
expBezPoreza(TQRExpr)=Footer&Stavke@611,7[103x18]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.UKUPPRODVREDNOST)!^0000/0&1@psSolid«
lblOsnovicaPDV(TQRLabel)=Footer@490,44[117x18]#taRightJustify${00101}Osnovica za PDV!frmDocMPRacun.lblPrint^0000/0&1@psSolid«
expUkOsnovicaPDV(TQRExpr)=Footer&Stavke@611,44[103x18]#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@4,142[204x17]#taRightJustify${00101}Broj fiskalnog isecka:!^0000/0&1@psSolid«
dbtBrojFiskalnog(TQRDBText)=Zaglavlje@210,142[62x17]#taLeftJustify${00101}frmDocMPRacun.qryDokument%FAKTDOBIZV!^0000/0&1@psSolid«
lblAvRacun(TQRLabel)=Footer@437,102[170x35]Arial»8@8[]1#taLeftJustify${00100}Uplaceno po avansnom racunu:!^0000/0&1@psSolid«
expAvRacun(TQRExpr)=Footer&IznosiBand@611,120[103x17]Arial»8@8[]1#taRightJustify$###,###,##0.00{001010}!frmDocMPRacun.expPrint^0000/0&1@psSolid«
lblOstajeZaUplatu(TQRLabel)=Footer@437,140[170x17]Arial»8@8[fsBold]1#taLeftJustify${00100}OSTAJE ZA UPLATU:!^0000/0&1@psSolid«
expOstajeZaUplatu(TQRExpr)=Footer&IznosiBand@611,140[103x17]Arial»8@8[fsBold]1#taRightJustify$###,###,##0.00{001010}!frmDocMPRacun.expPrint^0000/0&1@psSolid«
lblFakturisao1(TQRLabel)=ChildFooter@257,20[150x15]Arial»8@8[]238#taLeftJustify${00101}Robu izdao - odgovorno lice:!^0000/0&1@psSolid«
lblOLSviPodaci(TQRLabel)=ChildFooter@257,36[242x47]Arial»8@8[]1#taLeftJustify${01101}!QRF.QRDocOLSviPodaci^0000/0&1@psSolid«
lblFakturisao(TQRLabel)=ChildFooter@507,20[82x15]Arial»8@8[]238#taLeftJustify${00101}Račun izdao:!^0000/0&1@psSolid«
dbtRefSviPodaci(TQRDBText)=ChildFooter@507,36[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 <DATUM> iznosi: <VREDNOST> <POSCENVAL> (Kurs: 1 <POSCENVAL> = <KURS> <ROBAVAL>). U slučaju neblagovremenog plaćanja zaračunavamo kursne razlike.!frmDocMPRacun.lblPrint^0000/0&1@psSolid«
expUkOsnovicaPDV1(TQRExpr)=Footer&Stavke@611,64[103x18]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.VREDPOREZA)!^0000/0&1@psSolid«
expUkOsnovicaPDV2(TQRExpr)=Footer&Stavke@611,82[103x18]#taRightJustify$###,###,##0.00{000111}SUM(qryStavka.ProVrednost)!^0000/0&1@psSolid«