conversion of currency

(0) Share

Report

Posted on by pradeep M B

213

hello experts,

i have wriiten the below code for converting given currency into default currency . i am geeting wrong value, plse hlp me out.

[
SysEntryPointAttribute(false)
]

public void processReport()
{
SintoPCurrencyContractClass Contract;
Contract= this.parmDataContract();
accountNum=contract.parmAccountNum();

while select * from vendTrans

where

vendTrans.AccountNum ==accountNum

{
SintoPCuurencyTmp.AccountNum = vendTrans.AccountNum;
SintoPCuurencyTmp.Voucher = vendTrans.Voucher;
SintoPCuurencyTmp.AmountCur=vendTrans.AmountCur;
SintoPCuurencyTmp.Invoice=vendTrans.Invoice;
SintoPCuurencyTmp.CurrencyCode=vendTrans.CurrencyCode;
SintoPCuurencyTmp.IndAmountCur = any2real (Currency::amountCur2MST (vendTrans.AmountCur,"jpy"));

currencyExchangeHelper = CurrencyExchangeHelper::newExchangeDate(Ledger::current(), systemDateGet());
SintoPCuurencyTmp.IndAmountCur = currencyExchangeHelper.calculateCurrencyToCurrency('INR', vendTrans.CurrencyCode,vendTrans.AmountCur,true);

// SintoPCuurencyTmp.IndAmountCur=vendTrans.AmountMST;
// SintoPCuurencyTmp.IndCurrencyCode=vendTrans.CurrencyCode;
SintoPCuurencyTmp.VendName=vendTrans.vendTableName();

SintoPCuurencyTmp.insert();
}

}

I have the same question (0)

All responses (7)

Answers (5)

Sort by

Verified answer

Martin Dráb 239,392 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Do you realize that you assign IndAmountCur twice? Because the second assignment overwrites the first one, it's like if the first one wasn't ever there. If you don't want to use the first one, delete it. If you want, delete the second assignment.

If you still have a problem, come back and explain which calculation are you using.

Was this reply helpful? Yes No
Verified answer

Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

you have 2 lines with currency conversion.

"...Currency::amountCur2MST (vendTrans.AmountCur,"jpy")..."

"...currencyExchangeHelper.calculateCurrencyToCurrency('INR', vendTrans.CurrencyCode,vendTrans.AmountCur,true)..."

Where exactly do you get a wrong value?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi pradeep,

Have you checked the standard accounting currency conversion functionality that is available in the periodic section of the GL module?

What do you miss from this standard function that some coding is needed?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

This is the line of code that will set your IndAmountCur field:

SintoPCuurencyTmp.IndAmountCur = currencyExchangeHelper.calculateCurrencyToCurrency('INR', vendTrans.CurrencyCode,vendTrans.AmountCur,true);

Could you share us

- what values you pass to all these parameters

- what is the actual return value

- what is the expected return value?

Thanks!

Was this reply helpful? Yes No
pradeep M B 213 on at

Like (0)

Report
Copy link

Link copied!

thank you for response,

i want to convert any amount(us,jpy..etc) to indian currency

so can u hlp me out.

regards,

pradeep

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, we are happy to help you. Let's start by getting the relevant facts from your side - so could you please answer my previous question?

Was this reply helpful? Yes No
pradeep M B 213 on at

Like (0)

Report
Copy link

Link copied!

Thank you sir,

Now currency amount is working fine.

regards,

Pradeep

Was this reply helpful? Yes No