web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Pricing for 1000 Produ...
Customer experience | Sales, Customer Insights,...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by viet561995 196
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!


 
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    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!
  • viet561995 Profile Picture
    viet561995 196 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 87 Most Valuable Professional

#2
11manish Profile Picture

11manish 69 Super User 2026 Season 2

#3
Syed Aqib Raza Profile Picture

Syed Aqib Raza 48

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans