Hi All, I am trying to pull item prices via SOAP and it all works good until we consider Multi-Currency / Multi-Vendor / Multi-Subsidiary scenario. Imagine I have an item like on the screenshot #1. • Purchase Price (base one) = 1499 is exposed as "cost" attribute in ItemSearchBasic (all good - can use it Basic/Joined/Advanced searches). • The issue is getting Vendors sublist (which determines price for the combination of Vendor-Subsidiary-Currency): ◦ ItemSearchBasic exposes this sublist as itemVendorList and purchasePrice field in it. However purchasePrice is omitted if there are prices in 2 currencies on one line (check the 1st line of the Vendors sublist). Proof - screenshot #2. ◦ ItemSearchAdvanced exposes this sublist in basic(ItemSearchRowBasic) as fields vendor / vendorCode / vendorCost / vendorName / vendorPriceCurrency / vendorSchedule. And first line in sublist is returned correctly. BUT the subsidiary column of the sublist is just missing in the response. According to ItemSearchRowBasic documentation it was not supported at all. So only subsidiary in item header is exposed, but not the subsidiary in Vendors sublist. No joins at ItemSearchRow are helpful too. Soooo...is it SuiteTalk limitation which prevents us from getting all the item pricing data via SOAP in such Multi-Currency / Multi-Vendor / Multi-Subsidiary scenario or am I missing something?

what do the results look like when adding the subsidiary column

ItemSearchRowBasic has the only subsidiary property and it holds data about the item<>subsidiary join. Data from Vendors collection (==itemVendorList in basic search) is exposed as properties with vendor prefix (see attachment). And dedicated subsidiary column is just not there. No joins in ItemSearchRow are useful either. As a result, when querying data for this specific item and a subsidiary where it is allowed (say "Parent Company" in my case) AdvancedSearch returns 6 lines with the different prices (5 lines and the first line having 2 prices in different currencies). But the subsidiary is "Parent Company" everywhere. So it is impossible to get which of those prices should be really applied to "Parent Company". If you don't filter by subsidiary and just try pull specific item via ItemSearchAdvanced then you'll get lines count = N subsidiaries * 6 lines with prices per subsidiary.