Skip to main content
Question

Xero Sales Invoice date, one day behind

  • 21 May 2024
  • 6 replies
  • 25 views

Since moving to the new Xero intregration with zapier sales invoices are being posted one day behind. The date going into the Xero Sales invoice is correct but the output  is one day behind 

6 replies

ken.a
Userlevel 7
Badge +6

Hi @rpuser,

Before we dig deeper into this, could you please let me know if you’re experiencing this issue with the “due_date” or “date” field?

I'll be keeping an eye out for your response!

Michael Lucas
Userlevel 2
Badge

Hi @ken.a 

 

We are currently experiencing the same issue, and it relates to both the date and due_date fields when creating a Sales Invoice.

 

We are currently passing in both dates in the same format as Xero, and both dates when processed show as a day earlier - an example of data in and data out are attached.

 

This only looks to be an issue since updating to the last version of the Xero connector if you can advise.

 

 

ken.a
Userlevel 7
Badge +6

Hi @Michael Lucas,

Thanks for confirming.

I did some digging into this, and it seems like this was a bug. However, it looks like this bug has been fixed 2 days ago. Could you please confirm if you’re still running into this issue?

I'll be keeping an eye out for your response!

R

Hello

 

We resolved the issue using a formater to format the invoice date to UTC. This solve the issue for the invoice date but using the formater in the same way to format the invoice due date, the output in Xero is always the invoice date and not the due date passed to the formater

A
Userlevel 1

Hi, I’m having the same issue with my automation. Often I notice the invoice [created] date is one day earlier than it should be. It doesn’t happen for all invoices, I think it gets to a time in the day and switches to the correct date. The due date is always fine but it’s just the invoice [created] date. 

 

@rpuser can you elaborate on how you used the formatter to resolve it?

@ken.a do you have any further suggestions on how to resolve?

ken.a
Userlevel 7
Badge +6

Hi @Apollo,

Could you please attempt to modify the "Invoice Date" field and add a +1d at the end of the mapped data in that field? We have a help article on how to do this here: https://help.zapier.com/hc/en-us/articles/8496307860109-Adjust-date-and-time-values-in-Zaps.

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Reply


Terms & Conditions