Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Aigars Lapins
Level 1

Apply Bank Deposit to and Invoice using API

Hi,

 

I am integrating an external system with Quickbooks Online, and I am struggling to make Quickbooks apply a deposit to an invoice through API. I followed this documentation article:

https://quickbooks.intuit.com/learn-support/en-uk/help-article/service-items/record-customer-prepaym...

I can do the application through the Quickbooks Online user interface using those instructions. The application is basically a 0 amount payment that has the invoice selected in the Outstanding Transactions and the Deposit in the Credit section. To see how this transaction looks I used Get Payment API call and I get this example:

{
  "Payment": {
    "CustomerRef": {
      "value": "69"
    },
  "TotalAmt": 0,
  "TxnDate": "2023-12-21",
  "CurrencyRef": {
    "value": "GBP",
    "name": "British Pound Sterling"
  },
  "Line": [
    {
      "Amount": 72.00,
      "LinkedTxn": [
        {
          "TxnId": "249",
          "TxnType": "Invoice"
        }
      ]
    },
    {
      "Amount": 72.00,
      "LinkedTxn": [
        {
          "TxnId": "248",
          "TxnType": "Deposit"
        }
      ]
    }
  ]
  }
}

 

When I try and send a similar Payment through the API I get this error: "A business validation error has occurred while processing your request - Business Validation Error: The Amount Received (plus credits) can't be less than the selected charges. Also, the selected charges can't be less than the selected credits."

By poking around, I discovered that the API is ignoring the TxnType=Deposit Line and when I checked the Payments documentation I didn't see Deposit as a valid TxnType option there. So technically, I understand that it could ignore the Deposit application line.

The question then is - how can I do the application between Deposit and Invoice through the API?

If there is no way, then my suggestion would be to make the API handle the same scenario as the documentation suggests and as the user interface can handle - process the Deposit transaction type in the Lines of the Payment.

 

This deposit application setback is the last thing for me to launch the integration so hoping for a quick response.

 

Aigars Lapins

Garage Hive

 

PS: Some text because of error: Post flooding detected (community received posts of a unique message more than 1 times within 3,600 seconds)

3 Comments 3
RCV
QuickBooks Team
QuickBooks Team

Apply Bank Deposit to and Invoice using API

I appreciate you reaching out to the Community. I can share information using API in QuickBooks Online (QBO).

 

I recommend that you sign up and post this question to our separate online forum called Intuit Developer Community. One of the experts handling the Application Program Interface (API) will reach out and further assist you. Then, they'll assist you with applying a deposit to an invoice through API. This is where developers engage with others to discuss programming concerns. Here's how to post your concern:

 

  1. Go to this link: https://help.developer.intuit.com/s/.
  2. Choose QuickBooks Online under What do you need help with?.
  3. Tick Ask a Question.
  4. Log into your existing Intuit Developer Account or create a new one.
  5. Enter your concern.
  6. Click Ask.

 

For more information about managing bank transactions in QBO, consider checking out this article: Categorize and match online bank transactions in QuickBooks Online.

 

Lastly, you may click this article to see information about reconciling your accounts so they always match your bank and credit card statements for future reference: Reconcile an account in QuickBooks Online .

 

I'd like to know how you get on after posting your question in the Intuit Developers forum, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

Aigars Lapins
Level 1

Apply Bank Deposit to and Invoice using API

I have published it in the Developer Community, but there is not reaction there.

Aigars Lapins
Level 1

Apply Bank Deposit to and Invoice using API

One week has passed and no answer on the developer forum.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us