Kaladi Consulting Services

Enterprise

nth level Assembly BOM explosion/detailed report

Problem Statement

A Large Equipment based Automation & Solution implementation company in assembling, manufacturing, implementation, and multi-vendors dealing for sub-assemblies & raw material provision had a pain area where the customer need to a purchase forecast report that should give a BOM explosion view of an open Sales Orders with more than 1000+ line items and in addition to that they also wanted to get the wholistic view of the multiple add-on information for each line items to support their planning process.

Kāladi Solution

Kāladi consulting has developed a downloadable Excel Report with the support of a well-known data structure logic of Recursive Functional Loop that has been developed with the Server-side Suite Script to do a detailed level of BOM explosion programmatically so that any number of Assemblies and Item groups present in the Sales Orders could be drilled down from 1st level to nth level in the BOM hierarchy and all the sub-elements could be fetched off for the display.

In addition to this, this report would also inform the following add-on details to the customer pertains to each exploded line item to facilitate their planning and delivery process

This report could be run easily from a custom Suitlet page and pass on the list of parameters. With this Report the customer could effectively understand all the materials on-demand, purchase forecasting for single or set of open Sales orders that are pending to be fulfilled to the detailed level of sub-products and raw-materials to build assemblies and sub-assemblies.

Leveraged Features of NetSuite

For more information
about this project

For more information
about this project

More case studies
SFA Solution
Manifold increase in sales efficiency through mobile SFA solution
Landed Costing
Manufactured & bought-out (local & imported) finished goods​
RPA
Download files from Practice Management Applications
WEB
Developing Enterprise Procurement Portal
Web Portal
Web portal for effectively managing engagement with various stakeholders