Just wondering. Is it possible to create an invent...
# inventorym
Michael McNamara
07/14/2021, 6:13 PMJust wondering. Is it possible to create an inventory report that lists the matrix children horizontally instead of vertically like this?
k
KevinJ of Kansas
07/14/2021, 6:23 PMI suppose you could do a Decode statement to make it do this - but I'd be more inclined to just run the inventory valuation and then pivot chart my data
m
Michael McNamara
07/14/2021, 6:23 PMOK.
Michael McNamara
07/14/2021, 6:28 PMCan that all be done in Netsuite?
Michael McNamara
07/14/2021, 6:28 PMHow do you pivot chart in Netsuite?
k
KevinJ of Kansas
07/14/2021, 6:29 PMNo.
KevinJ of Kansas
07/14/2021, 6:29 PMDownload to excel and pivot there.
m
Mark C
07/14/2021, 7:47 PMUnless you only want to use it on screen - then you could use SuiteAnalytics to build out a pivot table and use it in-system. But you can't export those.
m
Michael McNamara
07/14/2021, 7:48 PMThanks Mark. That may be it otherwise I’ll take Kevin’s suggestion.
k
KevinJ of Kansas
07/14/2021, 7:57 PMI would expect to struggle making this map work in SuiteAnalytics, but I suppose it's feasible
m
Michael McNamara
07/15/2021, 3:55 PMHey guys. I figured it out. It is possible using inventory balance search with Multiple Formula (Numeric) with CASE WHEN {item.custitem_psgss_product_size}=‘XS’ THEN {onhand} ELSE NULL END
👏 1