Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Product Catalogue Advi...

Product Catalogue Advice For A Price Table

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, we sell a product and the price we charge depends on the size of the customer regards two factors - depending on number of employees and offices). Below is an example.

Does anyone have any suggestions on how this type of pricing would be best managed in Dynamics CRM?

We are using Sales Orders in Sales/CRM.

Employees	Offices
Employees	1	2 to 3	4 to 5	6 to 10	11 to 20	21 to 40	41+
1	$4	$6	$11	$14	$18
2 to 3	$7	$10	$13	$17	$25
4 to 6	$12	$16	$21	$23	$27	$33
7 to 10	$22	$26	$32	$43	$60	$80
11 to 20	$32	$38	$53	$67	$870	$114
21 to 50	$49	$54	$70	$78	$112	$147
51 to 99	$75	$81	$112	$120	$147	$182
100 to 249	$105	$113	$120	$144	$172	$205
250 to 500	$120	$137	$145	$190	$221	$250	$275
501+	$150	$168	$180	$210	$240	$271	$301

Thanks for any help.

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Product Catalogue Advice For A Price Table

Hello,

I believe you can use Price Lists if you want to use the default functionality without extra customization.

I would create a Price List for each relation between Employee and Office.

Then, under Product, create a Price List Item for each Price List with the desired price.

Then, on the Sales Order or other sales entity, create a script to auto populate the price list base on the client information, regards the Employees and Offices.

When adding products to the sales entities, it will display automatically the prices based on the Price List.

Hope this helps you finding the best solution.

Cheers!

Pedro Pisco