Suggestion: Inventory reports are available in SCM->Inventory->Inventory register,
In Stock Ledger report, after selecting date range,, we can select the location code from and to as Aprv location. Later on, users can select the location code from and to as Nexp location for a separate report. If the user is selecting Available “Y” then it will show all available stock including “NEXP” stock also.