retrieve "transactioncurrencyid" from parent "opportunity"

(1) Share

Report

Posted on by DiePic

448

Hi all

I'm trying to retrieve the /transactioncurrencyid/ from parent /opportunity/.
This is my Javascript lines:
var strValuta = parent.Xrm.Page.getAttribute(/transactioncurrencyid/).getValue();
var formattedCurrencyId = strValuta[0].id;
var formattedCurrencyName = strValuta[0].name;
alert(strValuta + / - / + formattedCurrencyId + / - / + formattedCurrencyName);

In my parent opportunity the currency is CHF but in the alert I retrieve the EUR that is not correct.
Can somebody correct my javascript or suggest me some alternate idea to retrieve the correct currency in my child table?
Thanks in advance

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi，

Your description: from parent /opportunity...in my child table..

Will this parent opportunity be a lookup field on a child table?

If so, you can get opportunity id, then use this id to retrieve this record to get transactioncurrencyid value.

Please refer to this example code
function getOpportunityCurrency(executionContext) { var formContext = executionContext.getFormContext(); var opportunityID = formContext.getAttribute("opportunityid")[0].id; Xrm.WebApi.retrieveRecord("opportunity", opportunityID, "?$select=_transactioncurrencyid_value").then( function success(result) { console.log(result); // Columns var opportunityid = result["opportunityid"]; // Guid var transactioncurrencyid = result["_transactioncurrencyid_value"]; // Lookup var transactioncurrencyid_formatted = result["_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue"]; var transactioncurrencyid_lookuplogicalname = result["_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname"]; alert(""); }, function(error) { console.log(error.message); } ); }

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No
DiePic 448 on at

Like (0)

Report
Copy link

Link copied!

Hi Leah Ju and thanks for the reply.
It's exactly what I was looking for.
Now with this javascript
if (!strNumOpportunita) {
formContext.getAttribute("ath_name").setValue(NumOpportunita);
formContext.getAttribute("transactioncurrencyid").setValue([{ id: strValuta, entitàType: "transactioncurrency" }]);
}

my value columns are correct, but how can I also change the name of the exposed "value" field?

Was this reply helpful? Yes No
Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi ,

The image is not loading.
You are trying to update the 'transactioncurrencyid' value on the child table, right?

This is one lookup column, you need set it's value with id, name and entity type.

It should be like:

Xrm.WebApi.retrieveRecord("opportunity", opportunityID, "?$select=_transactioncurrencyid_value").then( function success(result) { console.log(result); // Columns var opportunityid = result["opportunityid"]; // Guid var transactioncurrencyid = result["_transactioncurrencyid_value"]; // Lookup var transactioncurrencyid_formatted = result["_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue"]; var transactioncurrencyid_lookuplogicalname = result["_transactioncurrencyid_value@Microsoft.Dynamics.CRM.lookuplogicalname"]; var lookup = []; lookup[0] = {}; lookup[0].id = transactioncurrencyid; lookup[0].entityType = transactioncurrencyid_lookuplogicalname; lookup[0].name = transactioncurrencyid_formatted; // Get and Set New Lookup formContext.getAttribute("transactioncurrencyid").setValue(lookup); }, function (error) { console.log(error.message); } );

Was this reply helpful? Yes No
DiePic 448 on at

Like (0)

Report
Copy link

Link copied!

now it's working .... thank you very much Leah Ju

Was this reply helpful? Yes No