Feature - Create Price Code 1 from Item Minimum Price Utility

Feature - Create Price Code 1 from Item Minimum Price Utility

Release Date: 6/15/2016


This feature gives the user the ability to generate and update price code 1 based on the minimum price field in the Item Master file. The new utility is accessed thru I/M -> Maintenance -> Product Category File.  


The purpose behind this utility is to allow you to give your best price (item minimum price) to a certain number of your customers by product category. This maybe due to these customers achieving the certain purchasing volume for that product category.  Since you won't give this price to other customers, the general method in Elliott is to set up price code 1, which is by customer and item number. Setting up price code 1 is tedious.  In addition, the maintenance effort is huge when the best price (item minimum price) is changed. That is the reason behind this utility.  If the item minimum price is also your best price, then you can consider using this utility to help you create and update the price code 1 in an efficient way. 


Setup starts by setting up customers that are associated with a Product Category.  A new field, Define Min Prc Customer, has been added to this application.   Default value for this field is “N.” Entering "Y" will cause another window to appear that allows entry of a list of Customer numbers.







There’s no limit to the number of customers that can be entered in this window. To add a customer, press the “Insert” key.  A small window will appear where the user will enter the customer number and F7/F8 search is allowed.  Once a valid customer is entered, the customer name is displayed.  To delete a customer from the list, press the “Delete” key. 






After setting up customers related to the Product Category, select  I/M -> Maintenance -> Product Category File-> Update Price Codes. Enter the Product Category to process. While running the update, a report will be created showing all records Added (a new price code was created for the customer using minimum price), Deleted (the minimum price is now zero), Updated (the minimum price has changed), and Skipped (the minimum price has not changed).  The Deleted, Updated and Skipped actions only apply to records created by this utility. 






Modified Programs:

IMCATMIN.SL, FD, WS, DS,  IO (new)
IMMINITM.SL, FD, WS, DS,  IO (new)
IMCATFIL.FD
IM1501.CBL
IMCATPRC.CBL (new)
IMMINUTS.CBL (new)
IMMINUTP.CBL (new)

DLM








    • Related Articles

    • "The Price Check Digit of the Number You Entered Is Incorrect" with UPC Code

      Release Date: 04/12/2021 Version: 7.5 & Higher Q - We received a new item from a vendor with the UPC code 284672190114. When we entered this item into the Elliott UPC Code field, we received the message "The Price Check Digit of the Number You ...
    • APINVIMS Accounts Payable Invoice Import Utility

      A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...
    • Feature - Add Item Description 1 and 2 to the CHGITEM Event

      Release Date: 2/11/25 Version: 8.5 and Above This change adds the fields item description 1 and item description 2 to the CHGITEM event. You can subscribe to the event from Inventory Management-> Maintenance-> Item File or Inventory Management-> ...
    • AP22S1 Accounts Payable Purge AP Open Item File

      Purge A/P Open Item File Application Overview Even when an invoice has been fully paid, the information on the A/P Open Item File pertaining to it remains on file until purged. If you never purged the A/P Open Item File, the disk would eventually get ...
    • AROLOAD Accounts Receivable A/R Open Item File Maintenance

      A/R Open Item File Maintenance Application Overview The A/R Open Item File is the file where all transactions that occur between you and your customers are stored. As such, it is a very important file. Any time you want to know how much a customer ...