I'm running Pledge Billing ones a month. After that I run the Pledge Billing Summary and I found some of them has "No Account Number Available" but when I check the Constituents Account everything is fine Credit Card number, Expiration date, etc Could somebody has any idea? Thank you Adrian
Adrian
Did you receive any answers to this question?
Margaret
Adrian,
We have had that problem a couple of times. We discovered that Tessitura is inexplicably assigning a business unit of 0 to some of the contributions although we only have one business unit = 1.
We worked with technical support and weren't able to identify the cause.
Our DBA went through the contribution records and changed all business units to 1 which resolved the problem.
Susan
Do you know where they had to replace the Business unit?
I would make sure that all Batch Types in TR_BATCH_TYPE, Funds, and Payment Methods have a business unit defined.
If you cannot find the reason, please open a support ticket and we’d be glad to help you.
______________________________________
Ryan Creps
Network Developer |Tessitura Network, Inc
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Susan Zukov Sent: Wednesday, June 17, 2009 2:24 PM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] Pledge Billing report
From: Adrian Karmel <bounce-adriankarmel8286@tessituranetwork.com> Sent: 5/29/2009 8:03:46 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.76/2183 - Release Date: 06/17/09 05:53:00
I believe it is t_contribution.
Ryan
We were missing Business Unit for the Auto Billing Batch type. Everything else had business units defined.
Thanks
Adrian Did you receive any answers to this question? Margaret From: Adrian Karmel <bounce-adriankarmel8286@tessituranetwork.com> Sent: 5/29/2009 8:03:46 AM I'm running Pledge Billing ones a month. After that I run the Pledge Billing Summary and I found some of them has "No Account Number Available" but when I check the Constituents Account everything is fine Credit Card number, Expiration date, etc Could somebody has any idea? Thank you Adrian -- View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/477/2099.aspx#2099 Adrian Karmel Application Administrator IT Harbourfront Centre 235 Queens Quay West Toronto, ON, Canada M5J 2G8 Office: (416) 973-5095 akarmel@harbourfrontcentre.com www.harbourfrontcentre.com heart of toronto's waterfront Harbourfront Centre A 10-acre public trust powered by the creative cultures of Canada and the world.
We had the same issue only we were selecting the wrong Payment Method. To our issue we created seperate payment method - credit card entries. Here is the troubleshooting list support gave us which uncovered our issue. This will be helpful for those searching for answers
Troubleshooting steps to resolve "No Account Number Available"....
1) In the TR_BILLING_TYPE table, ensure that the entry for the billingtype that you are using for the pledge auto billing run has the 'AutoBilling Ind' column set to "Auto CC Billing". 2) In Campaigns/References/Payment Method, check to ensure that there isone set of your credit card types with the 'Default for Billing' boxchecked for each of your payment method groups. If you have multiplepayment method groups, you would have one of each of your credit cardtypes for each payment method group set up as 'Default for Billing'.These are the payment methods that will be used for auto billing. If youhave more than one credit card type defined for any payment method,select only one of these types for 'Default for Billing'. For example,if you have 4 payment method groups and you take Visa and Amex, youwould have one Visa payment method and one Amex payment method set up asdefault for billing for each payment method group. 3) Ensure that the Business Unit and Payment Method Group selected onthe Parameters screen have associated credit cards set up as "Defaultfor Billing' in Campaigns/References/Payment Method. 4) For an example of an account that was not billed, please look at thecredit card number in the T_CONTRIBUTION row, and the associated row inT_ACCOUNT for this credit card to ensure that they are both encrypted(or that they are both un-encrypted).