Best answer

Quickbooks Integration Bug - Update Invoice (Allow ACH payments)

  • 8 March 2024
  • 3 replies
  • 32 views

I’ve been setting up a Zap to trigger when a new invoice is created. The reason this is necessary is because we are importing our invoices, and for whatever reason, Quickbooks does not pull the customer’s email in, or enable any payment methods when you import invoices (integration, CSV whatever, doesn’t matter).

I’ve got it all set up, and it looks like it should work. But I’ve identified a bug. I’m not sure if anyone has any ideas of how to get around this.

I know that I’ve got this set up properly, as I can get the email to update from testing this zap.

I first identify the invoice

 


Then I tell it to update the email from the find customer action I ran before this step

 


And in the same action I tell it to set “Accept Payment Via Bank Transfer” to “Yes” (True)

​​​​​​​

Theoretically, this would cause the Bank Transfer option to turn on and the customer email to be populated for the specified invoice, but when I test the zap, only the email populates. The Payment methods do not change at all.

I did some troubleshooting, and I learned a few things. If you have both Bank Transfer and Credit Card set to Yes, the Zap turns them both on. But if only one is turned to “Yes” then nothing related to the payment method changes. I also tried setting one to Yes and one to No to see if that would resolve it, but alas, nothing happened.

I noticed during the test of the Zap, the fields appear to read false, even though the preview states it will set it to True.

Here are some screenshots to further illustrate.

When both are set to Yes

 


The request looks like this (sorry for the artifacts, had to grab these quickly)


​​​​​​​The response looks like this

 


But if one is set to True, and one False (or nothing)

The request looks like this

 


And the response looks like this

​​​​​​​

 


My assumption here is that the reason this is happening is there is some sort of conditional logic on this part of the integration. It’s not allowing you to request one as true without the other being set to true.


Does anyone know if Zapier manages this integration? I submitted a support ticket, but the ticket may need to go to Quickbooks, and I have zero hope that they would understand or address this type of issue.​​​​​​​

icon

Best answer by ken.a 8 March 2024, 10:38

View original

3 replies

Userlevel 7
Badge +6

Hi there @Kushal,

I did some digging into this, and it seems like this issue is a known bug with the QuickBooks Online app when using the “Create Invoice” and “Update Invoice” action where the boolean values for "Accept Payment Via Bank Transfer" (ACH) and "Accept Payment Via Credit Card" is not respected.

Our team is aware of the issue and is working on a fix. I've added your email address as another affected user. That does a few things:

  • Bring this to the attention of the integration developers
  • Help track and prioritize fixes
  • Allows us to notify you via email if/when this is fixed

Unfortunately, I do not have an ETA, but I’ve added you to the list of users affected by this issue so we can let you know as soon as we have any updates.

I appreciate your patience and understanding.

Hi @ken.a , thanks for your response. Please be advised that this is for the “Update Invoice” action. It may be happening on create invoice as well, but I wanted to make sure the full scope of the issue is understood.

Userlevel 7
Badge +6

Hi @Kushal,

I’m so sorry for the confusion on my part. This issue is also happening with the “Update Invoice” action. I have edited and included the “Update Action” in my previous response.

Reply