Feature - Item Generic Search to Show Items with QtyOH <> Zero

Feature - Item Generic Search to Show Items with QtyOH <> Zero

Release date 12/31/2020

Version 8.5 & Up

This feature builds on a previous project that added limiting the item search to items with QtyOH > zero.  See the following Knowledge Base article:


This project will add a toggle option to show only items with Qty <> zero (not equal to zero.) The primary purpose of this enhancement is to allow users to have the option to see all items that have "activities," which includes those items with a negative quantity available.

This new option will only appear if IM Global Control, screen 1, field "4. Item Generic Search With Avail/Excess Qty" is set to "Y" (Show Qty Avail) or "E" (Show Excess Qty).  When this flag is enabled, the F7 key in Item Search will allow the user to toggle between three states:
  1. State 1: All Items (Default)
  2. State 2: Items Qty > 0
  3. State 3: Items Qty <> 0
The "Qty" can be Qty Avail (OH - Allocated) or Excess Qty (OH - Allocated + BO), depending on the above Global Setup flag value. 

When the search is entered, all Items will appear in the search regardless of the current Qty:


Press F7 to restrict search to Items with Qty > 0.



Press F7 again to restrict search to Items with Qty <> 0.



Press F7 again to return to all items listed in the search.

Modified programs: GENSRCHI.PL, ITEMGEN.CBL

DLM



    • Related Articles

    • Feature - Item Generic Search to Show Item Quantity Greater than Zero Only

      Release date: 2/15/2019 Added to Item Generic Search the option to Show Items with Quantity Greater than Zero Only. This new option will only appear if IM Global Control, screen 1, field "4. Item Generic Search With Avail/Excess Qty" is set to "Y" ...

    • Power Search: Running and Designing Search Basics

      Release Date: TBD Version: 8.6 and above PowerSearch is a new search-developing platform for Elliott Business Software. It is based on the PSQL relational engine accessing the Elliott database, which provides more flexibility when designing searches. ...

    • Reorder Advice Custom CSV Export Shows Zero Items

      Q - I am running our saved CSV report from I/M Reordering Advice Report, Custom CSV Export. Below is the screen shot for the parameters: I was hoping that choosing N on “Print Items with All Zeroes?” would exclude the items that have no activity. But ...

    • Feature - Exclude Obsolete Customers from Customer Generic Search

      Release date: 4/24/2019 Version: 8.5 and Up We have introduced a Global Setup flag to indicate an “Obsolete Customer Type” in A/R Global Setup. For those customers that are obsoleted (no longer customers but the customer data is retained), their ...

    • Feature - Prod Cat and UDC F7 Search from Within Item User Search

      Release Date: 3/7/22 Version: 8.5 and Above When the item user-defined search by product category or user-defined code is enabled, the user can search for an item by its product category or user-defined code. However, some users may have hundreds of ...