Feature - Add Sales or Usage to Where-Used inquiry

Feature - Add Sales or Usage to Where-Used inquiry

Release date: 4/15/19

Version: 8.5 and up

Changes have been made to single level Where-Used inquiry to show Sales or Usage in place of the standard Cost column.

If no change is made, the Cost column is the standard method. 

To set up Sales or Usage, go to System Utilities --> Global Setup --> Dist --> Bomp Global Control.  On screen 6, a new option has been added: 19. Single Level Where-Used Inquiry Last Column.
 


If C=Cost is selected, the inquiry program will process as it currently does and the Months field will display "N/A."

If S=Qty Sold Last ?? Months or U=Qty Usage Last ?? Months is selected, the program will prompt for a number of months from 1-99.  The current month is not included in the number of months. To include the current month qty sold or usage statistic as part of the last ?? months will distort the statistic depend of what date of the month today is. For example, if today is Feb 1, 2019 and you choose to display the last 4 months usage, then the system will display the 4 months usage total of Oct, Nov, Dec 2018 and Jan 2019.  It will stay like that until Mar 1, 2019.

This is how the screen will appear if field 19 is set to U(Usage) and the months is set to 48.


Please not that the locations chosen to include in the Sold or Usage column will either be all netable locations or a specific location as entered in the "Loc:" screen field.

Modified programs: NSCTLFIL.FD, NSCTLFIL.W32, NSCTLINI, NSCTLMN3, BMWUSEIQ

DLM



    • Related Articles

    • Feature - Material Work Order Inquiry Material Used

      Release Date: 1/7/19 When entering a production transaction for a material work order, the user has the ability to add other material used at the time of production. This may be required if a component is not available at production time and a ...

    • Feature - Add "Related Quotes" Option to Where-Used Inquiry

      Release date: 1/23/2018 A new option, F4=Related Quotes, has been added to the Single Level Where-Used Inquiry screen. If the user presses F4, the the following window “Single Level Where-Used Related Quote” will pop up. The screen is similar to ...

    • How to Enable Add-on Sales Items Feature

      Release Date: 12/07/2021 Version: 7.5 & Up Q - Can you advise where this "add-on" list is accessed in Elliott by Sales Order Entry personnel? I can't find any flags or anywhere in Sales Entry where an "add-on box" pops up to select items. We've never ...

    • Feature - Display Usage of Item Customer Usage from Inventory Transactions

      Release Date: 8/4/2016 This feature adds the ability to view Item Customer Usage values as a percentage of total usage on the Stock Status Inquiry screen. In Global Setup -> cop-Ctl -> Stock Status Inquiry, a new field has been added, "10. Display ...

    • Feature - Sales Promotion Desk

      Release Date - 8/30/16 Sales Promotion Desk IntroductionIn Elliott Business Software, Item Master table, we have the following fields that allow users to put an item on sale: Start Sale Date End Sale Date Sale Price If customers purchase this item ...