Hi, I'm wondering if it is possible to create an order and provided number? I was trying to do it and I received the following error message: "A record with the same primary key already exists." despite the fact that the order with provided number doesn't exist. mutation CreateOrder($companyId: Int) {
useCompany(no: $companyId) {
order_create( values: [
{
orderNo: 99,
orderType: 1,
name: "Test order",
orderDateAsDate: "2024-03-10",
customerNo: 99999999,
orgUnit2: 125
}
]) {
affectedRows
items {
orderNo
name
customerNo
orderDateAsDate
}
}
}
} Response: {
"errors": [
{
"message": "A record with the same primary key already exists.",
"path": [
"useCompany",
"order_create",
"values/0"
],
"extensions": {
"data": {
"status": 3,
"status_name": "PrimaryKeyAssignmentFailed"
}
}
}
],
"data": {
"useCompany": {
"order_create": {
"affectedRows": 0,
"items": null
}
}
},
"extensions": {
"vbnxt-trace-id": "00000000000000007438f11cafe2fdb3"
}
}
... View more