web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Purchase Order format ...
Microsoft Dynamics GP (Archived)

Purchase Order format - Wrap line text

(0) ShareShare
ReportReport
Posted on by Community Member

I am trying to format the output of the Purchase Order.  We often have Order lines that need more than one line, howver I can find no setting in the Report Formatter that allows me set this option.

Any ideas on how to display multiple lines for a single purchase order item line?

*This post is locked for comments

I have the same question (0)
  • winthropdc Profile Picture
    winthropdc on at

    You can use the RW_ParseString() report writer function as a user defined function (system series) in a set of calculated fields.  You will need to make one calculated field for each line of x characters (up to max of 80).  This function will not split a word, but rather breaks on the spaces.

    The parameters are:

    in string IN_string;    { String Field to Parse }
    in integer IN_characters;  { Number of Characters per Line }
    in integer IN_line;    { Line Number to Return } 

    So an example would be for 3 lines of 50 characters

    Calc field 1: RW_ParseString('Description'   50   1)

    Calc field 2: RW_ParseString('Description'   50   2)

    Calc field 2: RW_ParseString('Description'   50   3)

    This does mean that you have to set aside the space for 3 lines on the report, and a gap will be left if the description does not need the number of lines.

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 


     

  • Community Member Profile Picture
    Community Member on at

    Thanks, it works a treat.

  • Community Member Profile Picture
    Community Member on at

    Thank you so much David, you're amazing!

  • Community Member Profile Picture
    Community Member on at

    David,

    Could you take this a step further?  I've added a calculated field to display the PO Note Text of the Blank Purchase Order.  I'm able to display the is first 80 characters but no more.  My field includes the following:

    function script RWGet NoteText POP_PO.PO Note ID Array(1) 80 1

    How and where does the RW_Parse String fit in?  I tried putting it first and then adding the above but receive an error message.  Am I assuming correctly that the ParseString would be part of the same calculated field?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans