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 file name and path for "CSV File Name & Path."
Fields exported:
ParentItem - Parent item number
ParentDesc - Parent item description 1
ParentDesc2 - Parent Item description 2
LLC - Parent low level code
DfltRtg - Parent default routing
ParentDesc - Parent item description 1
ParentDesc2 - Parent Item description 2
LLC - Parent low level code
DfltRtg - Parent default routing
CompItem - Component item number (Component line only)
CompDesc - Component description 1 (Component line only)
CompDesc2 - Component description 2 (Component line only)
SeqNo - Component sequence number (Component line only)
CompLLC - Component low level code (Component line only)
P/M - Component purchased or manufactured flag (Component line only)
Act - Component activity code (Component line only)
Scrap - Component scrap factor (Component line only)
UOM - Component stocking unit of measure (Component line only)
QtyPer - Component quantity per parent (Component line only)
CompCost - Component cost (Component line only)
ExtCost - Component extended cost (Component line only)
LastRecv - Date last received
CompDesc - Component description 1 (Component line only)
CompDesc2 - Component description 2 (Component line only)
SeqNo - Component sequence number (Component line only)
CompLLC - Component low level code (Component line only)
P/M - Component purchased or manufactured flag (Component line only)
Act - Component activity code (Component line only)
Scrap - Component scrap factor (Component line only)
UOM - Component stocking unit of measure (Component line only)
QtyPer - Component quantity per parent (Component line only)
CompCost - Component cost (Component line only)
ExtCost - Component extended cost (Component line only)
LastRecv - Date last received
ParentOrigCost - Parent original cost from the Item Master File (Parent line only)
ParentNewCost - Calculated parent cost based on current component cost and routing information, if chosen (Parent line only)
CostVariance - Difference between the parent original cost and the parent new cost (Parent line only)
ParentNewCost - Calculated parent cost based on current component cost and routing information, if chosen (Parent line only)
CostVariance - Difference between the parent original cost and the parent new cost (Parent line only)
if field 4, "Include Routing," is "Y" the following fields will be included after ExtCost and before LastRecv columns:
Oper - Operation number
OperType - Operation type
OperId - Operation ID
OperDesc - Operation description 1
OperDesc2 - Operation description 2
WC - Work center
Dept - Department
QtyPerBatch - Quantity per batch
UserDefCd - Routing user defined code
MachineNo - Machine number
Est/Std - Estimated or standard values
DirectLabRate - Direct labor rate
DirectLabRateUOM - Direct labor rate unit of measure
DirectLabGrade - Direct labor grade
DirectLabHrs - Direct labor hours
DirectLabAmt - Direct labor amount
ShareLabRate - Shared labor rate
ShareLabRateUOM - Shared labor rate unit of measure
ShareLabGrade - Shared labor grade
ShareLabHrs - Shared labor hours
ShareLabAmt - Shared labor amount
MachRate - Machine rate
MachRateUOM - Machine rate unit of measure
MachOperMode - Machine operation mode
MachHrs - Machine hours
BurdenAmt - Burden amount
OperType - Operation type
OperId - Operation ID
OperDesc - Operation description 1
OperDesc2 - Operation description 2
WC - Work center
Dept - Department
QtyPerBatch - Quantity per batch
UserDefCd - Routing user defined code
MachineNo - Machine number
Est/Std - Estimated or standard values
DirectLabRate - Direct labor rate
DirectLabRateUOM - Direct labor rate unit of measure
DirectLabGrade - Direct labor grade
DirectLabHrs - Direct labor hours
DirectLabAmt - Direct labor amount
ShareLabRate - Shared labor rate
ShareLabRateUOM - Shared labor rate unit of measure
ShareLabGrade - Shared labor grade
ShareLabHrs - Shared labor hours
ShareLabAmt - Shared labor amount
MachRate - Machine rate
MachRateUOM - Machine rate unit of measure
MachOperMode - Machine operation mode
MachHrs - Machine hours
BurdenAmt - Burden amount
Modified programs: BM1000, BM10P3
DLM
Related Articles
BM1000 Bill of Material Print Costed Bill of Material
BM1000 Bill of Material Print Costed Bill of Material ← Bill of Material / Work Order Plus Print Costed Bill of Material Application Overview Print Costed Bill Of Material prints a selected range of parent items and "rolls up" their costs from the ...BMPRDANL Bill of Material Labor Performance Report
Labor Performance Report Application Overview The Labor Performance Report prints the productivity of each selected operator. The operator’s time is categorized into 4 types: productive, non-productive, break time (payable break) and meal break time ...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 ...BM1601 Bill of Material Feature/Option Configuration Inquiry
BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...BM0100 Bill of Material Product Structure File Maintenance
BM0100 Bill of Material Product Structure File Maintenance ← Bill of Material / Work Order Plus Product Structure File Maintenance Application Overview This application enables the user to maintain the Product Structure File. Numbers of related ...