Cause:
The actual stock is not transferring to a specific location by considering EXP date. Segregate near expiry process creating unconfirmed stock transfer. Many of the stock is in allocated state, They need to be deallocated so that near expiry transfer scheduler will transfer automatically. Also, The stock which is expired is also showing in NEXP.
Suggestion: User should execute segregate near expiry process manually for the stock which has to be transferred. Afterwards, users should confirm all the stock transfer transactions . Which will deallocate the stock automatically. Then users can process the reports for the stock.