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 - Sales Order Import Error Directory Support

      Date Released: 8/21/18 This feature gives users the ability to move import files that contain errors to an error directory during the Interface process. This is helpful for users who want to use defer processing to import sales orders every few ...

    • 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 ...

    • Feature - Sales Order Import Request Date Warning

      Release Date: 6/13/19 Version: 8.2 and Up Previously users would control whether the message "Request Date Has Already Passed" was a warning or just a standard attention message through Global Setup-> Add-Ons-> Sales Order Import field 20, Ship Date ...

    • Feature - Sales Order Import ATP Quantity Warning

      Release Date: 6/17/19 Version: 8.2 and Up Sales Order Import gives the user warning messages in some situations when the quantity ordered is greater than the quantity available. This feature gives the user the ability to also give a warning if the ...

    • Feature - Skip Orders With Duplicate PO Numbers in Sales Order Import

      Release Date: 5/21/2024 Revised Date: 08/27/2024 Version: 8.5 and Up Background Sales Order Import would flag orders with duplicate purchase order numbers in Elliott as a warning, but allow the orders to import and place them on hold. This behavior ...