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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Vendor Requires Minimum Total QTY of items in PO

(0) ShareShare
ReportReport
Posted on by 15,529

Hi 

We have a vendor that we buy multiple items from them. But they require PO total QTY (among all items in PO) should be X numbers. For instance, if we order 10 different items in PO if we add up all QTY it should reach to 200.

Is it anyway in BC that we can set this up?

Also, can be automated through MRP?

Thanks 

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Hello,

    On the Item Card you can establish a minimum order quantity for the Purchase Order. However, that is per Item and you want a minimum order quantity per Vendor Purchase Order. This is not possible. I would ask your Partner to write an extension that performs a PO validation that meets a Vendors minimum order quantity. Not hard but doable.

    Hope this helps.

    Thanks,

    Steve

  • MahGah Profile Picture
    15,529 on at

    Thanks Steven

    That was the part I was trying to avoid. But seems like it is the only solution.

  • Guy McKenzie Profile Picture
    1,336 on at

    You could use extended texts as an aide memoir.

    Obviously not as neat as automating requirements but can work as a suitable solution. I used this method very effectively in a purchasing department where we had complex mixes, of min x qty per SKU, min y qty per SKU group and a potential minimum order spend for the whole order.

    Writing the logic for MRP to do this would have been an expensive nightmare whereas an extended text just lists the requirement as a line of text for the user when adding that item.

    Note, it is item rather than vendor specific. If you have multiple vendors for the same product, this will have limitations.

    Recurring purchase lines may also give you a partial solution by showing what other items are from that supplier within the PO itself. Note this would be a workaround and could be quite fudgy but may be perfectly acceptable or at least an improvement.

  • MahGah Profile Picture
    15,529 on at

    Hi Guy

    Thank you so much for your replay and help. I will work with our team to use this method. Also, since we are in SaaS version I have found the following app that can help with specific vendor.

    appsource.microsoft.com/.../PUBID.aitana_management_sl|AID.idynamics_internal_notes|PAPPID.bfec7d00-c0ce-420f-845c-653287d3c60f

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans