i am looking for a way to control the item purchase prices within specific period, so i am using the end date field located in the purchase price list as a deadline for users to select these specific items in their purchase order.
i want to make more control over that, so in case the user is selecting an item that is not within the period that i have set in purchase price, i dont want any cost to be showing for that item as an indicator for the user to know that today he / she is not allowed to purchase this item, however, when the user choose the item in a date that is after the purchase price end it, the system keeps showing a cost for that item in purchase order and this cost is the last direct cost located in item card.
is there a way to prevent the system from doing that so the user can get ZERO cost in purchase order for any item selected out of purchase price list date range no matter what the costs showing in the item card? i am looking for a way to let the system read the prices only from purchase price list all the time and completely ignore the costs showing in the item card.
