Feature - Master Scheduling Sales Forecast Import

Feature - Master Scheduling Sales Forecast Import

Release date: 5/6/2021

Version: 8.5 and Up

There is a new import feature in Master Scheduling, Processing, and Sales Forecast Entry.



The import will facilitate the entry of Sales Forecast transactions.  The import screen is standard with three menu options of Pre-Interface, Interface, and Layout.  Three fields are prompted, Header Row, File Name, and Override Flag.  If your file contains a header row, respond Y to field 1.  The second field is the full path and file name of the import file.  Keep this simple with no spaces or special characters.  The limit is 50 characters.  The Append/Override flag can be used to clear out any transactions that exist in the Sales Forecast file.  If the Sales Forecast contains any transactions you want to retain, use the Append mode.  If you want to clear out certain records before importing, like for a date range, use the Purge function.



The layout is simple, but requires the same data as manual entry.



The Item Number, Due Date, and Forecast Order Quantity are required.  The Order Number is optional.  If not provided, a sequential number will be automatically assigned.



The Item Number must be a valid item in Elliott that is Active and be flagged as a Master Schedule item (field 73).  The Due Date must be a valid date and exist in the Shop Calendar file of Master Scheduling.  The Order Number can be any alphanumeric, but is limited to six characters.  The quantity must be a valid number and the number of decimal places must not exceed the number configured in the Elliott Company file.



Modified Programs: MSFOCPY, MSFOMNT, MSFOCSVS, MSFOCSVP
MAD







    • Related Articles

    • Feature - Added Archive Function to Sales Order Import File Search Window

      Release Date: 9/21/23 Version: 8.5 and Above Some customers have asked how to delete or archive files from the Import Folder for Sales Order Import. This can happen because the import file has invalid information which will require the trading ...

    • Feature - Alleviate Error 25 When Two Users Import Sales Orders Simultaneously

      Release Date: 9/26/19 Version: 8.5 and up If two users attempt to run Sales Order Import at the same time, the second user will receive an error 25 on the Import Header File (CPIMPHDR). If the second import is launched from deferred processing, this ...

    • Feature - Check for Duplicate PO During Sales Order Import

      Release Date: 7/19/2016 A new feature has been added to COP Sales Order Import that will check imported orders for potential duplicates. Setup by entering "Y" in Global Setup - > Add-ons -> Sales order import, field 23. When running Sales Order ...

    • Feature - Ability to Change EDI Import Path

      Release Date: 1/9/17 This feature gives the user the ability to change the path used when importing EDI orders. This option is enabled through Util-Setup-> Global Setup-> Add-Ons-> Sales Order Import. Field 4. Can User Override Path During Import? ...

    • Feature - Avalara Tax Code Support in Sales Order Import

      Release Date: 9/6/23 Version: 8.6 and Above Sales Order Import now determines the correct tax codes for an order based on the ship-to state and country for the order. First, the application will determine if the address is a foreign address (non-US ...