Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
i am trying to create my custom template for our quotes and i have few questions:
A) How can i recall the customer (account information and contact) information (for instance: address, zip code, country) on the template quote? I can't find the function and field on the XML mapping...
I need to print on the quote the Account information and i don't want our users to write manually the information for each quote;
In the quote form i have these fields:
B) On the product lines i want that the template showing the item code (in our inventory is Product ID), however even with the field "Productid" it is still showing the product name instead of the product code. What should i do?
C) Our users want to put a discount per line based on a % not on a net value, how can i do that?
I would recommend you post each problem in a separate thread, rather than posting three problems in one thread.
A) Since the relationships between both Quote and Account, Quote and Contact are N:1, so we should select quote_customer_accounts and quote_customer_contacts in N:1 relationship when create a template.
In this way, we can insert Account and Contact fields in the word.
B) The name corresponding to the field "Product ID" is "productnumber" instead of "productid".
"productid" is the name of field "Product".
So you should select productnumber in xml mapping.
C) Could you provide more information?
For example, which field is your discount? Is it OOTB or custom?
How was it calculated? What fields are involved in the calculation?
Does the field involved in the calculation change after it becomes %?
For answer relate to A)
Thank you for your reply (I promise, next time I will separate the questions!)!
Ok, I will do that, but then on the quote form on the CRM should I have the possibility to select Account and Contact? Or as it is now I select only a contact or an account and then the template pick up only the related data?
For answer relate to B)
Thank you. I will try to find it because yesterday I was not able to see it. Maybe now with the new template I am going to create I will see it.
I will keep you posted.
Thank you again
For answer relate to C)
SO basically now on the system when I create a quote I can type manually a discount per line. What I can type is not a % but it is a net value, for instance 200 $.
Our business model is based on Retail price list where is indicated the retail price (so what is our product price in a boutique) however each of our account buys with a % discount from the public pricelist.
Item # 69 on pricelist A - 2019 has a retail price of 2000 USD;
When we create a quote for the account "retail 1" which has a negotiated standard discount of -45%, our operator should type on the item line Discount = 45 (not 950 USD) and the software should calculate the net price. That is similar on what's happens on Business Central on the quote.
At the moment there is on the quote form on Sales there is a line about % but is for the full order;
Would be amazing if I can create for each account conditions for the price lists (we have 3 different pricelist each with different products) so automatically when the operator picks up the quote the system pre-set the discount. But of course I don't know how to do it.
More question on B point;
Unfortunately I am not able to find the field "ProductNumber" on word ... why that?
I need your help on this. I need to complete the quote template and this is the major issue to the finalization of the job.
I got sick a few days ago so sorry for not responding to you in time.
Field 'Potential Customer' can only be selected for account or contact, not both.
So on the word template, there will only be one mapping between quote_customer_accounts and quote_customer_contacts has value. It displays related data based on the value of the field 'Potential Customer'.
The reason there is no field "ProductNumber" in word is that it is the field of the Product entity,not the Quote Line entity. So it does not appear in the mapping quote_details.
We need to create a new field for the Quote Line entity to inherit the value of the Product entity field.
There are several ways to achieve this, and I recommend using calculated fields here.
Don't set the condition of the calculated field, set its action to = productid.productnumber.
In this case, every time the Quote Line is saved, the new field will be changed with the value of the field "ProductNumber" of the Product entity.
Then, download the word template again, and you will see the new field, which is used to represent "Product ID".
There is a OOTB feature that can meet your needs, that is Discount List.
Using the Discount List, we can implement a discount that automatically applies percentages based on Quantity for a single Quote Line.
Please refer to this document to know how to set up discount lists: https://docs.microsoft.com/en-us/dynamics365/sales-enterprise/set-up-discount-list
Here is a demo.
I have three Discounts in a Discount List.
When you are creating Price List Item, you can choose Discount List.
The effect is as follows:
When I create a Quote Line and select the Price List Item as the Existing Product, whenever I enter a different Quantity, the field Amount will automatically apply the percentage discount based on the Discount List of the Price List Item.
For the Price List Item you have created, you have to export them to Excel and then edit and import it.
To keep this thread pure, I split the last question into a separate thread.
Please click Yes in my answers to close this thread.
The last issue will be discussed in the new thread.
Business Applications communities