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

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

    • What Are The Definitions of Various Item End Item Codes?

      Release Date: 02/17/2020 Version: 7.5 & up Q - In Item Master File Maintenance, field "74. End Item Code", I see the possible following values: F = Feature K = Kit S = Style D = Desc-Item C = Shortcut A = Adjust Other=Usr-Defined See sample screen ...