Invoice import and date custom value error

Hey there,

I’m having an issue with importing invoices from a CSV file. I have two custom fields: “Apartment” and “Date of Service.” When exporting invoices, these both come out great. When importing; however, the “Apartment” custom field is imported correctly (as it’s a number), but the “Date of Service” custom field is not. Also, the “Balance” field becomes double the “Amount” field. Here’s what I’m seeing:

This is the view from the main invoice page:

You can see “Date of Service” has a value. But, when I click on the invoice itself, the value is gone.

If I then proceed to make changes and save the invoice, the “Date of Service” becomes null. Why is this error occurring? Is there any way to fix it?

Hi,

If it’s a custom date field the value would need to be in YYYY-MM-DD format.

1 Like