All,
Has anyone worked with the new Tessitura Analytics Finance Cube enough to know how payments on invoices might be handled?
That is when a customer actually pays off an invoice is there a way to find their payments?
It's been the one thing our finance manager cannot figure out. She sees no difference between an unpaid and paid invoice.
After a bunch of investigation, it appears to me that at least in Analytics V 15.0.4 that some??/all?? ZeroAdjust transactions are being dropped from the Finance eCube. Intentionally / unintentionally I don't know. It is some of these ZeroAdjust transactions that actually have the payments, and because I can't surface these transactions in the finance eCube. We are having the same problems. Which has confused my Finance person as well.
I do have an open support ticket on this issue. Have not at this moment heard anything in particular. (I'm a bit behind in my email today so maybe have no yet gotten to that email.)
Hi Tom,
I've just started working with the Finance Cube.
I did notice that by default it includes both sides of the transaction, so a lot of reports end up with totals of zero.
I have been using a Filter of GL Entry Type = Payment Method, for any widgets that look at payments and this has worked well.
However, I've been using this for Pledge Payments, so not sure it will be of any help on the invoices issue you have.
cheers, Dara
I think pledge payments might be different.
Tom,
I have found a similar issue when trying to create a Dashboard which shows money still On Account. It seemed like payments were zeroed out instead of showing the credit and debit as one would expect. I was unable to figure out a formula to show where there is money left on Account. Or it is possible I don't know what I am doing.
Terry Stevens do you have a support ticket in on this as well?
Terry Stevens, did you ever find an answer to this? I'm able to find how much money was put On Account, but I can't seem to get the amount that's been used... Let me know if you discovered anything!
I think i figured that out when I was looking at Refunds. If you use "Debit Amount" in the finance cube, that seems to be what the constituent has used. Credit amount is what's available for them to use. For the example below, this constituent had two shows cancel and put on their account and then used both of those amounts for next year's subscription. I'm still working out the logic to get it to be all in one line item though so we know how much is on one constituents account
Lily, not sure if this is what you need, but I realized that when you take money from On Account and refund it back to a credit card it happens within a single a "Zero Transaction" transaction. I have a widget that is filtered by my On Account payment method and Zero Transaction transaction type.
To show On Account money that has been used towards a future performance, I have a widget that is filtered by On Account payment method and Ticket Purchase transaction type.
We are on v15.1.7... I know there are some difference in the Finance cube between v15 versions.
Sheela, would you be willing to share that dashboard??