Pricing for 1000 Products with Unit Piece & Cubic Meter (M3)

(0) Share

Report

Posted on by viet561995

194

Hey Dynamics 365 Sales gurus, I'm facing a pricing and unit conundrum and need your support.
I have over 1000 products with prices based on pieces & cubic meters, For example i have product A & B:

Product A:
- 1 piece = $356,703
- 1 piece = 37.3257 M3
- 1 M3 = $9,556.449 (converted price)
Product B:
- 1 piece = $534,545
- 1 piece = 27.9943 M3
- 1 M3 = $19,094.78 (converted price)

The challenge is that for product A, 1 piece = 37.3257 M3 but for product B 1 piece = 27.9943 M3. (The conversion is difference for 1000 products)

My problem is i need to create 1000 unit for the piece for 1000 product if i want to setup a different price. Use that Unit to setup the price list.

The question is:

How can I lower the amount of maintain the Unit Groups and Price Lists in D365 Sales to manage this dynamic pricing and conversion scenario for 1000+ products?
Is there a way to achieve automatic price calculations based on conversion (piece or M3) (I'm thinking about the quantity field in the Unit Group?

I'm open to any suggestions, tips, and tricks!

Thank you!

I have the same question (0)

All responses (2)

Answers (0)

Leah Ju Microsoft Employee on at

Like (1)

Report

Hi Partner,

So you're saying that these 1,000 products, whether they're sold by the piece or by the cube, are all priced differently?

--All different, had to set up 1000 units

You mentioned that prices are calculated automatically, so is there any pattern to the conversion between pieces and cubes?

--It's hard to do without a routine.

Looking forward to an engineer with more business experience to help answer the question!

Was this reply helpful? Yes No
viet561995 194 on at

Like (0)

Report

DearLeah Ju

Your answer somewhat answer my first question. But i still dont know what's the purpose of the "quantity field" and how it affect the quote's price

Was this reply helpful? Yes No

Join the conversation

Community site session details

Pricing for 1000 Products with Unit Piece & Cubic Meter (M3)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Pricing for 1000 Products with Unit Piece & Cubic Meter (M3)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates