Pledge Billing report

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 billing
type that you are using for the pledge auto billing run has the 'Auto
Billing Ind' column set to "Auto CC Billing".

2) In Campaigns/References/Payment Method, check to ensure that there
is
one set of your credit card types with the 'Default for Billing' box
checked for each of your payment method groups. If you have multiple
payment method groups, you would have one of each of your credit card
types for each payment method group set up as 'Default for Billing'.
These are the payment methods that will be used for auto billing. If you
have 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, you
would have one Visa payment method and one Amex payment method
set up as
default for billing for each payment method group.

3) Ensure that the Business Unit and Payment Method Group selected on
the Parameters screen have associated credit cards set up as "Default
for Billing' in Campaigns/References/Payment Method.

4) For an example of an account that was not billed, please look at the
credit card number in the T_CONTRIBUTION row, and the associated row in
T_ACCOUNT for this credit card to ensure that they are both encrypted
(or that they are both un-encrypted).

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 billing
type that you are using for the pledge auto billing run has the 'Auto
Billing Ind' column set to "Auto CC Billing".

2) In Campaigns/References/Payment Method, check to ensure that there
is
one set of your credit card types with the 'Default for Billing' box
checked for each of your payment method groups. If you have multiple
payment method groups, you would have one of each of your credit card
types for each payment method group set up as 'Default for Billing'.
These are the payment methods that will be used for auto billing. If you
have 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, you
would have one Visa payment method and one Amex payment method
set up as
default for billing for each payment method group.

3) Ensure that the Business Unit and Payment Method Group selected on
the Parameters screen have associated credit cards set up as "Default
for Billing' in Campaigns/References/Payment Method.

4) For an example of an account that was not billed, please look at the
credit card number in the T_CONTRIBUTION row, and the associated row in
T_ACCOUNT for this credit card to ensure that they are both encrypted
(or that they are both un-encrypted).