Orphaned transactions in SF

[Tami]

We have 2 transactions that came through to Salesforce with Temporary Contacts. We kept getting this error message "SObject row was retrieved via SOQL without querying the requested field: CnP_PaaS__CnP_Transaction__c.Reconciled__c". The donation is created but I can't access whatever corresponding transaction was created and seems to be hiding somewhere. I have deleted one of the Temporary Contacts, all accounts and contacts (we use 1:1 model), donations and emptied the recycle bin. When I tried to use the C&P Importer it says I already have that transaction. Please advice. I've granted you login access. Thank you.

Org # 00Di0000000gbtx

Order #1412111608142910205 on 12/11/2014 with Transaction ID 3069236 - the temporary contact for this one has been deleted
AND
Order # 1412141559088147479 on 12/14/2014 - the temporary contact for this one still exists

[CnP.Support]

Good day Tami,

Have you grant us access to your account?

If not please grant access so we can review your account.

How to grant access: http://forums.clickandpledge.com/showthread.php?t=1065
Please make sure to post your organization name & the Salesforce Organization ID so we know how to locate your instance.

[Tami]

Yes I have.

[Tami]

Org name is International Leadership Institute

[CnP.Support]

Good day!

In the current release the queries are static and as such additions to the Transaction table will generate error.

In release 9.x we are changing the queries to dynamic so additional fields added by clients won't generate the error.

For now you can't add custom fields to C&P objects.

I hope that answers your question. Please let us know if we can be of any further assistance.

[Tami]

So what do I do about attaching the donation to the transaction so our accounting reports will reflect the fees that donation generated. Or for that matter show the transaction in SF at all? I'm not adding a custom field to a C&P object. I just want to attach the donation the temporary contact generates to the correct transaction ID.