We recently completed a manufacturing client’s NetSuite implementation. Along the way, the client asked if it was possible to create a report showing what was available to build based on current inventory levels. We did some initial research and discovered that the only way to produce the requested report is if Advanced Bill of Materials (Advanced BOM) is not enabled. So what happens when you need BOTH?!
It appears our client is not the only one out there in this predicament… We found two NetSuite enhancement requests currently logged:
- Enhancement # 492366 – Advanced BOM = T > Item Saved Search > Be able to expose Current Revision components when pulling Assembly Items
- Enhancement # 430107 – Item Saved Search > Ability to Show BOM components of all level assemblies like BOM Inquiry Report
Now, if you don’t need Advanced BOM enabled, pulling a report of what is available to build based on current inventory levels is not difficult. We found a SuiteAnswers article that describes using an Item Search that looks at the Member Items. Member Items are a sublist of the Assembly item, but only when the Advanced BOM feature is not enabled.
When the Advanced BOM function IS enabled, the BOM becomes a subrecord of the assembly that has a further subrecord of BOM revision. The BOM revision record is the one that then contains the member items and quantities.
Given these limitations, we researched more and implemented a workaround that allows you to use Advanced BOM AND pull a report of what’s available to build based on current inventory levels at the same time. Check it out below and put it to work yourself!
Looking for more ways to enhance NetSuite to suit your specific needs? Make the Limebox Tools SuiteBundle your first stop.
Two quick steps to use Advanced BOM AND pull a report showing what’s available to build based on current inventory
01.
Create a custom sublist field by navigating to Customization > Lists, Records, and Fields > Other Sublist Fields > New
- Sublist Record Type: Bill of Materials Revision Component
- Label: Available Qty
- Type: Decimal Number
- Uncheck “Store Value”
- On the Sourcing and Filtering tab, select Source List: Item and Source From: Available
- ID: _lb_avail_qty
02.
Create a Saved Search of Record “Bill of Materials Revision”
- Criteria: Filter: Component: Item Type Description = Inventory Item
- Results: Field “Bill of Materials,” Summary type “Group”; Formula (Numeric), Summary type “Minimum”, Formula: Floor(NVL({component.custrecord_lb_avail_qty},0)/NULLIF({component.bomquantity},0))
03.
Problem solved… Here are the results of the search.
Get More NetSuite Tips and Tricks from Limebox
We’re here to help you win on NetSuite! Send us your email and you’ll be among the first to know when we release new NetSuite hacks and news!
Simple Solutions with Out-of-the-(Lime)box Thinking
Do you have a frustrating NetSuite limitation? Send it our way, and we’ll see what we can do!
Our NetSuite-Certified experts have solved dozens of frustrating limitations and conundrums over the years. With some outside-the-box, problem solving genius.
At Limebox, we help organizations implement and optimize enterprise-ready NetSuite, and custom software solutions, for their entire ecosystem. We deliver bonafide results the first time. With an eye for simplification and a genius for problem solving.