Feature - Allow End Item Where-Used to Select Items Based on CSV File

Feature - Allow End Item Where-Used to Select Items Based on CSV File

Release Date - 4/25/18

BOMP -> Reports -> End Item Where-Used Report currently allows users to specify a range of items, and few other parameters for selection. This feature gives the user the ability to individually identify a list of items in a CSV file and use that as the input parameters. This option is available from the Starting Item Number field.



The F3 option gives the user the ability to use a CSV file as the input for item number range. A window is displayed when the F3 key is pressed.



There are two entry fields required. 

File Path - Enter the full path to the CSV file. The application will verify that the CSV file exists before proceeding to the next field.

Does CSV Have Header Row? - Answer Y or N to indicate if the first line in the CSV file is a header row.



If a CSV file is specified, a literal "<From File>" is displayed next as the starting item number and the name of the CSV file is displayed below field 1. Fields 1 – 7 will be disabled. If the user changes their mind and wants to enter a starting and ending item range or use a different CSV file, then the user has to start over by exiting the screen and starting over.    

If the CSV file is specified, the End Item Where Used Report will use the item number provided to generate the report. The CSV file name is provided in the legend area of the report.

Programs Modifed: BM0800, BM08P1
CLS


    • Related Articles

    • Feature - Allow Export to CSV File for End Item Where-Used Report

      Release Date 4/23/18 This feature adds CSV support to the End Item Where-Used Report in Bill of Material Processing. Two new report options are available to support this functionality: 8. Create CSV File? - This field will default to the previously ...

    • BM0800 Bill of Material End Item Where-Used Report

      BM0800 Bill of Material End Item Where-Used Report ← Bill of Material / Work Order Plus End Item Where-Used Report Application Overview The End Item Where-Used Report prints the end items that are parents at some level for a selected range of ...

    • Feature - Allow to Select by Include Web Items Only Flag in User Defined CSV Export

      Release Date: 02/16/2012 Version: 8.5 & Up In I/M -> Reports -> Reorder Advice/User Def CSV -> Print -> User Defined CSV Export, a new flag has been added to allow users to select by web item. See sample screen below: You can indicate whether an item ...

    • BM33S1 Bill of Material Option Item Where-Used Report

      Option Item Where-Used Report Application Overview The Option Item Where-Used Report prints the feature items that are parents for a range of option items. For each option item, the report prints the parent feature item along with a description of ...

    • BM1601 Bill of Material Feature/Option Configuration Inquiry

      BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...