<Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="10"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="10"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="2"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="6"><Tile clickConstraint="PERiode<=#{maand}" comment="" content="{#name:ODJ#format:##,####0}" fontsize="4" horizontalAlignment="1" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="1"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout></LayoutPanel><LayoutPanel colspan="10"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="3"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel><Tile clickConstraint="PERiode<=#{maand}" content="#{icon}" horizontalAlignment="0" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="2"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><TileField field="#ODJ-#OVJ as vrs" /><TileField field="iif(#vrs > 0, ' ▲ ' , ' ▼ ') as icon" /><TileField field="iif(#vrs >= 0, '#50BA90' , '#FF2B38') as fc" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile clickConstraint="PERiode<=#{maand}" content="{#name:vp#postfix:%#format:0.0}" horizontalAlignment="2" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="2"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><TileField field="#ODJ-#OVJ as vrs" /><TileField field="iif(#OVJ=0,100,((#vrs/#OVJ)*100)) as vp" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="3"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout></LayoutPanel><LayoutPanel colspan="10"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout>

Sumatra_Package��N��8�OjW!��16�M��w��|�e�cc``cP��KI��wI,q��I�M-Iԫ��ab(~�U~��=��Z�2�$1��=D2Jˡ( �K,(��/)��O1�K��cbH��L��0��y%��y�E'��XP@��Ţ�M"�=T�.f�g.��"bss�V��T]��mN��N!q�z�3��?��"� ��bDx�~x�ǭ|�p��.LP��|�u��* εε�A� �-��P:�:w�ݨO�۳�5�QK��O��%��ij`��X|�|�&Au��s��(��%h�*��4��@�|�O;��7u+6�� 0505a __pkg_Verkoop10_3fkf0jyv6wwv__pp__ This version of the Builder is no longer supported and cannot be used to open this file. Please update to version 5.1.8580 or later to open this file. This file was created with version 5.5.1355 of the Builder. Continuing will downgrade the file and may cause minor differences in functionality. Verkoop

LightPlusDark Placeholder 1 mod0 rcwMbU7pquTOThkhcYcUehPMHzPAlxQ/vY+15fe5niI= 1080 2026-07-09T14:07:49.0455375Z https://licensejwt1.vault.azure.net/keys/ModuleStamping/9d40d28b9c73483bb45c07d9d85b9bfa TlGs3JbmZYHkyJwvPt7QWSjqQOGbhroXdQciRzu3QZSqP33QyQz9bGO8QBjZqSi1Ymmm4Eq7mz1E89UdO/nrCCODcCRu4Q9PDzgopwqooYUsWQJcZNAKq5gl0+BAXY+5yyvx8yo3uFgK+0jgw2FLIholC14LqvPTXSrarCkjYoh4nlLnxmAF0GbGYfYGALixLRV3FYY1sWiVD3KX+duikh3694B9GqeP2+sjuGL+TW5bBK3GXlLVt6hQlgKfsX9xLyvinV5Ah1CTcNs0NrpWiOdXwSc1Qsw8WTfP6qeSqKC/AfNM8D0NAO80ZCQ2AN3/ZDsxkKc/Xbv3VQlbFc7tdg== ProdVer 5.5 Ver0505acolor184, 139, 163color2186, 189, 237)colorTheme3IdisableExcelExport0iconid:23!presnameVerkooptooltip�Overzichten met betrekking tot de verkoopordersv 43)expandTabs1!presname!Notebookv 52�)background)foregroundtitle%DashboardB ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__ top1v7�fieldjaar�field5Jaar-1 as Jr1�fieldmaand|=extraConstraint�(boekjr=#{jaar} OR boekjr=#{Jr1}) AND periode<=#{maand}namecOMZETrowNum0tableOMZALG top0v 51{!Compress1fieldboekjr{!Compress1fieldartcode{fieldyartcode@artbst.oms30 ArtOmschr{!Compress1fieldperiode{fieldomzet{!Compress1fielddebnr{field�debnr@DEBITEUREN.debcode debcode{fieldidebnr@DEBITEUREN.naam NAAM{field}debnr.represent_id represent_id{field�debnr.represent_id.fullname RepNaam{fieldqartcode@ARTBST.artgrp Artgrp{field�artcode@ARTBST.artgrp.groepnaam ArtgrpNaammode0-orientation5horizontalBar5splitPosition 500Vcolumns1v 50�Vcolumns 30v 50�colspan8* )background-disableMenu0)foregroundmarkup0title�Omzet #{jaar} {#name:Maand#prefix: t/m maand }Vcolumns 10)syncPanels1v 50�colspan 10�=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan 10Vcolumns 10)syncPanels1v 50�colspan2�=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan6�=clickConstraintEPERiode<=#{maand}commentQcontent�{#name:ODJ#format:##,####0}!fontsize4MhorizontalAlignment11marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table:cOMZETEverticalAlignment1�field�sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ�field�sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJcolor5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan2�=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan 10Vcolumns 10)syncPanels1v 50 �colspan3�=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237��=clickConstraintEPERiode<=#{maand}content�#{icon}MhorizontalAlignment01marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table:cOMZETEverticalAlignment2�field�sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ�field�sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ�fieldA#ODJ-#OVJ as vrs�field�iif(#vrs > 0, ' ▲ ' , ' ▼ ') as icon�field�iif(#vrs >= 0, '#50BA90' , '#FF2B38') as fccolor5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237��=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan2�=clickConstraintEPERiode<=#{maand}content�{#name:vp#postfix:%#format:0.0}MhorizontalAlignment21marginBottom0)marginLeft0-marginRight0%marginTop0markup11passIncoming1table:cOMZETEverticalAlignment2 �field�sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ�field�sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ�fieldA#ODJ-#OVJ as vrs�field�iif(#OVJ=0,100,((#vrs/#OVJ)*100)) as vpcolor5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan3�=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan 10�=clickConstraintEPERiode<=#{maand}MhorizontalAlignment01passIncoming1EverticalAlignment0color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan8*)background-disableMenu0)foreground-lookupTable$SRNF$markup0title}Omzet per maand #{Jr} tov #{VJ}�!Compress0field1#{Jr1} as VJmarkup0�!Compress0field5#{jaar} as Jrmarkup0!Compress1legend2!passthru11queryHeaders1table:cOMZETv 50)yAxisTitle'Omzet'�fieldperiodetitle'Maand'type -1 field�IIF(boekjr=#{jaar},omzet, 0.0) as ODJ%graphType5titley{#name:jaar#init:YEAR(@today)} field�IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OVJ%graphType4title�{#name:jaar#init:YEAR(@today)}-1color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�colspan 14)expandTabs1v 52�)background)foregroundtitle!Stijgersx)linkTarget1VK_StijgDaalv 50�nameSortByvalue9SUM(#vrs) desc�name%BaseLablevalueITop 10 groei omzet�name Topvalue 10�)background)foregroundtitleDalersvname1VK_StijgDaal�nameSortByvalue%SUM(#vrs)�name%BaseLablevalueqTop 10 achterblijvende omzet�name Topvalue 25)expandTabs1v 52�)background)foregroundtitleKlanten* )background-disableMenu0)foregroundmarkup0title�%BaseLable% klanten {#name:jaar}{#name:maand#prefix: t/m maand }n2IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0!fontsize2=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0sortBy!%SortBy%style3style22table:cOMZET top%Top%v 55�-Aggregation0Hidden05crossTreeType1fielddebcode9fieldLevelType2title'Code'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldnaam9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{jaar},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues� Hidden1field�IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues� Hidden1fieldemax(#{maand} ) as periode9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1�!Compress1)Constraint1Hidden1fielddebnr9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1�)background)foregroundtitle%Artikelen* )background-disableMenu0)foregroundmarkup0title�%BaseLable% {#name:jaar}{#name:maand#prefix: t/m maand }n2IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0!fontsize2=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0sortBy!%SortBy%style3style22table:cOMZET top%Top%v 55�-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldartcode9fieldLevelType2title%'Artikel'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field%ArtOmschr9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{jaar},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues� Hidden1field�IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues� Hidden1fieldemax(#{maand} ) as periode9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1�Vcolumns 30v 50�colspan 16* )background-disableMenu0)foregroundmarkup0title-Orderintake!Compress1=extraConstraint� (YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)0.01IhorizontalBarChart1legend2%stackBars1table:cOMZETv 51�field%(PERIODE)type1 fieldomzet�field�CAST(represent_id as varchar) + ' - ' +RepNaam as RepNaamtype1color5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�%condition!periode=)expandTabs1v 52�)background)foregroundtitleKlantmode0-orientation-verticalBar5splitPosition 500mode0-orientation5horizontalBar5splitPosition 500B ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__ top1v7�field9Jaar as {year}�fieldU#{periode} as {month}x)linkTarget=Omz_JrVrg_Klantv 50vnameAOmz_JrVrg_ArtGrp* )background-disableMenu0)foregroundmarkup0title�Artikelgroep{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3comment�[Converted from Table on 13-2-2019 13:37:03] 5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint�(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableMSV_OmzetFact__pkg__v 55�-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldaartcode@ITEMS.Assortment9fieldLevelType2!sortType1title'Code'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field�artcode@ITEMS.Assortment.Description9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title�'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title�'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValuesvnameEOmz_JrVrg_Artikel�name5AddConstraint* )background-disableMenu0)foregroundmarkup0title�Artikel{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3comment�[Converted from Table on 13-2-2019 13:37:03] 5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint7(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1) %AddConstraint%=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableMSV_OmzetFact__pkg__v 55�-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldartcode9fieldLevelType2!sortType1title'Code'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldeartcode@ITEMS.Description9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title�'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title�'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�)background)foregroundtitle1Artikelgroepmode0-orientation5horizontalBar5splitPosition 500B ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__ top1v7�field9Jaar as {year}�fieldU#{periode} as {month}x)linkTargetAOmz_JrVrg_ArtGrpv 50x)linkTargetEOmz_JrVrg_Artikelv 50�%condition%(artcode=B ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__ top1v7�field9Jaar as {year}�fieldU#{periode} as {month}mode2-orientation5horizontalBar5splitPosition 306* )background-disableMenu0)foregroundmarkup0title�Klanten{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3comment�[Converted from Table on 13-2-2019 13:37:03] 5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint�debnr = #{debnr} AND (boekjr=#{year} OR boekjr=CAST(#{year} as INT)-1) AND periode<=#{month}=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableOMZALGv 44�-Aggregation0Hidden05crossTreeType1fieldadebnr@DEBITEUREN.debcode9fieldLevelType2!sortType1title'Code'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldUdebnr@DEBITEUREN.naam9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title�'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title�'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�!Compress1)Constraint1Hidden1fielddebnr9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1*)background-disableMenu0)foreground-lookupTable$SRNF$markup0title�Omzet verloop |||#{JaarFrom} - #{JaarTm} periode #{periode}�!Compress0fieldE#{year} as JaarTmmarkup0�!Compress0fieldU#{year}-2 as JaarFrommarkup0=extraConstraint'debnr = #{debnr} AND (boekjr=#{year} AND periode<=#{month}) OR ( boekjr<#{year} AND boekjr>=CAST(#{year} as INT)-2)tableOMZALGv 50�fieldYboekjr + '-' + periodetype1 fieldomzet%graphType7titleomzetcolor5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�%condition(datum=x)linkTargetEOmz_JrVrg_Artikelv 50�%condition(debnr=B ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__ top1v7�field9Jaar as {year}�fieldU#{periode} as {month}mode2-orientation5horizontalBar5splitPosition 306* )background-disableMenu0)foregroundmarkup0title�Artikel{#name:Month#prefix: t/m maand }n0IcolHHInSeparateCol0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme3comment�[Converted from Table on 13-2-2019 13:37:03] 5depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint�debnr = #{debnr} AND (boekjr=#{year} OR boekjr=CAST(#{year} as INT)-1) AND periode<=#{month}=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableOMZALGv 44�-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldartcode9fieldLevelType2!sortType1title'Code'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldeartcode@ITEMS.Description9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title�'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title�'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues*)background-disableMenu0)foreground-lookupTable$SRNF$markup0title�Omzet verloop |||#{JaarFrom} - #{JaarTm} periode #{periode}�!Compress0fieldE#{year} as JaarTmmarkup0�!Compress0fieldU#{year}-2 as JaarFrommarkup0=extraConstraint'debnr = #{debnr} AND (boekjr=#{year} AND periode<=#{month}) OR ( boekjr<#{year} AND boekjr>=CAST(#{year} as INT)-2)tableOMZALGv 50�fieldYboekjr + '-' + periodetype1 fieldomzet%graphType7titleomzetcolor5113, 188, 158%color.alt180, 186, 144color1252, 153, 49%color.alt1252, 153, 49color-223, 41, 54%color.alt-255, 43, 56color)1, 102, 94%color.alt5244, 244, 244color5102, 207, 228%color.alt138, 161, 219color5195, 217, 228%color.alt143, 103, 122color128, 139, 133%color.alt128, 139, 133color-225, 58, 40%color.alt-218, 113, 4color-127, 33, 27%color.alt5254, 124, 124color)23, 51, 52%color.alt5178, 178, 178color132, 155, 181%color.alt5123, 225, 247color184, 139, 163%color.alt186, 189, 237�%condition)(PERIODE)=mode0-orientation-verticalBar5splitPosition 500* )background-disableMenu0)foregroundmarkup0title�Omzet per artikelgroep||| #{RepNaam}n0IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru11queryHeaders0ArowLevelExpanded0QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style20table:cOMZETv 55�-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldArtgrp9fieldLevelType2!sortType1title1Artikelgroep�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field)ArtgrpNaam9fieldLevelType2titleNaam�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldomzet9fieldLevelType2format!#,##0.00titleOmzetkcolor5negativeColor�footerheadermodeValues�footerheadermodeValues* )background-disableMenu0)foregroundmarkup0title}Omzet per artikel||| #{RepNaam}n0IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple0!passthru01queryHeaders0ArowLevelExpanded0QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style0style20table:cOMZETv 55�-Aggregation0!Compress1)Constraint1Hidden05crossTreeType1fieldartcode9fieldLevelType2titleArtikel�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1field%ArtOmschr9fieldLevelType2title1Omschrijving�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldomzet9fieldLevelType2format!#,##0.00titleOmzetkcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�%condition=IIF(YEAR(orddat�fromwIIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,orddat,DATEADD(YY,+1,orddat))= to�IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,orddat,DATEADD(YY,+1,orddat))<=mode0-orientation-verticalBar5splitPosition 500* )background-disableMenu0)foregroundmarkup0title�Orderintake per artikelgroep|||{#name:Orddat#prefix:T/m }n2IcolHHInSeparateCol0AcolLevelExpanded0ucollapseSingleResultColGroups0ucollapseSingleResultRowGroups0)colorTheme35depthFirstCol05depthFirstRow0IdisableExcelExport0=extraConstraint� (YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)=CAST(#{year} as INT)-1)=hideColOfTotals0)hideCorner0AhideResultTitles0=hideRowOfTotals0UlevelColorsDescending01markupTitles0!multiple1!passthru11queryHeaders1QshowColOfTotalsFirst0QshowRowOfTotalsFirst0style3style22tableOMZALGv 55�-Aggregation0Hidden05crossTreeType1fieldadebnr@DEBITEUREN.debcode9fieldLevelType2!sortType1title%'Relatie'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType1fieldUdebnr@DEBITEUREN.naam9fieldLevelType2title'Naam'�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF(boekjr=#{year},omzet, 0.0) as Omz9fieldLevelType2format!#,##0.00title�'Omzet ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3field�IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj9fieldLevelType2format!#,##0.00title�'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation1Hidden05crossTreeType3fieldY(#Omz)-(#OmzVj) as vrs9fieldLevelType2format!#,##0.00title)'Verschil'kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�-Aggregation3Hidden05crossTreeType 13field#vrsfield2!(#OmzVj)9fieldLevelType2format0.0%title '%'�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden0%alignment15crossTreeType3field#vrs9fieldLevelType2format1;"";"";"";""%textWidth 100title'+/-'kcolor5113, 188, 158!gradient15negativeColor-223, 41, 54�footerheadermodeValues�footerheadermodeValues�-Aggregation0Hidden05crossTreeType3field}IIF(boekjr=#{year},aantal, 0.0)9fieldLevelType2format#,##0title�'Aantal ' + {#name:Year#init:Year(@today)} kcolor5negativeColor�footerheadermodeValues�footerheadermodeValues�!Compress1)Constraint1Hidden1fielddebnr9fieldLevelType2=irr_Aggregation0Eirr_crossTreeType1x)linkTargetAOmz_JrVrg_ArtGrpv 50x)linkTargetEOmz_JrVrg_Artikelv 50�name5AddConstraint�)background)foregroundtitle1Artikelgroepmode0-orientation5horizontalBar5splitPosition 500B ElookupUseIncoming0!passthru1tableISV_DEFAULTS__pkg__ top1v7�field9Jaar as {year}�fieldU#{periode} as {month}x)linkTargetAOmz_JrVrg_ArtGrpv 50x)linkTargetEOmz_JrVrg_Artikelv 50�name5AddConstraint�.�)background)foregroundtitle)Openstaand)expandTabs1v 52�)background)foregroundtitleOrders%hideClear1v 54 � fieldafldatflags4size 10titleUAfleverdatum regel =<type2�fieldselcodeflags0title1Selectiecodetype1�-initialText)-- Alle --orderbyselcode9resetSelection0tableordseltitle]selcode + ' - ' + oms30valueselcodeEvalueIsConstraint0� field)debnr.naamflags1024size 10titleMNaam debiteur bevattype1�flags0title)Uitsluitentype1�EvalueIsConstraint1�title1'-- Alle --'�title7'Contracten (' + ..\\setup.orders_contract_order_selectioncode + ')'valueGselcode<>setup.orders_contract_order_selectioncode or selcode is null�titleG'Service-ord. (' + ..\\setup.orders_service_order_selectioncode + ')'value7selcode<>setup.orders_service_order_selectioncode or selcode is null�titleQ'Contract & Service'value�(selcode<>setup.orders_service_order_selectioncode AND selcode<>setup.orders_contract_order_selectioncode) or selcode is nullmode0-orientation5horizontalBar5splitPosition 500* )background)foregroundmarkup0!presname%Kopregelstitle� Orderportefeuille||| {#name:afldat#prefix:Afleverdatm<:#postfix: }{#name:debnr.naam#prefix:Debnaam bevat:#postfix: }{#name:selcode#prefix:Selcode:#postfix: }IdisableExcelExport0!presnameorkrgsortByorddattable%televeren top0v 54 �-Aggregation0!Compress1)Constraint1fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldselcode!presnameSelctitleSelctype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(debnr)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field%docnumber!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field-nettobedragformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldYprijs_n_val*esr_aantalformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1field-orkrg.koersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1field�orkrg.represent_id.fullname + ' (' + orkrg.represent_id + ')'format#!presname Vertitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field=orkrg.projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field=orkrg.routecode!presnameRoutetitleRoutetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field1orkrg.afldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(orkrg.fakdebnr)@(cicmpy:ix_debnr.debcode)!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldq(orkrg.fakdebnr)@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValuesvnameMVerkooporderdetailsmode2-orientation-verticalBar!presname!Verdeler5splitPosition 800* )background)foregroundmarkup0!presname%SubregelstitleqOrderregels order #{ordernr}IdisableExcelExport0!presnameorsrxsortByregeltableorsrx top0v 54(�-Aggregation0fieldregeltitle R.type4�footerheadermodeValues�footerheadermodeValues� -Aggregation0fieldartcode!presnameArtikeltitleArtikeltype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldoms45!presname1Omschrijvingtitle1Omschrijvingtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field!unitcodetitleEenheidtype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0fieldUesr_aantal/unitfactorformat#,##0title1Aantal Eenh.type6�footerheadermodeValues�footerheadermodeValues�-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitle5Aantal Vk.Vp.type6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Negative1!Positive1fieldqafldat=22991231?esr_aantal:0format#,##0!presname%Backordertitle%Wv. Back.type6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Negative1!Positive1field)aant_gelevformat#,##0!presnameGelevtitleGelev.type6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field�btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation0field=ordernr.valcodetitleVal.type1�footerheadermodeValues�footerheadermodeValues�-Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presnameBedragtitle)Bedrag Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field�esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleBedragtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldmagcode!presname Magtitle Magtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field-instruction!presname=Instructieregeltitle=Instructieregeltype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field�res_id.fullname + ' (' + res_id + ')'title)Medewerkertype1�footerheadermodeValues�footerheadermodeValuesmode0-orientation5horizontalBar!presname)Documenten5splitPosition 500* )background)foregroundmarkup0!presnameTiteltitleUGekoppelde documenten!presname)Translator�fromordernr to-OrderNumber IdisableExcelExport0!presnameTabletable=bacodiscussions top0v 54 �-Aggregation0)Constraint1field HIDformat#,##0!presname HIDtitleNummertype3�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldSubject!presname%Onderwerptitle%Onderwerptype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field-CreatedDateformat)d MMM yyyy!presname-CreatedDatetitle)Aangemaakttype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldAType.Description!presnameTypetitleTypetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field!JobLevelformat#,##0!presname!JobLeveltitleIBeveiligingsniveautype3�footerheadermodeValues!presname)background�footerheadermodeValues* )background)foregroundmarkup0!presnameTitletitle!Documentfield!document!presnamePictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0�)background)foregroundtitle!Facturen%hideClear1v 54�field%fakt_codeflags0title-Factuurcodetype1�-initialText)-- Alle --orderby%fakt_code9resetSelection0tableFAKCODtitle]fakt_code + ' ' + oms40value%fakt_codeEvalueIsConstraint0mode0-orientation5horizontalBar5splitPosition 500* )background)foregroundmarkup0!presnameTiteltitle'Niet-definitief afgedrukte facturen {#name:fakt_code#prefix:Factuurcode:#postfix: } IdisableExcelExport0!presnamefrkrgtablefrkrg top0v 54&�-Aggregation0)Constraint1field%fakt_code!presname Fctitle Fctype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0)Constraint1field)volgnr_fak!presname Nrtitle Nrtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldrefer!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(fakdebnr)@(cicmpy:ix_debnr.debcode)!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQfakdebnr@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field1represent_id!presnameVerttitleVerttype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldtot_bdrformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field5tot_bdr/koersformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field�[inv_in_vv='J']?[[frkrgx.vrachtkost*koers]:[frkrgx.vrachtkost]]format!#,##0.00!presnameVrachttitleVrachttype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field�[inv_in_vv='J']?[[frkrgx.orderkost*koers]:[frkrgx.orderkost]]format!#,##0.00!presnameOrdertitleOrdertype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%fakt_kortformat!#,##0.00!presnameKort%titleKort%type3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field�(debnr)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValuesvnameyFactuurregels (niet afgedrukt)* )background)foregroundmarkup0!presname!Facturentitle�Factuurregels #{fakt_code} #{volgnr_fak}IdisableExcelExport0!presname!FacturensortByregeltablefrsrg top0v 54�-Aggregation0fieldregeltitle r.type4�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldartcodetitle-Artikelcodetype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldoms45title1Omschrijvingtype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0field!unitcodetitleEenheidtype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0fieldUesr_aantal/unitfactorformat#,##0title-Aant. Eenh.type6�footerheadermodeValues�footerheadermodeValues�-Aggregation1field)esr_aantalformat#,##0!presnameAantaltitle=Aant. Vk. Verp.type3�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00title=Br. Prijs Val type6�footerheadermodeValues�footerheadermodeValues�-Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field�btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00!presnamePrijstitle=Netto Pr. Val type6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presname)Bedrag valtitle)Bedrag Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field5frkrg.valcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field�esr_aantal*(#nettoprijsval)*koersformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldmagcode!presname Magtitle Magtype1�footerheadermodeValues!presname)background�footerheadermodeValues�)background)foregroundtitle-Orderintake)expandTabs1v 52�)background)foregroundtitle!Per Week%hideClear1v 54�field!peiljaarflags2048format!#,##0.00!presname!PeiljaartitleJaartype3�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0�field%weekvanafflags2048!presname)Week vanafsize3title)Week vanaftype3�value1�fieldweektmflags2048!presname!Week t/msize3title!Week t/mtype3�value 53mode0-orientation5horizontalBar!presnameIntake5splitPosition 250* )background)foregroundmarkup0!presname=Intake per weektitle=Intake per weekb!Compress1=extraConstraint�(ord_soort='V' or ord_soort='A') AND datepart(isoyear, orddat)>cast(#{peiljaar} as float)-2 and datepart(isoyear, orddat)={#name:weekvanaf#default:1} and week(orddat)<={#name:weektm#default:53}legend1!passthru1!presname12,5D GrafieksortBy1week(orddat)tableorkrgv 51�field1week(orddat)!presnameWeektitleWeektype -1 fieldAbdr_ev_val*koers!presname-Orderbedragtitle-Orderbedrag�fieldedatepart(isoyear, orddat)!presnameJaartitleJaartype -1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode0-orientation5horizontalBar!presnameOrders5splitPosition 500* )background)foregroundmarkup0!presname%KopregelstitlewOrders {#name:datepart(isoyear, orddat)#format:0.} - week {#name:week(orddat)#format:0.}IdisableExcelExport0=extraConstraintyord_soort='V' or ord_soort='A'!presnameorkrgtableorkrg top0v 54&�-Aggregation0)Constraint1fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldselcode!presnameSelctitleSelctype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(debnr)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field%docnumber!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�represent_id.fullname + ' (' + represent_id + ')'!presname Vertitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldAbdr_ev_val*koersformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)bdr_ev_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field]orkrgx.vrachtkost*koersformat!#,##0.00!presnameVrachttitleVrachttype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldYorkrgx.orderkost*koersformat!#,##0.00!presnameOrdertitleOrdertype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)order_kortformat!#,##0.00!presnameKort%titleKort%type3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field%routecode!presnameRoutetitleRoutetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(fakdebnr)@(cicmpy:ix_debnr.debcode)!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQfakdebnr@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValuesx)linkTargetMVerkooporderdetailsv 50�)background)foregroundtitleUPer Vertegenwoordiger%hideClear1v 54 �field!peiljaarflags2048format!#,##0.00!presnameJaartitleJaartype3�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0� field1represent_idflags0!presname1represent_idtitleEVertegenwoordigertype1�)constraintUcicmpy.cmp_acc_man<>0groupbyIcicmpy.cmp_acc_man-initialText)-- Alle --orderbymcicmpy.cmp_acc_man.fullname9resetSelection0table)debiteurentitle�cicmpy.cmp_acc_man.fullname + ' (' + cicmpy.cmp_acc_man +')'valueIcicmpy.cmp_acc_manEvalueIsConstraint0�field%weekvanafflags2048!presname)Week vanafsize3title)Week vanaftype3�value1�fieldweektmflags2048!presnameWeek tmsize3titleWeek tmtype3�value 53mode0-orientation5horizontalBar!presnameIntake5splitPosition 250* )background)foregroundmarkup0!presname=Intake per weektitle�Intake per Vertegenwoordiger - #{peiljaar}b!Compress1=extraConstraintg (ord_soort='V' or ord_soort='A') AND YEAR(orddat)=cast(#{peiljaar} as float) and week(orddat)>={#name:weekvanaf#default:1} and week(orddat)<={#name:weektm#default:53}legend1!passthru1!presname12,5D GrafieksortBy1week(orddat)tableorkrgv 51�field1week(orddat)!presnameWeektitleWeektype -1 fieldAbdr_ev_val*koers!presname-Orderbedragtitle-Orderbedrag�fieldUrepresent_id.fullname!presnameEVertegenwoordigertitleEVertegenwoordigertype -1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode0-orientation5horizontalBar!presnameOrders5splitPosition 500* )background)foregroundmarkup0!presname%Kopregelstitle7Orders {#name:peiljaar#format:0.} - week {#name:week(orddat)#format:0.} - Vertegenwoordiger #{represent_id.fullname}IdisableExcelExport0=extraConstraint�(ord_soort='V' or ord_soort='A') and YEAR(orddat)=#{peiljaar}!presnameorkrgtableorkrg top0v 54&�-Aggregation0)Constraint1fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldselcode!presnameSelctitleSelctype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(debnr)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field%docnumber!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�represent_id.fullname + ' (' + represent_id + ')'!presname Vertitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldAbdr_ev_val*koersformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)bdr_ev_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field]orkrgx.vrachtkost*koersformat!#,##0.00!presnameVrachttitleVrachttype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldYorkrgx.orderkost*koersformat!#,##0.00!presnameOrdertitleOrdertype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)order_kortformat!#,##0.00!presnameKort%titleKort%type3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field%routecode!presnameRoutetitleRoutetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(fakdebnr)@(cicmpy:ix_debnr.debcode)!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQfakdebnr@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValuesx)linkTargetMVerkooporderdetailsv 50�)background)foregroundtitle5Per Invoerder%hideClear1v 54 �field!peiljaarflags2048format!#,##0.00!presnameJaartitleJaartype3�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0� fielduser_idflags0!presname%Invoerdertitle%Invoerdertype1�)constraint�BackOfficeBlocked='N' or blocked='N'-initialText)-- Alle --orderby!fullname9resetSelection0tablehumrestitle!fullnamevalue9left(usr_id,8)EvalueIsConstraint0�field%weekvanafflags2048!presname)Week vanafsize3title)Week vanaftype3�value1�fieldweektmflags2048!presnameWeek tmsize3titleWeek tmtype3�value 53mode0-orientation5horizontalBar!presnameIntake5splitPosition 250* )background)foregroundmarkup0!presname=Intake per weektitle�Intake per Invoerder - #{peiljaar}b!Compress1=extraConstraintw (ord_soort='V' or ord_soort='A') AND YEAR(orddat)=#{peiljaar} and week(orddat)>={#name:weekvanaf#default:1} and week(orddat)<={#name:weektm#default:53}legend1!passthru1!presname12,5D GrafieksortBy1week(orddat)tableorkrgv 51�field1week(orddat)!presnameWeektitleWeektype -1 fieldAbdr_ev_val*koers!presname-Orderbedragtitle-Orderbedrag�fielduser_id!presname%Invoerdertitle%Invoerdertype -1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode0-orientation5horizontalBar!presnameOrders5splitPosition 500* )background)foregroundmarkup0!presname%Kopregelstitle�Orders {#name:peiljaar#format:0.} - week {#name:week(orddat)#format:0.} - Invoerder #{user_id}IdisableExcelExport0=extraConstraint�(ord_soort='V' or ord_soort='A') and YEAR(orddat)=#{peiljaar}!presnameorkrgtableorkrg top0v 54&�-Aggregation0)Constraint1fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldselcode!presnameSelctitleSelctype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(debnr)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field%docnumber!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�represent_id.fullname + ' (' + represent_id + ')'!presname Vertitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldAbdr_ev_val*koersformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)bdr_ev_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field]orkrgx.vrachtkost*koersformat!#,##0.00!presnameVrachttitleVrachttype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldYorkrgx.orderkost*koersformat!#,##0.00!presnameOrdertitleOrdertype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)order_kortformat!#,##0.00!presnameKort%titleKort%type3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field%routecode!presnameRoutetitleRoutetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(fakdebnr)@(cicmpy:ix_debnr.debcode)!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQfakdebnr@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValuesx)linkTargetMVerkooporderdetailsv 50�)background)foregroundtitle5Orderhistorie%hideClear1!presname5Orderhistoriev 54�field1YEAR(orddat)flags0format 00!presnameJaartitle%Orderjaartype9�)constraintabkjrcode<=YEAR(@today)+1groupbyUcast(bkjrcode as int)-initialText)-- Alle --orderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalueUcast(bkjrcode as int)EvalueIsConstraint0�field5month(orddat)flags0!presnamePeriodesize5title)Ordermaandtype1�field)pakbon_datflags0!presname-Pakbondatumsize9title-Pakbondatumtype2�field�(fakdebnr)@(cicmpy:ix_debnr.debcode)flags0!presname=Factuurdebiteursize5title=Factuurdebiteurtype1� field1represent_idflags0!presname1represent_idtitleEVertegenwoordigertype1�)constraintUcicmpy.cmp_acc_man<>0groupbyIcicmpy.cmp_acc_man-initialText)-- Alle --orderbymcicmpy.cmp_acc_man.fullname9resetSelection0table)debiteurentitle�cicmpy.cmp_acc_man.fullname + ' (' + cicmpy.cmp_acc_man +')'valueIcicmpy.cmp_acc_manEvalueIsConstraint0� fieldvalcodeflags0!presnameValutatitleValutatype1�)constraint)active='J'-initialText)-- Alle --orderbyvalcode9resetSelection0tablevalutatitlevalcodevaluevalcodeEvalueIsConstraint0�fieldorddatflags0!presname)Orderdatumsize9title)Orderdatumtype2�field�(debnr)@(cicmpy:ix_debnr.debcode)flags0!presname5Orderdebiteursize5title5Orderdebiteurtype1�fieldselcodeflags0title1Selectiecodetype1�-initialText)-- Alle --orderbyselcode9resetSelection0tableordseltitle]selcode + ' - ' + oms30valueselcodeEvalueIsConstraint0�field%routecodeflags0!presnameRoutesize5titleRoutetype1mode0-orientation5horizontalBar!presnamepanel25splitPosition 500*)background)foregroundmarkup0title�Orderhistorie|||{#name:YEAR(orddat)#prefix:Jaar:#postfix: }{#name:pakbon_dat#prefix:Pakbondatum:#postfix: }{#name:(fakdebnr)@(cicmpy:ix_debnr.debcode)#prefix:Fakdebnr:#postfix: }{#name:verteg#prefix:Vert.:#postfix: }{#name:valcode#prefix:Val.:#postfix: }{#name:month(orddat)#prefix:Maand:#postfix: }{#name:orddat#prefix:Ord.dat.:#postfix: }{#name:(debnr)@(cicmpy:ix_debnr.debcode)#prefix:Debnr.:#postfix: }{#name:selcode#prefix:Sc.:#postfix: }{#name:routecode#prefix:Route:}IdisableExcelExport0=extraConstraint�afgehandld='J' and (ord_soort='V' or ord_soort='A')!presnameorkrgsortByordernrtableorkrg top0v 54&�-Aggregation0)Constraint1fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldselcode!presnameSelctitleSelctype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(debnr)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field%docnumber!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�represent_id.fullname + ' (' + represent_id + ')'!presname Vertitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldAbdr_ev_val*koersformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)bdr_ev_valformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field]orkrgx.vrachtkost*koersformat!#,##0.00!presnameVrachttitleVrachttype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldYorkrgx.orderkost*koersformat!#,##0.00!presnameOrdertitleOrdertype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field)order_kortformat!#,##0.00!presnameKort%titleKort%type3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field%routecode!presnameRoutetitleRoutetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�(fakdebnr)@(cicmpy:ix_debnr.debcode)!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQfakdebnr@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValuesx)linkTargetMVerkooporderdetailsv 50�)background)foregroundtitle5Omzethistorie)expandTabs1v 52 �)background)foregroundtitle=Factuurhistorie%hideClear1!presname=Factuurhistoriev 54�field!bkjrcodeflags0format 00!presnameJaartitleJaartype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcode-initialText)-- Alle --orderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0�fieldfakdatflags0!presname1Factuurdatumsize9title1Factuurdatumtype2�field�(fakdebnr)@(cicmpy:ix_debnr.debcode)flags0!presname=Factuurdebiteursize5title=Factuurdebiteurtype1� field1represent_idflags0!presname1represent_idtitleEVertegenwoordigertype1�)constraintUcicmpy.cmp_acc_man<>0groupbyIcicmpy.cmp_acc_man-initialText)-- Alle --orderbymcicmpy.cmp_acc_man.fullname9resetSelection0table)debiteurentitle�cicmpy.cmp_acc_man.fullname + ' (' + cicmpy.cmp_acc_man +')'valueIcicmpy.cmp_acc_manEvalueIsConstraint0� fieldvalcodeflags0!presnameValutatitleValutatype1�)constraint)active='J'-initialText)-- Alle --orderbyvalcode9resetSelection0tablevalutatitlevalcodevaluevalcodeEvalueIsConstraint0�fieldorddatflags0!presname)Orderdatumsize9title)Orderdatumtype2�field�(debnr)@(cicmpy:ix_debnr.debcode)flags0!presname5Orderdebiteursize5title5Orderdebiteurtype1�fieldselcodeflags0title1Selectiecodetype1�-initialText)-- Alle --orderbyselcode9resetSelection0tableordseltitle]selcode + ' - ' + oms30valueselcodeEvalueIsConstraint0mode0-orientation5horizontalBar!presnamepanel25splitPosition 500vname=Factuurhistorie*)background)foregroundmarkup0title�Factuurhistorie {#name:bkjrcode#prefix:Jaar:#postfix: }{#name:fakdat#prefix:factuurdatum:#postfix: }{#name:(fakdebnr)@(cicmpy:ix_debnr.debcode)#prefix:Fakdebnr:#postfix: }{#name:represent_id#prefix:Vert.:#postfix: }{#name:valcode#prefix:Val.:#postfix: }{#name:orddat#prefix:Ord.dat.:#postfix: }{#name:(debnr)@(cicmpy:ix_debnr.debcode)#prefix:Debnr.:#postfix: }{#name:selcode#prefix:Sc.:#postfix: }IdisableExcelExport0!presnamefrhkrgsortByfaknrtablefrhkrg top0v 54(�-Aggregation0)Constraint1fieldfaknr!presnameFactuurtitleFactuurtype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldfakdatformat)d MMM yyyy!presname1Factuurdatumtitle1Factuurdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldordernr!presnameOrdertitleOrdertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldrefer!presname)Referentietitle)Referentietype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldorddatformat)d MMM yyyy!presname)Orderdatumtitle)Orderdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldW[fakdebnr='']?[(debnr)@(cicmpy:ix_debnr.debcode):(fakdebnr)@(cicmpy:ix_debnr.debcode)]!presnameFactdebtitleFactdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�[[''+fakdebnr@debitr.naam]='']?[[''+debnr.naam]:[''+fakdebnr@debitr.naam]]!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�represent_id.fullname + ' (' + represent_id + ')'!presnameVerttitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldtot_bdrformat!#,##0.00!presnameBedragtitleBedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field5tot_bdr/koersformat!#,##0.00!presname)Bedrag valtitle)Bedrag valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldvalcode!presname Valtitle Valtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldkoersformat!#,##0.00!presnameKoerstitleKoerstype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldIfrhkrgx.vrachtkostformat!#,##0.00!presnameVrachttitleVrachttype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldEfrhkrgx.orderkostformat!#,##0.00!presnameOrdertitleOrdertype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%fakt_kortformat!#,##0.00!presnameKort%titleKort%type3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field%projectnrtitleProjecttype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0field�(orddeb)@(cicmpy:ix_debnr.debcode)!presname!Orderdebtitle!Orderdebtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldIorddeb@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldselcode!presnameSelctitleSelctype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field!bkjrcode!presnameJaartitleJaartype4�footerheadermodeValues!presname)background�footerheadermodeValuesvnameYFactuurhistoriedetailsmode2-orientation-verticalBar!presname!Verdeler5splitPosition 800*)background)foregroundmarkup0titleYFactuurregels #{faknr}IdisableExcelExport0!presnameorsrxsortByregeltablefrhsrx top0v 54"�-Aggregation0fieldregeltitle R.type4�footerheadermodeValues�footerheadermodeValues� -Aggregation0fieldartcode!presnameArtikeltitleArtikeltype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldoms45!presname1Omschrijvingtitle1Omschrijvingtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field!unitcodetitleEenheidtype1�footerheadermodeValues�footerheadermodeValues� -Aggregation0fieldUesr_aantal/unitfactorformat#,##0title1Aantal Eenh.type6�footerheadermodeValues�footerheadermodeValues�-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitle5Aantal Vk.Vp.type6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field�btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field-korting/100format#,##0%!presnameKort%titleKort%type6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation0field=ordernr.valcodetitleVal.type1�footerheadermodeValues�footerheadermodeValues�-Aggregation1fieldmesr_aantal*(#nettoprijsval)format!#,##0.00!presnameBedragtitle)Bedrag Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field�esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleBedragtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation0field=btw_code.btwperformat!#,##0.00!presnameBTW%titleBTW%type3�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)prijslijst!presnamePrijsltitlePrijsltype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldmagcode!presname Magtitle Magtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldafldatformat)d MMM yyyy!presname)Leverdatumtitle)Leverdatumtype2�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field�res_id.fullname + ' (' + res_id + ')'title)Medewerkertype1�footerheadermodeValues�footerheadermodeValuesmode0-orientation5horizontalBar!presname)Documenten5splitPosition 500* )background)foregroundmarkup0!presnameTiteltitleUGekoppelde documenten!presname)Translator�fromfaknr toOurRef�from!dagbknr= to'xyz'<>�fromfakdat= to'xyz'<> IdisableExcelExport0!presnameTabletable=bacodiscussions top0v 54 �-Aggregation0)Constraint1field HIDformat#,##0!presname HIDtitleNummertype3�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldSubject!presname%Onderwerptitle%Onderwerptype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field-CreatedDateformat)d MMM yyyy!presname-CreatedDatetitle)Aangemaakttype2�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldAType.Description!presnameTypetitleTypetype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field!JobLevelformat#,##0!presname!JobLeveltitleIBeveiligingsniveautype3�footerheadermodeValues!presname)background�footerheadermodeValues* )background)foregroundmarkup0!presnameTitletitle!Documentfield!document!presnamePictureshrink1table=Bacodiscussionsv 51UwebclientAutoDownload0�)background)foregroundtitlemOmzet per vertegenwoordiger%hideClear1!presname-SearchPanelv 54 � field)bkjrcodevaflags2048!presname!Boekjaartitle9Boekjaar vanaftype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0� field)bkjrcodetmflags2048!presname1Boekjaar t/mtitle1Boekjaar t/mtype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0�field%periodevaflags2048format#!presname5Periode vanaftitle5Periode vanaftype3�groupbyper_finorderbyper_fin9resetSelection0!selected%per_fin=1tableperdattitleper_finvalueper_finEvalueIsConstraint0�field%periodetmflags2048format#!presname-Periode t/mtitle-Periode t/mtype3�groupbyper_finorderby1per_fin desc9resetSelection0tableperdattitleper_finvalueper_finEvalueIsConstraint0mode0-orientation-verticalBar!presname!Splitter5splitPosition 200* )background)foregroundmarkup0!presnameTitletitle]Selecteer medewerker(s)IdisableExcelExport0=extraConstraintmdebnr<>'' and cmp_acc_man>0!multiple1!passthru1!presnamesource2sortBy-cmp_acc_mantablecicmpy top0�-Aggregation0!Compress1)Constraint1field-cmp_acc_man!presname-TableColumntitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQcmp_acc_man.fullname!presname-TableColumntitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�from-cmp_acc_man toverteg)expandTabs1!presname!Notebookv 52�)background)foregroundtitleLijstmode0-orientation5horizontalBar!presname!Splitter5splitPosition 333*)background)foregroundmarkup0title�Omzet per vertegenwoordiger|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }IdisableExcelExport0=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})!presnameLijstsortByUverteg,boekjr,periodetableomzdeb top0v 54�-Aggregation0!Compress1)Constraint1fieldverteg!presname Vertitle Vertype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field=humres.fullname!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1)Constraint1fieldboekjr!presnameJaartitleJaartype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1)Constraint1fieldperiode!presname Pertitle Pertype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldaantalformat#,##0!presnameAantaltitleAantaltype3�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field!br_prijsformat!#,##0.00!presnameBrutotitleBrutotype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldomzetformat!#,##0.00!presnameNettotitleNettotype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field9br_prijs-omzetformat!#,##0.00!presnameKortingtitleKortingtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldmargeformat!#,##0.00!presnameMargetitleMargetype6�footerheadermodeValues!presname)background�footerheadermodeValuesmode0-orientation5horizontalBar5splitPosition 300* )background)foregroundmarkup0!presname!FacturentitleMDetails per Factuur!presname)Translator� to�bkjrcode=#{boekjr} and per_fin=#{periode}Btableperdatv4�)constraint1field�'fakdat>='+datepart(yyyymmdd,bgdatum)+' and fakdat<='+datepart(yyyymmdd,eddatum) + ' and res_id=' + #{verteg}EvalueIsConstraint1IdisableExcelExport0!presnameorsrxsortByfaknrtablefrhsrx top0v 54�-Aggregation0!Compress1)Constraint1fieldfaknrtitle)Factuurnr.type4�footerheadermodeValues�footerheadermodeValues�-Aggregation0field�(frhkrg.debnr)@debiteuren.debcodetitleDebcodetype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldy(frhkrg.debnr)@debiteuren.naamtitleNaamtype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitleAantaltype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0Hidden1field�btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0Hidden1field�btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation1field�esr_aantal*(#brutoprijsval)*koersformat!#,##0.00!presnameBedragtitleBrutotype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field�esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleNettotype6�footerheadermodeValues�footerheadermodeValues� -Aggregation1field'((esr_aantal*(#brutoprijsval))-(esr_aantal*(#nettoprijsval)))*koersformat!#,##0.00titleKortingtype6�footerheadermodeValues�footerheadermodeValuesx)linkTargetYFactuurhistoriedetailsv 50�)background)foregroundtitleiGrafiek per Jaar per Vert.*)background)foregroundmarkup0title�Omzet per vertegenwoordiger|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzdebv 43�fieldboekjr!presnameJaartitleJaartype1 fieldOmzet!presnameYcolumntitleOmzet�field=humres.fullname!presnameEVertegenwoordigertitleEVertegenwoordigertype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitleuGrafiek per Periode per Vert.*)background)foregroundmarkup0title�Omzet per vertegenwoordiger|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzdebv 43�fieldperiode!presnamePeriodetitlePeriodetype -1 fieldOmzet!presnameYcolumntitleOmzet�field=humres.fullname!presnameEVertegenwoordigertitleEVertegenwoordigertype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitleqGrafiek per Periode per Jaar*)background)foregroundmarkup0title�Omzet per vertegenwoordiger|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzdebv 43�fieldperiode!presnamePeriodetitlePeriodetype -1 fieldOmzet!presnameYcolumntitleOmzet�fieldboekjr!presnameJaartitleJaartype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitleYOmzet per artikelgroep%hideClear1!presname-SearchPanelv 54 � field)bkjrcodevaflags2048!presname!Boekjaartitle9Boekjaar vanaftype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0� field)bkjrcodetmflags2048!presname1Boekjaar t/mtitle1Boekjaar t/mtype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0�field%periodevaflags2048format#!presname5Periode vanaftitle5Periode vanaftype3�groupbyper_finorderbyper_fin9resetSelection0!selected%per_fin=1tableperdattitleper_finvalueper_finEvalueIsConstraint0�field%periodetmflags2048format#!presname-Periode t/mtitle-Periode t/mtype3�groupbyper_finorderby1per_fin desc9resetSelection0tableperdattitleper_finvalueper_finEvalueIsConstraint0mode0-orientation-verticalBar!presname!Splitter5splitPosition 250* )background)foregroundmarkup0!presnameTitletitleiSelecteer artikelgroep(en)IdisableExcelExport0!multiple1!passthru1!presnamesource2sortBy)Assortmenttable9itemassortment top0�-Aggregation0)Constraint1field)assortment!presnameECode artikelgroeptitleECode artikelgroeptype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field-Description!presname1Omschrijvingtitle1Omschrijvingtype1�footerheadermodeValues!presname)background�footerheadermodeValues�from)assortment toartgrp)expandTabs1!presname!Notebookv 52�)background)foregroundtitleLijstmode0-orientation5horizontalBar!presname!Splitter5splitPosition 333*)background)foregroundmarkup0titlewOmzet per artikelgroep|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }IdisableExcelExport0=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})!presnameLijstsortByUartgrp,boekjr,periodetableomzgrp top0v 54�-Aggregation0!Compress1)Constraint1fieldartgrp!presname1Artikelgroeptitle1Artikelgroeptype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�artgrp@itemassortment.description!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1)Constraint1fieldboekjr!presname!Boekjaartitle!Boekjaartype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1)Constraint1fieldperiode!presnamePeriodetitlePeriodetype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldaantalformat!#,##0.00!presnameAantaltitleAantaltype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field!br_prijsformat!#,##0.00!presname-Bruto prijstitleBrutotype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldomzetformat!#,##0.00!presname5Omzet (netto)titleNettotype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field9br_prijs-omzetformat!#,##0.00titleKortingtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation1fieldmargeformat!#,##0.00!presnameMargetitleMargetype6�footerheadermodeValues!presname)background�footerheadermodeValuesmode0-orientation5horizontalBar5splitPosition 300* )background)foregroundmarkup0!presname!FacturentitleMDetails per Factuur!presname)Translator� to�bkjrcode=#{boekjr} and per_fin=#{periode}Btableperdatv4�)constraint1field�'fakdat>='+datepart(yyyymmdd,bgdatum)+' and fakdat<='+datepart(yyyymmdd,eddatum) + ' and artcode@items.assortment=' + #{artgrp}EvalueIsConstraint1IdisableExcelExport0!presnameorsrxsortByfaknrtablefrhsrx top0v 54�-Aggregation0!Compress1)Constraint1fieldfaknrtitle)Factuurnr.type4�footerheadermodeValues�footerheadermodeValues�-Aggregation0field�(frhkrg.debnr)@debiteuren.debcodetitleDebcodetype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldy(frhkrg.debnr)@debiteuren.naamtitleNaamtype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitleAantaltype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0Hidden1field�btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0Hidden1field�btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation1field�esr_aantal*(#brutoprijsval)*koersformat!#,##0.00!presnameBedragtitleBrutotype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field�esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleNettotype6�footerheadermodeValues�footerheadermodeValues� -Aggregation1field'((esr_aantal*(#brutoprijsval))-(esr_aantal*(#nettoprijsval)))*koersformat!#,##0.00titleKortingtype6�footerheadermodeValues�footerheadermodeValuesx)linkTargetYFactuurhistoriedetailsv 50�)background)foregroundtitleiGrafiek per Jaar per Groep*)background)foregroundmarkup0titlewOmzet per artikelgroep|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzgrpv 43�fieldboekjr!presnameJaartitleJaartype1 fieldOmzet!presnameYcolumntitleOmzet�field�artgrp@itemassortment.description!presname1Artikelgroeptitle1Artikelgroeptype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitleuGrafiek per Periode per Groep*)background)foregroundmarkup0titlewOmzet per artikelgroep|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzgrpv 43�fieldperiode!presnamePeriodetitlePeriodetype -1 fieldOmzet!presnameYcolumntitleOmzet�field�artgrp@itemassortment.description!presname1Artikelgroeptitle1Artikelgroeptype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitleqGrafiek per Periode per Jaar*)background)foregroundmarkup0titlewOmzet per artikelgroep|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzgrpv 43�fieldperiode!presnamePeriodetitlePeriodetype -1 fieldOmzet!presnameYcolumntitleOmzet�fieldboekjr!presnameJaartitleJaartype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitle]Omzet per Classificatie%hideClear1!presname]Omzet per Classificatiev 54 � field)bkjrcodevaflags2048!presname!Boekjaartitle9Boekjaar vanaftype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0� field)bkjrcodetmflags2048!presname1Boekjaar t/mtitle1Boekjaar t/mtype9�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0�field%periodevaflags2048format#!presname5Periode vanaftitle5Periode vanaftype3�groupbyper_finorderbyper_fin9resetSelection0!selected%per_fin=1tableperdattitleper_finvalueper_finEvalueIsConstraint0�field%periodetmflags2048format#!presname-Periode t/mtitle-Periode t/mtype3�groupbyper_finorderby1per_fin desc9resetSelection0tableperdattitleper_finvalueper_finEvalueIsConstraint0mode0-orientation-verticalBar!presname!Splitter5splitPosition 250* )background)foregroundmarkup0!presnameTitletitleiSelecteer Classificatie(s)IdisableExcelExport0!multiple1!passthru1!presnamesource2sortByAClassificationIDtable=classifications top0� -Aggregation0)Constraint1fieldAClassificationIDtitle5Classificatietype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldml_desctitle1Omschrijvingtype1�footerheadermodeValues�footerheadermodeValues�fromAClassificationID tomdebiteuren.ClassificationID)expandTabs1!presname!Notebookv 52�)background)foregroundtitleLijstmode0-orientation5horizontalBar!presname!Splitter5splitPosition 333*)background)foregroundmarkup0title�Omzet per Classificatie|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }IdisableExcelExport0=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})!presnameLijstsortBy�debiteuren.classificationid,boekjr,periodetableomzdeb top0v 54�-Aggregation0!Compress1)Constraint1fieldmdebiteuren.classificationid!presname1ArtikelgroeptitleClass.type1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�debiteuren.classificationid.ml_desc!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1)Constraint1fieldboekjr!presname!Boekjaartitle!Boekjaartype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1)Constraint1fieldperiode!presnamePeriodetitlePeriodetype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldaantalformat!#,##0.00!presnameAantaltitleAantaltype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1field!br_prijsformat!#,##0.00!presname-Bruto prijstitleBrutotype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldomzetformat!#,##0.00!presname5Omzet (netto)titleNettotype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field9br_prijs-omzetformat!#,##0.00titleKortingtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation1fieldmargeformat!#,##0.00!presnameMargetitleMargetype6�footerheadermodeValues!presname)background�footerheadermodeValuesmode0-orientation5horizontalBar5splitPosition 300* )background)foregroundmarkup0!presname!FacturentitleMDetails per Factuur!presname)Translator� to�bkjrcode=#{boekjr} and per_fin=#{periode}Btableperdatv4�)constraint1field� 'fakdat>='+datepart(yyyymmdd,bgdatum)+' and fakdat<='+datepart(yyyymmdd,eddatum) + ' and frhkrg.debiteuren.classificationid=' + "'" + #{debiteuren.classificationid}+ "'" EvalueIsConstraint1IdisableExcelExport0!presnameorsrxsortByfaknrtablefrhsrx top0v 54�-Aggregation0!Compress1)Constraint1fieldfaknrtitle)Factuurnr.type4�footerheadermodeValues�footerheadermodeValues�-Aggregation0field�(frhkrg.debnr)@debiteuren.debcodetitleDebcodetype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldy(frhkrg.debnr)@debiteuren.naamtitleNaamtype1�footerheadermodeValues�footerheadermodeValues�-Aggregation0!Negative1!Positive1field)esr_aantalformat#,##0!presnameAantaltitleAantaltype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0Hidden1field�btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsvalformat!#,##0.00!presnamePrijstitle5Br.Prijs. Valtype6�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0Hidden1field�btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsvalformat!#,##0.00title5Netto Pr. Valtype6�footerheadermodeValues�footerheadermodeValues�-Aggregation1field�esr_aantal*(#brutoprijsval)*koersformat!#,##0.00!presnameBedragtitleBrutotype6�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation1field�esr_aantal*(#nettoprijsval)*koersformat!#,##0.00titleNettotype6�footerheadermodeValues�footerheadermodeValues� -Aggregation1field'((esr_aantal*(#brutoprijsval))-(esr_aantal*(#nettoprijsval)))*koersformat!#,##0.00titleKortingtype6�footerheadermodeValues�footerheadermodeValuesx)linkTargetYFactuurhistoriedetailsv 50�)background)foregroundtitle�Grafiek per Jaar per Classificatie*)background)foregroundmarkup0title�Omzet per Classificatie|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzgrpv 43�fieldboekjr!presnameJaartitleJaartype1 fieldOmzet!presnameYcolumntitleOmzet�field�debiteuren.classificationid.ml_desc!presname1Artikelgroeptitle5Classificatietype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitle�Grafiek per Periode per Classificatie*)background)foregroundmarkup0title�Omzet per Classificatie|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzgrpv 43�fieldperiode!presnamePeriodetitlePeriodetype -1 fieldOmzet!presnameYcolumntitleOmzet�field�debiteuren.classificationid.ml_desc!presname1Artikelgroeptitle5Classificatietype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitle�Grafiek per Periode per Classificatie*)background)foregroundmarkup0title�Omzet per Classificatie|||{#name:bkjrcodeva#prefix:Boekjaar: #postfix: }{#name:bkjrcodetm#prefix:t/m #postfix: }{#name:periodeva#prefix:Periode: #postfix: }{#name:periodetm#prefix:t/m }b!Compress1=extraConstraintw(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})legend1!passthru1!presname)2.5D Graphtableomzgrpv 43�fieldperiode!presnamePeriodetitlePeriodetype -1 fieldOmzet!presnameYcolumntitleOmzet�fieldboekjr!presnameJaartitleJaartype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163�)background)foregroundtitleIDashboard Art.grp.%hideClear1v 54� fieldartgrpflags0!presname1artikelgroeptitle1Artikelgroeptype1�-initialText)-- Alle --orderby)assortment9resetSelection0table9itemassortmenttitle�'' + assortment + ' - ' + descriptionvalue)assortmentEvalueIsConstraint0� field%jaarpervaflags8!presname!Jaar pertitleQJaar + Periode vanaftype1�)constraintabkjrcode<=YEAR(@today)+1groupby�bkjrcode + right('00' + per_fin,2)orderby�bkjrcode + right('00' + per_fin,2)9resetSelection0!selected�bkjrcode = Year(@today) and per_fin = '1'tableperdattitle�bkjrcode + right('00' + per_fin,2)value�bkjrcode + right('00' + per_fin,2)EvalueIsConstraint0� field%jaarpertmflags4!presnameJaarPertitleIJaar + Periode t/mtype1�)constraintabkjrcode<=YEAR(@today)+1groupby�bkjrcode + right('00' + per_fin,2)orderby�bkjrcode + right('00' + per_fin,2) desc9resetSelection0!selected�bkjrcode = Year(@today) and per_fin = '12'tableperdattitle�bkjrcode + right('00' + per_fin,2)value�bkjrcode + right('00' + per_fin,2)EvalueIsConstraint0�from%jaarperva to�boekjr + right('00' + periode,2)�from%jaarpertm to�boekjr + right('00' + periode,2)mode0-orientation5horizontalBar!presname!Splitter5splitPosition 500*)background)foregroundmarkup0titleOmzet {#name:artgrp#prefix:Artikelgroep:#postfix: }|||Vanaf jaarperiode #{jaarperva} t/m jaarperiode #{jaarpertm}!Compress1!passthru1!presnameGraphtableomzgrp�field�boekjr + right('00' + periode,2)!presnamejaarpertitlejaarpertype1 fieldomzet%graphType5!presnameOmzettitleOmzetcolor5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode2-orientation-verticalBar!presname!Splitter5splitPosition 500* )background)foregroundmarkup0!presname1Artikelgroeptitle�Omzet per Artikelgroep|||{#name:boekjr + right('00' + periode,2)#prefix:Jaarperiode:#postfix: }mode0-orientation5horizontalBar!presname!Splitter5splitPosition 500mode2-orientation-verticalBar!presname!Splitter5splitPosition 500IdisableExcelExport0!passthru1!presnameTablesortByartgrptableomzgrp top0v 54�-Aggregation0!Compress1)Constraint1fieldartgrp!presname1Artikelgroeptitle1Artikelgroeptype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field�artgrp@itemassortment.description!presnameOmschrtitleOmschrtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldomzetformat!#,##0.00!presname5Omzet (netto)title5Omzet (netto)type6�footerheadermodeValues!presname)background�footerheadermodeValuesRfieldomzethaving1sum(omzet)>0!passthru1!presnameOmzPie)showLegend1tableomzgrpv 43[!compress1)constraint1fieldartgrpcolor5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163!presname)Translator�fromartgrp= to9artbst.artgrp=* )background)foregroundmarkup0!presname%ArtikelentitleArtikelen #{artgrp} #{artgrp@itemassortment.description}|||{#name:boekjr + right('00' + periode,2)#prefix:Jaarperiode:#postfix: }IdisableExcelExport0!presnameTablesortByartcodetableomzalg top0v 54�-Aggregation0!Compress1fieldartcode!presname-Artikelcodetitle-Artikelcodetype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldQartcode@ARTBST.oms30!presname1Omschrijvingtitle1Omschrijvingtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldomzetformat!#,##0.00!presname5Omzet (netto)title5Omzet (netto)type6�footerheadermodeValues!presname)background�footerheadermodeValues* )background)foregroundmarkup0!presname)Debiteurentitle�Omzet per Debiteuren|||{#name:boekjr + right('00' + periode,2)#prefix:Jaarperiode:#postfix: }IdisableExcelExport0!passthru1!presnameTablesortBydebnrtableomzgrp top0v 54�-Aggregation0!Compress1fielddebnr!presname9Debiteurnummertitle9Debiteurnummertype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fieldEdebnr@debitr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation1fieldomzetformat!#,##0.00!presname5Omzet (netto)title5Omzet (netto)type6�footerheadermodeValues!presname)background�footerheadermodeValues�)background)foregroundtitle1Statistieken%hideClear1v 54� field!peiljaarflags2048!presname%Peildatumtitle!Peiljaartype1�)constraintabkjrcode<=YEAR(@today)+1groupby!bkjrcodeorderby5bkjrcode desc9resetSelection0!selectedUbkjrcode=YEAR(@today)tableperdattitle!bkjrcodevalue!bkjrcodeEvalueIsConstraint0)expandTabs1v 52�)background)foregroundtitle1Salesrapport* )background)foreground-lookupTable)SYS\$SRNF$markup0titleaSalesrapport #{peiljaar}21bottommargin 10)leftmargin 10-pageNumbers2-paperheight 297)paperwidth 210!presname%Overzicht-rightmargin 10=titleBackgroundAtitleBackground2=titleForeground%topmargin 10UwebclientAutoDownload10\UreportLayoutAlignmentleftYreportLayoutOccurrence%repeating�*)background)foregroundmarkup0titleaSalesrapport #{peiljaar}tablebedryf� Last1digits 60field]bedrnr + ' - ' + bedrnmtitle5Administratietype1�Last1digits 10fieldUcast(@today as date) format)d MMM yyyytitle-Afdrukdatumtype2\UreportLayoutAlignmentleftYreportLayoutOccurrencepagemode2-orientation5horizontalBar!presname!Verdeler5splitPosition 500mode2-orientation5horizontalBar!presname!Verdeler5splitPosition 500*)background!fontsize1)foregroundmarkup0!presnameTiteltitle�Orderintake per week |||#{peiljaar}!Compress1=extraConstraint (ord_soort='V' or ord_soort='A') and (datepart(isoyear, orddat)=cast(#{peiljaar} as int)-1 OR datepart(isoyear, orddat)=cast(#{peiljaar} as int))legend1!passthru1!presnameGraphtableorkrg�field1week(orddat)!presnameXcolumntitleWeektype -1 fieldGdatepart(isoyear, orddat)=cast(#{peiljaar} as int)?bdr_ev_val*koers:0%graphType5!presname=Intake dit jaartitle=Intake dit jaar fieldgdatepart(isoyear, orddat)=cast(#{peiljaar} as int)-1?bdr_ev_val*koers:0!presnameEIntake vorig jaartitleEIntake vorig jaarcolor5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163*)background!fontsize1)foregroundmarkup0!presnameTiteltitleqOmzet per week|||#{peiljaar}!Compress1=extraConstraint�(datepart(isoyear, fakdat)=cast(#{peiljaar} as int)-1 OR datepart(isoyear, fakdat)=cast(#{peiljaar} as int))legend1!passthru1!presnameGraphtablefrhkrg�field1week(fakdat)!presnameXcolumntitleWeektype -1 field�datepart(isoyear, fakdat)=cast(#{peiljaar} as int)?tot_bdr:0%graphType5!presname9Omzet dit jaartitle9Omzet dit jaar field�datepart(isoyear, fakdat)=cast(#{peiljaar} as int)-1?tot_bdr:0!presnameAOmzet vorig jaartitleAOmzet vorig jaarcolor5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode2-orientation5horizontalBar!presname!Verdeler5splitPosition0mode2-orientation-verticalBar!presname!Verdeler5splitPosition 500*)background!fontsize1)foregroundmarkup0!presnameTiteltitleuTop 10 Debiteuren #{peiljaar}IdisableExcelExport0=extraConstraintIboekjr=#{peiljaar}!fontsize2!presnameTabelsortBy=sum(omzet) desctableomzdeb top 10v 54�-Aggregation0!Compress1fielddebnr!presname=Debiteur nummertitleDebnrtype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1fieldQleft(debitr.naam,40)!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldomzetformat!#,##0.00!presnameOmzettitleOmzettype6�footerheadermodeValues!presname)background�footerheadermodeValues*)background!fontsize1)foreground-lookupTable$SRNF$markup0!presnameTiteltitleyTop 10 Debiteuren #{vorigjaar}�!Compress0field�cast(cast(#{peiljaar} as int)-1 as varchar(4)) as vorigjaarmarkup0IdisableExcelExport0=extraConstraint�boekjr=cast(cast(#{peiljaar} as int)-1 as varchar(4))!fontsize2!presnameTabelsortBy=sum(omzet) desctableomzdeb top 10v 54�-Aggregation0!Compress1fielddebnr!presname=Debiteur nummertitleDebnrtype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1fieldQleft(debitr.naam,40)!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0fieldomzetformat!#,##0.00!presnameOmzettitleOmzettype6�footerheadermodeValues!presname)background�footerheadermodeValues*)background!fontsize1)foreground-lookupTable)SYS\$SRNF$markup0!presnameTiteltitle�Top 10 Orderportefeuille|||#{vandaag}�!Compress0field}cast(@today as date) as vandaagmarkup0IdisableExcelExport0!fontsize2!presnameTabelsortByUsum(nettobedrag) desctable%televeren top 10v 54 �-Aggregation0!Compress1fieldordernr!presname-Ordernummertitle-Ordernummertype4�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0!Compress1fieldrefer!presnameEOrderomschrijvingtitle1Omschrijvingtype1�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0fielddebnr!presname9Debiteurnummertitle!Debiteurtype4�footerheadermodeValues!presname)background�footerheadermodeValues� -Aggregation0field)debnr.naam!presnameNaamtitleNaamtype1�footerheadermodeValues!presname)background�footerheadermodeValues�-Aggregation0field-nettobedragformat!#,##0.00!presnameiTotaalbedrag incl. kortingtitle1Totaalbedragtype6�footerheadermodeValues!presname)background�footerheadermodeValues�)background)foregroundtitleAGem. Orderwaardemode0-orientation5horizontalBar5splitPosition 500*)background)foreground-lookupTable)SYS\$SRNF$markup0!presnameTitletitle�Gemiddelde orderwaarde per maand #{peiljaar}/#{vorigjaar}�!Compress0field�cast(#{peiljaar} as int)-1 as vorigjaarmarkup0b!Compress1=extraConstraint�(YEAR(orddat)=cast(#{peiljaar} as float)-1 OR YEAR(orddat)=cast(#{peiljaar} as float) )and (ord_soort='A' or ord_soort='V')legend1!passthru1!presname12,5D Grafiektableorkrg�field5MONTH(orddat)!presnameXcolumntitleMaandtype -1 fieldUavg(bdr_ev_val*koers)!presnameYGemiddelde orderwaardetitleYGemiddelde orderwaarde�field1YEAR(orddat)!presnameJaartitleJaartype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode0-orientation-verticalBar5splitPosition 300*)background)foregroundmarkup0title�Verkooporders #{YEAR(orddat)} #{MONTH(orddat)}IdisableExcelExport0=extraConstraint�(ord_soort='A' or ord_soort='V')sortByordernrtableorkrg top0v 54� -Aggregation0)Constraint1fieldordernrtitleIVerkoopordernummertype4�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldIdebiteuren.debcodetitle9Debiteurnummertype4�footerheadermodeValues�footerheadermodeValues� -Aggregation1fieldI(bdr_ev_val*koers)format!#,##0.00title-Orderwaardetype6�footerheadermodeValues�footerheadermodeValuesx)linkTargetMVerkooporderdetailsv 50�)background)foregroundtitleAGem. Orderaantalmode0-orientation5horizontalBar5splitPosition 500*)background)foreground-lookupTable$srnf$markup0!presnameTitletitle�Aantal orders per maand #{peiljaar}/#{vorigjaar}�!Compress0field�cast(#{peiljaar} as int)-1 as vorigjaarmarkup0b!Compress1=extraConstraint�(YEAR(orddat)=cast(#{peiljaar} as float)-1 OR YEAR(orddat)=cast(#{peiljaar} as float) )and (ord_soort='A' or ord_soort='V')legend1!passthru1!presname12,5D Grafiektableorkrg�field5MONTH(orddat)!presnameXcolumntitleMaandtype -1 field9count(ordernr)!presnameYGemiddelde orderwaardetitle5Aantal orders�field1YEAR(orddat)!presnameJaartitleJaartype1color5113, 188, 158color1252, 153, 49color-223, 41, 54color)1, 102, 94color5102, 207, 228color5195, 217, 228color128, 139, 133color-225, 58, 40color-127, 33, 27color)23, 51, 52color132, 155, 181color184, 139, 163mode0-orientation-verticalBar5splitPosition 300*)background)foregroundmarkup0titleWVerkooporders {#name:YEAR(orddat)#prefix:Jaar:#postfix: }{#name:MONTH(orddat)#prefix:Maand:#postfix: }IdisableExcelExport0=extraConstraint�(ord_soort='A' or ord_soort='V')sortByordernrtableorkrg top0v 54� -Aggregation0)Constraint1fieldordernrtitleIVerkoopordernummertype4�footerheadermodeValues�footerheadermodeValues�-Aggregation0fieldIdebiteuren.debcodetitleDebcodetype4�footerheadermodeValues�footerheadermodeValues�-Aggregation0field=debiteuren.naamtitleNaamtype1�footerheadermodeValues�footerheadermodeValues� -Aggregation1fieldI(bdr_ev_val*koers)format!#,##0.00title-Orderwaardetype6�footerheadermodeValues�footerheadermodeValuesx)linkTargetMVerkooporderdetailsv 50+)resourceId�0443ec8b57d220c3868de75044730c9e; Version: 5.5.1355 View created by Sumatra Software B.V. <Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="10"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="10"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="2"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="6"><Tile clickConstraint="PERiode<=#{maand}" comment="" content="{#name:ODJ#format:##,####0}" fontsize="4" horizontalAlignment="1" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="1"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout></LayoutPanel><LayoutPanel colspan="10"><Layout columns="10" syncPanels="1" v="50"><LayoutPanel colspan="3"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel><Tile clickConstraint="PERiode<=#{maand}" content="#{icon}" horizontalAlignment="0" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="2"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><TileField field="#ODJ-#OVJ as vrs" /><TileField field="iif(#vrs > 0, ' ▲ ' , ' ▼ ') as icon" /><TileField field="iif(#vrs >= 0, '#50BA90' , '#FF2B38') as fc" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="2"><Tile clickConstraint="PERiode<=#{maand}" content="{#name:vp#postfix:%#format:0.0}" horizontalAlignment="2" marginBottom="0" marginLeft="0" marginRight="0" marginTop="0" markup="1" passIncoming="1" table=":cOMZET" verticalAlignment="2"><TileField field="sum(IIF(boekjr=#{jaar},omzet, 0.0)) as ODJ" /><TileField field="sum(IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0)) as OVJ" /><TileField field="#ODJ-#OVJ as vrs" /><TileField field="iif(#OVJ=0,100,((#vrs/#OVJ)*100)) as vp" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel><LayoutPanel colspan="3"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout></LayoutPanel><LayoutPanel colspan="10"><Tile clickConstraint="PERiode<=#{maand}" horizontalAlignment="0" passIncoming="1" verticalAlignment="0"><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Tile></LayoutPanel></Layout><TitleColumn Compress="0" field="#{Jr1} as VJ" markup="0" /><TitleColumn Compress="0" field="#{jaar} as Jr" markup="0" /><Graph Compress="1" legend="2" passthru="1" queryHeaders="1" table=":cOMZET" v="50" yAxisTitle="'Omzet'"><GraphColumnX field="periode" title="'Maand'" type="-1" /><GraphColumnY field="IIF(boekjr=#{jaar},omzet, 0.0) as ODJ" graphType="5" title="{#name:jaar#init:YEAR(@today)}" /><GraphColumnY field="IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OVJ" graphType="4" title="{#name:jaar#init:YEAR(@today)}-1" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" fontsize="2" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" sortBy="%SortBy%" style="3" style2="2" table=":cOMZET" top="%Top%" v="55"><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="debcode" fieldLevelType="2" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="naam" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{jaar},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="max(#{maand} ) as periode" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="1" irr_crossTreeType="1" field="debnr" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" fontsize="2" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" sortBy="%SortBy%" style="3" style2="2" table=":cOMZET" top="%Top%" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" title="'Artikel'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="ArtOmschr" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{jaar},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="IIF((boekjr=CAST(#{jaar} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="max(#{maand} ) as periode" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><Graph Compress="1" extraConstraint="(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)<DATEPART(DAYOFYEAR,SV_DEFAULTS__PKG__.vandaag)" legend="1" legendOverPlot="1" table="SV_VERKOOPORDERS__PKG__" v="50"><GraphColumnX field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,orddat,DATEADD(YY,+1,orddat)) as Orddat" type="2" /><GraphColumnY cumulate="1" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,0,nettobedrag)" graphType="7" marker="1" title="Vorig jaar" /><GraphColumnY cumulate="1" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar ,nettobedrag,0)" graphType="4" marker="1" title="Jaar" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><Graph25D Compress="1" having="ABS(SUM(omzet))>0.01" horizontalBarChart="1" legend="2" stackBars="1" table=":cOMZET" v="51"><GraphColumnX field="(PERIODE)" type="1" /><GraphColumnY25D field="omzet" /><GraphColumnX field="CAST(represent_id as varchar) + ' - ' +RepNaam as RepNaam" type="1" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph25D><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03] " depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="SV_OmzetFact__pkg__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Assortment" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Assortment.Description" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03] " depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1) %AddConstraint%" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="SV_OmzetFact__pkg__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Description" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03] " depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="debnr = #{debnr} AND (boekjr=#{year} OR boekjr=CAST(#{year} as INT)-1) AND periode<=#{month}" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="OMZALG" v="44"><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="debnr@DEBITEUREN.debcode" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="debnr@DEBITEUREN.naam" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="1" irr_crossTreeType="1" field="debnr" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><TitleColumn Compress="0" field="#{year} as JaarTm" markup="0" /><TitleColumn Compress="0" field="#{year}-2 as JaarFrom" markup="0" /><Graph extraConstraint="debnr = #{debnr} AND (boekjr=#{year} AND periode<=#{month}) OR ( boekjr<#{year} AND boekjr>=CAST(#{year} as INT)-2)" table="OMZALG" v="50"><GraphColumnX field="boekjr + '-' + periode" type="1" /><GraphColumnY field="omzet" graphType="7" title="omzet" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03] " depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="debnr = #{debnr} AND (boekjr=#{year} OR boekjr=CAST(#{year} as INT)-1) AND periode<=#{month}" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="OMZALG" v="44"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" sortType="1" title="'Code'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode@ITEMS.Description" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><TitleColumn Compress="0" field="#{year} as JaarTm" markup="0" /><TitleColumn Compress="0" field="#{year}-2 as JaarFrom" markup="0" /><Graph extraConstraint="debnr = #{debnr} AND (boekjr=#{year} AND periode<=#{month}) OR ( boekjr<#{year} AND boekjr>=CAST(#{year} as INT)-2)" table="OMZALG" v="50"><GraphColumnX field="boekjr + '-' + periode" type="1" /><GraphColumnY field="omzet" graphType="7" title="omzet" /><ColorPalette><ColorItem color.alt="80, 186, 144" color="113, 188, 158" /><ColorItem color.alt="252, 153, 49" color="252, 153, 49" /><ColorItem color.alt="255, 43, 56" color="223, 41, 54" /><ColorItem color.alt="244, 244, 244" color="1, 102, 94" /><ColorItem color.alt="38, 161, 219" color="102, 207, 228" /><ColorItem color.alt="43, 103, 122" color="195, 217, 228" /><ColorItem color.alt="28, 139, 133" color="28, 139, 133" /><ColorItem color.alt="218, 113, 4" color="225, 58, 40" /><ColorItem color.alt="254, 124, 124" color="127, 33, 27" /><ColorItem color.alt="178, 178, 178" color="23, 51, 52" /><ColorItem color.alt="123, 225, 247" color="32, 155, 181" /><ColorItem color.alt="86, 189, 237" color="84, 139, 163" /></ColorPalette></Graph><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="0" rowLevelExpanded="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table=":cOMZET" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="Artgrp" fieldLevelType="2" sortType="1" title="Artikelgroep"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="ArtgrpNaam" fieldLevelType="2" title="Naam"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="omzet" fieldLevelType="2" format="#,##0.00" title="Omzet"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="0" queryHeaders="0" rowLevelExpanded="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table=":cOMZET" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="1" field="artcode" fieldLevelType="2" title="Artikel"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="ArtOmschr" fieldLevelType="2" title="Omschrijving"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="omzet" fieldLevelType="2" format="#,##0.00" title="Omzet"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)<DATEPART(DAYOFYEAR,SV_DEFAULTS__PKG__.vandaag)" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="1" queryHeaders="1" rowLevelExpanded="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table="SV_VERKOOPORDERS__PKG__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="3" field="artcode.Assortment" fieldLevelType="2" format="#,##0" sortType="1" title="'Artikelgroep'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode.Assortment.Description" fieldLevelType="2" title="'Omschrijving'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1,nettobedrag,0) as Vj" fieldLevelType="2" format="#,##0.00" title="'Order intake ' + CAST(..\\SV_DEFAULTS__PKG__.Jaar-1 as VARCHAR)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar,nettobedrag,0) as Hj" fieldLevelType="2" format="#,##0.00" title="'Order intake ' + CAST(..\\SV_DEFAULTS__PKG__.Jaar as VARCHAR)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="#Hj-#Vj as Verschil" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#Verschil" field2="#Vj" fieldLevelType="2" format="0.0%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Hidden="1" irr_crossTreeType="1" field="#{Orddat} as Orddat" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" colLevelExpanded="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar OR YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1) AND DATEPART(DAYOFYEAR,orddat)<DATEPART(DAYOFYEAR,SV_DEFAULTS__PKG__.vandaag)" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="0" passthru="0" queryHeaders="1" rowLevelExpanded="0" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="0" style2="0" table="SV_VERKOOPORDERS__PKG__" v="55"><CrossTableField Aggregation="0" Compress="1" Constraint="1" Hidden="0" crossTreeType="3" field="artcode" fieldLevelType="2" format="#,##0" sortType="1" title="'Artikel'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="artcode.Description" fieldLevelType="2" title="'Omschrijving'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar-1,nettobedrag,0) as Vj" fieldLevelType="2" format="#,##0.00" title="'Order intake ' + CAST(..\\SV_DEFAULTS__PKG__.Jaar-1 as VARCHAR)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(YEAR(orddat)=SV_DEFAULTS__PKG__.Jaar,nettobedrag,0) as Hj" fieldLevelType="2" format="#,##0.00" title="'Order intake ' + CAST(..\\SV_DEFAULTS__PKG__.Jaar as VARCHAR)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="#Hj-#Vj as Verschil" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#Verschil" field2="#Vj" fieldLevelType="2" format="0.0%"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><CrossTable colHHInSeparateCol="0" collapseSingleResultColGroups="0" collapseSingleResultRowGroups="0" colorTheme="3" comment="[Converted from Table on 13-2-2019 13:37:03] " depthFirstCol="0" depthFirstRow="0" disableExcelExport="0" extraConstraint="(boekjr<=#{year} AND boekjr>=CAST(#{year} as INT)-1)" hideColOfTotals="0" hideCorner="0" hideResultTitles="0" hideRowOfTotals="0" levelColorsDescending="0" markupTitles="0" multiple="1" passthru="1" queryHeaders="1" showColOfTotalsFirst="0" showRowOfTotalsFirst="0" style="3" style2="2" table="OMZALG" v="55"><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="debnr@DEBITEUREN.debcode" fieldLevelType="2" sortType="1" title="'Relatie'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="1" field="debnr@DEBITEUREN.naam" fieldLevelType="2" title="'Naam'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},omzet, 0.0) as Omz" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="IIF((boekjr=CAST(#{year} as INT)-1),omzet, 0.0) as OmzVj" fieldLevelType="2" format="#,##0.00" title="'Omzet ' + CAST({#name:Year#init:Year(@today)} -1 as varchar)"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="1" Hidden="0" crossTreeType="3" field="(#Omz)-(#OmzVj) as vrs" fieldLevelType="2" format="#,##0.00" title="'Verschil'"><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="3" Hidden="0" crossTreeType="13" field="#vrs" field2="(#OmzVj)" fieldLevelType="2" format="0.0%" title="'%'"><irr_DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" alignment="1" crossTreeType="3" field="#vrs" fieldLevelType="2" format=";"";"";"";""" textWidth="100" title="'+/-'"><DataBars color="113, 188, 158" gradient="1" negativeColor="223, 41, 54" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField Aggregation="0" Hidden="0" crossTreeType="3" field="IIF(boekjr=#{year},aantal, 0.0)" fieldLevelType="2" format="#,##0" title="'Aantal ' + {#name:Year#init:Year(@today)} "><DataBars color="" negativeColor="" /><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></CrossTableField><CrossTableField irr_Aggregation="0" Compress="1" Constraint="1" Hidden="1" irr_crossTreeType="1" field="debnr" fieldLevelType="2"><irr_DataBars color="" negativeColor="" /><irr_ColorScheme footer="" header="" mode="Values" /><irr_FgColorScheme footer="" header="" mode="Values" /></CrossTableField></CrossTable><TableList disableExcelExport="0" presname="orkrg" sortBy="orddat" table="televeren" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="nettobedrag" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijs_n_val*esr_aantal" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="orkrg.koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="orkrg.represent_id.fullname + ' (' + orkrg.represent_id + ')'" format="#" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orkrg.afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(orkrg.fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(orkrg.fakdebnr)@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="orsrx" sortBy="regel" table="orsrx" top="0" v="54"><TableColumn Aggregation="0" field="regel" title="R." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode" presname="Artikel" title="Artikel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms45" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="unitcode" title="Eenheid" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="esr_aantal/unitfactor" format="#,##0" title="Aantal Eenh." type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal Vk.Vp." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="afldat=22991231?esr_aantal:0" format="#,##0" presname="Backorder" title="Wv. Back." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="aant_gelev" format="#,##0" presname="Gelev" title="Gelev." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="korting/100" format="#,##0%" presname="Kort%" title="Kort%" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr.valcode" title="Val." type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)" format="#,##0.00" presname="Bedrag" title="Bedrag Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.btwper" format="#,##0.00" presname="BTW%" title="BTW%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijslijst" presname="Prijsl" title="Prijsl" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="magcode" presname="Mag" title="Mag" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="instruction" presname="Instructieregel" title="Instructieregel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="res_id.fullname + ' (' + res_id + ')'" title="Medewerker" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo from="ordernr" to="OrderNumber" /><TableList disableExcelExport="0" presname="Table" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="HID" format="#,##0" presname="HID" title="Nummer" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Subject" presname="Onderwerp" title="Onderwerp" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedDate" format="d MMM yyyy" presname="CreatedDate" title="Aangemaakt" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Type.Description" presname="Type" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="JobLevel" format="#,##0" presname="JobLevel" title="Beveiligingsniveau" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></Translator><ImagePanel field="document" presname="Picture" shrink="1" table="Bacodiscussions" v="51" webclientAutoDownload="0" /><TableList disableExcelExport="0" presname="frkrg" table="frkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="fakt_code" presname="Fc" title="Fc" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Constraint="1" field="volgnr_fak" presname="Nr" title="Nr" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="refer" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdebnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id" presname="Vert" title="Vert" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="tot_bdr" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="tot_bdr/koers" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="[inv_in_vv='J']?[[frkrgx.vrachtkost*koers]:[frkrgx.vrachtkost]]" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="[inv_in_vv='J']?[[frkrgx.orderkost*koers]:[frkrgx.orderkost]]" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakt_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="Facturen" sortBy="regel" table="frsrg" top="0" v="54"><TableColumn Aggregation="0" field="regel" title="r." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode" title="Artikelcode" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms45" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="unitcode" title="Eenheid" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="esr_aantal/unitfactor" format="#,##0" title="Aant. Eenh." type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aant. Vk. Verp." type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" title="Br. Prijs Val " type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="korting/100" format="#,##0%" presname="Kort%" title="Kort%" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" presname="Prijs" title="Netto Pr. Val " type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)" format="#,##0.00" presname="Bedrag val" title="Bedrag Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="frkrg.valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.btwper" format="#,##0.00" presname="BTW%" title="BTW%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijslijst" presname="Prijsl" title="Prijsl" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="magcode" presname="Mag" title="Mag" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Graph25D Compress="1" extraConstraint="(ord_soort='V' or ord_soort='A') AND datepart(isoyear, orddat)>cast(#{peiljaar} as float)-2 and datepart(isoyear, orddat)<cast(#{peiljaar} as float)+1 and week(orddat)>={#name:weekvanaf#default:1} and week(orddat)<={#name:weektm#default:53}" legend="1" passthru="1" presname="2,5D Grafiek" sortBy="week(orddat)" table="orkrg" v="51"><GraphColumnX field="week(orddat)" presname="Week" title="Week" type="-1" /><GraphColumnY25D field="bdr_ev_val*koers" presname="Orderbedrag" title="Orderbedrag" /><GraphColumnX field="datepart(isoyear, orddat)" presname="Jaar" title="Jaar" type="-1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" extraConstraint="ord_soort='V' or ord_soort='A'" presname="orkrg" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id.fullname + ' (' + represent_id + ')'" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_ev_val*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_ev_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.vrachtkost*koers" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.orderkost*koers" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="order_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdebnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Graph25D Compress="1" extraConstraint="(ord_soort='V' or ord_soort='A') AND YEAR(orddat)=cast(#{peiljaar} as float) and week(orddat)>={#name:weekvanaf#default:1} and week(orddat)<={#name:weektm#default:53}" legend="1" passthru="1" presname="2,5D Grafiek" sortBy="week(orddat)" table="orkrg" v="51"><GraphColumnX field="week(orddat)" presname="Week" title="Week" type="-1" /><GraphColumnY25D field="bdr_ev_val*koers" presname="Orderbedrag" title="Orderbedrag" /><GraphColumnX field="represent_id.fullname" presname="Vertegenwoordiger" title="Vertegenwoordiger" type="-1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" extraConstraint="(ord_soort='V' or ord_soort='A') and YEAR(orddat)=#{peiljaar}" presname="orkrg" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id.fullname + ' (' + represent_id + ')'" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_ev_val*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_ev_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.vrachtkost*koers" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.orderkost*koers" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="order_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdebnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Graph25D Compress="1" extraConstraint="(ord_soort='V' or ord_soort='A') AND YEAR(orddat)=#{peiljaar} and week(orddat)>={#name:weekvanaf#default:1} and week(orddat)<={#name:weektm#default:53}" legend="1" passthru="1" presname="2,5D Grafiek" sortBy="week(orddat)" table="orkrg" v="51"><GraphColumnX field="week(orddat)" presname="Week" title="Week" type="-1" /><GraphColumnY25D field="bdr_ev_val*koers" presname="Orderbedrag" title="Orderbedrag" /><GraphColumnX field="user_id" presname="Invoerder" title="Invoerder" type="-1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" extraConstraint="(ord_soort='V' or ord_soort='A') and YEAR(orddat)=#{peiljaar}" presname="orkrg" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id.fullname + ' (' + represent_id + ')'" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_ev_val*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_ev_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.vrachtkost*koers" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.orderkost*koers" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="order_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdebnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="afgehandld='J' and (ord_soort='V' or ord_soort='A')" presname="orkrg" sortBy="ordernr" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(debnr)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="docnumber" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id.fullname + ' (' + represent_id + ')'" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="bdr_ev_val*koers" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bdr_ev_val" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.vrachtkost*koers" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="orkrgx.orderkost*koers" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="order_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="routecode" presname="Route" title="Route" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(fakdebnr)@(cicmpy:ix_debnr.debcode)" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdebnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="frhkrg" sortBy="faknr" table="frhkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="faknr" presname="Factuur" title="Factuur" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakdat" format="d MMM yyyy" presname="Factuurdatum" title="Factuurdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr" presname="Order" title="Order" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="refer" presname="Referentie" title="Referentie" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddat" format="d MMM yyyy" presname="Orderdatum" title="Orderdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="[fakdebnr='']?[(debnr)@(cicmpy:ix_debnr.debcode):(fakdebnr)@(cicmpy:ix_debnr.debcode)]" presname="Factdeb" title="Factdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="[[''+fakdebnr@debitr.naam]='']?[[''+debnr.naam]:[''+fakdebnr@debitr.naam]]" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="represent_id.fullname + ' (' + represent_id + ')'" presname="Vert" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="tot_bdr" format="#,##0.00" presname="Bedrag" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="tot_bdr/koers" format="#,##0.00" presname="Bedrag val" title="Bedrag val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="valcode" presname="Val" title="Val" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="koers" format="#,##0.00" presname="Koers" title="Koers" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="frhkrgx.vrachtkost" format="#,##0.00" presname="Vracht" title="Vracht" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="frhkrgx.orderkost" format="#,##0.00" presname="Order" title="Order" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="fakt_kort" format="#,##0.00" presname="Kort%" title="Kort%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="projectnr" title="Project" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(orddeb)@(cicmpy:ix_debnr.debcode)" presname="Orderdeb" title="Orderdeb" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="orddeb@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="selcode" presname="Selc" title="Selc" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="bkjrcode" presname="Jaar" title="Jaar" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" presname="orsrx" sortBy="regel" table="frhsrx" top="0" v="54"><TableColumn Aggregation="0" field="regel" title="R." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode" presname="Artikel" title="Artikel" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="oms45" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="unitcode" title="Eenheid" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="esr_aantal/unitfactor" format="#,##0" title="Aantal Eenh." type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal Vk.Vp." type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="korting/100" format="#,##0%" presname="Kort%" title="Kort%" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ordernr.valcode" title="Val." type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)" format="#,##0.00" presname="Bedrag" title="Bedrag Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Bedrag" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="btw_code.btwper" format="#,##0.00" presname="BTW%" title="BTW%" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="prijslijst" presname="Prijsl" title="Prijsl" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="magcode" presname="Mag" title="Mag" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="afldat" format="d MMM yyyy" presname="Leverdatum" title="Leverdatum" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="res_id.fullname + ' (' + res_id + ')'" title="Medewerker" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo from="faknr" to="OurRef" /><FromTo from="dagbknr=" to="'xyz'<>" /><FromTo from="fakdat=" to="'xyz'<>" /><TableList disableExcelExport="0" presname="Table" table="bacodiscussions" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="HID" format="#,##0" presname="HID" title="Nummer" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Subject" presname="Onderwerp" title="Onderwerp" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="CreatedDate" format="d MMM yyyy" presname="CreatedDate" title="Aangemaakt" type="2"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Type.Description" presname="Type" title="Type" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="JobLevel" format="#,##0" presname="JobLevel" title="Beveiligingsniveau" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></Translator><ImagePanel field="document" presname="Picture" shrink="1" table="Bacodiscussions" v="51" webclientAutoDownload="0" /><TableList disableExcelExport="0" extraConstraint="debnr<>'' and cmp_acc_man>0" multiple="1" passthru="1" presname="source2" sortBy="cmp_acc_man" table="cicmpy" top="0"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="cmp_acc_man" presname="TableColumn" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="cmp_acc_man.fullname" presname="TableColumn" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" presname="Lijst" sortBy="verteg,boekjr,periode" table="omzdeb" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="verteg" presname="Ver" title="Ver" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="humres.fullname" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" field="boekjr" presname="Jaar" title="Jaar" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" field="periode" presname="Per" title="Per" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="aantal" format="#,##0" presname="Aantal" title="Aantal" type="3"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="br_prijs" format="#,##0.00" presname="Bruto" title="Bruto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" presname="Netto" title="Netto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="br_prijs-omzet" format="#,##0.00" presname="Korting" title="Korting" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="marge" format="#,##0.00" presname="Marge" title="Marge" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo to="bkjrcode=#{boekjr} and per_fin=#{periode}" /><LookupTranslator table="perdat" v="4"><LookupTranslatorField constraint="1" field="'fakdat>='+datepart(yyyymmdd,bgdatum)+' and fakdat<='+datepart(yyyymmdd,eddatum) + ' and res_id=' + #{verteg}" valueIsConstraint="1" /><TableList disableExcelExport="0" presname="orsrx" sortBy="faknr" table="frhsrx" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="faknr" title="Factuurnr." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(frhkrg.debnr)@debiteuren.debcode" title="Debcode" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(frhkrg.debnr)@debiteuren.naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#brutoprijsval)*koers" format="#,##0.00" presname="Bedrag" title="Bruto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Netto" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="((esr_aantal*(#brutoprijsval))-(esr_aantal*(#nettoprijsval)))*koers" format="#,##0.00" title="Korting" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></LookupTranslator></Translator><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzdeb" v="43"><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="humres.fullname" presname="Vertegenwoordiger" title="Vertegenwoordiger" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzdeb" v="43"><GraphColumnX field="periode" presname="Periode" title="Periode" type="-1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="humres.fullname" presname="Vertegenwoordiger" title="Vertegenwoordiger" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzdeb" v="43"><GraphColumnX field="periode" presname="Periode" title="Periode" type="-1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" multiple="1" passthru="1" presname="source2" sortBy="Assortment" table="itemassortment" top="0"><TableColumn Aggregation="0" Constraint="1" field="assortment" presname="Code artikelgroep" title="Code artikelgroep" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="Description" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" presname="Lijst" sortBy="artgrp,boekjr,periode" table="omzgrp" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="artgrp" presname="Artikelgroep" title="Artikelgroep" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artgrp@itemassortment.description" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" field="boekjr" presname="Boekjaar" title="Boekjaar" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" field="periode" presname="Periode" title="Periode" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="aantal" format="#,##0.00" presname="Aantal" title="Aantal" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="br_prijs" format="#,##0.00" presname="Bruto prijs" title="Bruto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" presname="Omzet (netto)" title="Netto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="br_prijs-omzet" format="#,##0.00" title="Korting" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="marge" format="#,##0.00" presname="Marge" title="Marge" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo to="bkjrcode=#{boekjr} and per_fin=#{periode}" /><LookupTranslator table="perdat" v="4"><LookupTranslatorField constraint="1" field="'fakdat>='+datepart(yyyymmdd,bgdatum)+' and fakdat<='+datepart(yyyymmdd,eddatum) + ' and artcode@items.assortment=' + #{artgrp}" valueIsConstraint="1" /><TableList disableExcelExport="0" presname="orsrx" sortBy="faknr" table="frhsrx" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="faknr" title="Factuurnr." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(frhkrg.debnr)@debiteuren.debcode" title="Debcode" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(frhkrg.debnr)@debiteuren.naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#brutoprijsval)*koers" format="#,##0.00" presname="Bedrag" title="Bruto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Netto" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="((esr_aantal*(#brutoprijsval))-(esr_aantal*(#nettoprijsval)))*koers" format="#,##0.00" title="Korting" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></LookupTranslator></Translator><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzgrp" v="43"><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="artgrp@itemassortment.description" presname="Artikelgroep" title="Artikelgroep" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzgrp" v="43"><GraphColumnX field="periode" presname="Periode" title="Periode" type="-1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="artgrp@itemassortment.description" presname="Artikelgroep" title="Artikelgroep" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzgrp" v="43"><GraphColumnX field="periode" presname="Periode" title="Periode" type="-1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" multiple="1" passthru="1" presname="source2" sortBy="ClassificationID" table="classifications" top="0"><TableColumn Aggregation="0" Constraint="1" field="ClassificationID" title="Classificatie" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="ml_desc" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" presname="Lijst" sortBy="debiteuren.classificationid,boekjr,periode" table="omzdeb" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="debiteuren.classificationid" presname="Artikelgroep" title="Class." type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debiteuren.classificationid.ml_desc" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" field="boekjr" presname="Boekjaar" title="Boekjaar" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" Constraint="1" field="periode" presname="Periode" title="Periode" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="aantal" format="#,##0.00" presname="Aantal" title="Aantal" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="br_prijs" format="#,##0.00" presname="Bruto prijs" title="Bruto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" presname="Omzet (netto)" title="Netto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="br_prijs-omzet" format="#,##0.00" title="Korting" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="marge" format="#,##0.00" presname="Marge" title="Marge" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Translator presname="Translator"><FromTo to="bkjrcode=#{boekjr} and per_fin=#{periode}" /><LookupTranslator table="perdat" v="4"><LookupTranslatorField constraint="1" field="'fakdat>='+datepart(yyyymmdd,bgdatum)+' and fakdat<='+datepart(yyyymmdd,eddatum) + ' and frhkrg.debiteuren.classificationid=' + "'" + #{debiteuren.classificationid}+ "'" " valueIsConstraint="1" /><TableList disableExcelExport="0" presname="orsrx" sortBy="faknr" table="frhsrx" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="faknr" title="Factuurnr." type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(frhkrg.debnr)@debiteuren.debcode" title="Debcode" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="(frhkrg.debnr)@debiteuren.naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Negative="1" Positive="1" field="esr_aantal" format="#,##0" presname="Aantal" title="Aantal" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="btw_code.exclus='I'?prijs83/((bdr_vat_val+100)/100):prijs83 as brutoprijsval" format="#,##0.00" presname="Prijs" title="Br.Prijs. Val" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Hidden="1" field="btw_code.exclus='I'?prijs_n/((bdr_vat_val+100)/100):prijs_n as nettoprijsval" format="#,##0.00" title="Netto Pr. Val" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#brutoprijsval)*koers" format="#,##0.00" presname="Bedrag" title="Bruto" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="esr_aantal*(#nettoprijsval)*koers" format="#,##0.00" title="Netto" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="((esr_aantal*(#brutoprijsval))-(esr_aantal*(#nettoprijsval)))*koers" format="#,##0.00" title="Korting" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList></LookupTranslator></Translator><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzgrp" v="43"><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="debiteuren.classificationid.ml_desc" presname="Artikelgroep" title="Classificatie" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzgrp" v="43"><GraphColumnX field="periode" presname="Periode" title="Periode" type="-1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="debiteuren.classificationid.ml_desc" presname="Artikelgroep" title="Classificatie" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph25D Compress="1" extraConstraint="(boekjr>=#{bkjrcodeva} and boekjr<=#{bkjrcodetm}) and (periode>=#{periodeva} and periode<=#{periodetm})" legend="1" passthru="1" presname="2.5D Graph" table="omzgrp" v="43"><GraphColumnX field="periode" presname="Periode" title="Periode" type="-1" /><GraphColumnY25D field="Omzet" presname="Ycolumn" title="Omzet" /><GraphColumnX field="boekjr" presname="Jaar" title="Jaar" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><Graph Compress="1" passthru="1" presname="Graph" table="omzgrp"><GraphColumnX field="boekjr + right('00' + periode,2)" presname="jaarper" title="jaarper" type="1" /><GraphColumnY field="omzet" graphType="5" presname="Omzet" title="Omzet" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph><Splitter mode="0" orientation="horizontalBar" presname="Splitter" splitPosition="500"><Splitter mode="2" orientation="verticalBar" presname="Splitter" splitPosition="500"><TableList disableExcelExport="0" passthru="1" presname="Table" sortBy="artgrp" table="omzgrp" top="0" v="54"><TableColumn Aggregation="0" Compress="1" Constraint="1" field="artgrp" presname="Artikelgroep" title="Artikelgroep" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artgrp@itemassortment.description" presname="Omschr" title="Omschr" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" presname="Omzet (netto)" title="Omzet (netto)" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><Pie field="omzet" having="sum(omzet)>0" passthru="1" presname="OmzPie" showLegend="1" table="omzgrp" v="43"><PieField compress="1" constraint="1" field="artgrp" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Pie></Splitter><Translator presname="Translator"><FromTo from="artgrp=" to="artbst.artgrp=" /><Title background="" foreground="" markup="0" presname="Artikelen" title="Artikelen #{artgrp} #{artgrp@itemassortment.description}|||{#name:boekjr + right('00' + periode,2)#prefix:Jaarperiode:#postfix: }"><TableList disableExcelExport="0" presname="Table" sortBy="artcode" table="omzalg" top="0" v="54"><TableColumn Aggregation="0" Compress="1" field="artcode" presname="Artikelcode" title="Artikelcode" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="artcode@ARTBST.oms30" presname="Omschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" presname="Omzet (netto)" title="Omzet (netto)" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TableList disableExcelExport="0" passthru="1" presname="Table" sortBy="debnr" table="omzgrp" top="0" v="54"><TableColumn Aggregation="0" Compress="1" field="debnr" presname="Debiteurnummer" title="Debiteurnummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr@debitr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="omzet" format="#,##0.00" presname="Omzet (netto)" title="Omzet (netto)" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><ReportGenerator bottommargin="10" leftmargin="10" pageNumbers="2" paperheight="297" paperwidth="210" presname="Overzicht" rightmargin="10" titleBackground="" titleBackground2="" titleForeground="" topmargin="10" webclientAutoDownload="1"><ReportLayout><ReportItem reportLayoutAlignment="left" reportLayoutOccurrence="repeating"><Translator><FromTo /><Title background="" foreground="" markup="0" title="Salesrapport #{peiljaar}"><InfoPage table="bedryf"><DataColumn Last="1" digits="60" field="bedrnr + ' - ' + bedrnm" title="Administratie" type="1" /><DataColumn Last="1" digits="10" field="cast(@today as date) " format="d MMM yyyy" title="Afdrukdatum" type="2" /></InfoPage><Graph Compress="1" extraConstraint="(ord_soort='V' or ord_soort='A') and (datepart(isoyear, orddat)=cast(#{peiljaar} as int)-1 OR datepart(isoyear, orddat)=cast(#{peiljaar} as int))" legend="1" passthru="1" presname="Graph" table="orkrg"><GraphColumnX field="week(orddat)" presname="Xcolumn" title="Week" type="-1" /><GraphColumnY field="datepart(isoyear, orddat)=cast(#{peiljaar} as int)?bdr_ev_val*koers:0" graphType="5" presname="Intake dit jaar" title="Intake dit jaar" /><GraphColumnY field="datepart(isoyear, orddat)=cast(#{peiljaar} as int)-1?bdr_ev_val*koers:0" presname="Intake vorig jaar" title="Intake vorig jaar" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph><Graph Compress="1" extraConstraint="(datepart(isoyear, fakdat)=cast(#{peiljaar} as int)-1 OR datepart(isoyear, fakdat)=cast(#{peiljaar} as int))" legend="1" passthru="1" presname="Graph" table="frhkrg"><GraphColumnX field="week(fakdat)" presname="Xcolumn" title="Week" type="-1" /><GraphColumnY field="datepart(isoyear, fakdat)=cast(#{peiljaar} as int)?tot_bdr:0" graphType="5" presname="Omzet dit jaar" title="Omzet dit jaar" /><GraphColumnY field="datepart(isoyear, fakdat)=cast(#{peiljaar} as int)-1?tot_bdr:0" presname="Omzet vorig jaar" title="Omzet vorig jaar" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph><TableList disableExcelExport="0" extraConstraint="boekjr=#{peiljaar}" fontsize="2" presname="Tabel" sortBy="sum(omzet) desc" table="omzdeb" top="10" v="54"><TableColumn Aggregation="0" Compress="1" field="debnr" presname="Debiteur nummer" title="Debnr" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="left(debitr.naam,40)" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="omzet" format="#,##0.00" presname="Omzet" title="Omzet" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TitleColumn Compress="0" field="cast(cast(#{peiljaar} as int)-1 as varchar(4)) as vorigjaar" markup="0" /><TableList disableExcelExport="0" extraConstraint="boekjr=cast(cast(#{peiljaar} as int)-1 as varchar(4))" fontsize="2" presname="Tabel" sortBy="sum(omzet) desc" table="omzdeb" top="10" v="54"><TableColumn Aggregation="0" Compress="1" field="debnr" presname="Debiteur nummer" title="Debnr" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="left(debitr.naam,40)" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="omzet" format="#,##0.00" presname="Omzet" title="Omzet" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TitleColumn Compress="0" field="cast(@today as date) as vandaag" markup="0" /><TableList disableExcelExport="0" fontsize="2" presname="Tabel" sortBy="sum(nettobedrag) desc" table="televeren" top="10" v="54"><TableColumn Aggregation="0" Compress="1" field="ordernr" presname="Ordernummer" title="Ordernummer" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" Compress="1" field="refer" presname="Orderomschrijving" title="Omschrijving" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr" presname="Debiteurnummer" title="Debiteur" type="4"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debnr.naam" presname="Naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="nettobedrag" format="#,##0.00" presname="Totaalbedrag incl. korting" title="Totaalbedrag" type="6"><ColorScheme footer="" header="" mode="Values" presname="background" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TitleColumn Compress="0" field="cast(#{peiljaar} as int)-1 as vorigjaar" markup="0" /><Graph25D Compress="1" extraConstraint="(YEAR(orddat)=cast(#{peiljaar} as float)-1 OR YEAR(orddat)=cast(#{peiljaar} as float) )and (ord_soort='A' or ord_soort='V')" legend="1" passthru="1" presname="2,5D Grafiek" table="orkrg"><GraphColumnX field="MONTH(orddat)" presname="Xcolumn" title="Maand" type="-1" /><GraphColumnY25D field="avg(bdr_ev_val*koers)" presname="Gemiddelde orderwaarde" title="Gemiddelde orderwaarde" /><GraphColumnX field="YEAR(orddat)" presname="Jaar" title="Jaar" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" extraConstraint="(ord_soort='A' or ord_soort='V')" sortBy="ordernr" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" title="Verkoopordernummer" type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debiteuren.debcode" title="Debiteurnummer" type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="(bdr_ev_val*koers)" format="#,##0.00" title="Orderwaarde" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList><TitleColumn Compress="0" field="cast(#{peiljaar} as int)-1 as vorigjaar" markup="0" /><Graph25D Compress="1" extraConstraint="(YEAR(orddat)=cast(#{peiljaar} as float)-1 OR YEAR(orddat)=cast(#{peiljaar} as float) )and (ord_soort='A' or ord_soort='V')" legend="1" passthru="1" presname="2,5D Grafiek" table="orkrg"><GraphColumnX field="MONTH(orddat)" presname="Xcolumn" title="Maand" type="-1" /><GraphColumnY25D field="count(ordernr)" presname="Gemiddelde orderwaarde" title="Aantal orders" /><GraphColumnX field="YEAR(orddat)" presname="Jaar" title="Jaar" type="1" /><ColorPalette><ColorItem color="113, 188, 158" /><ColorItem color="252, 153, 49" /><ColorItem color="223, 41, 54" /><ColorItem color="1, 102, 94" /><ColorItem color="102, 207, 228" /><ColorItem color="195, 217, 228" /><ColorItem color="28, 139, 133" /><ColorItem color="225, 58, 40" /><ColorItem color="127, 33, 27" /><ColorItem color="23, 51, 52" /><ColorItem color="32, 155, 181" /><ColorItem color="84, 139, 163" /></ColorPalette></Graph25D><TableList disableExcelExport="0" extraConstraint="(ord_soort='A' or ord_soort='V')" sortBy="ordernr" table="orkrg" top="0" v="54"><TableColumn Aggregation="0" Constraint="1" field="ordernr" title="Verkoopordernummer" type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debiteuren.debcode" title="Debcode" type="4"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="0" field="debiteuren.naam" title="Naam" type="1"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn><TableColumn Aggregation="1" field="(bdr_ev_val*koers)" format="#,##0.00" title="Orderwaarde" type="6"><ColorScheme footer="" header="" mode="Values" /><FgColorScheme footer="" header="" mode="Values" /></TableColumn></TableList> select YEAR(GetDate()) Jaar, MONTH(GetDate()) maand, GetDate() vandaag,'Boekdatum' BalansType,0.7 LogABC_A_perc,0.2 LogABC_B_perc,0.1 LogABC_C_perc SELECT 'Boekdatum' AdmStelsel UNION ALL SELECT 'Rapportagedatum' SELECT IIF(k.afgehandld=0 AND uitgifte=0,1,0) as Televeren, k.ordernr ordernr, k.debnr, k.refer, k.docnumber, k.orddat, k.ordbv_afgd, k.ordbv_afdr, k.selcode, k.represent_id, s.regel, s.afldat, s.artcode, s.ar_soort, s.oms45, s.oms45_f, s.magcode, s.esr_aantal, s.unitfactor, s.unitcode, s.esr_aantal / s.unitfactor aantverp, s.prijslijst, s.projectnr, s.gip * k.koers gip, s.gip * s.esr_aantal * k.koers gipbedrag, s.vvp * k.koers vvp, s.vvp * s.esr_aantal * k.koers vvpbedrag, s.korting korting, case b.exclus when 'I' then s.prijs83 / ((100 + s.bdr_vat_val) /100) else prijs83 end * k.koers prijs83, case b.exclus when 'I' then s.prijs83 / ((100 + s.bdr_vat_val) /100) else prijs83 end * k.koers * s.esr_aantal brutobedrag, case b.exclus when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100) else s.prijs_n end * k.koers prijs_n, case b.exclus when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100) else s.prijs_n end * s.esr_aantal * k.koers nettobedrag, k.valcode, case b.exclus when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100) else s.prijs_n end prijs_n_val, s.btw_code, s.bdr_vat_val, s.bdr_vat_val/100*((case b.exclus when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100) else s.prijs_n end) * s.esr_aantal * k.koers) bdr_vat, ((s.bdr_vat_val/100)+1) * ((case b.exclus when 'I' then s.prijs_n / ((100 + s.bdr_vat_val) /100) else s.prijs_n end) * s.esr_aantal * k.koers) bdr_incl_vat, s.PlannedDate, s.RequestedDate, s.OriginalPlannedDate, s.purchaseordernr, s.regel_hfda FROM orsrg s INNER JOIN orkrg k ON s.ordernr = k.ordernr INNER JOIN btwtrs b on s.btw_code=b.btwtrans WHERE k.ord_soort IN('V','A') AND s.ar_soort<>'P' artcode debnr represent_id btw_code valcode magcode projectnr

SELECT * ,NettoPrijs * aantal as omzet ,BrutoMarge * aantal as marge ,BrutoPrijs * aantal as OmzetBruto ,bkjrcode boekjr ,fakdebnr debnr FROM ( SELECT artcode, assortment artgrp, s.fakdat Datum, k.fakdebnr, esr_aantal aantal ,CASE b.exclus WHEN 'E' THEN (prijs83) WHEN 'I' THEN prijs83 / ((100 + b.btwper) /100) ELSE prijs83 END * s.koers as BrutoPrijs ,CASE b.exclus WHEN 'E' THEN (prijs_n) WHEN 'I' THEN prijs_n / ((100 + b.btwper) /100) ELSE prijs_n END * s.koers as NettoPrijs ,(CASE b.exclus WHEN 'E' THEN prijs_n WHEN 'I' THEN (prijs_n/ ((100 + b.btwper) /100)) ELSE prijs_n END - vvp ) * s.koers as BrutoMarge ,(SELECT top 1 bkjrcode FROM perdat WHERE s.fakdat<=eddatum ORDER BY eddatum) bkjrcode ,(SELECT top 1 per_fin FROM perdat WHERE s.fakdat<=eddatum ORDER BY eddatum) periode FROM frhsrg s INNER JOIN frhkrg k ON s.faknr = k.faknr and s.fakdat = k.fakdat INNER JOIN btwtrs b ON s.btw_code = b.btwtrans INNER JOIN items i ON s.artcode=i.itemcode and i.type <> 'P' ) a artcode debnr artgrp