Microsoft Dynamics AX (Archived)

how to convert the Total Net amount into Amount in Words in SSRS Report

(0) Share

Report

Posted on by srinivas pamidi

1,737

i am currently Working on the Purchase order SSRS Report.

i need to display the Amount in words of the Total PO amount,

Please Help me.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

public str AmountToWords(real _amount)
{

int amount;

str amount2Words;

amount = real2int(round(_amount , 1));

amount2Words = Global::numeralsToTxt(amount);

amount2Words = subStr(amount2Words,5,strLen(amount2Words)-4);

amount2Words = subStr(amount2Words,strLen(amount2Words)-10,-strLen(amount2Words));

amount2Words = '(Amount:' +' '+ str2Capital(amount2Words) + ' only)';

return amount2Words;

}

for more information you can visit: https://360dynamics.blogspot.com/2017/09/dynamics-ax-x-code-amount-to-word.html

Was this reply helpful? Yes No
Suggested answer

Mallika Roy 552 on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

Hi,

Add a str2016 type field in the temporary table. You need to refresh the dataset to get the new field in visual studio level. In DP class pass the total amount to Global::numeralsToTxt(TotalAmount) and assign it in the new field.

Was this reply helpful? Yes No
Sohaib Cheema 47,776 User Group Leader on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

your code above, is correct

Simply

PurchPurchaseOrderHeader .NewStringTypeField = Global::numeralsToTxt(PurchPurchaseOrderHeader .Amount);

Note:

If Field is not coming in DataSet, its a spate subject, which can be because of any reason. I would not be interested to comment on that

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

i am understand, but which Code is writing on that Place.

i am adding a New String Field in the PurchPurchaseOrderHeader but it is not Coming in the Data Set.

Please Provide me the Code if Possible.

Was this reply helpful? Yes No
Sohaib Cheema 47,776 User Group Leader on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

yeah that should most likely a workable code by putting it on this table.

another approach can be adding code in at following location

\Classes\PurchPurchaseOrderDP\setPurchPurchaseOrderHeader

just before/above this line of code

purchPurchaseOrderHeader.insert();

you have to add a string type field, in your PurchPurchaseorderHeader , in this case and that would reflect the String/Amount in words on SSRS

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

Hi Sohaib,

I am Writing the below Code in PurchPurchaseorderHeader Table.

display str numToText()

{

Str text;

text = Global::numeralsToTxt(this.Amount);

return text;

}

My Question Is How to Get this in the Visual studio dataset

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

Please Give The Detailed Explanation.

i am customizing the Purchase order Report.

Where to write this Code.

and Where To add this Field.

Was this reply helpful? Yes No
Sohaib Cheema 47,776 User Group Leader on at

Like (1)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

you cannot do this on SSRS level, easily.

The most optimal way is to do it inside AX and send results to SSRS just to display those

you may use Global::numeralsToTxt

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: how to convert the Total Net amount into Amount in Words in SSRS Report

Use

Global method likewise

Global::num2Text("");

Was this reply helpful? Yes No