This disagrees with NetSuite so looking for an alt...
# manufacturingm
MikeP
07/23/2021, 12:40 PMThis disagrees with NetSuite so looking for an alt idea: From a transaction search type=Work Order, i want the Assembly Item and it’s quantity, same row I want it’s component item and quantity (these have just a single component BOM)
Instead…I’m forced to use the same search with filter=main line, export each and vlookup to pop all other values…
Thoughts?
k
KevinJ of Kansas
07/23/2021, 2:50 PMcan use a summary saved search, and then do a decode on {mainline}
KevinJ of Kansas
07/23/2021, 2:51 PMdo a formula text using mainline to see what it returns
KevinJ of Kansas
07/23/2021, 2:51 PMand then use it in your formula
KevinJ of Kansas
07/23/2021, 2:51 PMi.e.
decode({mainline},'T',{desiredfield})KevinJ of Kansas
07/23/2021, 2:52 PMformula would need some tweaking for sure, but just a framework to get you started - but you do that a few times and then do maximums and group by your main item.
a
Amanda Morris CPA CMA CPIM CGMA
08/03/2021, 4:24 PMI am looking into other reporting tools because I want this level of detail not just over all profitability. I want to see trends in those components!