Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / I need a cheque writin...
Microsoft Dynamics GP (Archived)

I need a cheque writing software

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello all,

Please I need your help.

My question is a little bit different.

GP is not converting amount in word accurately. for example 9999.99

gp will convert it has nine thousand nine hundred and ninety nine Naira 99 kobo

but banks in Nigeria cant accept a check that has such an amount in words because the decimal figures is not converted.(nine thousand nine hundred and ninety nine Naira ninety nine kobo )

I tried to write a VB script but its giving me Run time error most times but some time it will work.

I decided to have a third party check writing software that can convert all the figures into words and print on a check leaflet.

What kind of software can I use with GP for check writing.

I will really appreciate your support.

Thank you

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need a cheque writing software

    Ok thank you

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: I need a cheque writing software

    You just align that two fields like below the screen shot.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need a cheque writing software

    Thank you.

    But how do I have these fields in report with horizontal alignment.

    Thank you

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: I need a cheque writing software

    You need to create two local string variables. One is converting round values to string and another is converting decimal values to string and finally use these fields in report with horizontal alignment.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need a cheque writing software

    @All thanks fir your responses God bless.

    @Soma please what can I do if I have more than eight nine chars. Because that's is the scenario that I have.

    Thank you

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: I need a cheque writing software

    Ian is correct. The string field in GP Report writer is support only 89 chars. Thinking the amounts to words are coming within 89 chars. So, try Ian response. If you have any doubt for converting amounts to words, follow the below link that will help you in coding level.

    congruentdynamics.blogspot.in/.../converting-dollars-and-cents-to-words.html

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: I need a cheque writing software

    that is probably the GP report writer seeing the field as not wide enough.  Make it wider in report writer so that it can display all of its contents.  You may have to mess with the font size so it fits on a cheque.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need a cheque writing software

    @Mariano

    Thank you for your response it really helped me.

    But I have  challenge with length.

    It could not convert 9,999,999.99

    It was converting it as" Ninety Nine Nine Million Nine hundred ninety nine Th"

    Please how can I resolve this issue.

    Thank you

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: I need a cheque writing software

    What you will need to do here is slightly different. You will need to create two calculated fields in Report Writer: 1 for the integer part of the amount and one for the decimal part. In both cases, you will use the RW_ConvertToWordsAndNumbers or the RW_ConvertToWordsAndNumbersParse to get the equivalent amount in words for both the integer and decimal part. You will then need to strip the currency termination for the decimal part as this may contain the currency unit (Naira) and replace it for the currency subunit (Kobo). You may need to create a third calculated field for this and use the RW_Replace function.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: I need a cheque writing software

    Hello,

    Please I need your help.

    GP is not converting amount in word accurately. for example 9999.99

    gp will convert it has nine thousand nine hundred and ninety nine Naira 99 kobo

    but banks in Nigeria cant accept a check that has such an amount in words because the decimal figures is not converted.(nine thousand nine hundred and ninety nine Naira ninety nine kobo )

    I tried to write a VB script but its giving me Run time error most times but some time it will work.

    I decided to have a third party check writing software that can convert all the figures into words and print on a check leaflet.

    What kind of software can I use with GP for check writing.

    I will really appreciate your support.

    Thank you

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans