Finance: General Ledger Report on 9.05.702A Prog

This report take quite some time to run, has anyone re-written this report or created a dashboard? There is an old posting in Yahoo, but doesnt state any solutions.

Like the Yahoo post, they want the PONum and VendorID. They want the report so that the managers can see in detail what they are spending on. We use 3 segments, Natural-Div-Department.

Have you looked at the report’s data definition and your database indices to see if you could add an index to help? I haven’t rewritten the report but I know these tables are huge and it may be that nobody thought to optimize it.