Feature - Gross Requirements Report Item/Qty CSV Import

Feature - Gross Requirements Report Item/Qty CSV Import

Date Released - 5/23/16

The feature will allow the user to import an CSV file containing a list of items and the quantity of the parent. This CSV file should contain two columns - the item number and the quantity of the parent.



When running the Bill of Material Processor-> Reports-> Gross Requirements Report, a new option is available from the item number field.


F3=Import Item - When the user presses the F3 key, a window will pop up asking the user for the name of the file to import.


File Path: Path to the CSV file to be imported. The application will verify that the file exists and that there are records in the file.
Does CSV Have Header Row? Default is Y. If the CSV file has a row with headings, answer Y. Otherwise, answer N.

Once the user answers N to the Any Change prompt, the application will pre-process the file looking for any errors in the CSV file. The application will:

  1. Verify that the Item Number is on file.
  2. Verify that the quantity entered is greater than zero.
  3. Verify that the number of decimal places in the quantity field is less than or equal to the number of decimals supported by the company file. For example, if the quantity field contains 1.999 but the company file only support 2 decimal places, this is an error condition.
If any errors are found in the CSV file, the user will be presented with an error message with details of the first error encountered. The user should correct this issue and try to import the file again.



If the CSV is the first "item" entered, the user will be returned to the location field and the remaining report parameters can be entered. If the CSV is not the first "item" number entered, the user will be returned to the Any Changes field. Once the user enters past the Item Number To Change or answers N to Any Changes, the item numbers from the CSV file will be imported and added to the list of items to process.

Programs Modified: BM1100
CLS




    • Related Articles

    • BM1100 Bill of Material Gross Requirements Report

      BM1100 Bill of Material Gross Requirements Report ← Bill of Material / Work Order Plus Gross Requirements Report Application Overview The Gross Requirements Report application prints a selected number of levels of components for a selected quantity ...

    • Feature - Gross Requirements Report COP Order Import

      Date Released - 5/24/16 The feature will allow the user to import COP line items to the BOMP Requirements Work File. When running the Bill of Material Processor-> Reports-> Gross Requirements Report, a new option is available from the item number ...

    • Detail Cash Receipt CSV Import with Negative Values Causes Error Message

      Release Date: 01/19/2024 Version: 8.5 & Up Q - In the KB article: https://support.netcellent.com/portal/en/kb/articles/feature-support-for-discount-amount-and-reference-in-cash-receipts-detail-interface, I see we can use negative amounts with Detail ...

    • Common Issues with Importing CSV Files Into Elliott

      Release Date: 12/18/2020 Version: 7.0 & Up Elliott Business Software has extensive features with CSV file export and import. It provides a gateway to view Elliott's data in Excel spreadsheets and optionally allow users to edit the data in ...

    • Feature - Gross Requirements to Use COP Order Customized Structure

      Release Date: 03/25/2022 Version: 8.5 & Higher In the COP Order Entry Line Item Screen, the user can press "F4=Custom Prod Stru" key to customize the components needed to produce the parent item for this order. See sample screen below: In BOMP -> ...