Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Vendor Requires Minimum Total QTY of items in PO

(0) ShareShare
ReportReport
Posted on by 15,433

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 

  • MahGah Profile Picture
    MahGah 15,433 on at
    RE: Vendor Requires Minimum Total QTY of items in PO

    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

  • Guy McKenzie Profile Picture
    Guy McKenzie 1,330 on at
    RE: Vendor Requires Minimum Total QTY of items in PO

    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
    MahGah 15,433 on at
    RE: Vendor Requires Minimum Total QTY of items in PO

    Thanks Steven

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor Requires Minimum Total QTY of items in PO

    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans