Report to display the "gift" date

We are currently implementing Tessitura with full Go-Live in 2013 and we began inputting Contributions into the Live system on July 10, 2012.

Our Development manager is attempting to generate month-end reports for our Finance manager.
We cannot determine how to generate reports that contain specific data.

Description of our problem:
A local corporation pledged $100,000 to our organization in July, 2011.
The corporation submitted a payment toward this pledge of $10,000, and this payment was dated July 31, 2012.
We received the payment later, and we inputted the $10,000 payment on Sept 7, 2012.

Our Finance manager needs to show the contribution occurred in July, 2012 rather than Sept. 2012.
In our attempts to generate reports for our Finance group, we can display the original pledge date (July 2011) and we can display the transaction inputted on Sept. 7, 2012.
However, we cannot generate a report that indicates the $10,000 was "received" on July 31,2012.

Is there a report (either through List Manager or Extractions) that will show:
            the date of the original transaction (July 2011)
            the date of the inputted transaction (Sept 7, 2012)
            the date the “gift” was made (July 31, 2012)

I created some SQL and I can “see” the original transaction date of July 2011, and the transaction inputted Sept. 7.
However, I cannot see the Sept 7 transaction referencing a date of July 31, 2012.

We are very new to Tessitura and we realize the answer may be obvious.

Thanks          Wendell Baskin
Bass Hall (Performing Arts Fort Worth)
wbaskin@basshall.com

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

We are currently implementing Tessitura with full Go-Live in 2013 and we began inputting Contributions into the Live system on July 10, 2012.

Our Development manager is attempting to generate month-end reports for our Finance manager.
We cannot determine how to generate reports that contain specific data.

Description of our problem:
A local corporation pledged $100,000 to our organization in July, 2011.
The corporation submitted a payment toward this pledge of $10,000, and this payment was dated July 31, 2012.
We received the payment later, and we inputted the $10,000 payment on Sept 7, 2012.

Our Finance manager needs to show the contribution occurred in July, 2012 rather than Sept. 2012.
In our attempts to generate reports for our Finance group, we can display the original pledge date (July 2011) and we can display the transaction inputted on Sept. 7, 2012.
However, we cannot generate a report that indicates the $10,000 was "received" on July 31,2012.

Is there a report (either through List Manager or Extractions) that will show:
            the date of the original transaction (July 2011)
            the date of the inputted transaction (Sept 7, 2012)
            the date the “gift” was made (July 31, 2012)

I created some SQL and I can “see” the original transaction date of July 2011, and the transaction inputted Sept. 7.
However, I cannot see the Sept 7 transaction referencing a date of July 31, 2012.

We are very new to Tessitura and we realize the answer may be obvious.

Thanks          Wendell Baskin
Bass Hall (Performing Arts Fort Worth)
wbaskin@basshall.com

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!