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

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

    • AROLOAD Accounts Receivable A/R Open Item File Maintenance

      A/R Open Item File Maintenance Application Overview The A/R Open Item File is the file where all transactions that occur between you and your customers are stored. As such, it is a very important file. Any time you want to know how much a customer ...

    • AP22S1 Accounts Payable Purge AP Open Item File

      Purge A/P Open Item File Application Overview Even when an invoice has been fully paid, the information on the A/P Open Item File pertaining to it remains on file until purged. If you never purged the A/P Open Item File, the disk would eventually get ...

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

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