Custom Function for updating expiry date of Invoice failed due to Invalid Date specified in Custom Field

Custom Function for updating expiry date of Invoice failed due to Invalid Date specified in Custom Field

Hi,

We have an issue which we did not encountered prior to 26 Apr.
Basically we have a custom function, that is used to update the expiry date of the invoice. As our payments terms are based on end-of-months of xx days.
Inclusive as well, in the invoice, we have a custom field DATE, that defines when we actually send the invoice to the client through a separate portal. The format of the custom field DATE (cf_posted_data) is dd/MM/yyyy (that matches our Zoho Books Org date setting).

As we are only updating the expiry date of the invoice, the custom function works successfully when custom field DATE  (cf_posted_data)  is blank.
But if there is a DATE value  (cf_posted_data)  e.g. 23/05/2022, the custom function fails with the error:
 "code": 6, "message": "Invalid date 23/05/2022 specified."
Would anyone be able to provide some insights?

  2. invoiceID = invoice.get("invoice_id");
  3. invoicedate = invoice.get("date").toDate();
  4. organizationID = organization.get("organization_id");
  5. invoicepaymenttermslabel = invoice.get("payment_terms_label");
  6. invoicepaymenttermsdays = invoice.get("payment_terms");

  8. x_day = 0;
  9. if(invoicepaymenttermsdays == "121")
  10. {
  11. x_day = 120;
  12. }
  13. else if(invoicepaymenttermsdays == "91")
  14. {
  15. x_day = 90;
  16. }
  17. //OBTAIN THE END OF THE MONTH POST x days
  18. newinvoiceduedate = invoice.get("date").addDay(x_day).eomonth(0);
  19. DuenumberOfDays = daysBetween(invoicedate,newinvoiceduedate);
  20. invoice.put("due_in_days",DuenumberOfDays);
  21. //FORMAT THE NEW DUE DATE
  22. newupdatedinvoiceduedate = toString(newinvoiceduedate,"yyyy'-'MM'-'dd");
  23. newinvoiceduedateformatted = toString(newinvoiceduedate,"dd'/'MM'/'yyyy");
  24. invoice.put("due_date",newupdatedinvoiceduedate);
  25. invoice.put("due_date_formatted",newinvoiceduedateformatted);
  26. invoice.put("billing_address","");
  27. invoice.put("shipping_address","");
  28. //UPDATE INVOICE
  29. updatedinvoice = zoho.books.updateRecord("Invoices","2XXXXXXXXXXX",invoiceID,invoice);
  30. info updatedinvoice;

Thanks