Hello,
I am needing to report on Gross Profit % for each inventory item(1 unit).
Basically listing all Inventory items with a column that displays the Gross Profit %, to what is set in Netsuite.
I see there are formula fields using saved search, would it be possible to use a formula field to calculate the GP%, and display it for every item.
Formula would be (Sales Price-Purchase Price)/Sales Pricex100
Not sure if reports would be the way to go, but please share if you know a better way.
Thank you