We assessed on-account fees at the beginning of the year for on-account credit that was 5 years or more on inactive accounts. What report do I run to see how much we assessed? We need to figure out how much to move over from one account to the other. Thanks!
Hi Amy,
I'm not sure I understand what you mean by "on-account fees" but I have a very simple SQL script to get details of the monies currently being held On Account which I'd be happy to share - feel free to email me directly martin.keen@nida.edu.au if you'd like it.
As for moving monies on account, I don't think there's an elegant way of doing it. When doing it here, we have a specific payment method (set up with the blessing of the Finance Team) which is largely ignored by Finance reporting. We open a specific batch type, open an order (without any product or fees) for constituent A (who has the On Account monies) and make a payment to this payment method, thereby removing the On Account Balance. We then create a new order for constituent B and make a payment using the payment method and then reversing it to the On Account payment method. The user has to ensure the batch results in a zero balance as the Finance team check assiduously!
Martin