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 GiovanniPaste 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
If Duns("DocType")="13" Then
 docTotal = LD.QueryDataNum("SELECT DocTotal FROM OINV WHERE DocEntry = " & Duns("DocAbs"))
End If
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("DueDate") & " " & Duns("DocAbs")" PropertyName="Value" /></DataBindings></Item></Controls></root>
hth
Giovanni Carletti
Great Advice!Thanks Philipp!
Giovanni from Lugano
0
Please sign in to leave a comment.
Comments
0 comments