Open Forum

 View Only
  • 1.  How to show cheque amount in words within report writer

    TOP CONTRIBUTOR
    Posted Oct 26, 2022 09:50 AM
    Hi there,

    Please advise how can i show cheque amount in word within report writer. Not sure what calculated field i can create to convert number into words?

    Example:- $150.80 shown as "one hundred fifty dollars and Eighty cents" in report writer.

    Thanks!
    Sunaina

    ------------------------------
    Sunaina Sharma, Business Application Analyst(Admin)
    Oakville Enterprise Corporation
    ------------------------------


  • 2.  RE: How to show cheque amount in words within report writer

    GPUG ALL STAR
    Posted Oct 27, 2022 12:30 AM
    Have a look at the articles that describe the RW functions I created in core GP.

    Announcing Report Writer Function RW_ConvertToWordsAndNumbersParse | David Musgrave's Winthrop Development Consultants Blog (wordpress.com)

    RW – Getting RW_ConvertToWordsAndNumbers() to show cents in words | David Musgrave's Winthrop Development Consultants Blog (wordpress.com)

    RW – Getting RW_ConvertToWordsAndNumbers() to work with multi-currency | David Musgrave's Winthrop Development Consultants Blog (wordpress.com)

    Regards

    David

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

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

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



  • 3.  RE: How to show cheque amount in words within report writer

    TOP CONTRIBUTOR
    Posted Oct 27, 2022 03:55 PM
    Thanks David

    ------------------------------
    Sunaina Sharma, Business Application Analyst(Admin)
    Oakville Enterprise Corporation
    ------------------------------



  • 4.  RE: How to show cheque amount in words within report writer

    GPUG ALL STAR
    Posted 16 days ago
    Hi Sunaina,
    You shouldn't have to peform any custom report writer function to print your checks in "words" in GP.. My recalling is that this was added thru some PSTL option years ago: 
    Information about Check Amount to Words tool - Dynamics GP | Microsoft Learn

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role