{"id":135,"date":"2019-04-19T19:03:23","date_gmt":"2019-04-19T19:03:23","guid":{"rendered":"http:\/\/morepalmer.org\/?p=135"},"modified":"2019-06-03T20:44:46","modified_gmt":"2019-06-03T20:44:46","slug":"auto-populate-fields-on-quote-creation","status":"publish","type":"post","link":"https:\/\/morecpq.com\/index.php\/2019\/04\/19\/auto-populate-fields-on-quote-creation\/","title":{"rendered":"AUTO-POPULATE Fields on Quote Creation"},"content":{"rendered":"\n<p>Repubished from here: <a href=\"https:\/\/learningsalesforcecpq.com\/2018\/09\/19\/auto-populate-fields-on-quote-creation\/\">https:\/\/learningsalesforcecpq.com\/2018\/09\/19\/auto-populate-fields-on-quote-creation\/<\/a><\/p>\n\n\n\n<p>A specific set of fields on Quote can be&nbsp;<strong>auto-populated<\/strong>&nbsp;from the associated&nbsp;<strong>Opportunity<\/strong>&nbsp;and&nbsp;<strong>Account<\/strong>&nbsp;at the time of creating a new Quote.<\/p>\n\n\n\n<p>If you do not do the necessary setup, sales reps would spend time re-entering Quote fields which were already filled in at the time of creating Opportunity and Account.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i2.wp.com\/learningsalesforcecpq.com\/wp-content\/uploads\/2018\/09\/quote-without-account-and-address-information-details.png?zoom=2&amp;resize=770%2C323&amp;ssl=1\" alt=\"New Quote Creation Page WITHOUT auto-populated fields\" class=\"wp-image-318\"\/><figcaption>New Quote Creation Page WITHOUT auto-populated fields<\/figcaption><\/figure>\n\n\n\n<p>Salesforce CPQ provides a&nbsp;<strong>Field Metadata<\/strong>&nbsp;custom setting where we can set up the fields that we want to be pre-filled with the corresponding values on Quote creation.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/learningsalesforcecpq.com\/wp-content\/uploads\/2018\/09\/quote-with-account-and-address-information-details.png?zoom=2&amp;resize=770%2C324&amp;ssl=1\" alt=\"AUTO-POPULATE Fields on New Quote Creation\" class=\"wp-image-317\"\/><figcaption>New Quote Creation Page WITH auto-populated fields<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Use Case<\/h2>\n\n\n\n<p>John Cook works as a CPQ Administrator at Universal Containers (UC). Usually, Sales reps at UC go through&nbsp;<strong>Account -&gt; Opportunity -&gt; Quote<\/strong>&nbsp;flow to create new Opportunities and Quotes.<\/p>\n\n\n\n<p>While creating a new Opportunity from an Account, lookup to that Account gets set on the Opportunity. While creating a new Quote from an Opportunity, lookup to that Opportunity gets set but,<strong>&nbsp;lookup to the Opportunity\u2019s Account DOESN\u2019T get set&nbsp;<\/strong>on the Quote. Reps have to explicitly select the corresponding Account in Account field on the Quote.<\/p>\n\n\n\n<p>Sales Reps expect that the system should be smart enough to automatically pre-populate the Account lookup on Quote with its Opportunity\u2019s Account.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Setup?<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>Navigate to&nbsp;<strong>Setup | Develop | Custom Settings | Field Metadata<\/strong>. Click&nbsp;<strong>Manage<\/strong>Field Metadata<\/li><li>Click&nbsp;<strong>New<\/strong>&nbsp;on the Field Metadata page.<\/li><li>Enter the&nbsp;<strong>Name<\/strong>,&nbsp;Field Name and&nbsp;<strong>Object Name<\/strong>&nbsp;of the Field you want to auto-populate where<ul><li><strong>Name<\/strong>: SFDC ID of Account Field (SFDC ID of the Quote Field)<\/li><li><strong>Field Name<\/strong>: SBQQ__Account__c (Quote Field API Name)<\/li><li><strong>Object Name<\/strong>: SBQQ__Quote__c (API Name of the Object)New Field Metadata Custom Setting RecordNew Field Metadata Record<\/li><\/ul><\/li><li>To get the Account Field SFDC ID, navigate to&nbsp;<strong>Setup | Build | Create | Objects | Quote | Account Field.&nbsp;<\/strong>Copy the SFDC ID from the address URL of this page.Account Field on Quote<\/li><li>Click&nbsp;<strong>Save<\/strong>.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Check if it works as expected<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>Navigate to the&nbsp;<strong>Opportunity&nbsp;<\/strong>on which you want to create a new Quote, go-to<strong>&nbsp;Quotes Related List&nbsp;<\/strong>and click<strong>&nbsp;New&nbsp;<\/strong>button.Opportunity Page- Account Details<\/li><li>Once done, you can see that the Account field on Quote gets pre-filled with the associated&nbsp;<strong>Opportunity\u2019s Account<\/strong>&nbsp;i.e.&nbsp;<strong>Genepoint<\/strong>.Account Field pre-populated with Opportunity\u2019s Account on Quote<\/li><li>Repeat for the other Fields that you want to be auto-populated.All records in Field Metadata Custom SettingAll records in Field Metadata<\/li><li>When you click&nbsp;<strong>New Quote<\/strong>&nbsp;button in Quotes related list on Opportunity, you can see that the&nbsp;<strong>Account<\/strong>,&nbsp;<strong>Sales Rep<\/strong>&nbsp;and&nbsp;<strong>Billing &amp; Shipping Address<\/strong>&nbsp;fields on Quote are auto-populated with the information from associated Opportunity and Account.Quote Creation Page WITH auto-populated fields<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Considerations<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Supported Fields \u2013&nbsp;<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>You can configure the following fields to auto-populate on a quote:<\/li><\/ul>\n\n\n\n<table class=\"wp-block-table\"><tbody><tr><th>FIELD LABEL<\/th><th>FIELD API&nbsp;NAME<\/th><\/tr><tr><td>Account<\/td><td>SBQQ__Account__c<\/td><\/tr><tr><td>Billing City<\/td><td>SBQQ__BillingCity__c<\/td><\/tr><tr><td>Billing Country<\/td><td>SBQQ__BillingCountry__c<\/td><\/tr><tr><td>Billing Name<\/td><td>SBQQ__BillingName__c<\/td><\/tr><tr><td>Billing Postal Code<\/td><td>SBQQ__BillingPostalCode__c<\/td><\/tr><tr><td>Billing State<\/td><td>SBQQ__BillingState__c<\/td><\/tr><tr><td>Billing Street<\/td><td>SBQQ__BillingStreet__c<\/td><\/tr><tr><td>Distributor<\/td><td>SBQQ__Distributor__c<\/td><\/tr><tr><td>Partner<\/td><td>SBQQ__Partner__c<\/td><\/tr><tr><td>Primary Contact<\/td><td>SBQQ__PrimaryContact__c<\/td><\/tr><tr><td>Sales Rep<\/td><td>SBQQ__SalesRep__c<\/td><\/tr><tr><td>Shipping City<\/td><td>SBQQ__ShippingCity__c<\/td><\/tr><tr><td>Shipping Country<\/td><td>SBQQ__ShippingCountry__c<\/td><\/tr><tr><td>Shipping Name<\/td><td>SBQQ__ShippingName__c<\/td><\/tr><tr><td>Shipping Postal Code<\/td><td>SBQQ__ShippingPostalCode__c<\/td><\/tr><tr><td>Shipping State<\/td><td>SBQQ__ShippingState__c<\/td><\/tr><tr><td>Shipping Street<\/td><td>SBQQ__ShippingStreet__c<\/td><\/tr><\/tbody><\/table>\n\n\n\n<h3 class=\"wp-block-heading\">Billing Address Fields<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>When billing address fields are set to auto-populate, bill-to information is pulled from either the distributor, partner or direct account&nbsp;<strong>present on the Opportunity<\/strong>:<ul><li><strong>By default<\/strong>, bill-to information is pulled from the distributor account.<\/li><li>If there is no distributor account present on the opportunity, billing information is pulled from the partner account.<\/li><\/ul>If there is no partner account present on the opportunity, billing information is pulled from the direct account i.e. Opportunity\u2019s Account.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Shipping Address Fields<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>When shipping fields are set to auto-populate, ship-to information is pulled from the direct account&nbsp;<strong>present on the Opportunity<\/strong>. If ship-to information within the direct account is empty, the auto-populating fields will instead pull the values from bill-to information.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Special Fields on Opportunity<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>You need to create special fields on Opportunity to auto-populate below fields on the Quote.<\/li><\/ul>\n\n\n\n<table class=\"wp-block-table\"><tbody><tr><th>QUOTE FIELDS<\/th><th>SPECIAL FIELDS TO BE CREATED ON OPPORTUNITY<\/th><\/tr><tr><td>Primary Contact<\/td><td>QuotePrimaryContact__c<\/td><\/tr><tr><td>Partner<\/td><td>QuotePrimaryPartner__c<\/td><\/tr><\/tbody><\/table>\n\n\n\n<h3 class=\"wp-block-heading\">Sales Rep Field on Quote<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>If \u201cSBQQ__SalesRep__c\u201d field is added in the&nbsp;<strong>Field Metadata<\/strong>&nbsp;custom setting, Quote\u2019s&nbsp;<strong>Sales Rep<\/strong>&nbsp;field is pre-filled with the value from&nbsp;<strong>Opportunity\u2019s Owner&nbsp;<\/strong>field.<\/li><li>Navigate to the&nbsp;<strong>Opportunity&nbsp;<\/strong>on which you want to create a new Quote, go-to<strong>&nbsp;Quotes Related List&nbsp;<\/strong>and click<strong>&nbsp;New&nbsp;<\/strong>button.<br><ul><\/ul><\/li><li>You can see that the Sales Rep field on Quote gets pre-filled with the associated&nbsp;<strong>Opportunity\u2019s Owner<\/strong>&nbsp;i.e.&nbsp;<strong>JASON LIVESTON<\/strong>.Sales Rep Field pre-populated with Opportunity\u2019s Owner on Quote<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Repubished from here: https:\/\/learningsalesforcecpq.com\/2018\/09\/19\/auto-populate-fields-on-quote-creation\/ A specific set of fields on Quote can be&nbsp;auto-populated&nbsp;from the associated&nbsp;Opportunity&nbsp;and&nbsp;Account&nbsp;at the time of creating a new Quote. If you do not do the necessary setup, sales reps would spend time re-entering Quote fields which were already filled in at the time of creating Opportunity and Account. Salesforce CPQ provides a&nbsp;Field &hellip;<br \/><a href=\"https:\/\/morecpq.com\/index.php\/2019\/04\/19\/auto-populate-fields-on-quote-creation\/\" class=\"more-link pen_button pen_element_default pen_icon_arrow_double\">Continue reading <span class=\"screen-reader-text\">AUTO-POPULATE Fields on Quote Creation<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,23],"tags":[27,25,26,24],"class_list":["post-135","post","type-post","status-publish","format-standard","hentry","category-cpq","category-hidden-features","tag-auto-populate","tag-creation","tag-hidden-features","tag-quote"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":3,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":198,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions\/198"}],"wp:attachment":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/tags?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}