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 :
Small and medium business | Business Central, N...
Answered

Vendor Requires Minimum Total QTY of items in PO

(0) ShareShare
ReportReport
Posted on by 15,583

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,583 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,340 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,583 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,857 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,047 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans