Does anyone have any good tips for how to handle invoice reconciliation? Our main concern at the moment is that many invoices can be used to pay for products going to multiple GL accounts. The T_TRANSACTION table can easily breakdown the different GL accounts, but my concerns is when we actually receive payment from the customer. From what I can tell the payment is recorded as a zero adjustment transaction, and I have not found a way to link the invoice payment back to the original invoice GLs in order to tell our finance office what accounts the payment needs to be attributed to. And if there is a way to do that, how would you go about handling a partial invoice payment, or an invoice payment applied to multiple invoices.
At the moment, when we report transaction data to the finance office, we apply all invoice shortages to our main ticket GL and offset the differences in our Credit Card totals. Then we apply the payments from the zero adjustment transaction to the same GL account. However, manipulating transaction data like that has gotten us into trouble more often than I'd like, so we'd like to start reporting transaction data from Tessitura explicitly as it is in Tessitura. We just don't know what to do with zero adjustment transactions like this.
Jesse,
If you are wanting to tie each line in T_TRANSACTION back to each specific line item... I wish you luck. I have worked at the and am under the impression that it cannot be done. Returns and Exchanges cause a huge issue with that.
John
I don't necessarily want to tie it back to the actual order lineitems but I want to tie the Zero Adjustment transaction back to the original Ticket Purchase or Fee Payment transactions associated to when the invoice was originally created. From there I can obtain a GL but linking the fee_no or pmap_no back to their reference tables. And even if I can do that there is still the issue of partial payments, and how to determine how much of each payment is to be applied to which GL, and how to track it.
Hey man,
Have you tried looking in bi.VT_TRANSACTION_AND_PAYMENTPrice types and Performances in the Order that are paid by Payment Method Invoice are listed in there. That's about as close as it gets. Once you create that invoice bucket how you pay that off later is a bit of a bun fight.