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 - Customer CSV Import

      Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...
    • 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 ...
    • Feature - Add Desc2 Column to Item Linkage CSV Report

      Release Date: 4/19/2017 In I/M -> Reports -> Item Linkage CSV Report, the Desc2 column is now added to the exported CSV file. See sample screen below. The following columns are supported in the CSV file: Item# - Item number Desc - Item description 1 ...
    • Feature - Added QI (Qty Sold in Invoice History) Data Type to the User Defined CSV Export

      Release date: 10/8/2020 Version: 8.5 & Up Changes have been made to the Reordering Advice User Defined CSV Export programs. You can access this feature from I/M -> Reports -> Reordering Advice Reports -> Maintenance -> User Defined CSV Layout for the ...