Hello all, I am working on a report (Report Type: Current Inventory Status) that shows me pricing + stock on hand.
We have not been able to pull pricing into that report.
Since NetSuite does not provide a standard way to pull the standard unit price for EU Direct & EU Wholesale price levels in a report, I thought of adding a custom field for each of them that can be used in our report. The prices can be pulled using a saved search though.
So, the custom Item field is sourcing its value from an Item Search -> The field does not store value since we source the value from the search.
I confirmed that the custom field sources the value accurately on the Item record.
But if I go to the report, I am unable to find this field to add as one of the columns.
Any idea how we can solve this?