Happy Business Starts Here

Zuora Staff

Netsuite sync error: "Caused by: Unparseable date

Problem: 

 

Syncing Zuora Invoices to NetSuite encountered 1 document error(s)
First document failure: [Input ProfileLocation: Export/Invoice_PostedDate; DocumentLocation: /Export[0]/Invoice_PostedDate[0]]: Error Parsing Date '2016-08-26', Expected Format yyyy-MM-dd'T'HH:mm:ssZ: Unparseable date: "2016-08-26"; Caused by: Error Parsing Date '2016-08-26', Expected Format yyyy-MM-dd'T'HH:mm:ssZ: Unparseable date: "2016-08-26"; Caused by: Unparseable date: "2016-08-26"

 

Based on the error, Z-Suite sync could not parse the Invoice.InvoicePostedDate field due to an invalid format.

INV0001234 has an InvoicePostedDate = '8/26/2016' which cannot be parsed by the sync. All invoices have a date format of example: 2016-08-25T21:17:03-0700.

However, invoice INV0001234 was posted right at Midnight so the timestamp T00:00:00-0800 was dropped. 

 

You can identify the invoice # by going to:

Billing > Manage NetSuite Integration > View Activity

 

Then, locate the last time stamp of the failure.

Sample: 2016-08-26 01:29:20

 

Then go to Data Exports > Look for a File name InvoiceItem.html and find the entry to the time stamp of 08/26/2016 13:29:20.

In this case, the one I  found has the time stamp of 2016-08-26 01:29:21. Click on the InvoiceItem.html hyperlink and it will download.  

 

Netsuite.png

 

Then look for the Invoice.PostedDate column to identify which one is missing the time stamp.

This is the correct format: 2016-08-25T21:17:03-0700
You need to locate the one with incorrect format such as this: 2016-08-26 and this is how you locate the invoice number in question



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Highlighted
Zuora Staff

Re: Netsuite sync error: "Caused by: Unparseable date

Solution: 

 

Option 1: If your tenant has the option to unpost invoices please first try to unpost and post the invoice again. Then perform the sync. If your tenant does not have the unpost invoices feature and you would like it to be turned on please submit a support ticket and we can enable it for you. 

 

Option 2: Since your tenant does not have the unpost invoice feature. Please use the below workaround.

 

  1. Manually create an invoice in NetSuite for INV0001234
  2. In Zuora, set INV0001234's NetSuite fields as below to link it to the NetSuite invoice
  3. Transferred to Accounting = Yes
  4. NetSuite Integration ID = <Id of the NetSuite invoice>
  5. NetSuite Integration Status = Sync Complete

Then try the invoice sync again. 

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √