Topic: Stock Check Sheet | Inventory Planning Reports has serious Bugs.
I am a small manufacturing firms has BoM loaded to all of its products. Where Inventory Planning Report are very critical in nature.
Company has over 6000 stock id and nearly 3000 Manufacturable stock ids. Whenever we tried to generate these two report, System gets hanged and Gatway Timeout is persisting.
Because Stock Check alone is executine over 3 Lakhs queries to bring the report to users. Sometime is very more as well.
Company has 4CPU System with 16GB RAM. But No use as of now.
Now Instruction to the company, "DON'T TOUCH INVENTORY REPORTS"!!!
Could please suggest us any solutions for this issue?