Angela Ebensteiner (Technical Lead, Microsoft Dynamics) share a fix on Microsoft Dynamics GP Support blog for the performance issue with Received Not Invoiced report in Purchase Order Processing (POP).
To brief you here on why this performance issue occur, it’s because of huge pile of PO records staying on POP open tables, even after they are closed. When you run the report, it goes through each and every record on POP open table, due to which you got to wait for some time till query processing finishes.
Fix is to remove completed POs from open tables to history, which we have a standard utility available in GP.
VAIDY
Pingback: Performance Issue with Received/Not Invoiced Report in POP | Interesting Findings & Knowledge Sharing