In the standard reservation form, we have to first locate the summary line - Say 'Item ledger entries' and click on the 'Lot Qty' to see lot wise inventory details.
We would like to build a form where on the top grid it show the summary line and clicking one of the summary lines, it shows the lot wise inventory on the bottom grid.
This will minimize the number of clicks for our customers and at the same time provide all the necessary details to take informed reservation decision.
Our technical team finding it difficult to implement especially because this requires the data retrieval from the multiple tables and to be displayed on the same form.
Any pointer or suggestion how this can be achieved?