Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : lmR8ajCdvxAPHMEWvCKqQs
Microsoft Dynamics CRM (Archived)

Link Payment Terms Field

Like (0) ShareShare
ReportReport
Posted on 12 Feb 2017 06:41:45 by

Payment terms field in accounts entity is  mapped with payment terms field in quotes entity, but for some reason when i create the quote and identify the account, the payment terms field does not take the value as identified in the account entity. 

I need to do this step, as each account has its own payment terms method, and i don't want  each time when i create a quote to search what is the payment method for this account. 

*This post is locked for comments

  • Goloknath Profile Picture
    on 13 Jun 2017 at 09:47:54
    RE: Link Payment Terms Field

    If you don't need the information to be stored in quote, you can create an account quick view form and put that form into the quote. The quick view form should contain the payment details.

    Otherwise you can use a workflow to populate the value, i.e. set the quote.payment term to account.payment term bla bla bla

  • Andreas Oetken Profile Picture
    on 13 Jun 2017 at 09:37:28
    RE: Link Payment Terms Field

    ok, the "normal" business process is

    • to first create an opportunity for an account, and then
    • create a quote based on this opportunity.

    To our understanding this process is the main idea behind the concept of Dynamics 365.

    The opportunity entity has no fields for payment, freight and shipment terms, therefore these information cannot be mapped from an account to the opportunity.

    Our customer and we also expect from Dynamics 365, that the given payment terms of the associated account is copied into the new quote created from an opportunity.

    Otherwise it would make really no sense to store information about payment, freight and shipment terms into the account entity.

  • Goloknath Profile Picture
    on 13 Jun 2017 at 09:14:07
    RE: Link Payment Terms Field

    Dude. Your test steps are wrong.

    - adding a new quote and assigning it to an account, which already has payment terms defined

    >>Mapping will not trigger on lookup change. You have to go to account and add new quote from the associated view.

    - creating a new quote within an existing opportunity assigned to an account with payment terms defined

    >>This is not account to quote mapping, this is rather opportunity to quote mapping.

  • Andreas Oetken Profile Picture
    on 13 Jun 2017 at 07:45:21
    RE: Link Payment Terms Field

    The provided mapping of fields is already part of standard configuration of Dynamics 365.

    But unfortunately it does NOT work!

    I tested it with a new created D365-Account on two ways:

    - adding a new quote and assigning it to an account, which already has payment terms defined

    Result: Payment terms of the account are NOT copied to the quote

    - creating a new quote within an existing opportunity assigned to an account with payment terms defined

    Result: Payment terms of the account are NOT copied to the quote

    To my understanding the mapping of the field paymenttermscode from Account to Quote is correct and should work, when a new quote is created.

    But it does NOT work!

  • Suggested answer
    Nadeeja Bomiriya Profile Picture
    6,804 on 13 Feb 2017 at 01:44:45
    RE: Link Payment Terms Field

    Hi Shahd,

    +1 for Mark's suggestion.  Here's how to do it.

    Navigate to Settings > Customizations > Customize the system (Ideally, you should use a solution).

    Expand Entities > Quote

    Click N:1 Relationships

    Open the quote_customer_account relationship

    Click New

    Select the fields to map.

    Account-to-Quote-mapping.png

  • Suggested answer
    TheMarkChristie Profile Picture
    10,328 Moderator on 12 Feb 2017 at 12:44:45
    RE: Link Payment Terms Field

    Hi Shahd

    On the relationship between Accounts and Quotes you can add a map so it brings it through each time

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,533 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,619 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete