The purpose of this page is to add, edit, remove, and activate/inactive these records. Insert excerpt Def - BOM (Bill of Materials) Def - BOM (Bill of Materials) nopanel true
Software Version: 2024.01.31 and newer
Table of Contents | ||
---|---|---|
|
...
Toolbar Icons | Description | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||||||||||||||||||
Help |
| ||||||||||||||||||||||||
New |
| ||||||||||||||||||||||||
Save |
| ||||||||||||||||||||||||
Save & Close |
| ||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||
BOM Class | A single select lookup to identify the class of the BOM record. This defaults from the Class selected from the New button when the record was created but can be changed prior to the initial save. This is required and is not editable after the initial save. The lookup contains the list of all 'Active' BOM Classes.
Database Field: ERPx_IMBOM.BOMClassSK | ||||||||||||||||||||||||
BOM ID | A textbox that identifies the unique ID for the BOM record. This can be manually entered on new but if not specified, it will be auto assigned from the 'Doc Prefix' + 'Next Num.' from the BOM Class that was selected when the record was created. This is only editable prior to the initial Save. This must be unique and no duplicates are allowed, else the message "[BOM ID]: BOM ID has already been used." will display on Save.
Database Field: ERPx_IMBOM.BOMID | ||||||||||||||||||||||||
BOM Item |
Only one combination of the same Item and Site can be on an Open BOM record Database Fields: ERPx_IMItem.ItemID, ERPx_IMBOM.ItemSK | ||||||||||||||||||||||||
BOM Units | A numeric textbox to identify the target units of a typical Batch of a BOM Item. This defaults to blank and is not required. If entered the value must be > 0 else the message "BOM Units must be blank or greater than 0." will be displayed on save. This is formatted to the # of decimals specified on the BOM Item's 'Unit Decimal Places' in the Item Master. This is only editable for BOM Items with a 'Manage Items By' property value of "Units Only" or "Units and Weight". 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. Database Field: ERPx_IMBOM.Units | ||||||||||||||||||||||||
BOM Units UOM (There is no label for this field) |
Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.UnitsUOMSK | ||||||||||||||||||||||||
BOM Weight | A numeric textbox to identify the target weight of a typical Batch of a BOM Item. This defaults to blank and is not required. If entered the value must be > 0 else the message "BOM Weight must be blank or greater than 0." will be displayed on save. This is formatted to the # of decimals specified on the BOM Item's 'Weight Decimal Places' in the Item Master. This is only editable for BOM Items with a 'Manage Items By' property value of "Weight Only" or "Units and Weight". 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. Database Field: ERPx_IMBOM.Weight | ||||||||||||||||||||||||
BOM Weight UOM (There is no label for this field) |
Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.WeightUOMSK | ||||||||||||||||||||||||
Fixed Cost | A numeric textbox to specify a fixed cots rate for the BOM Item. This defaults to blank and is not required. If entered, the value must be >=0, else the message "Fixed Cost must be greater than or equal to 0." is displayed on Save. It is editable while the record is in 'Open' Status. 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 | ||||||||||||||||||||||||
Scaling UOM | A single select lookup to identify the scaling UOM for the BOM Item. This defaults based on the Item's 'Manage Items By' property on the Item master file as follows:
The selected value must be either the BOM Units UOM or BOM Weight UOM else the message "Scaling UOM must match either BOM Units UOM or BOM Weight UOM." will be displayed on Save. For example, if the BOM Units UOM is 'Case' and the BOM Weight UOM is 'Lbs', the Scaling UOM can only be set to either 'Case' or 'Lbs'. It cannot be set to 'Kg' for example, even if 'Kg' exists on the BOM Item's UOM Schedule. This is editable while the BOM is in a status of Open. The lookup contains a blank value, the current assigned value, and a list of all 'Active' UOM's on the BOM Item's UOM Schedule. Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOM.ScalingUOMSK | ||||||||||||||||||||||||
Status | A single select lookup to identify the status of the BOM. This defaults to "Open" for new records, is required, and is always editable, even after the record has been 'Closed'.
Database Field: ERPx_IMBOM.StatusSK |
Inventory Items Tab
The Inventory Items tab is where Inventory tracked items, that will be backflushed, are added to the BOM. This tab is always editable when the BOM Status = "Open" but is not editable when the BOM Status = "Closed".
This tab also contains columns for each Attribute that is set up for the 'Items' attribute type. 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.
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Add Item |
| ||||||||||||||||
Column Filter Show/Hide |
| ||||||||||||||||
Excel |
| ||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
Quick Column Filter |
| ||||||||||||||||
Remove Items |
| ||||||||||||||||
Saved Layouts |
| ||||||||||||||||
Fields | Description | ||||||||||||||||
Checkbox |
| ||||||||||||||||
Include in Yield | A Yes/no lookup to identify whether the Item is included in the yield calculation or not. This defaults to 'Yes' and is required. This is editable while the record is in 'Open' status. This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMItem.IncludeInYield | ||||||||||||||||
Item |
When the 'Add Item' icon is clicked, users may enter all or part of an Item ID or Description and hit the Enter key on the keyboard. If a complete Item ID was entered, the line item will be saved, if not, the Item Lookup dialog box will open with a list of items containing the data entered. From the Item Lookup dialog box, users may check the checkbox next to one or multiple item(s) to add to the transaction using the Save & Close button. This is never editable on BOM with a Status = "Closed".
Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPx_IMBOMItem.ItemSK | ||||||||||||||||
Ln. |
For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e. 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30). This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMItem.LineNumber | ||||||||||||||||
Lot Tracked | Identifies if the line item is Lot Tracked or not. This is a non-editable Yes/No field that is automatically assigned from the Item master file setup. This is never editable from the BOM record. Database Field: ERPx_IMItem.TrackMethodEN | ||||||||||||||||
Scaling Method | Identifies the method in which the item scales, based on the scheduled or actual produced quantity of the BOM Item. This is a single select lookup that defaults to 'Variable', is required and is always editable. The lookup contains the following options:
This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMItem.ScalingMethodEN | ||||||||||||||||
Units | A numeric textbox to identify the target units of the Item when used on this BOM. This defaults to blank and is not required. If entered the value must be >= 0 else the message "Units and/or Weight must be greater than or equal to 0." will be displayed on save. This is formatted to the # of decimals specified on the BOM Item's 'Units Decimal Places' in the Item Master. This is only editable for Items with a 'Manage Items By' property value of "Units Only" or "Units and Weight". This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMItem.Units | ||||||||||||||||
Unit UOM | A single select lookup to assign the Unit UOM for the Item. This defaults from the Item's Inventory Units UOM and is only required and editable for Items with a 'Manage Item By' property value of "Units Only" or "Units and Weight". If editable, the lookup contains all Unit UOMs on the Items UOM Schedule. This is never editable on BOM with a Status = "Closed".
Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOMItem.UnitsUOMSK | ||||||||||||||||
Weight | A numeric textbox to identify the target weight of the Item when used on this BOM. This defaults to blank and is not required. If entered the value must be >= 0 else the message "Units and/or Weight must be greater than or equal to 0." will be displayed on save. This is formatted to the # of decimals specified on the BOM Item's 'Weight Decimal Places' in the Item Master. This is only editable for Items with a 'Manage Items By' property value of "Weight Only" or "Units and Weight". This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMItem.Weight | ||||||||||||||||
Weight UOM | A single select lookup to assign the Weight UOM for the Item. This defaults from the Item's Inventory Weight UOM and is only required and editable for Items with a 'Manage Item By' property value of "Weight Only" or "Units and Weight". If editable, the lookup contains all Weight UOMs on the Items UOM Schedule. This is never editable on BOM with a Status = "Closed".
Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOMItem.WeightUOMSK |
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Add Item |
| ||||||||
Column Filter Show/Hide |
| ||||||||
Excel |
| ||||||||
Group By Show/Hide |
| ||||||||
More Actions |
| ||||||||
Quick Column Filter |
| ||||||||
Remove items |
| ||||||||
Saved Layouts |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Amount | A numeric textbox that displays the calculated extended amount of the Cost item. This is calculated as: [Current Rate] * [Quantity]. This defaults to blank and is updated on Save. This is never editable. This is a calculated field that is not stored in the database. | ||||||||
Cost Item | A textbox that identifies the Cost Item displayed as [Cost Item ID]: [Cost Item Description]. This defaults to blank, is required to save a line item and only editable prior to the initial Save. When the 'Add Item' icon is clicked, users may enter all or part of a Cost Item ID or Description and hit the Enter key on the keyboard. If a complete Item ID was entered, the line item will be saved, if not, the Item Lookup dialog box will open with a list of items containing the data entered. From the Item Lookup dialog box, users may check the checkbox next to one or multiple item(s) to add to the transaction using the Save & Close button. Note: The Cost Item lookup displays the UOM for the corresponding item in parentheses since it is possible to have the same Cost Item ID with a different UOM. Database Fields: ERPx_IMCostItem.CostItemID: CostItemDescription, ERPx_IMBOMCostItem.BOMCostItemSK | ||||||||
Current Rate | A numeric text box to show the current cost rate of the item based on the current date. On save, this is updated to show to cost rate that is applicable for the item based on the current date. This can only be edited by changing the Item's 'Cost Rate' and 'Effective Date' from the Cost Items List View. Database Field: ERPx_IMCostItem.Rate | ||||||||
Ln. |
For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e. 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30). This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMCostItem.LineNumber | ||||||||
Quantity |
This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMCostItem.Quantity | ||||||||
Scaling Method | Identifies the method in which the item scales, based on the scheduled or actual produced quantity of the BOM Item. This is a single select lookup that defaults to the Scaling Method setup for the selected Cost Item. It is required and is editable while the record is in the status of 'Open'. The lookup contains the current selected value and the options "Variable" or "By Batch". This is never editable on BOM with a Status = "Closed". Database Field: ERPx_IMBOMCostItem.ScalingMethodEN | ||||||||
UOM | A single select lookup to identify the Unit of Measure of the Cost Item. This defaults from the Cost Item selected and is never editable from this record. It can be edited from the Cost Items List View at any time. Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOMCostItem.UOMSK |
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Add Each Site | Auto Adds all Sites to the BOM record. This is a data entry tool that is helpful in configuring BOM records that apply to a majority of Sites, but not all. In this instance, it easier to auto add them all and remove the ones you do not need. Clicking this icon adds all 'Active' Sites to the BOM record. | ||||||||
Add Item | Adds a blank line in the grid to allow for data entry of a Site. If a valid Site ID is entered, the line will be saved. If not, the 'Site Lookup' window will open allowing users to search for the Site(s). | ||||||||
Column Filter Show/Hide |
| ||||||||
Excel |
| ||||||||
Group By Show/Hide |
| ||||||||
Quick Column Filter |
| ||||||||
Remove Items |
| ||||||||
Saved Layouts |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Site | Identifies which Sites are applicable to the BOM record. This is a single select lookup that displays the [Site ID] - [Site Name] for all 'Active' Sites. If no Sites have been selected there will be one row indicating "All". Database Field: ERPx_IMBOMSite.BOMSiteSK |
...