Feature - Use Attribute to Exclude Updates to Demand Quantities in the Inventory Location History File

Feature - Use Attribute to Exclude Updates to Demand Quantities in the Inventory Location History File

Release Date: 2/26/26
Version: 8.5 and above

This feature gives the user the ability to specify if certain customers or certain orders should be excluded from demand calculations. This is helpful when processing orders for customers that are big box stores that should not inflate demand from individual customer orders.

To support this feature, a new option has been added to the popup window if answering "Y" to Global Setup Flag in Dist -> I/M Global Control -> Screen 3 -> 11. Track Demand For Sales of Certain Locs Only.


Exclude Customer Demand If This Attribute Exists - Enter the attribute that is associated with the customer record that indicates that the customer's orders should be excluded from the demand calculations.
Exclude Order Demand If This Attribute Exists - Enter the attribute that is associated with an order record that indicates that the order should be excluded from the demand calculations. 


The following areas are affected with this change:
  1. Posting invoices to Accounts Receivable will check for this attribute. If found, only the sales accumulators in the location history file will be updated.
  2. This change also applied if recalculating location history information through I/M -> Utility -> Generate Location History -> General Location History Sales Info or  Global Setup -> Utilities -> I/M Utilities -> Generate Statistic Info -> Generate Location Sales Info.
  3. Generating the two location Buyer's Desk work file will also look for the attribute when updating the demand quantity used in various Buyer's Desk calculations.
Programs modified: NSCTLFIL.FD, NSCTLFIL.W42, NSCTLINI, NSCTLMN3, CP0305, IMGENLHP, POBDGENP
CLS


    • Related Articles

    • Feature - Consolidate Specific Location Quantities in One Location Buyer Desk

      Release Date: 5/30/24 Version: 8.5 and Above If the Buyer Desk Global Setup option 2. Prompt Customer Type & Location in Buyer Desk, is set to N, Buyer Desk can be configured to run for either one location or two locations. If configured to run for ...

    • Feature - Sales Promotion Desk

      Release Date - 8/30/16 Sales Promotion Desk Introduction In 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 ...

    • What Information Is Stored in the Location History (IMLOCHST) Table?

      Release Date: 11/27/2017 Many users have noticed the existence of the IMLOCHST (I/M Location History) table and would like to know what information is stored there and how to access it. This document is an attempt to explain what information is ...

    • IM2500 Inventory Management Reset Allocated Quantities

      Reset Allocated Quantities Application Overview The Reset Allocated Quantities application exists so that if there is ever any doubt about the correctness of the allocated quantities in the Inventory Item File, the Inventory Location File, or the ...

    • Hold Trx - Inventory Quantities Changed at Another Workstation Record Not Saved

      Release Date: 06/25/2024 Version: 8.5 & Up Q - When we try to add a hold transaction by serial number, we get this message: Inventory Quantities Changed At Another Workstation. Record Not Saved Several other users have had this message. But ...