Total document field in dunning letter

Giovanni Carletti

Dear Mr. Grenacher,

I'm working on dunning letter with my customer and I find that it's important to have in the dunning letter rows also a column with paid amount.

I start having an invoice with total amout of 1000 CHF. then the BP pay for example 400 CHF and then after 1 month when I'll generate the dunning letter, is important to show in the report that the original invoice have 1000 CHf as total amount, 400 CHF of "paid amount" and 600 CHf as open amount.

Actually the systems show both 600 CHf in the two columns...

Can you make available in the report design the Dun.DocTotal field or something else?

regards,
Giovanni Carletti

Philipp Knecht

Hi Giovanni

Paste this Control into the detail Section :

[quote]<?xml version="1.0" encoding="utf-16" standalone="yes"?><root type="PerpetuumSoft.Reporting.Designer.ReportClipboard" id="1" version="2"><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="2"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="3" Location="696.85039370078744;0" Text="RgTotal" TextAlign="MiddleLeft" GenerateScript="Dim docTotal As Double = 0&#xD;&#xA;If Duns(&quot;DocType&quot;)=&quot;13&quot; Then&#xD;&#xA; docTotal = LD.QueryDataNum(&quot;SELECT DocTotal FROM OINV WHERE DocEntry = &quot; &amp; Duns(&quot;DocAbs&quot;))&#xD;&#xA;End If&#xD;&#xA;textBox30.Value = docTotal" Name="textBox30" Size="271.65354330708664;70.866142272949219"><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="4" UseCultureSettings="false" FormatStyle="Number" UseGroupSeparator="true" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="5"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="6" Expression="Duns(&quot;DueDate&quot;) &amp; &quot; &quot; &amp; Duns(&quot;DocAbs&quot;)" PropertyName="Value" /></DataBindings></Item></Controls></root>

hth

Giovanni Carletti

Great Advice!

Thanks Philipp!

Giovanni from Lugano