Hi, I would like to generate a report that will sh...
# manufacturingi
Israel Trujillo
02/02/2021, 9:09 PMHi, I would like to generate a report that will show the average cost of assembly item broken down to each individual components. Does NetSuite have anything standard that can be referred?
k
KevinJ of Kansas
02/02/2021, 9:13 PMI helped a client with this one time - short answer was it was ugly.
KevinJ of Kansas
02/02/2021, 9:13 PMhad to do iterative custom field updates in order to calculate it. Chose to do it with workflows
KevinJ of Kansas
02/02/2021, 9:13 PMMainly because of limits of "1 record up, and 1 record down" in saved searches
KevinJ of Kansas
02/02/2021, 9:15 PMNormally the suggestion is to use planned standard cost - which NS is pretty good at doing.
KevinJ of Kansas
02/02/2021, 9:15 PMand does give you a native rollup if you do that.
p
Paweł Kubera
02/04/2021, 10:41 AMHi, as a standard you can use BOM Inquiry and customise view with adding Average Cost column. Then export the list to excel and do hatever you want 🙂
p
Peter Bertelsen
02/05/2021, 11:31 AMIf you only need components and Average costs i will suggets using the BOM inquiry like Paweł said.
Otherwise its possible to get all the data with a few searches.
I made a custom suitelet displaying all levels in a BOM like the BOM Inquiry, but also showing the structure of routings, sum of time requirements total and for each work center.