Skip to main content
Answer

Unable to update invoice date in QuickBooks Online despite successful previous steps

  • July 1, 2024
  • 9 replies
  • 94 views

Hi - I cannot seem to get the “update invoice” to work properly in my Zap.  All previous steps are successful, including the “find invoice” step just before it.  I’m only trying to update the invoice date, however, I actually cannot get any update to push through.  I am identifying the invoice by using the ID from the previous step, and the date formatting is as shown.  What am I missing?

 

Best answer by Troy Tessalone

@amberACS 

In order to update the invoice, the existing data points that are required by the API docs need to be populated again on the Zap step for QBO Update Invoice.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 1, 2024

Hi @amberACS 

For us to have more context about the error, post screenshots with how your Zap step is configured in EDIT mode for the ‘Action’ tab section.

 


  • Author
  • Beginner
  • July 1, 2024

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 1, 2024

@amberACS 

From the screenshots, these are the only 2 fields that appear to be set, but nothing related to a date field.

See required fields for a sparse update to an invoice per the QBO API docs: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#sparse-update-an-invoice

 

 

 

 


  • Author
  • Beginner
  • July 1, 2024

Let’s try that again!  Here are the date fields I am trying to update.

Earlier had removed these and ONLY put “test” in the “message on invoice” field and even that would not push through, just in case it was something with my dates.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 1, 2024

@amberACS 

Dates look fine.

I think other fields expect values to be populated when updating a QBO invoice.

 

See required fields for a sparse update to an invoice per the QBO API docs: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#sparse-update-an-invoice

 

 


  • Author
  • Beginner
  • July 1, 2024

These fields listed in Business Rules are all populated on my invoice.   The QBO API is hard for me to understand, i’m not a programmer.  I just want to update the INVOICE DATE.  I don’t actually see that listed.  I tried to just update the DUE DATE and that doesn’t work either. 

I see this

 

So I fed through this and still get the same error

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • July 1, 2024

@amberACS 

In order to update the invoice, the existing data points that are required by the API docs need to be populated again on the Zap step for QBO Update Invoice.


  • Author
  • Beginner
  • July 2, 2024

That was it!  I finally got it working.  Thank you


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • July 3, 2024

That’s awesome @amberACS! A huge thanks to Troy for lending a hand and pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗