Fetch the item unit price under the item pricing subtab in the customer record even if the items have different primary sale unit

To fetch the unit price of the items in the customer record under the item pricing subtab, we can use a saved search. But if the unit of measure is different the saved search will fetch the unit price based on the base unit. So if the item’s primary sales unit is different than the base unit it will be incorrect.

Solution

Create a Dataset/workbook based on customer records. From that workbook select the item unit price under the price level subtab. It will show the correct unit price under the item pricing in the customer record.

Leave a comment

Your email address will not be published. Required fields are marked *