Skip to main content

Notifications

Business Central forum
Suggested answer

Economic reorder quantity

Posted on by 172
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. 
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 4,791 Super User 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,108 Super User 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 61,962 Super User 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 5,208 Super User 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.
     

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,623 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,463 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans