Hi all,
I want to write a program to fetch invoice via Acumatica openAPI and send to clients. My problem is after send invoice to clients, I want to add a note to the invoice in the Acumatica. I checked openAPI and can not find any endpoints related to modify invoice. I only found a /Invoice/{actionName} endpoint maybe can do that. Also I can’t find any action like add a note. Does anyone have any idea on this?
Best answer by jinin
View originalHi
You can make an API call (Salesinvoice) to update the notes in Acumatica after sending the invoice to the client.
Url :entity/Test/20.200.001/SalesInvoice
Method:PUT
Request:
{
"ReferenceNbr": {
"value": "AR009875"
}, "Type": {
"value": "Invoice"
},
"note": {
"value": "Invoice Released"
}
}
You have to add the Customer ID as well. Acumatica’s API often forces you to provide multiple keys, even if one really should do (ReferenceNbr should be enough, but it isnt). The API does tell you this. You can see in your Postman screenshot it says CustomerID cannot be empty.
I tested doing the update with the following JSON and it worked.
{
"note": {
"value": "test"
},
"Amount": {
"value": 874.0000
},
"Balance": {
"value": 874.0000
},
"BillingPrinted": {
"value": true
},
"BillToContactOverride": {
"value": false
},
"Customer": {
"value": "10008"
},
"CustomerOrder": {},
"Description": {},
"Hold": {
"value": false
},
"LinkARAccount": {
"value": "11000"
},
"LocationID": {
"value": "MAIN"
},
"PostPeriod": {
"value": "012021"
},
"ReferenceNbr": {
"value": "000004"
},
"ShipToContactOverride": {
"value": false
},
"Status": {
"value": "Open"
},
"TaxTotal": {
"value": 0.0000
},
"Terms": {
"value": "DEFTERMS"
},
"Type": {
"value": "Invoice"
},
"custom": {}
}
Got it. I was mostly offering help for the error that was in the screenshot you posted “Customer ID cannot be empty”. It is possible that once the Invoice is created, you no longer get this error when you do an update, in which case my comment may not be relevant. Acumatica’s API is kind of “REST-like”, as opposed to RESTful, so there are some weird things that aren’t necessarily predictable until you actually test with Postman.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
