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) / Check amount preceded ...
Microsoft Dynamics GP (Archived)

Check amount preceded by leading asterisks

(0) ShareShare
ReportReport
Posted on by DebN 3,954

Is this possible?  I either get too much space between the end of the asterisks and the amount or the asterisks overwrite part of the check amoun.  Do I need a calculated field?

*This post is locked for comments

  • DebN Profile Picture
    DebN 3,954 on at
    RE: Check amount preceded by leading asterisks

    Thank you, MaxB!  I didn't realize that option existed.  I did get it to work by concatenating asterisks with the amount using the RW_Format function.  

  • Verified answer
    DinB Profile Picture
    DinB 3,812 on at
    RE: Check amount preceded by leading asterisks

    There is actually an option in Report Writer to create a new Format  and fill the blank space with Asterisk. See if this works.

    Asterisk.jpg

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Check amount preceded by leading asterisks

    Deborah,

    I suspect the answer is to convert the numeric value to text inside of the calculated field.

    Kirk

  • DebN Profile Picture
    DebN 3,954 on at
    RE: Check amount preceded by leading asterisks

    Hi Kirk,

    Yes, I did create a calculated field to concatenate the asterisks with the Check Total field (converted to a string) but the I loose the formatting of the amount - no comma (thousands separator).  Do I need to include another function in there to keep the number formatting?

    Thank you.

    Deborah

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Check amount preceded by leading asterisks

    Hi Deborah,

    Have you tried making a calculated field to concatenate the leading and trailing asterisk with the check amount? This is how I make our code39 barcodes work with the SOP Number field on sales orders.

    Regards,

    Kirk

  • DebN Profile Picture
    DebN 3,954 on at
    RE: Check amount preceded by leading asterisks

    Hi Matt,

    Thanks for the post but we're trying to add leading asterisks, not trailing.

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Check amount preceded by leading asterisks

    I would take a look at this blog post.  It's old but should still be applicable:

    dynamicsgpblogster.blogspot.com/.../how-to-add-trailing-asterisks-after.html

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,399 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans