RE: Base price multiple currencies

 

Hi everyone, I am working with web service in the v2017.2 api, I need to recover the base price of an item in a currency other than usd, it is the currency found on tab 5. I manage to return the base price but always in the usd currency. How should I return the prices in mxn? Thanks a lot.

 

ItemSearchAdvanced itemSearchAdvanced = new ItemSearchAdvanced()

{

columns = new ItemSearchRow()

{

basic = new ItemSearchRowBasic()

{

internalId = new SearchColumnSelectField[] { new SearchColumnSelectField() },

itemId = new SearchColumnStringField[] { new SearchColumnStringField() },

displayName = new SearchColumnStringField[] { new SearchColumnStringField() },

basePrice = new SearchColumnDoubleField[] { new SearchColumnDoubleField() }

},

pricingJoin = new PricingSearchRowBasic()

{

currency = new SearchColumnSelectField[] { new SearchColumnSelectField() },

saleUnit = new SearchColumnSelectField[] { new SearchColumnSelectField() }

}

},

criteria = new ItemSearch()

{

basic = new ItemSearchBasic()

{

type = new SearchEnumMultiSelectField()

{

operatorSpecified = true,

@operator = SearchEnumMultiSelectFieldOperator.anyOf,

searchValue = new[] { "_inventoryItem", "_assembly" }

},

itemId = new SearchStringField

{

operatorSpecified = true,

@operator = SearchStringFieldOperator.contains,

searchValue = param.itemId

},
}

}

};

 

Gaston Rookie Asked on June 13, 2023 in SuiteTalk.
Add Comment
1 Answers

Hi,

Do you see different values for currency from the pricing join?

I think you might want Unit Price from the pricing join.

Thanks,

Chris

Intermediate Answered on June 29, 2023.

Hello Chis, thank you very much for your answer.

The unit price always returns the price in the first currency. I can’t get my price charged in another currency back.

Do you have any other ideas?

on June 29, 2023.
Add Comment

Your Answer

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