Hi
relatively new to Dynamics and still trying to find my way. We have recently added extended text to our items as the description field wasn't long enough. Now this extended text shows up in quotes and on invoices with a $0 value against it.
How can we remove that?
Thank you
Katarina
Thank you. That is very helpful when we start with the word documents
Thank you, I will pass that on to those who do the coding.
And for WORD layouts, you'll have to create new XML-items.
You'll have to check in your OnAfterGetRecord (line), if the value is 0 then make the text empty.
if not zero, then convert the decimal value to a text.
so basicaly
if decimalValue = 0 then
TextValue := ''
else
TextValue := format(DecimalValue);
and add a column on the line to show the TextValue.
that you then use in the word layout instead of the standard xml field.
Hi KHayston - If you're using RDLC, use the command Code.BlankZero as a command
=Code.BlankZero(Fields!Abc.value)
Thanks. But the printing or not printing of the line is not the issue here. I don't want to have the $0 beside a comment line.
When you setup the Extended Texts if you scroll down on the page you can enable or disable which documents the Extended Texts show on.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156