Scenario
User wants to get the Sales Price of an Item in a Saved Search. The needed information is found in the Item Record > Sales/Pricing tab > Pricing sublist:
Upon checking the Item Record's System Notes, it is noted that changes made to the Base Price reflects in the Sales Price (Rate) field.
However, in the Results tab of an Item Saved Search, there is no Sales Price (Rate) field is not available to be selected.
Solution
In an Item Saved Search, you can get the information by using the Base Price field.
- the Base Price label showing on the UI is dependent on the name assigned to the Price Level. You may check this via Setup > Accounting > Accounting Lists > Price Level.
Using the System Notes joining fields, you can get it by using the Rate field.
- The reason for this is that the Label of Rate on the Inventory Part Form is defaulted to 'Sales Price (Rate)'.
- This is the default in the system's form but you can still edit the label to show the desired value.
How to Edit the Label shown on the System Notes
- On the Item Record (Edit mode), click on Customize > Customize Form
- On the Custom Entry form, click on Fields tab > Sales/Pricing sub tab
- Look for the Description: Rate. Notice that the Label is showing as Sales Price (Rate).
NOTE: Make sure that editing the label will not affect any script or search that is configured to pull up the exact label (Sales Price (Rate)) from the system notes.
>> As per testing, if you edit this value, the System Notes will show/reflect this updated value in all the lines (even those previously entered updates for Base Price).
-----
If you find this information useful, let us know by reacting or commenting on this post!
Related Discussion: