Amount In words in Arabic

[former_member351438]

Dear Sap Masters.

As per my subject name. I want to show amount in words in Arabic format.

I pasted my formula i created in crystal report for your reference. Hope you can help me with this one. Thanks a lot

IF {OINV.DocCur} = 'SAR' THEN
{OINV.DocCur} + ' ' + UPPERCASE(ToWords({OINV.DocTotal}))
ELSE 
{OINV.DocCur} + ' ' + UPPERCASE(ToWords({OINV.DocTotalFC}))

[ido_millet · Accepted solution]

The image below shows the results from a prototype UFL function to do this.
The test assumes you wish to specify the amount as currency in Egyptian pounds.
Are the results correct?

[former_member351438 · Accepted solution]

This what I need. Please

[former_member351438 · Accepted solution]

Hello,

Im hoping you can guide me.

[former_member905677 · Accepted solution]

hi, ido Millet

i want this kind of result on above image like Value in Arabic

i tried but didn't get any solution i try 3rd party tool that you share blow but didn't get solution

can you please share me this formula or UFL dll that you used in formula ?

[mrhs84 · Accepted solution]

Could you please provide me with the function?

[ido_millet · Accepted solution]

This function is part of my CUT Light UFL (User Function Library):
https://www.milletsoftware.com/CUT_Light_User_Manual/#uflNumber2Arabic()

There are other 3rd-party UFLs listed here.

[ido_millet]

I finished implementing this as a new function in my UFL (User Function Library).
A list of 3rd-party UFLs is available here, and mine is one of them.
Or you can implement similar logic in your own UFL.

[abhilash_kumar]

Hi,

The ToWords function in CR only supports English words.

You'd need to write your own function that converts amounts into Arabic literals.

-Abhilash

[former_member351438]

Hello,

Can you teach me how to do that?

[ido_millet]

Search for past threads on this topic.
For example: https://answers.sap.com/questions/442464/sap-crystal-reports-how-to-use-towords-to-display.html