0.81582cm
5.40117cm
3.66507cm
1.47354cm
1.2cm
1.79148cm
0.9cm
2.02063cm
1.90583cm
1.06251cm
true
true
Br.
Textbox19
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
=IIf(Parameters!PRINT_SIFRA.Value=1,"Šifra - Opis","Opis")
13
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Slika
Textbox32
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Kol.
12
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Jed.
11
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Cijena
(
=First(Fields!BASE_VALUTA.Value, "dtPostavke")
)
10
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Rb.
(%)
9
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Cijena s popustom
8
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
true
true
Iznos
(
=First(Fields!BASE_VALUTA.Value, "dtPostavke")
)
8
=Parameters!HEADER_COLOR.Value
Middle
2pt
2pt
2pt
2pt
0.13749cm
true
true
=Fields!OA_ART_OPIS2.Value
Textbox37
WhiteSmoke
Top
2pt
2pt
2pt
2pt
5
true
true
Textbox45
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox60
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox62
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox62
WhiteSmoke
2pt
2pt
2pt
2pt
2.0356cm
true
true
=RowNumber(Nothing) & "."
Textbox21
true
true
=IIf(Parameters!PRINT_SIFRA.Value=1,Fields!ART_SIFRA.Value+" - "+Fields!OA_ART_OPIS.Value,Fields!OA_ART_OPIS.Value)
6
Database
=Code.GetImage(Fields!IMG_SLIKA.Value)
image/png
FitProportional
NoOutput
true
true
=Fields!OA_COUNT.Value
5
true
true
=Fields!OA_MJERA.Value
4
true
true
=Fields!OA_PRICE.Value
3
true
true
=Fields!OA_DISCOUNT.Value
2
true
true
=Fields!OA_PRICE.Value*(100-Fields!OA_DISCOUNT.Value)/100
1
true
true
=Fields!OA_PRICE.Value*(100-Fields!OA_DISCOUNT.Value)*Fields!OA_COUNT.Value/100
1
0.39688cm
true
true
Textbox15
WhiteSmoke
Top
2pt
2pt
2pt
2pt
true
true
Textbox18
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox39
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox23
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox24
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox25
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox28
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
Textbox123
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=sum(Fields!OA_PRICE.Value*(100-Fields!OA_DISCOUNT.Value)*Fields!OA_COUNT.Value/100)
1
WhiteSmoke
2pt
2pt
2pt
2pt
=Fields!OA_ART_OPIS2.Value
=Fields!OA_ART_OPIS2.Value
=iif(Fields!OA_ART_OPIS2.Value is nothing,true,false)
After
Detail
Detail_Collection
Output
=iif(Fields!OA_ART_OPIS2.Value is nothing,true,false)
Before
true
ARTIKLI
=Fields!OA_ID.Value
5.4125cm
0.12646cm
3.63248cm
19.17354cm
true
true
=Parameters!COMPANY_DATA_B1.Value
textbox11
10.04474cm
2.2cm
9.05527cm
1
2.5cm
19.1cm
0cm
-18.94999cm
2
true
true
="PONUDA br. " & Parameters!PONUDA_BROJ.Value
4.86159cm
0.1cm
0.37452cm
19.1cm
3
15.33812cm
0.3cm
0cm
5.50265cm
4
true
true
Ponudu izdao:
13.42332cm
0.3cm
0.74074cm
5.50265cm
5
true
true
="Datum dokumenta: " & Parameters!PONUDA_DATUM.Value +VBCRLF +"Datum valjanosti: " & Parameters!PONUDA_DATUM_VALJANOST.Value
+vbcrlf +"Sastavio: " & Parameters!PONUDA_SASTAVIO.Value
2.78833cm
10.2cm
0.74074cm
8.9cm
6
true
=Parameters!OFFER_DESCRIPTION.Value
12.27623cm
0.05001cm
0.25604cm
19.1cm
7
9.1175cm
0.12646cm
0cm
19.1cm
8
1.5pt
6.92696cm
2.87304cm
0.44901cm
true
true
Ukupno:
Textbox19
2pt
2pt
2pt
2pt
true
true
=Sum(System.Math.ROUND(Fields!OA_PRICE.Value * Fields!OA_COUNT.Value,2))
textbox15
2
2pt
2pt
2pt
2pt
0.39611cm
true
true
Rabat:
Textbox26
1.5pt
2pt
2pt
2pt
2pt
true
true
=Sum(System.Math.ROUND(Fields!OA_PRICE.Value * Fields!OA_COUNT.Value, 2)) - Sum(System.Math.ROUND(Fields!OA_PRICE.Value * Fields!OA_COUNT.Value * (1 - Fields!OA_DISCOUNT.Value / 100), 2))
Textbox27
1.5pt
2pt
2pt
2pt
2pt
0.21089cm
true
true
Neto iznos:
Textbox40
1.5pt
2pt
2pt
2pt
2pt
true
true
=Sum(System.Math.ROUND(Fields!OA_PRICE.Value * (100 - Fields!OA_DISCOUNT.Value) * Fields!OA_COUNT.Value / 100, 2))
Textbox41
1.5pt
2pt
2pt
2pt
2pt
0.39611cm
true
true
="PDV(" &Fields!TAX_VALUE.Value & "% osnovica: "+format(sum(Fields!OA_PRICE.Value*(100-Fields!OA_DISCOUNT.Value)*Fields!OA_COUNT.Value/100),"#,##0.00") +"):"+
iif( Fields!TAX_PNP_VALUE.Value=0,"", vbcrlf+"PNP(" &Fields!TAX_PNP_VALUE.Value & "%" +" osnovica: "+format(sum(Fields!OA_PRICE.Value*(100-Fields!OA_DISCOUNT.Value)*Fields!OA_COUNT.Value/100),"#,##0.00") +"):")
Textbox52
1.5pt
2pt
2pt
2pt
2pt
true
true
=FORMAT( round(sum(round(Fields!OA_PRICE.Value*(1-Fields!OA_DISCOUNT.Value/100)*Fields!OA_COUNT.Value,2))*Fields!TAX_VALUE.Value/100 +0.000001,2) ,"#,##0.00")+
iif( Fields!TAX_PNP_VALUE.Value=0,"", VBCRLF+ FORMAT(sum(round(Fields!OA_PRICE.Value*(1-Fields!OA_DISCOUNT.Value/100)*Fields!OA_COUNT.Value+0.000001,2))*Fields!TAX_PNP_VALUE.Value/100 ,"#,##0.00"))
1.5pt
2pt
2pt
2pt
2pt
true
0.29026cm
true
true
="Posebni porez na motorna vozila(" & Parameters!OFF_PP_PERCENTAGE.Value & "% osnovica: "+format(Parameters!OFF_PP_OSNOVICA.Value,"#,##0.00") +"):"
Textbox16
1.5pt
Middle
2pt
2pt
2pt
2pt
true
true
=Parameters!OFF_PP_IZNOS.Value
Textbox17
1.5pt
Middle
2pt
2pt
2pt
2pt
0.34317cm
true
true
="Povratna naknada " + format(Fields!OA_PN.Value,"#,##0.00") +" * "+ format(sum(Fields!OA_COUNT.Value),"#,##0.00")
1.5pt
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!OA_COUNT.Value * Fields!OA_PN.Value)
Textbox15
1.5pt
Middle
2pt
2pt
2pt
2pt
0.34317cm
true
true
UKUPNO (
=First(Fields!BASE_VALUTA.Value, "dtPostavke")
):
Textbox48
1.5pt
2pt
2pt
2pt
2pt
true
true
=Parameters!OFF_TOTAL_MPC.Value
1.5pt
2pt
2pt
2pt
2pt
0.51831cm
true
true
="UKUPNO ("+First(Fields!BASE_CONVERSION_VALUTA.Value, "dtPostavke")+"):"+vbcrlf+
First(Fields!BASE_CONVERSION_FIX_DESCRIPTION.Value, "dtPostavke")
2pt
Top
2pt
2pt
2pt
2pt
true
true
=Parameters!OFF_TOTAL_MPC.Value/First(Fields!BASE_CONVERSION_FIX_VALUE.Value, "dtPostavke")
1.5pt
2pt
2pt
2pt
2pt
=iif(Sum(Fields!OA_DISCOUNT.Value)=0,true,false)
=iif(Sum(Fields!OA_DISCOUNT.Value)=0,true,false)
=iif(Parameters!IS_IN_PDV.Value=false,true,false)
=Fields!TAX_VALUE.Value
=Fields!TAX_VALUE.Value
=IIF(Fields!TAX_VALUE.Value=0 and Parameters!IS_IN_PDV.Value=false ,TRUE,FALSE)
=iif(Parameters!OFF_PP_IZNOS.Value=0,true,false)
Before
=Fields!OA_PN.Value
=Fields!OA_PN.Value
=iif(Fields!OA_PN.Value=0,true,false)
=iif(First(Fields!BASE_CONVERSION_SHOW_INFO.Value, "dtPostavke"),false,true)
ARTIKLI
9.15278cm
9.42647cm
2.94703cm
9.8cm
9
true
=Parameters!OFFER_DESC_STATIC.Value
12.63811cm
0.05001cm
0.2825cm
19.1cm
10
true
true
= "Kupac: "+vbcrlf+ Parameters!BUYER.Value
3.10583cm
1.36078cm
0.96965cm
7.12604cm
11
Database
=Code.GetImage(Parameters!COMPANY_LOGO.Value)
image/png
FitProportional
0.05069cm
0.16148cm
2.41403cm
9.70687cm
12
NoOutput
15.31284cm
7.72132cm
0cm
5.50265cm
13
true
true
Naručitelj:
13.39804cm
7.72132cm
0.74074cm
5.50265cm
14
2.96472cm
8.35632cm
0cm
0.39557cm
15
2.95909cm
8.75189cm
0.29104cm
0cm
16
2.95909cm
0.91996cm
0.29104cm
0cm
17
2.96472cm
0.91996cm
0cm
0.25104cm
18
4.25187cm
0.69436cm
0cm
8.05753cm
19
true
0.34396cm
0.13557cm
0cm
0.35688cm
0.13557cm
0.34396cm
0cm
1
0.34396cm
7.57733cm
0cm
0.38334cm
2
7.96067cm
0.34396cm
0cm
3
true
4.3052cm
0.65561cm
0.38cm
8.09625cm
20
true
true
OVO NIJE FISKALIZIRANI RAČUN!
11.30361cm
0.15001cm
0.59146cm
7.78623cm
21
Database
=Code.GetImage(Parameters!IMG_BARCODE.Value)
image/png
FitProportional
0.0507cm
2cm
5.50957cm
NoOutput
true
true
HUB3 podaci za plaćanje internet bankarstvom
2.15653cm
0.42903cm
5.48416cm
1
2pt
2pt
2pt
2pt
true
13.01102cm
13.66585cm
2.58556cm
5.50957cm
22
=IIF(Parameters!IMG_BARCODE.Value="",TRUE,FALSE)
15.59658cm
19.3cm
1cm
true
true
true
true
=Globals!PageNumber & " / " & Globals!TotalPages
0.01cm
17.4cm
0.5cm
1.8cm
19.3cm
0cm
-19.2cm
1
true
true
=Parameters!COMPANY_DATA_B2.Value
textbox33
0.01cm
0.15001cm
0.99cm
17.14416cm
2
29.7cm
21cm
0.5cm
0cm
0.7cm
1.5cm
1cm
0
SQL
18fee242-4d29-4df5-b405-0fcc575e1137
System.Data.DataSet
/* Local Connection */
f5f295be-cafc-4f13-b592-1f284e8fbced
DummyDataSource
/* Local Query */
OA_ID
System.String
OA_OFF_ID
System.String
OA_ART_OPIS
System.String
OA_COUNT
System.String
OA_PRICE
System.String
OA_TAX_ID
System.String
OA_DISCOUNT
System.String
OA_OF_ID
System.String
OA_ORDER
System.String
ART_NAZIV
System.String
ART_SIFRA
System.String
OA_MJERA
System.String
TAX_VALUE
System.String
ART_PRICE_EURO
System.String
OA_ART_OPIS2
System.String
OA_PN
System.String
OA_MPC
System.String
OA_MPC_WITH_DISCOUNT
System.String
TAX_PNP_VALUE
System.String
TAX_NAME
System.String
ART_IS_USLUGA
System.String
IMG_SLIKA
System.String
dsArtikli
C:\NEW\PRODUX_PROJEKT\PRODUX_PRODAJA\_FINANCIJE\DS\dsArtikliPonuda.xsd
dtArtikli
dsPostavke
/* Local Query */
COMPANY
System.String
COMPANY_DATA_B1
System.String
COMPANY_DATA_B2
System.String
OFFER_DESCRIPTION
System.String
BILL_DESCRIPTION
System.String
FIN_ALLOW_PRICE_CHANGE
System.String
FIN_ALLOW_SO_DELETE
System.String
FIN_BILL_OFFSET
System.String
BASE_PROGRAM_VERZIJA
System.String
FIN_BILL_PREFIX
System.String
FIN_BILL_SUFIX
System.String
FIN_OFFER_PREFIX
System.String
FIN_OFFER_SUFIX
System.String
FIN_PRINT_LOGO
System.String
FIN_PRINT_BARCODE
System.String
FIN_HEADER_COLOR
System.String
COMPANY_LOGO
System.String
FIN_ALLOW_PRINT_CONTACT_BILL
System.String
FIN_HAVE_SELLER_ORDERS
System.String
FIN_HAVE_RACUN_OTPREMNICA
System.String
FIN_BILL_TYPE_ID
System.String
SER_FIX_CONDITIONS
System.String
SER_PRINT_BARCODE
System.String
SER_MANDATORY_USER
System.String
SER_VOZILA_PATH
System.String
SER_NALOZI_PATH
System.String
SER_BILL_CHOSED_OPTION
System.String
SER_SKLADISTE_ID
System.String
FIN_SO_WITHOUT_ITEMS
System.String
FIN_PRINT_OFFER_USER_CREATED
System.String
FIN_IS_IN_PDV
System.String
FIN_FISKAL_ACTIVE
System.String
FIN_AUTO_BLAGAJNA
System.String
FIN_ARTICLI_STANJE
System.String
FIN_LOGIN_POS_INDEX
System.String
SET_SIFRA_ISPIS
System.String
SET_SHOW_FOOTER_IK
System.String
FIN_BILL_COMPANY_MANDATORY
System.String
FIN_BILL_PRINT_BILL_LOCATION
System.String
FIN_BILL_PRINT_BILL_TYPE
System.String
FIN_AUTO_RABAT
System.String
SYS_YEAR_CLOSED
System.String
SYS_YEAR_CLOSED_ALLOW_EDIT
System.String
SYS_NEW_SETUP_PATH
System.String
FIN_SO_DOC_PATH
System.String
SYS_HAVE_PP_MARZA
System.String
SYS_PP_MARZA_DEFAULT_DESC
System.String
FIN_CHECK_COMPANY_DATA
System.String
FIN_CHECK_AVAILABILITY
System.String
SYS_HAVE_PNP
System.String
SER_IS_REGISTRACIJA_UNIQUE
System.String
SER_IS_SASIJA_UNIQUE
System.String
SER_USE_YEAR_IN_LABEL
System.String
SER_HAVE_OPERACIJE
System.String
FIN_NO_VP_IN_MP
System.String
SYS_KOM_ALL_SKLADISTA
System.String
DATE_LOCKED_TO
System.String
BASE_VERZIJA_PRODUX
System.String
EVID_STROJEVI_PATH
System.String
CRM_NOTE_PATH
System.String
RM_OB_IZJAVA_PRODAVATELJA
System.String
FIN_ARTICALS_PATH
System.String
SER_HAVE_EVIDENCIJE
System.String
FIN_HAVE_AMBALAZA
System.String
FIN_DESC_FONT_SIZE
System.String
TAX_VALUE
System.Double
BS_NAZIV
System.String
IMG_LOGO
System.String
HEADER_COLOR
System.String
RCPT_ISPORUCITELJ_NAZIV
System.String
RCPT_ISPORUCITELJ_SIFRA
System.String
CompanyName
System.String
OIB
System.String
COMPANY_MB
System.String
ACCOUNT_NUMBER
System.String
ADDRES_STREET
System.String
ADDRESS_CITY
System.String
FIN_HAVE_HZZO_RECEPTI
System.String
RCPT_POMAGALO_TAX_VALUE
System.String
RCPT_NP_VISE
System.String
RCPT_NP_HZZO
System.String
RCPT_HZZO_CompanyName
System.String
RCPT_SIFRA_NADLEZNE_ISPOSTAVE
System.String
FIN_PRINT_PROMET_BLAGAJNICI
System.String
FIN_ISPIS_AMBALAZA_ONLY_ON_DEMAND
System.String
FIN_PODRUZNICA_PRINT
System.String
BASE_CONVERSION_FIX_VALUE
System.String
BASE_VALUTA
System.String
BASE_CONVERSION_FIX_DESCRIPTION
System.String
BASE_CONVERSION_SHOW_INFO
System.String
BASE_CONVERSION_VALUTA
System.String
dsPostavke
C:\NEW\PRODUX_PROJEKT\PRODUX_PRODAJA\_FINANCIJE\DS\dsPostavke.xsd
dtDB_POSTAVKE
String
true
true
Report_Parameter_4
String
true
true
Report_Parameter_5
String
true
true
Report_Parameter_6
String
true
true
Report_Parameter_7
String
true
true
Report_Parameter_8
String
true
true
Report_Parameter_5
String
true
true
Report_Parameter_6
String
true
true
ReportParameter1
String
true
true
ReportParameter1
String
true
true
ReportParameter1
String
true
true
ReportParameter1
String
true
true
ReportParameter1
String
true
true
ReportParameter1
Integer
true
ReportParameter1
Boolean
true
ReportParameter1
Float
true
0
ReportParameter1
Float
true
0
ReportParameter1
Float
true
ReportParameter1
String
0
ReportParameter1
Float
ReportParameter1
Public Function GetImage(ByVal barcodebase64 As String) As Byte()
Return Convert.FromBase64String(barcodebase64)
End Function
hr
true
Cm
56c02fa2-306e-4288-a86b-0e7f4ad9bdf6