See steps below to display the Item Rate / Unit Price based on the transaction unit of measure:
1. Navigate to Lists>Search>Saved Searches>New>Transaction.
2. Under the Criteria, users can add a specific Criteria for one or two Sales Order lines.
- Main Line=F
- Tax Line=F
- Shipping Line=F
Users can use Internal ID (Number) to add the Internal ID of one sample Sales Order to easily check results.
3. Under the Results tab, remove unnecessary fields here. The following should be added:
- Date
- Number
- Name
- Item
- Quantity-----------------------------------------------------------------------------------This Field is the translated value into base unit
- Item Rate----------------------------------------------------------------------------------This Field is the Base Unit Price
- Units---------------------------------------------------------------------------------------This Field is the unit of measure selected on the line
- Quantity in Transaction Units----------------------------------------------------------This Field is the Quantity that appears in the Sales Order
- Formula (Numeric) where Formula = ({rate}*{quantity})/{quantityuom}------This Formula will multiply Base Unit Price by the Base Unit Quantity and divide by Quantity in Transaction Units
4. Enter a Search Title and click on Save & Run.
Users can verify the results of the Saved Search and modify as required.
Note: Please use the Formula only for searches where the row shows the line items, otherwise, you might get an error for rows where denominator is 0.