Feature - Indented Bill of Material CSV

Release date: 7/22/19

Version: 8.5 and up

Added the option to export the Indented Bill of Material report data to a CSV file.

CSV fields that will be exported:

ParentItem - Parent item number

ParentDesc - Parent item description 1

ParentDesc2 - Parent Item description 2

LLC - Parent low level code

EngnrRelse - Parent engineering release number

EngnrRev - Parent engineering revision number

ParActCd - Parent activity code

ParActSubCd - Parent activity sub code

LineNo - Report Line Sequence number to keep whole report can be restored to original sequence after sorting from different way on spreadsheet

Lv - Component level

SeqNo - Component sequence number

CompItem - Component item number

CompDesc - Component item description 1

CompDesc2 - Component item description 2

QtyPer - Component quantity per parent

CompLLC - Component low level code

UOM - Component unit of measure

AttchOper - Component attaching operation

Scrap - Component scrap factor

Act - Component product structure activity code

StkFlg - Component stocked flag

CtlFlg - Component controlled flag

P/M - Component purchased or manufactured flag and the mostly purchased or manufactured flag

OrdPol - Component order policy code

ProdCat - Component product category

UDC - Component user defined code

MCT - Component material cost type

CommCd - Component commodity code

CompActCd - Component item activity code

CompActSubCd - Component item sub activity code

If screen field "4. Type of Data To Print" is "I" (Inventory Data) the following fields will be exported:

CompQtyOH - Component quantity on hand at all locations

CompQtyOnOrder - Component quantity on order at all locations

CompQtyAlloc - Component quantity allocated at all locations

If screen field "4. Type of Data To Print" is "E" (Engineering Data) the following fields will be exported:

EngRls - Component engineering release

EngRev - Component engineering revision

RteRls - Component routing release

RteRev - Component routing revision

RteNum - Component routine number

If screen field "8. Print Reference Designators" is "Y", the following fields will be exported:

Ref1 - Reference designator 1

Ref2 - Reference designator 2

Ref3 - Reference designator 3

To export  the Indented Bill of Material report data to a CSV file, enter "Y" in "Create CSV File?," then enter a valid file name and path in "CSV File Name & Path."

Programs changed: BM0600.CBL, BM06P1.CBL

DLM

• Related Articles

• BM0300 Bill of Material Indented Bill of Material Inquiry

  Indented Bill of Material Inquiry Application Overview The Indented Bill Of Material Inquiry application is used to quickly and easily finds the Bill of Material for an entered parent item. It offers the option of blowing through phantom items ...

• BM0600 Bill of Material Indented Bill of Material Report

  BM0600 Bill of Material Indented Bill of Material Report ← Bill of Material / Work Order Plus Indented Bill of Material Report Application Overview The Indented Bill Of Material Report prints a selected number of levels of the components for a ...

• BM0000 Bill of Material Package Overview

  BM0000 Bill of Material Package Overview ← Bill of Material / Work Order Plus Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when ...

• Feature - Added CSV File Creation to Print Costed Bill of Material Report

  Release Date: 3/14/2019 Version: 8.2 and Up Added CSV file creation to Print Costed Bill of Material report. Go to BM --> Processing --> Print Costed Bill of Material If the CSV file output is desired, enter "Y for "Export to CSV File?" then enter a ...

• BM1800 Bill of Material Production Transaction Processing

  BM1800 Bill of Material Production Transaction Processing ← Bill of Material / Work Order Plus Production Transaction Processing Application Overview The Production Transaction Processing application allows for reporting progress made toward ...