ANS-0095 · SAVED SEARCHES & FORMULAS
What NetSuite Field Corresponds to the ‘shippingamount’ SearchColumn?
This guide clarifies the direct relationship between a specific search column and its corresponding transaction field in NetSuite.
Short answer
In NetSuite, when utilizing the 'shippingamount' search column, the system retrieves the value from the 'shippingcost' field associated with the record. This direct correspondence ensures accurate reporting of shipping expenses in search results, linking the search column to the specific transaction field.
Scenario
Users often encounter situations where they need to retrieve shipping cost data through NetSuite searches but are unsure which search column accurately reflects the 'shippingcost' field. This uncertainty can lead to incorrect data extraction or confusion when building custom reports and saved searches.
Solution
When performing a search in NetSuite and including the column 'shippingamount', the system will return the value from the field 'shippingcost' for the specified record. Therefore, to access the shipping cost of a record via a search, the correct column to use is 'shippingamount', which directly corresponds to the 'shippingcost' field.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support