Mahnungen mit ESR
Patrick Stoeckli
Hallo Philipp,Ich habe das Formular angepasst. Das Ausdruck ist OK. Jetzt habe ich der Problem, dass die Einstellung eine Mahnung pro Rechnung nicht berücksichtigt wird. Braucht das SelectGrid auch eine Query Anpassung? Wie eine neue Spalte 'Rechnungsnr'?
Gruss
Patrick
Philipp Knecht
Hallo PatrickDu meinst eine Rechnung pro Mahnung oder?
Falls ja kannst du mal ein neues Layout anlegen und das folgende XML als File reinladen.
(Habe einfach ausgehend vom Standard die Gruppierungskriterien geändert plus die Aggregate angepasst.)
hth
[quote]<?xml version="1.0" encoding="utf-8" standalone="yes"?><root type="PerpetuumSoft.Reporting.DOM.Document" id="1" version="2" Name="doc1" GridStep="11.811023622047244" IsTemplate="true" DoublePass="true" ImportsString="LayoutHelper"><StyleSheet type="PerpetuumSoft.Reporting.DOM.StyleSheet" id="2" Title="Standards"><Styles type="PerpetuumSoft.Reporting.DOM.StyleCollection" id="3"><Item type="PerpetuumSoft.Reporting.DOM.Style" id="4" TextAlign="MiddleLeft" Name="DocTitle"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="5" All="1 Solid Gray" /><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="6" Color="Black" /><Fill type="PerpetuumSoft.Framework.Drawing.LinearGradientFill" id="7" Angle="90" StartColor="Gainsboro" EndColor="DarkGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="8" FamilyName="Arial" Size="11.25" Underline="Off" Italic="Off" Bold="On" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="9" TextAlign="MiddleLeft" Name="DocLable"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="10" /><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="11" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="12" FamilyName="Arial" Size="8.25" Underline="Off" Italic="Off" Bold="Off" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="13" TextAlign="TopLeft" Name="DocContent"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="14" FamilyName="Arial" Size="9" Underline="Off" Italic="Off" Bold="Off" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="15" Name="RowTitel"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="16" BottomLine="1.5 Solid Gray" /><Fill type="PerpetuumSoft.Framework.Drawing.LinearGradientFill" id="17" Angle="90" StartColor="Gainsboro" EndColor="DarkGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="18" FamilyName="Arial" Size="8" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="19" Name="RowContent"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="20" FamilyName="Arial" Size="9" Underline="Off" Italic="Off" Bold="Off" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="21" Name="RowSubTot1"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="16" BottomLine="1.5 Solid Gray" /><Fill type="PerpetuumSoft.Framework.Drawing.LinearGradientFill" id="22" Angle="90" StartColor="215, 225, 238" EndColor="SkyBlue" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="23" FamilyName="Arial" Size="9" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="24" Name="RowSubTot2"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="16" BottomLine="1.5 Solid Gray" /><Fill type="PerpetuumSoft.Framework.Drawing.LinearGradientFill" id="25" Angle="90" StartColor="193, 208, 229" EndColor="CornflowerBlue" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="26" FamilyName="Arial" Size="9" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="27" Name="RowSubTot3"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="16" BottomLine="1.5 Solid Gray" /><Fill type="PerpetuumSoft.Framework.Drawing.LinearGradientFill" id="28" Angle="90" StartColor="LightSlateGray" EndColor="LightSteelBlue" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="29" FamilyName="Arial" Size="9" Bold="On" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="30" Name="DocAdress"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="31" FamilyName="Arial" Size="11" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="32" TextAlign="TopLeft" Name="DocFooter"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="33" FamilyName="Arial" Size="8.25" Underline="Off" Italic="Off" Bold="Off" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="34" TextAlign="MiddleLeft" Name="RowLabel"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="35" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="36" FamilyName="Arial" Size="8.25" Underline="Off" Italic="Off" Bold="Off" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="37" Name="RowDetails"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="38" FamilyName="Arial" Size="8" Underline="Off" Italic="Off" Bold="Off" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Style" id="39" TextAlign="MiddleLeft" Name="RowDetailsLabel"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="41" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="42" FamilyName="Arial" Size="8" Underline="Off" Italic="Off" Bold="Off" /></Item></Styles></StyleSheet><Parameters type="PerpetuumSoft.Reporting.DOM.ParameterCollection" id="43" /><Pages type="PerpetuumSoft.Reporting.DOM.PageCollection" id="44"><Item type="PerpetuumSoft.Reporting.DOM.Page" id="45" Location="0;0" Margins="118.11; 141.732; 295.275590551181; 118.11" Name="page1" Size="2480.3149606299212;3507.8740157480315"><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="46"><Item type="swissLD.Reporting.AdvancedDataBand" id="47" DataSource="B1_Data.Dunning" ColumnsGap="0" Location="0;685.03936767578125" Name="Duns" Size="2480.3149606299212;2515.748046875"><Sort type="PerpetuumSoft.Reporting.DOM.DataBandSortCollection" id="48" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="49" /><Totals type="PerpetuumSoft.Reporting.DOM.DataBandTotalCollection" id="50" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="51"><Item type="PerpetuumSoft.Reporting.DOM.GroupHeader" id="52" Location="0;59.055118560791016" NewPageBefore="true" Name="AddressHeader" Size="2480.3149606299212;1133.8582763671875"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="53"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="54" Expression="Duns("CardCode") & Duns("DocNum")" PropertyName="Group" /></DataBindings><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="55"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="56" Location="1464.56689453125;118.11023712158203" Text="Adress" TextAlign="TopLeft" GenerateScript="' Adress

textBox2.Value=Duns("DunningDunningBP.CardName")

' Absatz
textBox2.Value+= vbcrlf

' Street
textBox2.Value+= Duns("DunningDunningBP.Address")

' Absatz
textBox2.Value+= vbcrlf

' Zip and City
textBox2.Value+=Duns("DunningDunningBP.Country") + "-" + Duns("DunningDunningBP.ZipCode") + " " +Duns("DunningDunningBP.City")" StyleName="DocAdress" Name="textBox2" Size="826.77166748046875;377.9527587890625"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="57" /></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="58" Location="295.27560424804688;1051.18115234375" Text="Docnum" TextAlign="MiddleLeft" StyleName="DocLable" Name="textBox5" Size="259.842529296875;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="59" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="60"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="61" Expression="GetData("LD.Txt.T0002504")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="62" Location="555.11810302734375;1051.18115234375" Text="Duedate" TextAlign="MiddleLeft" StyleName="DocLable" Name="textBox6" Size="354.33071899414062;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="63" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="64"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="65" Expression="GetData("LD.Txt.T0002506")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="66" Location="1677.1654052734375;1051.18115234375" Text="to paid" TextAlign="MiddleRight" StyleName="DocLable" Name="textBox7" Size="543.30706787109375;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="67" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="68"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="69" Expression="GetData("LD.Txt.T0002505")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="70" Location="2220.472412109375;1051.18115234375" Text="level" TextAlign="MiddleRight" StyleName="DocLable" Name="textBox8" Size="141.73228454589844;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="71" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="72"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="73" Expression="GetData("LD.Txt.T0002518")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="74" Location="909.44879150390625;1051.18115234375" Text="Balance" TextAlign="MiddleRight" StyleName="DocLable" Name="textBox15" Size="342.51968383789062;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="75" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="76"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="77" Expression="GetData("LD.Txt.T0002507")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="78" Location="1251.968505859375;1051.18115234375" Text="day" TextAlign="MiddleRight" StyleName="DocLable" Name="textBox21" Size="212.59841918945313;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="79" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="80"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="81" Expression="GetData("LD.Txt.T0002508")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="82" Location="1464.56689453125;1051.18115234375" Text="fee" TextAlign="MiddleRight" StyleName="DocLable" Name="textBox23" Size="212.59841918945313;70.866142272949219"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="83" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="84"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="85" Expression="GetData("LD.Txt.T0002509")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.AdvancedText" id="86" Location="295.27560424804688;578.74017333984375" Text="Headertext" TextAlign="TopLeft" GenerateScript="advancedText1.Text=""
' Levels 
If Duns.Max("Levels")=0 Then
 advancedText1.Text=GetData("LD.Txt.T0002511")

Else If Duns.Max("Levels")=1 Then
 advancedText1.Text=GetData("LD.Txt.T0002511")

Else If Duns.Max("Levels")=2 Then
 advancedText1.Text=GetData("LD.Txt.T0002512")

Else If Duns.Max("Levels")=3 Then
 advancedText1.Text=GetData("LD.Txt.T0002513")

End If

advancedText1.Text = advancedText1.Text.Replace("@date",LD.Date(GetData("B1_Data.DunningWizard.ToDate"),"dd.MM.yy"))" StyleName="DocContent" Name="advancedText1" Size="2066.92919921875;472.44094848632812"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="87" /></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="88" Location="1464.56689453125;70.866142272949219" Text="Adresse Firma" TextAlign="MiddleLeft" StyleName="DocLable" Name="textBox36" Size="933.07086181640625;35.433071136474609"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="89" FamilyName="Arial" Size="6" Underline="On" Italic="Off" Bold="Off" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="90"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="91" Expression="GetData("B1_Data.CompanyInfo.CompnyName") + ", " + _
GetData("B1_Data.CompanyDetails.Street") + ", " + _
GetData("B1_Data.CompanyDetails.ZipCode") + " " + _
GetData("B1_Data.CompanyDetails.City")" PropertyName="Value" /></DataBindings></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="92" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Detail" id="93" Location="0;1417.3228759765625" StyleName="DocContent" Name="detail1" Size="2480.3149606299212;70.866142272949219"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="94" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="95"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="96" Location="1866.1417236328125;0" Text="OpenTotal" TextAlign="MiddleRight" Name="textBox9" Size="354.33071899414062;70.866142272949219"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="97" FamilyName="Tahoma" Size="9" Underline="Off" Italic="Off" Bold="On" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="98" UseCultureSettings="false" GroupSeparator=" '" FormatStyle="Number" NumberNegativePattern="1" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="99"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="100" Expression="Duns("OpenSum")+(Duns("OpenSum")*Duns("IntrstPC")/100)" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="101" Location="295.27560424804688;0" Text="DocNum" TextAlign="MiddleLeft" Name="textBox10" Size="259.842529296875;70.866142272949219"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="102"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="103" Expression="Duns("DocNum")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="104" Location="555.11810302734375;0" Text="DueDate" TextAlign="MiddleLeft" Name="textBox11" Size="354.33071899414062;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="105" UseCultureSettings="true" FormatStyle="Date" UseGroupSeparator="true" FormatMask="dd/MM/yyyy" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="106"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="107" Expression="Duns("DueDate") & " " & Duns("DocAbs")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="108" Location="1677.1654052734375;0" Text="Cur" TextAlign="MiddleRight" Name="textBox12" Size="188.97637939453125;70.866142272949219"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="109"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="110" Expression="Duns("OpenCurr")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="111" Location="2220.472412109375;0" Text="Level" TextAlign="MiddleRight" Name="textBox13" Size="141.73228454589844;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="112" UseCultureSettings="false" FormatStyle="Number" UseGroupSeparator="false" DecimalPlaces="0" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="113"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="114" Expression="Duns("EDunLevel")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="115" Location="909.44879150390625;0" Text="OpenSum" TextAlign="MiddleRight" Name="textBox20" Size="342.51968383789062;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="116" UseCultureSettings="false" GroupSeparator=" '" FormatStyle="Number" NumberNegativePattern="1" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="117"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="118" Expression="Duns("OpenSum")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="119" Location="1251.968505859375;0" Text="Days" TextAlign="MiddleRight" Name="textBox22" Size="212.59841918945313;70.866142272949219"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="120"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="121" Expression="Duns("IntrstDays")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="122" Location="1464.56689453125;0" Text="Amnt" TextAlign="MiddleRight" Name="textBox24" Size="212.59841918945313;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="123" UseCultureSettings="false" GroupSeparator=" '" FormatStyle="Number" NumberNegativePattern="1" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="124"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="125" Expression="Duns("OpenSum")*Duns("IntrstPC")/100" PropertyName="Value" /></DataBindings></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="126"><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="127" Name="Levels" Expression="Duns("EDunLevel")"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="128"><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="129" Expression="Duns("CardCode")" /></Groups></Item></Aggregates></Item><Item type="PerpetuumSoft.Reporting.DOM.GroupFooter" id="130" Location="0;1807.086669921875" StyleName="DocContent" Name="groupFooter1" Size="2480.3149606299212;259.842529296875"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="131"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="132" Expression="Duns("DocNum") & Duns("OpenCurr")" PropertyName="Group" /></DataBindings><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="133"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="134" Location="1889.7637939453125;47.244094848632812" Text="OpenTotal" TextAlign="MiddleRight" Name="textBox25" Size="330.70864868164062;70.866142272949219"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="135" FamilyName="Arial" Size="9" Underline="Off" Italic="Off" Bold="On" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="5" All="1 Solid Gray" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="136" UseCultureSettings="true" FormatStyle="Number" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="137"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="138" Expression="Duns.Sum("OpenSum",Duns("DocNum"),Duns("OpenCurr"))+ Duns.Sum("Amnt",Duns("DocNum"),Duns("OpenCurr"))/100 + Duns.Max("FeeMax",Duns("DocNum"),Duns("OpenCurr")) " PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="139" Location="295.27560424804688;47.244094848632812" Text="Balance Total" TextAlign="MiddleRight" Name="textBox26" Size="1381.8897705078125;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="140" UseCultureSettings="true" FormatStyle="Number" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="141"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="142" Expression="GetData("LD.Txt.T0002516")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="143" Location="1677.1654052734375;47.244094848632812" Text="Cur" TextAlign="MiddleRight" Name="textBox31" Size="188.97637939453125;70.866142272949219"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="144"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="145" Expression="Duns("OpenCurr")" PropertyName="Value" /></DataBindings></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="146" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Footer" id="147" Location="0;2125.984130859375" StyleName="DocContent" Name="footer1" Size="2480.3149606299212;342.51968383789062"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="148" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="149"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="150" Location="295.27560424804688;11.811023712158203" Text="Footertext" TextAlign="TopLeft" Name="textBox4" Size="1145.6693115234375;153.54330444335938"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="151"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="152" Expression="GetData("LD.Txt.T0002514")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="153" Location="295.27560424804688;188.97637939453125" Text="Salutations" TextAlign="TopLeft" Name="textBox17" Size="637.7952880859375;47.244094848632812"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="154"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="155" Expression="GetData("LD.Txt.T0002515")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="156" Location="295.27560424804688;259.842529296875" Text="Username" TextAlign="TopLeft" Name="textBox18" Size="637.7952880859375;47.244094848632812"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="157"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="158" Expression="GetData("B1_Data.UserDetails.U_NAME")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.AdvancedText" id="159" Location="1464.56689453125;-11.811023712158203" Text="<b><u>Neue Aargauer Bank</u></b>, 5201 Brugg AG, Switzerland (BC 5881)<br/>
Swift AHHBCH22XXX<br/>
CHF - Konto 0883-622306-71-1, IBAN CH59 0588 1062 2306 7100 1<br/>
<b>EUR - Konto 0883-622306-72, IBAN CH52 0588 1062 2306 7200 0<br/></b>

<b><u>Aargauische Kantonalbank</u></b>, 5201 Brugg AG, Switzerland (BC 76130)<br/>
Swift KBAGCH22<br/>
CHF - Konto 16 1.119.968.08, IBAN CH46 0076 1016 1119 9680 8<br/>

" TextAlign="TopLeft" StyleName="DocContent" Name="advancedText2" Size="968.50396728515625;377.9527587890625"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="160" FamilyName="Tahoma" Size="6" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="161" /></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="162" /></Item><Item type="PerpetuumSoft.Reporting.DOM.GroupFooter" id="163" Location="0;1653.5433349609375" StyleName="DocContent" Name="groupFooter2" Size="2480.3149606299212;94.488189697265625"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="164"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="165" Expression="Duns("DocNum") & Duns("OpenCurr")" PropertyName="Group" /><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="166" Expression="Duns("TotalFee")>0" PropertyName="Visible" /></DataBindings><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="167"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="168" Location="1866.1417236328125;11.811023712158203" Text="TotalFee" TextAlign="MiddleRight" StyleName="DocContent" Name="textBox14" Size="354.33071899414062;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="169" UseCultureSettings="false" GroupSeparator=" '" FormatStyle="Number" NumberNegativePattern="1" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="170"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="171" Expression="Duns.Max("FeeMax",Duns("OpenCurr"))" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="172" Location="295.27560424804688;11.811023712158203" Text="Total Fee" TextAlign="MiddleRight" StyleName="DocContent" Name="textBox16" Size="1381.8897705078125;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="173" UseCultureSettings="true" FormatStyle="Number" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="174"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="175" Expression="Duns("TotalFee")>0" PropertyName="Visible" /><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="176" Expression="GetData("LD.Txt.T0002517")" PropertyName="Value" /></DataBindings></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="177" /></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="178"><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="179" Name="OpenSum" Expression="Duns("OpenSum")"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="180"><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="181" Expression="Duns("DocNum")" /><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="182" Expression="Duns("OpenCurr")" /></Groups></Item><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="183" Name="Levels" DataType="Integer" Expression="CINT(Duns("EDunLevel"))"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="184" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="185" Name="FeeMax" DataType="Decimal" Expression="Duns("TotalFee")"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="186"><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="187" Expression="Duns("DocNum")" /><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="188" Expression="Duns("OpenCurr")" /></Groups></Item><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="189" Name="Amnt" Expression="Duns("OpenSum")*Duns("IntrstPC")"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="190"><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="191" Expression="Duns("DocNum")" /><Item type="PerpetuumSoft.Reporting.DOM.AggregateGroup" id="192" Expression="Duns("OpenCurr")" /></Groups></Item></Aggregates></Item><Item type="PerpetuumSoft.Reporting.DOM.PageHeader" id="193" Location="0;165.35432434082031" Size="2480.3149606299212;425.19683837890625" Name="pageHeader1"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="194" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="195"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="196" Location="1464.56689453125;11.811023712158203" Margins="0; 0; 0; 11.8110236220472" Text="Dunning" TextAlign="MiddleRight" GenerateScript="txtDocTitel.Value=""
' Levels 
If Duns.Max("Levels",Duns("CardCode"))=0 Then
 txtDocTitel.Value=GetData("LD.Txt.T0002500")

Else If Duns.Max("Levels",Duns("CardCode"))=1 Then
 txtDocTitel.Value=GetData("LD.Txt.T0002500")

Else If Duns.Max("Levels",Duns("CardCode"))=2 Then
 txtDocTitel.Value=GetData("LD.Txt.T0002501")

Else If Duns.Max("Levels",Duns("CardCode"))=3 Then
 txtDocTitel.Value=GetData("LD.Txt.T0002502")

End If" StyleName="DocTitle" Name="txtDocTitel" Size="897.6378173828125;82.677162170410156"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="197" /></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="198" Location="1464.56689453125;94.488189697265625" Margins="0; 0; 11.8110236220472; 0" Text="Belegnummer" TextAlign="MiddleLeft" StyleName="DocLable" Name="textBox28" Size="342.51968383789062;59.055118560791016"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="199" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="200" TopLine="0.5 Solid Gray" LeftLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="201"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="202" Expression="GetData("LD.Txt.T0000041")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="203" Location="1807.086669921875;94.488189697265625" Text="Belegsdatum" TextAlign="MiddleLeft" StyleName="DocLable" Name="textBox19" Size="307.08660888671875;59.055118560791016"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="204" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="205" TopLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="206"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="207" Expression="GetData("LD.Txt.T0000040")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="208" Location="2114.17333984375;94.488189697265625" Margins="0; 0; 0; 11.8110236220472" Text="Seite" TextAlign="MiddleRight" StyleName="DocLable" Name="textBox77" Size="248.031494140625;59.055118560791016"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="209" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="210" TopLine="0.5 Solid Gray" RightLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="211"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="212" Expression="GetData("LD.Txt.T0000034")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="213" Location="2114.17333984375;153.54330444335938" Margins="0; 0; 0; 11.8110236220472" Text="Seiten" TextAlign="MiddleRight" StyleName="DocContent" Name="textBox78" Size="248.031494140625;70.866142272949219"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="214" RightLine="0.5 Solid Gray" BottomLine="0.5 Solid Gray" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="215" UseCultureSettings="true" FormatStyle="Custom" UseGroupSeparator="true" FormatMask="dd/MM/yyyy" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="216"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="217" Expression="LD.FStr(PageNumber,"##0") + " / " + LD.Fstr(PageCount,"##0")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="218" Location="1807.086669921875;153.54330444335938" Text="Belegdatum" TextAlign="MiddleLeft" StyleName="DocContent" Name="textBox27" Size="307.08660888671875;70.866142272949219"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="40" BottomLine="0.5 Solid Gray" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="219" UseCultureSettings="true" FormatStyle="Custom" UseGroupSeparator="true" FormatMask="dd/MM/yyyy" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="220"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="221" Expression="GetData("B1_Data.DunningWizard.CreateDate")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="222" Location="1464.56689453125;153.54330444335938" Margins="0; 0; 11.8110236220472; 0" Text="Belegnummer" TextAlign="MiddleLeft" StyleName="DocContent" Name="textBox1" Size="342.51968383789062;70.866142272949219"><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="223" FamilyName="Arial" Size="9.75" Underline="Off" Italic="Off" Bold="On" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="224" LeftLine="0.5 Solid Gray" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="225"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="226" Expression="GetData("B1_Data.DunningWizard.WizardName")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="227" Location="1464.56689453125;224.40945434570313" Margins="0; 0; 11.8110236220472; 0" Text="Kundennummer" TextAlign="MiddleLeft" StyleName="DocLable" Name="textBox3" Size="897.6378173828125;59.055118560791016"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="228" Color="Gray" /><Border type="PerpetuumSoft.Framework.Drawing.Border" id="229" RightLine="0.5 Solid Gray" LeftLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="230"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="231" Expression="GetData("LD.Txt.T0000042")" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="232" Location="1464.56689453125;283.46456909179688" Margins="0; 0; 11.8110236220472; 0" Text="Kundennummer" TextAlign="MiddleLeft" StyleName="DocContent" Name="textBox29" Size="897.6378173828125;59.055118560791016"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="233" RightLine="0.5 Solid Gray" LeftLine="0.5 Solid Gray" BottomLine="0.5 Solid Gray" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="234" UseCultureSettings="true" FormatStyle="Custom" UseGroupSeparator="true" FormatMask="dd/MM/yyyy" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="235"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="236" Expression="Duns("CardCode")" PropertyName="Value" /></DataBindings></Item></Controls></Item><Item type="PerpetuumSoft.Reporting.DOM.PageFooter" id="237" Location="0;3259.842529296875" Size="2480.3149606299212;271.65353393554688" Name="pageFooter1"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="238" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="239" /></Item></Controls><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="240" /></Item></Pages></root>
Patrick Stoeckli
Hallo Philipp,Veilen Dank für das Formular. Es funktionniert gut. Es berücksichtigt aber die Raten nicht. Die Raten werden nicht als selbstständige Rechnung gesehen. Ich habe aber einen Weg gefunden, es trotzdem richtig zu drucken.
Danke und Gruss
Patrick
0
Please sign in to leave a comment.
Comments
0 comments