We are having trouble reconciling our Element Report to individual transactions in Tessitura and providing adequate back-up to prove this reconciliation. Ultimately, we want one report that aligns exactly with the Element report totals, which have been matching our bank deposits, but that also match Tessitura reports without manipulation. The Transactions by Posting has been the most useful Tessitura report so far, but it doesn't have the actual processing date, especially problematic for credit cards which we’re finding are posted on one day, but actually were charged on another. We also need to show the appropriate G/L codes as part of this reconciliation and gift (contribution) review. I'm looking for some financial perspective as the accountant handling this reconciliation, so if any accountants regularly handle posting from Tessitura to the G/L and reconciliation to the bank deposit and would share their experience, it would be much appreciated.
Ok. Thanks Jon. I’ll let you know. Deploying the reports now.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Jon Ballinger Sent: Monday, October 12, 2015 1:50 PM To: Gloria Ormsby Subject: Re: [Tessitura Finance Forum] Element Reconciliation
Hi Gloria,
If you run :
[UP_POPULATE_REFERENCE_METADATA] 'tr_eps_ssis_config' The table should get added to the system tables. The value to replace DBUSERPASSWORD is in the EpsConfig.dtsConfig file at line 19.
Let me know how you make out.
Jon
From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> Sent: 10/12/2015 10:02:00 AM
Jon,
I am following the installation directions for the EPS Data Tools and I'm at a point where I should see TR_EPS_SSIS_CONFIGURATION in system tables but it isn't there. I re-ran the install script which I see grants permissions to the table. The table appears in SSMS. I have run UP_POPULATE_REFERENCE_METADATA but still don't see it. Is it supposed to appear there or do I enter merchant data in the SQL table through SSMS? Also when I configured the SSIS package the DBUSERPASSWORD in not in the config file. Can you help?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!