Good morning:
I wonder if anyone has come up with how to build a A/P query that will provide not just account distributions, but project distributions further splitting charges to accounts. See below example, if you debit your expense account on an invoice and the charge itself is split between multiple project codes, how do I build a query that will return all of those distributions?
Example in A/P)
$100 invoice
100$ debited to telephone expenses
>>$50 to Project 1 << Query target these charges
>>$50 to Project 2 << Query target these charges
Unfortunately, my experimentation has only let me use a query to return the account distributions, but not the individual project charges that further distribute the account charges.
As this feature is available and used in multiple sections of Blackbaud, if anyone has figured out how to properly do this I would be interested in learning how.
