Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Link Payment Terms Field

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • 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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • 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
    Nadeeja Bomiriya 6,804 on at
    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
    TheMarkChristie 10,328 on at
    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans