Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

1.  Report Writer - Item description field length

GOLD CONTRIBUTOR
Posted 6 days ago
It looks like in the Sales Transaction Entry, the item description field can hold up to 100 characters but on the Report Writer report, the item description field only shows 50 characters so matter how wide you make your field.

Does anyone know how to have the enter item description value appear on the report? There must be a report writer function or calculated field that can do this.

Thank you

------------------------------
Christine Boisvert
IT Manager
Floform Countertops
Winnipeg MB
------------------------------


2.  RE: Report Writer - Item description field length

GPUG ALL STAR
Posted 5 days ago
@Christine Boisvert,

I remember that @David Musgrave published an article that talked about the maximum length of text fields on a Report Writer report. We needed to ensure that the cheque amount in words showed up fully on our A/P checks; so we used a Report Writer function to break apart the amount in words onto two lines.

What is the name of the report you're talking about? ​​There are three SOP Sales Transaction reports in our Report Writer list of "Original Reports". Which one are you trying to modify?

Regards,

------------------------------
"Sparkly" Steve Erbach - Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company - Appleton, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 (16.00.0439) / MR 2012 CU15
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach
------------------------------
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
------------------------------



3.  RE: Report Writer - Item description field length

TOP CONTRIBUTOR
Posted 5 days ago
Hi Christine,

I think 50 characters was the original length of the Item Description field, many years ago. I bet it was never updated when the field was changed to 100 characters a number of versions ago.

Unfortunately, if you want to use all 100 characters, you are going to run into a Report Writer limitation of 80 characters max per string. I believe information in this blog post can help with more detail:
https://blogs.msdn.microsoft.com/developingfordynamicsgp/2011/09/08/how-to-display-more-than-80-characters-of-an-extender-long-string-field-in-reports-using-the-support-debugging-tool/



------------------------------
Victoria Yudin
Microsoft Dynamics GP MVP 2005-2018
Flexible Solutions, Inc.
http://www.GPReportsViewer.com
http://victoriayudin.com
------------------------------



4.  RE: Report Writer - Item description field length

TOP CONTRIBUTOR
Posted 5 days ago
Hi Christine

Here is the article I wrote on this exact issue from 2009.

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2009/05/24/rw-showing-the-full-item-description-on-invoices-example/

David :-)

------------------------------
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
------------------------------



5.  RE: Report Writer - Item description field length

GOLD CONTRIBUTOR
Posted 5 days ago
Thanks everyone! I am modifying the SOP Long Options Invoice form. I can't link the SOP Line Work.Item Description field to the report therefore I will attempt to try and use the VBA route as recommended in David's link.

------------------------------
Christine Boisvert
IT Manager
Floform Countertops
Winnipeg MB
------------------------------



6.  RE: Report Writer - Item description field length

TOP CONTRIBUTOR
Posted 4 days ago
Hi Christine

Do you have GP Power Tools (Developer Tools Module) installed?

If so, you can create a custom RW function which is much neater than VBA and also works on the web client.

Let me know if you want details?

David

------------------------------
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
------------------------------