Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Credit card payments with non-QuickBooks merchant accountSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 Credit card payments with non-QuickBooks merchant account 
 Author   Message 
  QBUser1000 
  
 Group: Members 
 Posts: 9 
 Joined: 2009-01-30 
 Profile
 Posted : 2009-02-06 14:18:28
In the SalesReceipt table I noticed these fields: CreditCardTxnInfoResultReconBatchID, CreditCardTxnInfoResultPaymentGroupingCode

We run our own charges via our web site, and it would not help to switch to a QuickBooks merchant account because the processing is done BEFORE the transactions go into QB.

My question is: can we bypass the rule requiring a QuickBooks merchant account by making careful use of the CreditCard fields?  Is there any documentation on that?  In particular, I want to be able to group several credit card payments into a single batch deposit.

Same question, rephrased: how confident are you that nothing bad will happen if I put my own data into those fields so that I can query against them to find the payments to group into a single deposit?

Thank you very much.

Ann
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-02-06 16:22:27
See: XML error applying Credit Card payment  

  Top 
  QBUser1000 
  
 Group: Members 
 Posts: 9 
 Joined: 2009-01-30 
 Profile
 Posted : 2009-02-06 17:11:54
Ok, plan B. In QuickBooks Pro 2008 (USA), when you select Banking > Make Deposits, it shows a screen which QODBC references as ReceivePaymentToDeposit.

However, in QB, there is a column which shows the Payment Method. That field would enable me to do the grouping, without using any of the CreditCard fields.  The issue is that AmEx payments are processed separately from Visa/MC, so they need to be batched separately for any given 24 hour period.

I looked at all the outbound relations to try to figure out how to link back to SalesReceipt but am not sure yet.... Hint appreciated if you have time.

Or is it better to use the other approach ( mentioned in your post about Undeposited SalesReceipts that have not been deposited to a Bank Account? )

Ann

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-02-06 18:06:18

See: How do I write Deposits using QODBC? 

I personally don't like the sales receipt approach. I lean to raising the invoices only and then when the credit card batch is deposited into the bank account, then pay the invoices concerned instead.

See also: How do I create a new Customer, invoice them and mark the invoice as paid? 

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to