In RRI, I would like the following functionality.
In stock report I select/filter the stock that has expiration date older then 3 months. Then I put batch characteristic in rows to see the batches that follow upper criteria . I have a RRI set to sales report, to see if any of those batches were sold and in what quantity.
What I would like, is, that when I invoke RRI to sales, that it 'grabs' the listed batches in stock report and use them as filter in sales reports?
How to achive this?