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


Feedback and Knowledge Base