Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

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

Posted on by 132
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!


 
  • viet561995 Profile Picture
    viet561995 132 on at
    Pricing for 1000 Products with Unit Piece & Cubic Meter (M3)
    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
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Pricing for 1000 Products with Unit Piece & Cubic Meter (M3)
    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!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans