Use of sold products - purchased Electricity

(3) Share

Report

Posted on by Joke Laukens

I'm trying to set op some demo data on use of sold products - purchased Electricity.

The OOTB calculation model 'Use of Sold Products - Purchased Electricity: Location-Based' uses following logic referencing the activity.msdyn_lifespaninyears.

When importing some activity data, I cannot map with a 'lifespaninyears' field.

The field is not available in the Excel template either.

When checking out the documentation referenced in the excel template (https://learn.microsoft.com/en-us/common-data-model/schema/core/industrycommon/sustainability/purchasedenergy), there is mention of the lifespaninyears field.

So there should be a field.. however, there seems to be no possibility to fill it with de OOTB import possibilities??

FYI: I'm not considering manual entry as I want to prove the automation options.

What am I missing, or what is MSM missing?

Thanks.

Follow up question:

I wasn't able to import data into that field, but somehow (bug??/magic??) some data was automatically entered into the lifespan (in years) field..

How did that happen?

Categories:

Sustainability Manager

All responses (4)

Answers (1)

Ivan (Vanya) Kashperuk on at

Like (0)

Report

Use of sold products - purchased Electricity

All you can see is the lock icon, meaning this field is not editable.

OCID, on the other hand, would be editable on record creation, I guess.

But yeah, I will create a request to make it more explicit in the documentation
Joke Laukens 91 on at

Like (0)

Report

Use of sold products - purchased Electricity

Hi @Ivan (Vanya) Kashperuk,

Can you please answer my follow-up questions?

Thank you!
Joke Laukens 91 on at

Like (0)

Report

Use of sold products - purchased Electricity

Hi @Ivan (Vanya) Kashperuk

Thank you for your reply. This helps a lot.

Follow up question:

You mention that it is a calculated field, as I can see in the form, but I'm not quite sure how I should see that..

There is a lock icon - but so has the correlation ID and the correlation ID was provided by me in the source Excel.

I cannot find that information in the documentation either, see screenshots below.

Can you please point out where I could find this information? Maybe I'm missing a crucial part of documentation.

Thank you.
Verified answer

Ivan (Vanya) Kashperuk on at

Like (1)

Report

Use of sold products - purchased Electricity

So Lifespan is as you can see on the form is a calculated field, you cannot manually specify it.

The way it is calculated is quite simple - total number of days between consumption start and end dates, divided by 365 (so it's total number of years, essentially)

Your screenshot seems to have the From/To dates the same, which should result in 0, and that's what happens in a test environment I tried.