Hi! I'm creating a Vendor Bill from a third-party ...
# general
p
Hi! I'm creating a Vendor Bill from a third-party provider using a RESTlet script, however, I get this response:
Copy code
{
   success: false,
   message: "You entered 'null' into a field where a calendar date was expected.\\nPlease go back and change this value to the correct date.",
   name: "DATE_EXPECTED"
}
The integration script is converting and pushing the following date information from the payload: • date: "2024-09-23" -> mapped to {trandate}, date transformed to "2024-09-23T070000.000Z" • duedate: "2024-10-08" -> mapped to {duedate}, date transformed to "2024-10-08T070000.000Z" For context, the erroneous Vendor Bill that I'm trying to import is linked to a Purchase Order (no issue with importing a standalone Vendor Bill with the same script and payload format). No custom Date field for either the PO or the vendor bill. Has anyone encountered such a case? Does anyone have any idea which field NetSuite is asking for?
b
Hey @Prasya Aninditya, I started seeing this error as well curiously on the exact same date. Wondering if it's a bug introduced on the NetSuite side—were you able to resolve this?
g
@Prasya Aninditya Do you by chance have the Japan Localization bundle installed?
p
Hi all, sorry for the late reply. @Ben, not really resolved it, but I found a workarond. So this issue is happening when we are trying to create Vendor Bills with a linked PO. I figured removing the "Expected Receipt Date" on the PO resolves the issue, however, we don't advise this workaround for accounts that are using Advanced Inventory Management in NetSuite. @Griffin no, I don't have the Japan Localisation.