SOAP SalesOrder add request in secondary currency

I have multi-currency set up and my default currency is USD.

Can I send a sales order add request with a sales order in CAD (Canadian Dollars) and have it auto convert to USD for a USD-default customer?

I am trying with Postman but am getting the response…

<platformCore:statusDetail type=”ERROR”>
<platformCore:code>INSUFFICIENT_PERMISSION</platformCore:code>
<platformCore:message>You do not have permissions to set a value for element currencyname due to one of the following reasons: 1) The field is read-only; 2) An associated feature is disabled; 3) The field is available either when a record is created or updated, but not in both cases.</platformCore:message>
</platformCore:statusDetail>
Beginner Asked on November 12, 2019 in SuiteTalk.
Add Comment
9 Answer(s)

Hi Scot,

currencyName isn’t supported:
The 2011.2 and later endpoints include a change from previous endpoints to the currency field in the body of transactions. Endpoints prior to 2011.2 included the currencyName string type field. As of the 2011.2 endpoint, this field has been replaced by the currency RecordRef type field. If you upgrade to the 2011.2 endpoint or later, you must update any code that references currencyName.

So I think you’ll need something like:
<ns1:currency internalId=”10″ xsi:type=”ns2:RecordRef”/>

I’m just trying to find a previous sample but hope that helps for now.

Thanks,

Chris

Rookie Answered on November 12, 2019.
Add Comment

I’d expect that sort of error based on custom form setup, etc.

Are you able to share the request that you’re sending?

and

Are you able to log in as the integration user and create the desired transaction through the UI?

Rookie Answered on November 12, 2019.
Add Comment

After changing the customer to allow CAD as well as USD, I can post using administrator.

Does anyone know specifically what permission is needed to allow my integration role to do this?

 

Beginner Answered on November 12, 2019.
Add Comment

Hi Scot,

Has the role got Lists > Currency?

Thanks,

Chris

Rookie Answered on November 12, 2019.
Add Comment

I added that and there is no change to the result…

 

 

Beginner Answered on November 12, 2019.
Add Comment

I fixed it… was using <currencyName>… changed it to  <ns1:currency xsi:type=”xsd:string”>Canadian Dollar</ns1:currency>

Beginner Answered on November 12, 2019.
Add Comment

ignore that previous…

that did not change the currency on the sales order. the post went through and did not fail but it did not change the currency.

So, I am still stuck on how to post a CAD SalesOrder transaction.

 

Beginner Answered on November 12, 2019.
Add Comment

okay… ones step further… but it now tells me…

“Invalid currency reference key 3 for entity”

…but Canadian Dollars is internal id 3 in my system and the customer(entity) has both USD and CAD available…

Beginner Answered on November 12, 2019.
Add Comment

…nevermind… had the wrong customer…

 

This is now working!  Thanks for the assist @abbott!!!

Beginner Answered on November 12, 2019.

No worries – glad you’re sorted.

Such a battle getting some SuiteTalk requests up and running!

on November 12, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.