ANS-0033 · SAVED SEARCHES & FORMULAS
How to Display the Item Rate from Sales Order in NetSuite Item Fulfillment Saved Search
NetSuite users can retrieve the item rate from the originating sales order directly within an Item Fulfillment saved search using a simple formula.
Short answer
To display the item rate from the sales order in an Item Fulfillment saved search, add a custom Formula (Currency) field. Use the formula {appliedtotransaction.rate}. This formula directly pulls the rate of the item as it was recorded on the original sales order, ensuring accurate pricing information is available in your fulfillment reports.
Scenario
NetSuite users often require visibility into the specific item rate from the original sales order when analyzing item fulfillment records. Standard item fulfillment fields may not directly expose this information, making it challenging to report on the exact pricing applied at the time of sale.
Solution
To retrieve the item rate from the associated sales order within an Item Fulfillment saved search, users should add a new "Formula (Currency)" column. In the formula field, enter the following: {appliedtotransaction.rate}. This formula effectively links back to the original transaction (the sales order) and extracts the item's rate, providing the exact pricing information needed for reporting.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support