Hello, I’m wondering how I can go about importing a sales order into Acumatica by using the REST API. I realized that this is likely through the use of the Actions however I could not find one that would do the action of “New Sales Order”
Any ideas on how to do this?
Best answer by aaldrich
View originalHi,
Look at the below video around minutes 45, it should help! Watch the whole video to understand how Acumatica apis work.
https://youtu.be/WZjlfsN6aew
Also, you can look at https://openuni.acumatica.com/courses/integration/i330-data-manipulation-with-rest-api/
I hope this helps!
+17
Hi
API Request URL: - https://URL/InstanceName/entity/APISamplesEndpoint/18.200.001/SalesOrder
Request Body:
{
"OrderNbr": {
"value": "<NEW>"
},
"OrderType": {
"value": "SO"
},
"CustomerID": {
"value": "AACUSTOMER"
},
"note": "",
"CustomerOrder": {
"value": "STG21002"
},
"Details": [
{
"note": "",
"InventoryID": {
"value": "AACOMPUT01"
},
"OrderQty": {
"value": "1.0000"
},
"MasterQty": {
"value": "1.0000"
},
"ManualPrice": {
"value": true
},
"UnitPrice": {
"value": 79.99
},
"ManualDIscount": {
"value": true
},
"DiscountAmount": {
"value": 0
},
"TaxCategory": {
"value": "DEFAULT"
}
}
]
"Date": {
"value": "12/01/2022"
},
"RequestedOn": {
"value": "12/01/2022"
}
}
Hi
API Request URL: - https://URL/InstanceName/entity/APISamplesEndpoint/18.200.001/SalesOrder
Request Body:
{
"OrderNbr": {
"value": "<NEW>"
},
"OrderType": {
"value": "SO"
},
"CustomerID": {
"value": "AACUSTOMER"
},
"note": "",
"CustomerOrder": {
"value": "STG21002"
},
"Details": [
{
"note": "",
"InventoryID": {
"value": "AACOMPUT01"
},
"OrderQty": {
"value": "1.0000"
},
"MasterQty": {
"value": "1.0000"
},
"ManualPrice": {
"value": true
},
"UnitPrice": {
"value": 79.99
},
"ManualDIscount": {
"value": true
},
"DiscountAmount": {
"value": 0
},
"TaxCategory": {
"value": "DEFAULT"
}
}
],
"Date": {
"value": "12/01/2022"
},
"RequestedOn": {
"value": "12/01/2022"
}
}
This answer works great - It is a PUT request (You can also use the endpoint /entity/Default/20.200.001/SalesOrder)
(I was able to find the link above because of @yhartman post)
Hi, do you know if it is possible to send again the same sales order and UPDATE the items?
When I resend the same sales order, it updates the fields in the header as expected, but instead of updating the line items, it adds new line items.
Thanks,
Mario
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
