Hi everyone, I am trying to get the base price of another currency which is Mexican Peso, I am using SuiteTalk api v2017.2. I always get the value of the first currency which is USD. I tried other prices, filter by currency but I could not get the value needed. Can you help me?

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() }

}

,

pricingJoin = new PricingSearchRowBasic()

{

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

unitPrice = new SearchColumnDoubleField[] { new SearchColumnDoubleField() },

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

}

},

criteria = new ItemSearch()

{

basic = new ItemSearchBasic()

{

type = new SearchEnumMultiSelectField()

{

operatorSpecified = true,

@operator = SearchEnumMultiSelectFieldOperator.anyOf,

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

},

subsidiary = new SearchMultiSelectField()

{

operatorSpecified = true,

@operator = SearchMultiSelectFieldOperator.anyOf,

searchValue = new RecordRef[] { new RecordRef() { internalId = subsidiariaId } }

},

itemId = new SearchStringField

{

operatorSpecified = true,

@operator = SearchStringFieldOperator.contains,

searchValue = id

}

}

}

};