I'm trying to create a saved search that would do the following:
[LIST]
[*]Show me all checks created in a given month
[*]Show the bill/bill credits that the check is paying (basically the remittance detail)
[*]Show the class and account related to the expense line on those bill/bill credits
[/LIST]
The first two parts of this are easy. It's the last part that I can't figure out a way to do it in one search. When I pull the "Applied to.." fields, it looks like it's only pulling the main line info. So because of that, I can't find out which division, class, or account the bill/bill credit posted to.
I thought about perhaps going at it the other way (rather than filtering by bill payments, filter by bills/bill credits that are not open) and then pulling in the check number associated with it, but since the applying transaction could be a credit instead of the payment itself, I can't get that to work.
The only option that should work is to make two separate searches: one which pulls all transactions that are closed, and another which pulls the remittance info of each payment. Then I could combine those. This would still be...difficult though, since I'd have to pull a huge amount of transaction data (particularly since main line would be false), which given our data could potentially be 100,000+ rows.
Thanks.