BM1000 Bill of Material Print Costed Bill of Material

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 costs of their components.  If you choose, it will show the variance between the parent items' cost on file and the cost calculated from the components.  It also allows you to choose whether or not you wish the report to show active items, obsolete items and/or forecasted items.

 

As the costs are rolled up from the bill of material, it will explode through sub-assemblies if they are flagged as manufactured.  It will not explode through any purchased inventory items.  This is regardless of whether the items are flagged as stocked or non-stocked.  If a sub-assembly is flagged as a purchased item, this is an error in the product structure and may be corrected using the Product Structure File Maintenance application.

 

An important feature of this application is the ability to update the cost in the Inventory Item File for the range of parent items selected.  If the update cost option is chosen, the number of levels to explode will automatically be set to 11.  Caution: Only parent items' sub-assemblies within the item range defined in fields #1 and #2 will have their costs updated.  To avoid excluding any sub-assemblies, set the item range to All. It also offers the option to include components' scrap factor in the calculated cost for each.


If the parent item includes costs other than the material -- such as labor, for example -- then it is not desirable to use the option to update the parent item cost. Instead, you should use Plus Work Order posting or Cost Master roll up to update. In that case, this option should be disabled in Global Setup to prevent potential user mistakes. See the following article for more details: http://support.elliott.com/knowledgebase/articles/1188856-feature-disable-print-costed-bill-of-material-to

 

Run Instructions

 

      Select Print Costed Bill Of Material from the pull down BOMP Processing window.  The following screen will then be displayed:

 

 

Print Costed Bill of Material Entry Screen

 


The following options are available:

    • Select the desired mode from the Print Costed Bill Of Material menu bar
    • Enter the data requested on the screen

     

          To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

     

    Entry Field Descriptions

     

    Name

    Type and Description

    1.      Starting Parent Item No

    15 alphanumeric characters.

    Enter the item number of the parent item for which you wish to print a Print Costed Bill Of Material.

    Default is All.

    2.      Ending Parent Item No

    15 alphanumeric characters.

    Enter the item number of the last parent item for which you wish to print a Print Costed Bill Of Material.

    Default is the starting parent item number.

    3.      Print Active Items?

    Y or N.

    Enter Y to print active items or N to decline.

    This field defaults to Y.

    4.      Print Forecasted Items?

    Y or N.

    Enter Y to print forecasted items or N to decline.

    This field defaults to N.

    5.      Print Obsolete Items?

    Y or N.

    Enter Y to print obsolete items or N to decline.

    This field defaults to N.

    6.      Blow Through Phantom    Items?

    Y or N.

    Component items and subassemblies which are neither stocked nor controlled but which are manufactured are known as phantom items.  Answering Y to this question allows you to blow through phantom items to the real component items, which are down one level.

    Default is N.

    7.      Show Component Cost    Variance?

    Y or N.

    If you answer Y to this question the variance between the calc­ulated cost of the parent item and the cost that is in the Item File for this parent, will appear on the report.

    Default is N.

    8.      Number Of Levels To       Explode?

    2 numeric digits (99).

    The number of levels to explode must be 11 to obtain correct cost.

    Default is 11.

    9.      Effectivity Date

    A date in the standard date format.

    Enter the effectivity date you wish to use for printing items. This date will be used to determine whether to include or exclude items. If you press RETURN, no selection will be made based upon effectivity date.

    You will not be prompted to enter this field unless both active and forecasted have been selected for printing.

    Default is no selection based on effectivity date.

    10.    Reflect Scrap Factor In Cost?

    Y or N.

    Enter Y to include each component's scrap factor in the calculation of the extended cost.  Enter N to calculate the extended cost based solely on the quantity required per parent.  Defaults to N.

    11.    Update Parent Cost In   Inventory?

    Y or N.

    If you answer Y, the appropriate cost in the Inventory Item File for the parent item will be updated using the total cost of components for the parent.

    If Y is selected, the number of levels to explode set in field #8 will automatically be set to 11.

    Note:  If you set this field to Y but do not select All parent items in field #1, the costs of all sub-assemblies may not be updated.  If it is important that the costs of all sub-assemblies be updated, set the parent item range to All.

    Default is N.

    If the costing method defined in I/M Setup is LIFO or FIFO, parent costs may not be updated and field #11 will appear as follows:

    11.    Cost Type To Display?

    Only A, S, or R, is allowed.

    Enter the item cost to be used in printing the Costed Bill of Material.

    A      =   Average Cost

    S      =   Standard Cost

    R      =   Last Cost

    Entry is required.  There is no default value.

     

     


     

    Print Costed Bill of Material

     

     

                                

    Bill of Material / Work Order Plus

    1. BM0000 Bill of Material Package Overview
    2. What Is Work Order Plus And Where Can I Find The Documentation
    3. Work Order Plus Questions and Answers
    4. How to Reverse Plus Work Order Production Entries
    5. Planning Lead Time by Calendar Days or Work Days?
    6. How to See Cost in BOMP Plus Work Order Production History Report
    7. How to Close Plus Work Order
    8. Why I Received "Nothing In Range" with Plus Work Order Printing
    9. Receive "Trx Not Complete" on BOMP Production Edit List/Journal
    10. Feature - Trap Bad Date/Timestamp on Time Clock
    11. Feature - Enhanced Production Routing File Bill of Material Screen
    12. Print Plus Work Order Menu Option Is Missing
    13. Feature - Item Last Received Date to Include BOMP Production Activity
    14. BM01S1 Bill of Material Audit Trail Report
    15. BM23S1 Bill of Material Set Component Activity Flags
    16. BM24S1 Bill of Material Resequence Component Items
    17. BM26S1A Bill of Material Copy COP Orders into BOMP
    18. BM27S1 Bill of Material Purge Complete Production Orders
    19. BM29S1 Bill of Material Post Engineering Changes
    20. BM30S1 Bill of Material Engineering Change History Report
    21. BM32S1 Bill of Material Job Distribution History Report
    22. BM33S1 Bill of Material Option Item Where-Used Report
    23. BM0100 Bill of Material Product Structure File Maintenance
    24. BM0200 Bill of Material Single Level Bill of Material Inquiry
    25. BM0300 Bill of Material Indented Bill of Material Inquiry
    26. BM0400 Bill of Material Single Level Where-Used Inquiry
    27. BM0500 Bill of Material Single Level Bill of Material
    28. BM0600 Bill of Material Indented Bill of Material Report
    29. BM0700 Bill of Material Single Level Where-Used Report
    30. Feature - BOMP Integrity Check Utility
    31. BM0800 Bill of Material End Item Where-Used Report
    32. BM0900 Bill of Material Summarized Bill of Material Report
    33. BM1000 Bill of Material Print Costed Bill of Material
    34. BM1100 Bill of Material Gross Requirements Report
    35. BM1200 Bill of Material Print Picking List by Bill
    36. BM1300 Bill of Material BOMP Setup
    37. BM1400S1 Bill of Material Reset Low Level Codes
    38. BM1501 Bill of Material Feature/Option Configuration Maintenance
    39. BM1601 Bill of Material Feature/Option Configuration Inquiry
    40. BM1700 Bill of Material Production Order Entry
    41. BM1800 Bill of Material Production Transaction Processing
    42. BM1900 Bill of Material Post Production Transactions
    43. BM2000 Bill of Material Print Production Work Orders
    44. BM2101 Bill of Material Job Code File Maintenance
    45. BM2201 Bill of Material Issue Serial/Lot Component Item
    46. BM2801 Bill of Material Engineering Change Processing
    47. BM3100 Bill of Material Production Transaction History Report
    48. BMDPTMNT Bill of Material Department Maintenance
    49. BMDISCN Bill of Material B/M Distribution Report
    50. BMDPTIME Bill of Material Department Time Clock
    51. BMINQMNU Bill of Material Work Order Inquiry
    52. BMITMVRS Bill of Material Production Cost Variance Report
    53. BMLABMNT Bill of Material Labor Grade
    54. BMOIDMNT Bill of Material Operation ID
    55. BMPRDANL Bill of Material Labor Performance Report
    56. BMRTGMNU Bill of Material Production Routing
    57. BMSCHSCN Bill of Material Production Schedule Report
    58. BMSPCMNT Bill of Material Special Operation
    59. BMWCMNT Bill of Material Work Center Maintenance
    60. BMWCTIME Bill of Material Work Center Time Clock
    61. BMWIPSCN Bill of Material WIP Report
    62. BMWOPROD Bill of Material Work Order Production
    63. BMWORSCN Bill of Material Production History Report for WO+
    64. Feature - Option to Control if Item Last Received Date Is Updated from BOMP
    65. I Can Not Delete Some BOMP Work Orders
    66. Feature - BOMP Work Order Entry - F3=Copy COP Ord Function Improvement
    67. Feature - BOMP Plus WO Inquiry Detail Screen to Display Avg Dir Labor Time in HH:MM:SS Format
    68. Feature - Gross Requirements Report Item/Qty CSV Import
    69. Feature - Gross Requirements Report COP Order Import
    70. Feature - Component Qty Calculation Options In F3 Copy Function in BOMP WO Entry
    71. Plus Work Order Transaction Can't Post
    72. Feature - Production Routing File Maintenance - Show Material Cost for Std, Avg, and Last Cost
    73. Some Users Do Not Have Right for F3=Detail or F5=Order Prod Option in Plus Work Order Inquiry
    74. Feature - Print Kit Parent on Work Order
    75. Feature - Transfer Batch on Material Work Order Inquiry Screen
    76. Feature - Print User Name and Transfer Batch Status on Work Order
    77. Feature - Show “Active” Operators in Operator File Inquiry
    78. Feature - Transfer Batch on Plus Work Order Inquiry Screen
    79. Feature - Ability to Start a Material Work Order
    80. Feature - Drill Down to Where Used from Stock Status Inquiry Screen
    81. Feature - Allow User to Choose Time Format on Plus Work Order Traveler (BM20P3T)
    82. Feature - Material Work Order Copy Product Structure
    83. Feature - Plus Work Order Copy Product Structure
    84. Freezing When Printing Costed Bill of Materials
    85. Feature - Create Material Shortage Tracking with Plus Work Order
    86. Close Work Order With Quantity That Is Not Fully Reported
    87. Feature - Disable Print Costed Bill of Material to Update Parent Cost
    88. Feature - Item Selection in Cost Master Maintenance
    89. Feature - Plus WO Operation Number Default Increment
    90. Feature - Print Totals on Material Production History Report
    91. Feature - Print Total Quantity Order/Completed on the Production Schedule Report
    92. Feature - Add Default for Material Pick List, "Print By Pick Sequence"
    93. Feature - Allow Password to be Required to Update Parent Cost in Inventory
    94. Feature - Production Time Not Captured Report
    95. Feature - Add "Related Quotes" Option to Where-Used Inquiry
    96. Feature - Allow Export to CSV File for End Item Where-Used Report
    97. Feature - Allow End Item Where-Used to Select Items Based on CSV File

    Feedback and Knowledge Base