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

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 entered value. Answer Y if a CSV file should be created when the run is run.

9. CSV File Path & Name - This field will default to the previously entered value. It is only available if the Create CSV File option is set to Y.

If the Create CSV File option is set to Y and a file name has been provided, a CSV file will be created with the following fields:

  • ParentItem# - parent item number
  • Desc1 – parent item description 1
  • Desc2 – parent item description 2
  • Level – Level as shown on the report
  • LLC – parent item low level code
  • UOM – parent item UOM
  • CAT – parent item product category
  • AttchOper – BOMP attached operation for the component
  • ActFlg – As printed on the report
  • StkFlg – As printed on the report
  • CtlFlg – As printed on the report
  • EngRel – Parent item Engineering Release as shown on the report
  • QtyReq – As printed on the report
  • CompItem# - Component item number (which is part of the report group heading area)
  • Desc1 – Component item description 1 (from component group heading)
  • Desc2 – Component item description 2 (from component group heading)
  • LLC – Low Level Code (from component group heading)
  • EngRel – Comp Item Engineering Release (from component group heading)
If the QTYAVAILBYCOMP attribute is in use, the CSV file will contain the following fields:

  • ParentItem# - Parent Item number
  • CreateDate – Parent Item Create Date
  • Class – Parent Item ABC Class
  • 1stRecvDate – Parent Item 1st received date
  • LstRecvDate – Parent Item last received date
  • QtyAvail – Based on parent item, from QTYAVAILBYCOMP attribute “Stock Qty Avail”
  • BOMPAvail – Based on parent item, from QTYAVAILBYCOMP attribute “BOMP Qty Avail”
  • SchedRecvQty – Based on parent item (same as how the user defined CSV column “1D” (1st Pending Receiving Date) is calculated)
  • SchedRecvDate – Based on parent item (same as how the user defined CSV column “1Q” (1st Pending Receiving Qty) is calculated)
  • CompItem# - Component item number (which is part of the report group heading area)
  • ProdStrucA/O – Component product structure activity flag
  • BOMPAvailGrp – From QTYAVAILBYCOMP attribute
  • ProdStrucSeq# - Component product structure sequence number
  • CompCat – Component Item’s Product Category
  • CompClass – Component Item’s ABC Class
  • CompBin# - Component Item’s Bin Number from the item master file
  • QtyReq – As printed on the report
  • CompActive – Component item activty code from the item master file
  • CompCreateDate – Component item’s create date
  • CompQtyAvail – From QTYAVAILBYCOMP attribute based on component item number
  • CompBOMPAvail – From QTYAVAILBYCOMP attribute based on component item number
  • CompNextPODate – From QTYAVAILBYCOMP3 attribute based on component item number
  • CompNextPOQty – From QTYAVAILBYCOMP3 attribute based on component item number
  • CompQtyonOrd – Quantity on orde from the item master
  • CompUDC – Component item’s user defined code
  • Comp1stRecv – Component item’s 1st received date
  • CompLstRecv – Component item’s last received date
Programs changed: BM0800, BM08P1

CLS




    • Related Articles

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

    • 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 - User Defined CSV Export Item Batch Support

      Release Date - 2/5/18 This feature gives the user the ability to define a batch that can be used when running the User Defined CSV Export. The batch can be defined from I/M-> Reports-> User Defined CSV Report-> Maintenance-> User Defined CSV Batch. ...

    • Feature - Reorder Advice/User Defined CSV Export Introduction

      Release Date: 08/07/2020 Version: 8.0 & Up Introduction The User-Defined CSV Export is a specialized report writing tool and CSV creator for inventory information to allow you to analyze an Excel spreadsheet. This program allows access to ...