Hi,
Here is our client requirement.
We have shelf life controlled item with batch tracking.
On hand list, we would like to visualize as a dimension to show manufacturing n expiry date of the product so that the team can send that product to the customer.
Business dont want to see in duplicate tabs with batches screen in one form and on hand list in 1 form. Is there any easy way to join these two tables through advanced filter so that it can be visualized under 1 screen.
Thanks.