Too many documents to run Account Balances by Month

We are having difficulty viewing the “Account Balance by Month” (P0902p1) report for our inventory related accounts.  This is due to the large number of work order related documents that are posting in detail to the G/L.  We would like to figure out a way to keep the G/L detail (as we use it in researching work order activity) but still be able to bring up the balances report.  So far, I can only find information on summarizing work order postings which we don’t want.  Is there a way to do keep the detail but still get the monthly balances?