Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Calculated field using...
Sales forum
Suggested answer

Calculated field using another field from another entity

Posted on by 138

Hi,

I am new to D365 CE and i am trying to replicate what i have in the below image to populate a field off another field of different entity.

Thank you.

0143.tempsnip.png

  • Suggested answer
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: Calculated field using another field from another entity

    Hi zyir,

    I recommend you use the rollup field to do this: Dynamics 365 Rollup Fields - Carl de Souza

  • zyir Profile Picture
    zyir 138 on at
    RE: Calculated field using another field from another entity

    Thank you, Haag Liu

    While i go through the links you send here is what i am trying to achieve

    "I created a service Order Details table that contains multiple Tarif amount, and i am trying to make use of all total amount in the service Order Details on a new Table called Service Order to calculate discount, Tax etc just like the Image i attached". 

  • Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: Calculated field using another field from another entity

    Hi zyir,

    I would like to know why you copied the field and where you are going to fill it in.

    To retrieve a record from different entity and populate in a form based on selected product: https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/382366/how-to-retrieve-a-record-from-different-entity-and-populate-in-a-form-based-on-selected-product

    Automatically populate fields from another entity: https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/392999/auto-fill-field-from-another-entity

    Or auto populate an entity such as order: https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/409849/auto-populate-order-addresses 

    I need to know more about your needs.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans