Skip to main content
Question

How to set premium freight price on Sales Order programmatically via API

  • Sep 11, 2023 12:13 AM UTC
  • 11 replies
  • 335 views
  • Translate All

Forum|alt.badge.img

Is it possible to send a total premium freight price value when creating a sales order?

Below is the request we are sending but it does not work

 

{"CustomerID":{"value":"855215____"},"FinancialSettings":{"Branch":{"value":"LOCAL"}},"CustomerOrder":{"value":"10"},"Details":[{"InventoryID":{"value":"CC-W0930"},"OrderQty":{"value":1},"UnitPrice":{"value":166},"custom":{"Transactions":{"UsrAssembled":{"value":true},"UsrHingePlacement":{"value":"Right"},"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"ASSEMBLE"},"OrderQty":{"value":1},"UnitPrice":{"value":16.6},"custom":{"Transactions":{"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"CUSTOM-CABINET"},"OrderQty":{"value":1},"UnitPrice":{"value":67.33},"custom":{"Transactions":{"ManualPrice":{"value":true}}}}],"Totals":{"PremiumFreight":{"value":175},"OverrideFreightAmount":{"value":true}}}

 

 

11 replies

Forum|alt.badge.img+3
  • Jr Varsity I
  • Sep 11, 2023 3:37 AM UTC

Hi,

Can you share for more information? It seems to to be working.

 

 

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Sep 11, 2023 4:38 AM UTC

@ericyz  I have modified your request and it is working as expected. 

 

Please change the INVENTORY ID field values and try to sync.

 

{
"OrderNbr": {
"value": "<NEW>"
},
"OrderType": {
"value": "SO"
},
"CustomerID": {
"value": "AACUSTOMER"
},
"FinancialSettings": {
"Branch": {
"value": "PRODWHOLE"
}
},
"CustomerOrder": {
"value": "10"
},
"Details": [
{
"InventoryID": {
"value": "AACOMPUT01"
},
"OrderQty": {
"value": 1
},
"UnitPrice": {
"value": 166
}
},
{
"InventoryID": {
"value": "CONBABY2"
},
"OrderQty": {
"value": 1
},
"UnitPrice": {
"value": 16.6
},
"custom": {
"Transactions": {
"ManualPrice": {
"value": true
}
}
}
},
{
"InventoryID": {
"value": "CONBABY1"
},
"OrderQty": {
"value": 1
},
"UnitPrice": {
"value": 67.33
},
"custom": {
"Transactions": {
"ManualPrice": {
"value": true
}
}
}
}
],
"Totals": {
"PremiumFreight": {
"value": 175
},
"OverrideFreightAmount": {
"value": true
}
}
}

 

 

 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Sep 11, 2023 1:06 PM UTC

Thank you both, so you are saying you did not change anything on my request and it works? If that is the case, could there be a setting on client’s acumatica implementation that is preventing my request to work? We are able to create sales orders, we are not able to set this field...

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Sep 12, 2023 2:03 AM UTC

@ericyz Are you able to update the value from the screen level manually?

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Sep 15, 2023 1:08 PM UTC

Yes I am able to set it manually. I did not see any difference on the API requests from yours with what I posted originally. You guys are basically saying request is correct and it should work? 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Sep 18, 2023 12:33 PM UTC

@ericyz  I see there is a difference between your request to my request. Have you checked with my JSON request and able to see the Premium Freight updated in SO?

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Sep 18, 2023 12:43 PM UTC

@Naveen Boga I copied my request and expanded the Totals area - I think it is in the same format with yours. What could be the issue?

 

{"CustomerID":{"value":"855215____"},"FinancialSettings":{"Branch":{"value":"LOCAL"}},"CustomerOrder":{"value":"10"},"Details":[{"InventoryID":{"value":"CC-W0930"},"OrderQty":{"value":1},"UnitPrice":{"value":166},"custom":{"Transactions":{"UsrAssembled":{"value":true},"UsrHingePlacement":{"value":"Right"},"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"ASSEMBLE"},"OrderQty":{"value":1},"UnitPrice":{"value":16.6},"custom":{"Transactions":{"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"CUSTOM-CABINET"},"OrderQty":{"value":1},"UnitPrice":{"value":67.33},"custom":{"Transactions":{"ManualPrice":{"value":true}}}}],

 

"Totals":

{"PremiumFreight":

     {"value":175},

"OverrideFreightAmount":

  {"value":true}

}

}

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Sep 22, 2023 2:24 PM UTC

Following up here, any ideas? My request looks same with the ones you tried that works. What could be the reason my request does not work? I am able to create the sales order, just can’t set that field

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Sep 22, 2023 4:19 PM UTC

@ericyz Did you check in any other instance and observed the same behaviour?

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Oct 30, 2023 10:16 PM UTC

Hi @ericyz were you able to find a solution? Thank you!

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Oct 31, 2023 2:10 PM UTC

No solution, we gave up on it unfortunately

Translate