Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHi,
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:
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)
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:
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.
I have published it in the Developer Community, but there is not reaction there.
One week has passed and no answer on the developer forum.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here