Hello everyone, I'm creating a saved search to report on sales profitability. I'm having trouble understanding the Est. Unit Cost calculation for items with costs defined in a different currency than the Sales Order (SO). The item's Cost Estimate Type is set to 'Item Defined Cost' (in USD). The Sales Order's currency is ARS. The issue: The cost is converting using an unexpected exchange rate. • Item Defined Cost: 736.60 USD • System Exchange Rate (USD to ARS) for SO date: 1,205.00 • Calculated Est. Unit Cost in Saved Search (ARS): 883,920.00 The result of $883,920.00 suggests the system is using an effective exchange rate of approximately $1,200, rather than the rate of $1,205 defined in the Currency Exchange Rates table. I've already confirmed the SO Header Exchange Rate is 1 (since the transaction currency = subsidiary base currency). My question is: Where is NetSuite pulling this rate of 1,200 for the Est. Unit Cost conversion? Is it using a daily average rate instead of the specific entry?

Consolidated Exchange Rates Consolidated Exchange Rate Types for Transaction Searches

Thank you so much!