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

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 

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)

 

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

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

• Feature - Disable Print Costed Bill of Material to Update Parent Cost

  Release Date: 07/07/2017 We are now introducing a Global Setup flag in Dist -> BOMP Global Control, screen 6: Flag "11. Disable Print Costed Bill of Material to Update Cost?" The default value is "N." If this flag is set to "Y," then in BOMP -> ...

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

• Feature - Allow Password to be Required to Update Parent Cost in Inventory

  Release date: 12/29/17 This feature will allow a password to be required to update parent cost in inventory during the Print Costed Bill of Material report. In BOMP Global Setup, screen 6, a new option "P" has been added to field "11. Disable Print ...

• Feature - Import for Material Cost Type Location Account File

  Release Date: 12/16/22 Version: 8.5 and Above This feature allows the user to import records for the Inventory Management Material Cost Type Location Account file. A new Import menu option has been added. After choosing the Import option, a new ...