Skip to main content
Question

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


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
  • 62 replies
  • September 11, 2023

Hi,

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

 

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • September 11, 2023

@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
        }
    }
}

 

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • September 11, 2023

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...


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • September 12, 2023

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


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • September 15, 2023

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? 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • September 18, 2023

@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?


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • September 18, 2023

@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}

}

}


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • September 22, 2023

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • September 22, 2023

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2756 replies
  • October 30, 2023

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


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 13 replies
  • October 31, 2023

No solution, we gave up on it unfortunately


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings