Improving the data transfer process between Tessitura & Sage

I’ve seen posts over a year old on the same topic, so I thought I’d start a new one in case others have been successful in improving the data transfer process between the two systems (I hope so!)

Why: All our data from Tessitura is either manually entered directly into Sage MAS 500 or into Sage Data Porter (and then uploaded in Sage). We definitely want to minimize as much data entry as possible, and instead have resources focused on reviewing data before it is posted to the financial accounting system.

We’re currently in discovery and wanted to understand what the realm of the possible has been to date for others:

  • Have you been able to partially or fully automate any process (one or more) between Tessitura to Sage MAS 500 (or a Sage product)?
    • If yes, what does the solution look like? Where did you gain efficiencies?
    • If no, what have been the barriers that have prevented you from implementing a solution?

Any feedback, documentation or thoughts is welcome!

Cheers,

Sapna



[edited by: Sapna Patel at 6:02 PM (GMT -6) on 29 Jan 2013]
Parents
  • I use Sage 100 Fund Accounting (MIP), and though I don’t import my Tessitura data (we do it manually on a monthly basis), I do import other things.  If you can get your Tess data into Excel/csv format, you might be able to with your software too.

     

    LESLIE FILLINGHAM | Finance Director | Milwaukee Repertory Theater
    Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202
    414.224.1761 tel | 414.224.9097 fax | Email:  lfillingham@milwaukeerep.com 
    Website: www.milwaukeerep.com

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Sapna Patel
    Sent: Tuesday, January 29, 2013 7:46 PM
    To: Leslie Fillingham
    Subject: [Tessitura Finance Forum] Improving the data transfer process between Tessitura & Sage

     

    I’ve seen posts over a year old on the same topic, so I thought I’d start a new one in case others have been successful in improving the data transfer process between the two systems (I hope so!)

    Why: All our data from Tessitura is either manually entered directly into Sage MAS 500 or into Sage Data Porter (and then uploaded in Sage). We definitely want to minimize as much data entry as possible, and instead have resources focused on reviewing data before it is posted to the financial accounting system.

    We’re currently in discovery and wanted to understand what the realm of the possible has been to date for others:

    • Have you been able to partially or fully automate any process (one or more) between Tessitura to Sage MAS 500 (or a Sage product)?
      • If yes, what does the solution look like? Where did you gain efficiencies?
      • If no, what have been the barriers that have prevented you from implementing a solution?

    Any feedback, documentation or thoughts is welcome!

    Cheers,

    Sapna




    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!

  • Thanks Leslie. That is definitely one of the options we are exploring. We're trying to see if we can get a Tessitura data to  match the format used by the Data Porter (a Sage MAS 500 module that mass imports data).

    Thanks,

    Sapna

     

    Sapna Patel

    Business Process Improvement Manager

    San Francisco Opera

    301 Van Ness Avenue

    San Francisco, CA 94102

    415-551-6335

    spatel@sfopera.com

  • Were you successful? We are looking at this process currently so any insights you gained would be greatly appreciated.

Reply Children
No Data