POM/P2GL: Summarize Filtered Rows
POM/P2GL can summarize transactions, creating a GL import file that contains 1 bank line and X revenue lines. This functionality is applied at the configuration level - and, therefore, impacts the entire file output.
We don't currently have a way of identifying selected transactions (e.g. Adj/Rev) where we do not want these summary transactions to be applied.
I'd like to see the ability to apply filters to the summary criteria to help drive when the summary should be applied.
JPP
shared this idea
Hi JP,
Thank you for submitting the idea. I wanted to make you aware that Post to GL currently supports this use case and summarization can be configured to summarize some transactions and not others. The only requirement is having the information available in the source data to be able to configure the scenarios needed.
I know I have seen clients have formulas configured with the following scenarios:
1. Summarize non-adjustments but not adjustment transactions
2. Summarize debit transactions but not credit transactions
3. Summarize specific account numbers but not other account numbers
4. Summarize transactions for specific funds but not other funds
There are definitely others that could be considered.