---
title: Did you know... if you create a PO and find you are just a little shy of meeting the minimum order amount, you can query the database to find additional items?
description: Just a little shy of meeting the minimum order $$ amount? Watch this short video to learn how to query the database to find additional items.
---

[![Retail Management Solutions - Pharmacy POS Built for Success](https://www.rm-solutions.com/hubfs/RMS%20Full%20Logo%202-Color%20SVG.svg) ](https://www.rm-solutions.com)

- [SOLUTIONS ](https://www.rm-solutions.com/pharmacy-pos)
  
  ## [Point of Sale (POS)](https://www.rm-solutions.com/pharmacy-pos)
  
  
  
  ### [POS Hardware](https://www.rm-solutions.com/pointofsalehardware)
  
  
  
  ### [Multi-Store & Enterprise](https://www.rm-solutions.com/star-link)
  
  
  
  ### [Payment Processing](https://www.rm-solutions.com/rmspay)
  
  
  
  ### [Training Programs](https://www.rm-solutions.com/customersuccessprograms)
- [FEATURES ](https://www.rm-solutions.com/did-you-know/did-you-know...-you-can-query-to-find-items-to-meet-min.-order-needs#)
  
  ### [Inventory Management](https://www.rm-solutions.com/inventorymanagement)
  
  
  
  ### [Will Call Management](https://www.rm-solutions.com/bin-management)
  
  
  
  ### [Customer Loyalty](https://www.rm-solutions.com/pharmacy-customer-loyalty)
  
  
  
  ### [Mobile POS & Delivery](https://www.rm-solutions.com/mobile-pharmacy-pos)
  
  
  
  ### [Meds to Beds](https://www.rm-solutions.com/meds-to-beds)
  
  
  
  ### [Nutrient Depletion](https://www.rm-solutions.com/nutributler)
  
  
  
  ### [eCommerce](https://www.rm-solutions.com/ecommerce)
  
  
  
  ### [Digital Couponing](https://www.rm-solutions.com/8112-digital-coupons)
  
  
  
  ### [NPLEx](https://www.rm-solutions.com/nplex)
- [LEARN ](https://www.rm-solutions.com/blog)
  
  ## [The RMS Blog](https://www.rm-solutions.com/blog)
  
  
  
  ### [Did You Know?](https://www.rm-solutions.com/did-you-know)
  
  
  
  ### [Biz Quiz](https://www.rm-solutions.com/biz-quiz)
  
  
  
  ### [CLIMB](https://www.rm-solutions.com/climb)
  
  
  
  ### [Testimonials](https://www.rm-solutions.com/testimonials)
  
  
  
  ### [eBook Library](https://www.rm-solutions.com/rms-library)
- [ABOUT ](https://www.rm-solutions.com/about)
  
  ## [About RMS](https://www.rm-solutions.com/about)
  
  
  
  ### [Contact Us](https://www.rm-solutions.com/contact)
  
  
  
  ### [Upcoming Events](https://www.rm-solutions.com/events)
  
  
  
  ### [Our Team](https://www.rm-solutions.com/employees)
  
  
  
  ### [Careers](https://www.rm-solutions.com/employment)
  
  
  
  ### [Our Partners](https://www.rm-solutions.com/partners)
  
  
  
  ### [Order Supplies](https://www.rm-solutions.com/rms-pharmacy-point-of-sale-supplies)
- [SUPPORT ](https://www.rm-solutions.com/support-services)

[CLIENT PORTAL ](https://acct87349.app.netsuite.com/core/media/media.nl?id=36450&c=ACCT87349&h=87bc9ee6b61042bcf658&_xt=.html) [BOOK A DEMO ](https://www.rm-solutions.com/book-a-demo)

Inventory

# Did you know... if you create a PO and find you are just a little shy of meeting the minimum order amount, you can query the database to find additional items?

Just a little shy of meeting the minimum order $$ amount? Watch this short video to learn how to query the database to find additional items.

[ Brad Jones ](https://www.rm-solutions.com/did-you-know/author/brad-jones)

 Oct 9, 2025

---

If you’re using the Min/Max feature when creating a PO, and your calculated order is shy of meeting the minimum order $$ amount or minimum free-freight $$ amount, you can now query the database to find additional items that are at or above the minimum but have not reached the maximum. You can then select a few of these items to meet the minimum vendor requirements and get your order placed. Watch [this short 3.5 minute video](https://www.rm-solutions.com/hubfs/29%20-%20Purchase%20Order_%20Using%20the%20Query%20Feature%20to%20Meet%20Min%20$$%20Amount.mp4) to learn more. 

 

[Inventory](https://www.rm-solutions.com/did-you-know/tag/inventory) [Inventory Management](https://www.rm-solutions.com/did-you-know/tag/inventory-management)

## Similar posts

Inventory Management

### [Did you know... you can use the FLC Update Utility to update Fine Lines and associated items at the same time?](https://www.rm-solutions.com/did-you-know/did-you-know...-you-can-use-the-flc-update-utility-to-update-fine-lines-and-associated-items-at-the-same-time)

 Brad Jones  Oct 23, 2025

Inventory

### [Did you know... you can map the fine line codes from any vendor to the codes in your POS?](https://www.rm-solutions.com/did-you-know/did-you-know...-you-can-map-the-fine-line-codes-from-any-vendor-to-the-codes-in-your-pos)

 Brad Jones  Apr 24, 2025

Inventory Management

### [Did you know... you can use our Retail Price Calculation Application to calculate retail prices based on the cost and target margin?](https://www.rm-solutions.com/did-you-know/did-you-know...-you-can-use-our-retail-price-calculation-application-to-calculate-retail-prices-based-on-the-cost-and-target-margin)

 Brad Jones  Oct 23, 2025

## Subscribe to the RMS Weekly Newsletter

Be first to know about new blog posts, special announcements, product launches, upcoming events, **CLIMB **content, and more from your favorite pharmacy POS partner.

[![Pharmacy POS Built for Success | Retail Management Solutions](https://www.rm-solutions.com/hubfs/RMS%20Full%20Logo%20White%20SVG.svg "Pharmacy POS Built for Success | Retail Management Solutions")](https://www.rm-solutions.com)

Retail Management Solutions  
4315 6th Avenue SE, Suite C  
Lacey, WA 98503

[GET IN TOUCH ](https://www.rm-solutions.com/contact)

<https://www.facebook.com/retailmanagementsolutions/> <https://www.twitter.com/rms_pos/> <https://www.instagram.com/rms_pos/> <https://www.youtube.com/@CLIMBWithRMS>

##### Solutions

[Point of Sale (POS)](https://www.rm-solutions.com/pharmacy-pos)  
[POS Hardware](https://www.rm-solutions.com/pointofsalehardware)  
[Multi-Location & Enterprise](https://www.rm-solutions.com/star-link)  
[Payment Processing](https://www.rm-solutions.com/rmspay)  
[Training Services](https://www.rm-solutions.com/customersuccessprograms)  
[24/7 Support](https://www.rm-solutions.com/support-services)

##### Features

[Inventory Management](https://www.rm-solutions.com/inventorymanagement)  
[Will Call Management](https://www.rm-solutions.com/bin-management)  
[Customer Loyalty](https://www.rm-solutions.com/pharmacy-customer-loyalty)  
[Mobile POS & Delivery](https://www.rm-solutions.com/mobile-pharmacy-pos)  
[Meds to Beds](https://www.rm-solutions.com/meds-to-beds)  
[Nutrient Depletion](https://www.rm-solutions.com/nutributler)  
[eCommerce](https://www.rm-solutions.com/ecommerce)  
[Digital Couponing](https://www.rm-solutions.com/8112-digital-coupons)  
[NPLEx](https://www.rm-solutions.com/nplex)

##### Learn

[RMS Blog](https://www.rm-solutions.com/blog)  
Newsletter  
[CLIMB](https://www.rm-solutions.com/climb)  
[eBooks](https://www.rm-solutions.com/rms-library)

##### Company

[About RMS](https://www.rm-solutions.com/about)  
[Our Team](https://www.rm-solutions.com/employees)  
[Our Partners](https://www.rm-solutions.com/partners)  
[Testimonials](https://www.rm-solutions.com/testimonials)  
[Upcoming Events](https://www.rm-solutions.com/events)  
[Careers](https://www.rm-solutions.com/employment)

© 2024 Retail Management Solutions      All rights reserved      [Privacy Policy](https://www.rm-solutions.com/rms-privacy-policy)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Brad Jones",
    "url" : "https://www.rm-solutions.com/did-you-know/author/brad-jones"
  },
  "dateModified" : "2025-10-09T18:07:17.566Z",
  "datePublished" : "2025-10-09T18:07:17.000Z",
  "headline" : "Did you know... if you create a PO and find you are just a little shy of meeting the minimum order amount, you can query the database to find additional items?",
  "mainEntityOfPage" : {
    "@id" : "https://www.rm-solutions.com/did-you-know/did-you-know...-you-can-query-to-find-items-to-meet-min.-order-needs",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.rm-solutions.com/hubfs/RMS%20Full%20Logos%20SVG.svg"
    },
    "name" : "Retail Management Solutions"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://209598.fs1.hubspotusercontent-na2.net/hubfs/209598/Videos/29%20-%20Purchase%20Order_%20Using%20the%20Query%20Feature%20to%20Meet%20Min%20$$%20Amount.mp4",
  "dateModified" : "2026-01-22T17:44:16.883Z",
  "duration" : "PT3M39S",
  "height" : 1080,
  "name" : "29 - Purchase Order_ Using the Query Feature to Meet Min $$ Amount",
  "thumbnailUrl" : "https://api-na2.hubspot.com/filemanager/api/v3/files/thumbnail-redirect/197208130654?portalId=209598&size=medium",
  "uploadDate" : "2025-10-07T21:16:08.264Z",
  "width" : 1920
}
```