The Costed Bill of Materials SuiteApp displays the total cost breakdown of an assembly item using the bill of materials revision, routing steps, and costing method. After installing the SuiteApp,
- Navigate to the Report: Go to Reports > Cost Accounting > Costed Bill of Materials in the NetSuite account.
- Select Subsidiary: From the Subsidiary dropdown list, choose the subsidiary that applies to the bill of materials.
- Choose Assembly Item: In the Item dropdown list, select the assembly item for which we want to generate the bill of materials.
- Select Location: From the Location dropdown, pick the location wish to view the data for.
- Pick Bill of Materials: In the Bill of Materials list, choose the relevant bill of materials. This will automatically fill the Bill of Materials Revision and Effective Date fields.
- Set Display Control: In the Display Control list, choose either By Date or By Revision. This selection determines how components are included in the assembly. This option only appears if the assembly item uses revision control for display.
- Review Date/Effective Date: The Date/Effective Date field shows the date used to decide when components should be included. If revision control is used, the field becomes editable when Display Control is set to By Date. Components are shown based on whether:
The selected date is on or after the effective start date.
The selected date is on or before the effective end date.
- Select Bill of Materials Revision: From the Bill of Materials Revision list, choose the appropriate revision.
- Manufacturing Routing (Optional): If the assembly item has an associated manufacturing routing, check the By Manufacturing Routing box. If the item doesn’t have a routing, this option will be disabled.
- Choose Manufacturing Routing: If we check the By Manufacturing Routing box, select the corresponding routing from the Manufacturing Routing list.
- Enter Build Quantity: In the Build Quantity field, specify the number of units want to calculate the cost for. By default, it’s set to 1, but if the Manufacturing Routing and Work Center feature is enabled, the default will be the costing lot size set in the assembly item record.
- Top Level Only Option: To restrict details to the assembly item, its components, and operations, check the Top Level Only box. Uncheck this to view all levels of the fully exploded bill of materials. This field cannot be selected if the By Manufacturing Routing box is checked.
- Select Material Cost: Choose the cost type for all components from the Material Cost dropdown. For details on cost types, refer to Cost Types for Material Cost Calculation.
- Submit: Click Submit to generate the costed bill of materials.
- View Results: After the report is processed, we can view the following subtabs:
Material Costs
Assembled Costs
Fully Exploded Costs
- Download the Report (Optional): To download the report, click the Download button.
- Email the Report (Optional): To send the report via email:
a. Click the Email button (opens in a new browser tab).
b. Enter the recipient email addresses in the Email Recipients field. By default, the email address of the logged-in user will be listed.
c. Click Submit to send the report.
- Simulate Report with Modified Values (Optional):
a. To simulate the report with different unit cost values for non-assembly items, modify the value in the Unit Cost column under the Material Costs subtab.
b. In the Simulate Build Quantity field of the same subtab, update the build quantity that want to simulate.
c. Click Simulate to generate the simulated report.
d. To download the simulated report, click the Download button.