Customization CR1006
Parts List Utility
Description of Need:
ACME needs to report on components within a top-level item, in the manner shown below. Rather than an “Exploded BOM,” this is more of a “Parts List.”
ACME will need to run reports against the data. For example, a user might want to view the “Parts List” for all parent items within a given Item Class, or where the Parent Item starts with “6.” One use of this information would be to locate all inventory needed to make an item.
Description of Solution:
WilloWare will create a utility that can be run from inside GP which will populate a “Parts List” table in the manner shown above. By populating the table for all items, it will allow ACME to link it to pull it into SmartList, link it to other tables, (such as the Item Master), and create the reports/inquiries needed through that tool. The data can also be exported to Excel.
Navigation: Tools >> Utilities >> Manufacturing >> Parts List Utility
Down to LLC: This defaults to 9999, which means the export will include all BOMs (top-level and all subassemblies). 9999 will be interpreted as “No LLC Restriction”, which means the utility will export all MFG BOMs and not consider the LLC. You must run the MFG Low Level Code utility to set the LLC value for each item. If that utility has not been run, the LLC is zero for all items. The LLC setting can be used to restrict the Parts List Utility so that only top-level BOMs are included by setting LLC = 1.
Assumptions/Requirements:
- Only MFG BOMs will be exported
For information on this design, or any other WilloWare customization or product, please contact us: