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

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

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

    • IM32S1 Inventory Management Kit Gross Requirements Report

      Kit Gross Requirements Report Application Overview The Kit Gross Requirements Report application prints the requirements for each component for a selected quantity of a kit item or items. The report allows the user to see how many of each component ...

    • Feature - New Item Import Through CSV File

      Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...