Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
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 have a requirement to run Dynamics CRM for a silver products manufacturer. These products are valued according to their weight.
Now, of course there is an estimated average weight for each item - but the catch is that actual sales and inventory relate to the precise weight of each item (silver is a precious metal and every gram/ounce counts).
The complication is due to the fact that the product is 1 unit but it's price is driven by it weight, so actually - price unit is per gram but sale unit is one product (say-a silver goblet).
At Quotes and Orders stages of the flow - an average weight will suffice, but once the flow reaches Invoice and even before on vendor and Inventory - weight MUST be exact.
I'm banging my head for quit a while to find a solution......
Anyone with an idea??
Please check the below approach:
1. Rename the "Quantity" (Out of box) field to "Effective Weight"
2. Add new field "Product Quantity" - This represents the number of products
3. Add new field "Product Weight" - This field represents weight of each product.
4. Effective weight = (Product Quantity) * (Product Weight) - (Business rule / Plugin)
This will give you the effective weight of silver in the out of box quantity.
Your price should be per gram.
Your product line (quote / order / invoice) represents the total silver gms.
That's all nice and neat
But what about the product configuration? what will be the unit settings for such a product?
Will it be Grams (the price unit) or shall it be Goblet (the sales unit)?
It totally affects Quotes, Orders, Invoices etc.
It is suggested you define it per gram. Then only the effective weight (Quantity) field will be helpful to calculate the actual value.
OK I'll give a shot and see how it all works.
Did the solution work for you. If yes, please close the thread by marking an answer verified.
Business Applications communities