Slow Query Question (Allocation/Ledger Query)
Hi all,
I am looking to do some reporting on the allocations we run every month. Our allocation setup uses project ID, and account in the pool, both set up on the allocation using a tree node. For example, the project tree node might contain several project IDs, and the account tree node contains a range of accounts. The allocation uses these chartfields in the pool, summarizes the ledger activity and creates a JE. My reporting task is to summarize the journal lines by project ID.
Here's the first issue. The lines on the allocation JE do not include the project ID from the pool. Basically, I need to build a query that shows what the result would be if the pool project ID were used in the allocation JE. I've done this, but the query is slow.