Here's a question from our Development team:
What are other people doing in the case when they have multiple invoice contacts at a company? For instance, suppose you have Company X and at some stage you do a sponsorship event for Department A of the company, which requires one invoice contact's name to appear on the invoice, but another time it's for Department B with a different company?
Do you create different constituent accounts for each department and turn it into a type of household where all the transactions can be seen together? Or do you put it all on the one constituent record, which creates the problem of having to change the main contact name every time you generate an invoice?
Or is there some other way that they haven't yet thought of?
Cheers,
Matt
We have a cascade of salutation types. We sometimes manually flip one to primary for a report run, and then back to “normal” after. John Trimble Data and Prospect ManagerDallas Symphony Orchestra Morton H. Meyerson Symphony CenterSchlegel Administrative Suites2301 Flora Street Dallas, Texas 75201 214-871-4041 - phone 214-981-2988 - faxj.trimble@DalSym.com www.dallassymphony.com From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Matthew Hodge Sent: Friday, May 23, 2014 1:20 AMTo: John TrimbleSubject: [Tessitura Development Forum] Multiple invoice contacts for one company Here's a question from our Development team:What are other people doing in the case when they have multiple invoice contacts at a company? For instance, suppose you have Company X and at some stage you do a sponsorship event for Department A of the company, which requires one invoice contact's name to appear on the invoice, but another time it's for Department B with a different company? Do you create different constituent accounts for each department and turn it into a type of household where all the transactions can be seen together? Or do you put it all on the one constituent record, which creates the problem of having to change the main contact name every time you generate an invoice? Or is there some other way that they haven't yet thought of? Cheers, Matt 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! --View this message online at http://www.tessituranetwork.com/Community/forums/p/11640/35946.aspx#35946 or reply to this message
We have a cascade of salutation types. We sometimes manually flip one to primary for a report run, and then back to “normal” after.
John Trimble Data and Prospect ManagerDallas Symphony Orchestra Morton H. Meyerson Symphony CenterSchlegel Administrative Suites2301 Flora Street Dallas, Texas 75201 214-871-4041 - phone 214-981-2988 - faxj.trimble@DalSym.com www.dallassymphony.com
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Matthew Hodge Sent: Friday, May 23, 2014 1:20 AMTo: John TrimbleSubject: [Tessitura Development Forum] Multiple invoice contacts for one company
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!
Hey Matthew,
Late reply but we solved this with something a little different (version 11 obviously because version 12 solves this problem)
We created a view:
SELECT aff.affiliation_no,aff.individual_customer_no,ltrim((isnull(pre.description,'')+' ')+isnull(cus.fname,'')+' ')+isnull(cus.lname,'') full_name,aff.group_customer_no,aff.affiliation_type_idFROMVB_CUSTOMER cusJOIN TR_PREFIX pre on cus.prefix = pre.idJOIN T_AFFILIATION aff on cus.customer_no = aff.individual_customer_noWHERE aff.affiliation_type_id in (10007,10012)
----------------------
Then we created a custom field in T_KEYWORD that links up to this.And we joined a row in our acknowledgement report that does someting like this in order to show the customers name on the invoice.
"join LV_AFFILIATE_DROPDOWN asn on asn.individual_customer_no=cast(ord.custom_5 as int)"