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!