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

    • CPIMPMNU Customer Order Processing Sales Order Import

      Sales Order Import Application Overview The Sales Order Import module is designed to import a pre-defined ASCII file to create COP sales orders. It is intended to provide an easy way for developers to create add-on solutions for creating sales ...

    • A Summary to Outline of Elliott EDI Integration Flow

      Release Date: 06/15/2023 Version: 8.x & Up Q - We currently use SPS Fulfillment Portal for our EDI processing. We are getting too great of a volume of EDI orders and we are evaluating whether to automate it with Elliott. Can you give me an outline of ...

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

    • CPSLSDSK Customer Order Processing Sales Desk

      Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...

    • Avalara - Sales & Cr/Dr Memo Processing

      Release Date: 4/28/23 Version: 8.6 and Above If you are using Avalara Interface, Elliott's A/R Sales & Cr/Dr Memo Processing will force the tax amount 1, 2, and 3 to be zeroes for taxable customers. This is because interfacing with Avalara requires ...