MS Dynamics NAVISION report
I come to go along a situation where I have to show total in words. I am designing a report where I am going to show the total in MS Dynamics NAV. I am designing a report which shows total of customer's balance in Words. Let's have look.
We have to use a variable of report type 1401 which is using two functions:-
InitTextVariable & FormatNoTextI am using the REPORT Check 1401 and there may be diffrence in Database localisation. In INDIAN VERSION these two functions exists.Now I am going to show how I have used these reports and functions in my report.
When you see in INDIAN version of DB inside report 1401 there are above functions being used.
For the example I have taken Customer Table with the following Fields.
This is the code Which I have used to retrieve the total of Balance Field.
In the last screen I have selected a particular user For the balance.
You can see the amount in words which you can show in your report.
I hope you understand the process and code of using the functions in your report. For Further querry please comment.
In my above report code I have taken (notext VARIABLE of datatype text) which is a type of array with dimension 2 notext[1] contains your required result for showing amount in words.
Thanks,
No comments:
Post a Comment