A Bill of Materials (BOM) is a centralized source of information containing a list of both 'Inventory Items' and 'Cost Items' used in production. BOMs specify a target output quantity and the quantities and scaling method of each of the inputs required to product the target quantity. The purpose of this page is to add, edit, remove, and activate/inactive these records.

This list view also contains columns for each Attribute that is set up for the targeted BOM Item. Because these are user defined, they are not included in the default view but can be added a saved layout. 'Items' attributes are not included in the help documentation.

Software Version: 2023.11.30 and newer

Page Header

Toolbar Icons	Description
Column Filter Show/Hide	Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Delete	Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. _{WARNING: Records cannot be recovered once they are deleted!}
Edit	Opens the selected record for editing. If a record is not selected, the page will either not open or will open the first record (depending on how the page was coded).
Excel	Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported.
Favorites	Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
Group By Show/Hide	Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total.
Help	Opens the online WIKI help page for the current page.
New	Allows users to select the type of transaction or record they want to add. The list includes all the 'Active' BOM Classes.
Quick Column Filter	Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Saved Layout	Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default.
Fields	Description
Checkbox	Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
# Cost Items	Identifies the total number of rows for Cost Items that are assigned to the 'Cost Items' tab on the BOM Record View. This is a count of the rows and not a count of the unique records so if the same Cost Item was added two times, this would show as 2. This is a calculated field and is not stored in the database.
# Inv. Items	Identifies the total number of rows for Inventory Items that are assigned to the 'Inventory Items' tab on the BOM Record View. This is a count of the rows and not a count of the unique records so if the same Inventory Item was added two times, this would show as 2. This is a calculated field and is not stored in the database.
Batch Units	Identifies the target units of a typical Batch of a BOM Item. For example, if a BOM Item is typically produced in batches of 300 cases then this would be set to 300. This quantity is then used to scale each of the 'Inventory Items' and 'Cost Items' if the BOMs scaling UOM is the Units UOM. This number is formatted to the number of Unit decimals setup on the Item master for the BOM Item. Database Field: ERPx_IMBOM.Units
Batch Weight	Identifies the target weight of a typical Batch of a BOM Item. For example, if a BOM Item is typically produced in batches of 2,000 lbs then this would be set to 2,000. This quantity is then used to scale each of the 'Inventory Items' and 'Cost Items' if the BOMs scaling UOM is the Weight UOM. This number is formatted to the number of Weight decimals setup on the Item master for the BOM Item. Database Field: ERPx_IMBOM.Weight
BOM Class	Identifies the BOM Class of the associated BOM ID and it is not editable after the initial save. BOM Classes are used to group and identify different types of BOMs (Bills of Material) together for reporting and data selection purposes. BOM Classes can be separate by product line, process, or anything else desired.
BOM ID	Identifies the unique ID for each BOM record. Clicking on the link opens the corresponding transaction record view. This is a system assigned value that comes from the 'Doc Prefix' + 'Next Num.' of the selected BOM Class of the record and is not editable by users. Database Field: ERPx_IMBOM.BOMID
BOM Item	Identifies the BOM Item, displayed as Item ID: Description. This is a non-editable textbox that displays the Item assigned to the corresponding BOM record. Item IDs are the unique identifier for Items. This represents the Item ID: Item Description of the 'BOM Item' and is not editable after the initial save. Database Fields: ERPx_IMItem.ItemID: ItemDescription, ERPx_IMBOM.ItemSK
BOM Item Description	Identifies the Description associated with the Item ID assigned to a transaction line, journal line detail or master file record. This represents the Item Description of the 'BOM Item' and is not editable after the initial save. Database Fields: ERPx_IMItem.ItemDescription, ERPx_IMBOM.ItemSK
BOM Item ID	Identifies the ID of the Item. This represents the Item ID of the 'BOM Item' and is not editable after the initial save. Item IDs are the unique identifier for Items. Database Fields: ERPx_IMItem.ItemID, ERPx_IMBOM.ItemSK
Cost UOM	Identifies the unit of measure the item's cost is stated in terms of. This is the value assigned in the "Cost UOM" property on the Item Record View. This is only editable from the Item master file record. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.CostUOMSK
Created	Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMBOM.CreatedDate
Created By	Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMBOM.CreatedBy
Fixed Cost Rate	Identifies a Fixed cost rate for the BOM Item. BOM Items are typically valued from the sum of the costs of all the 'Inventory Items' and 'Cost Items'. However, in some cases the BOM Item needs to be assigned a standard or fixed cost. This is most commonly used to cost By-Products and/or waste items. This is editable from the record view. Database Field: ERPx_IMBOM.FixedCostRate
Last Updated	Identifies the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMBOM.LastUpdated
Last Updated By	Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_IMBOM.LastUser
Scaling UOM	Identifies the unit of measure that the BOM Item (BOMs source item) uses for scaling each of the inventory and/or cost items assigned to the BOM. This must be either the BOM Item's Unit or Weight UOM. This is editable from the record view. Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.ScalingUOMSK
Site ID	Identifies the Site ID (warehouse ID) the transaction is associated with. This is a comma separated list of Site ID's where this BOM is applicable, if there are multiple Sites assigned, and not enough space to display each of them, '...' will be displayed at the end. If 'All' Sites are assigned, this will display as 'All'. This is editable from the record view. Database Fields: ERPx_MFSite.SiteID, ERPx_IMBOMSite.SiteSK
Status	Identifies the status of the BOM. Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type. The list of potential Statuses for a BOM include: Open: This is the default Status for all new records. While in the Status of 'Open', all editable fields are open for edit. Closed: Used to indicate that the record is no longer open to be used on other transactions. Closed records are only visible from inquiries, not list views. This is editable from the record view. Note: Temporarily we will display 'Closed' records in this List View. Database Fields: ERPx_ , ERPx_IMBOM.StatusSK
Units UOM	Identifies the unit of measure that the units are stored in (Box, Bag, Case, Each, Tote, etc.) for a line item or on the transaction. This represents the Units UOM for the targeted BOM Item. Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.UnitsUOMSK
Weight UOM	Identifies the unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for a line item or on the transaction. This represents the Weight UOM for the targeted BOM Item. Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.WeightUOMSK

Page Header

Related Topics

Page Definitions

Technical Details

Browser not supported