Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Economic reorder quantity
Small and medium business | Business Central, N...
Suggested answer

Economic reorder quantity

(1) ShareShare
ReportReport
Posted on by LF-16052033-0 220
Hello experts, 
 
When running planning, is there a way to tell the system to generate a plan that will result in purchasing a quantity that will result in the lowest total cost for that item. For example, we would by a screw for $.10, but we want to supply demand for 1000 screws as we would get a better price break. 
Categories:
Business Central
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,377 Super User 2024 Season 2 on at
    Economic reorder quantity
    first you need to know what qty will get a better price. This is maintained on item and/or vendor card. BC won't recommend a qty for you to purchase,
    the user must balance between the qty and price. For example, if you have a demand of 800 screws, you need to check if a bigger order will get better price. So BC only gives your suggestion if you run item planning or requisition worksheet. 
     
    Jun Wang
     
     
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,738 Super User 2024 Season 2 on at
    Economic reorder quantity
    No customization required.  As Valentin mentioned, a Fixed Reorder Quantity of 1000 OR Lot-for-Lot/Max Qty with an Order Multiplier of 1000.  You only need to include a Minimum Order Quantity if it is greater than your Order Multiplier.
     
    As mentioned before, this is not cost based, it is purely a quantity adjustment.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 71,565 Super User 2024 Season 2 on at
    Economic reorder quantity
    As far as I know, the standard doesn't have this feature.
    The easiest way is to customize a page that can prompt you with the most suitable price (or just price list).
     
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Economic reorder quantity
    The planning engine doesn't incorporate item cost/value. It only looks at quantities, so suggesting the lowest total cost is not something it could do. 
     
    However, you could easily do this with the correct set up for item quantities. For example, in the Item Card if you set the Reordering Policy to Fixed Reorder Qty., you can then set the Reorder Quantity to 1000. This way the system will suggest purchasing 1000 at a time. You can also incorporate the Order Modifier fields such as Minimum Order Quantity and Order Multiple.
     

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

News and Announcements

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans