Skip to main content
Solved

Vendor Price Worksheet API

  • March 15, 2024
  • 2 replies
  • 108 views

Hi!, Just wanted to ask on how to create new Vendor Price Worksheet thru API?

What Params, Body should I send?

Best answer by yhartman

Hi,

You can create Vendor Price Worksheets with the below.

URL: {YourSite}/entity/{EndpointName}/{EndpointVersion}/VendorPriceWorksheet

Method: PUT

Body: Demo Example

{
"Description": {
"value" : "Price from API"
},
"VendorSalesPrices": [
{
"Vendor": {
"value": "AASERVICES"
},
"InventoryID": {
"value": "AACOMPUT01"
},
"UOM": {
"value": "EA"
},
"PendingPrice": {
"value": 1.5
}
},
{
"Vendor": {
"value": "ALPINEAIR"
},
"InventoryID": {
"value": "CONAIRT1"
},
"UOM": {
"value": "EA"
},
"PendingPrice": {
"value": 1.5
}
}
]
}

To see the other fields you can access go to the Web Service Endpoints (SM207060) screen.

You can learn more about Api Integrations on Acumatica’s Open University.

https://openuni.acumatica.com/courses/integration/

 

I hope this helps!

2 replies

Forum|alt.badge.img+3
  • Jr Varsity I
  • Answer
  • March 17, 2024

Hi,

You can create Vendor Price Worksheets with the below.

URL: {YourSite}/entity/{EndpointName}/{EndpointVersion}/VendorPriceWorksheet

Method: PUT

Body: Demo Example

{
"Description": {
"value" : "Price from API"
},
"VendorSalesPrices": [
{
"Vendor": {
"value": "AASERVICES"
},
"InventoryID": {
"value": "AACOMPUT01"
},
"UOM": {
"value": "EA"
},
"PendingPrice": {
"value": 1.5
}
},
{
"Vendor": {
"value": "ALPINEAIR"
},
"InventoryID": {
"value": "CONAIRT1"
},
"UOM": {
"value": "EA"
},
"PendingPrice": {
"value": 1.5
}
}
]
}

To see the other fields you can access go to the Web Service Endpoints (SM207060) screen.

You can learn more about Api Integrations on Acumatica’s Open University.

https://openuni.acumatica.com/courses/integration/

 

I hope this helps!


  • Author
  • Freshman I
  • March 19, 2024

Thank you! @yhartman