Hope you are doing well.
I am new to Acumatica. I have a few questions regarding the data validation, hoping someone can help me out on this.
When I tried to test creating / updating records through API service, I noticed a few issues. For instance:
- When creating an invoice with an invalid type value in the payload. The application doesn’t response with error message, like “the invoice type is wrong”. Instead, an invoice with bad data is created. See screenshot #1. Once it happened, all other request of updating / creating invoice will fail.
- When creating an invoice with invalid details. For instance, if I create an invoice record with two items in “Details”, The first item has an invalid inventory id, then the second item has the valid inventory id. Acumatica will accept with this request, then create an invoice. But the details in the created invoice, the first item will have empty value in the “Inventory ID” value.
- When updating a closed invoice through API. Acumatica accepts the request and payload, but without invoke any actual updates. I understand a closed invoice can not be updated through UI, but it is hard to tell via an API call.
In summarize, we wonder if the payload can be verified before being submitted. Acumatica accepts the request only when all values are good, otherwise the request should be rejected.
Best answer by frederickodendaal77View original
Hi Yren, did you get a solution to this? I am experiencing the same problem.
I created this package and it prevents you from saving the invoice if one of the lines you send on the API contains an inventoryID that does not exist in the system.