Plaza 365
Plaza 365

No results found for your search

RegisterLog in

5

#GPPT Fixing the 80 character limitation for the rw_CreateSOPTrackingNumberString report writer function

Visit article

#customization

#gppowertools

#reportwriter

#stringmanipulation

#trackingnumbers

Dynamics 365 ERP - Development

Category

Sep 30, 2023

Published date

Text

Article Type

AI Summary

  • Leslie Vail, a GP Legend, will be presenting a session on Report Writer User Defined Functions at the upcoming Community Summit 2023.
  • Leslie encountered a limitation in Dexterity, the development tool behind Microsoft Dynamics GP, which truncates strings returned by Report Writer Calculated fields to 80 characters.
  • The limitation is a known issue and will not be fixed.
  • The only solutions are to use a custom Dexterity dictionary or a custom Report Writer function using GP Power Tools.
  • The article provides two versions of a custom report writer function to wrap the rw_CreateSOPTrackingNumberString() function and split the results based on comma characters.
  • The first version splits the tracking numbers into lines of up to 80 characters.
  • The second version splits the tracking numbers into individual numbers.
  • The article includes a screenshot of the Project Setup window showing the custom report writer functions, testing script, and associated scripts.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.