In replenishment page when i am doing a filter by supplier name then some product is not coming in the list which purchase price has defined twice for the same supplier. Like one supplier selling one product in two different price here supplier and product is same but the price is different. Then those products are not coming in the replenishment list when filtering by supplier name. I am thinking it’s happening for the SQL. Any solution for this?
