some of the data here doesnt match up, but that;s logged seperately. The main suggestion here is that i can find the max avilable in the report builder, but we should show the max avialable wherever we show the qty available and next due data :
https://www.useloom.com/share/a0ca0d1bb14d4f0582e403308505bb9b