Hello,
I am currently trying to create a set of sales invoices using an external system through the erpnext API. But erpnext system is returning an error such as:
417 - {"exc_type":"DoesNotExistError","exception":"frappe.exceptions.MandatoryError: [Sales Order, SAL-ORD-2022-00001]: items","exc":"[\"Traceback (most recent call last):\\n File \\\"apps/frappe/frappe/app.py\\\", line 69, in application\\n response = frappe.api.handle()\\n File \\\"apps/frappe/frappe/api.py\\\", line 138, in handle\\n doc = frappe.get_doc(data).insert()\\n File \\\"apps/frappe/frappe/model/document.py\\\", line 258, in insert\\n self._validate()\\n File \\\"apps/frappe/frappe/model/document.py\\\", line 526, in _validate\\n self._validate_mandatory()\\n File \\\"apps/frappe/frappe/model/document.py\\\", line 856, in _validate_mandatory\\n raise frappe.MandatoryError(\\nfrappe.exceptions.MandatoryError: [Sales Order, SAL-ORD-2022-00001]: items\\n\"]","_server_messages":"[\"{\\\"message\\\": \\\"Error: Data missing in table: Items\\\", \\\"title\\\": \\\"Message\\\"}\"]"}
It is specifically getting hung up on the items field of the sales order with my items looking like this:
[{
"qty": 1,
"item_code": "1\"x8\"x10' - Pine",
"item_name": "1\"x8\"x10' - Pine",
"description": "1\"x8\"x10' - Pine",
"rate": 171.44,
"amount": 171.44
},
{
"qty": 1,
"item_code": "2\"x 8\"x 10' Pine",
"item_name": "2\"x 8\"x 10' Pine",
"description": "2\"x 8\"x 10' Pine",
"rate": 257.14,
"amount": 257.14
}]
I am using Frappe version: 14.14.3
With Erpnext version: 14.6.0
Any help would be greatly appreciated.