I am using the restAPI to POST Items and Expenses from several PurchaseOrders to a single Vendorbill. There are lines that have overlapping orderline numbers and it is not working - despite them being from different OrderDocs.
EG
PO ABC has 3 lines { 1, 2, 3 }
PO XYZ has 2 lines { 1, 2 }
and I get this error since they both have orderline 1
{
"type": "https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1",
"title": "Bad Request",
"status": 400,
"o:errorDetails": [
{
"detail": "There are multiple sublist lines with the same identifier. Make sure every line is unique.",
"o:errorPath": "item.items[?(@.orderLine==1)]",
"o:errorCode": "DUPLICATE_KEYS"
}
]
}
Is there a way to allow this? Seems like a pretty common case…!
I was able to do this in the UI without any issue, but got stuck when using the RestAPI
Here is my JSON for the lines causing the problem
"expense": {
"items": [
{
"amount": 33.00,
"memo": "",
"line": 1,
"orderDoc": "129387",
"orderLine": 1,
"account": {
"externalId": "14000"
},
"cseg_cci_location": {
"externalId": "109"
}
},
{
"amount": 222.00,
"memo": "",
"orderDoc": "126763",
"orderLine": 1,
"line": 2,
"account": {
"externalId": "90012"
},
"cseg_cci_location": {
"externalId": "109"
}
}
]
Thanks!