I'm using SuiteQL to look at vendor purchase prices on the item record. I'm joining the itemVendor table to the item table and everything is working fine except for vendors where the purchase price currency differs from the specific vendor's primary currency. In those cases I still see the vendor line in the itemVendor table but there is no value in the purchaseprice field. If I change the currency to match the vendor's primary currency, the purchase price suddenly appears in the query. Has anyone seen this before and know what to do? Should I not be able to access the purchase price regardless of currency, I mean the information is in the database somewhere.