Saved Search to Show When to Order More of an Item

Instructions

1. Create a new Transaction search
2. Criteria

• Type: sales order
• Status: Partially Fulfilled, Pending Billing/Partially Fulfilled, or Pending Fulfillment
• main line: false
• Account Type: Income
• Shipping Line: false
• Tax Line: False
• Closed: False
• Purchase Order: none
• Formula Numeric: Formula (Numeric)

3. Results

• Absolutely important results
  • Item : Name
  • Document Number
  • Name
  • Quantity in Transaction Units
  • Formula: NVL({item.totalquantityonhand},0)
  • Formula: ({quantityuom} - NVL({item.totalquantityonhand},0) - NVL({item.quantityonorder},0) - NVL({quantityshiprecv},0) - NVL({quantitycommitted},0))
  • Item : On Hand
  • Formula: NVL({item.quantityonorder},0)
  • Quantity Fulfilled/Received

Got stuck on a step in this article?

We like to update our blogs and articles to make sure they help resolve any troubleshooting difficulties you are having. Sometimes, there is a related feature to enable or a field to fill out that we miss during the instructions. If this article didn't resolve the issue, please use the chat and let us know so that we can update this article!

Oracle NetSuite Alliance Partner & Commerce Partner

If you have general questions about SuiteCommerce or more specific questions about how our team can support your business as you implement NetSuite or SuiteCommerce, feel free to contact us anytime. Anchor Group is a certified Oracle NetSuite Alliance Partner and Commerce Partner equipped to handle all kinds of NetSuite and SuiteCommerce projects, large or small!