The average cost/unit and total inventory value in NetSuite is composed of the FOB price, duty and freight (landed costs). Is there a creative way to recalculate the average cost/unit and inventory value per FOB price, duty landed costs and freight landed costs separately? I tried using Prolecto's hack to calculate the cumulative quantity but the cumulative value is so challenging due to inventory-reducing transactions where I need to do: cumulative value/cumulative quantity x (negative) quantity.

I wouldn't touch doing that with ten foot pole and I'm really good at saved searches

There's a certain subsidiary that has strict external borrowing requirements and internal reporting requirements. At this point, I really ran out of ideas. The most that I can do is to export at least the raw data and do the math in Excel or SuiteQL maybe.