Hi Experts,
Purchase order translated amount in re...
# accountingn
Nawarain
09/20/2023, 6:23 AMHi Experts,
Purchase order translated amount in reporting currency is not equal to foreign currency / exchange rate showing in exchange rate list.
n
Nawarain
09/20/2023, 6:28 AMThank You for you reply but I am not able to understand how Netsuite is calculating this rate which is not available in exchange rate list.
m
michoel
09/20/2023, 6:29 AMThere is a different exchange rate table for reporting
n
Nawarain
09/20/2023, 6:29 AMOne is exchange rate list and other is consolidated rate list
👍 1
Nawarain
09/20/2023, 6:31 AMrate showing in list is 284.872 and Netsuite using rate is 292.88.
Nawarain
09/20/2023, 6:31 AMAny idea?
Nawarain
09/20/2023, 6:32 AMWe have integration with Xignite.
Nawarain
09/20/2023, 6:41 AMIs it using average rate on purchase order?
c
CD
09/20/2023, 7:37 AMWhich list? The daily list or the consolidated rates for the period?
n
Nawarain
09/20/2023, 7:51 AM@CD This is the issue , not sure from where it is picking rate to convert foreign currency into reporting / base currecy.
Nawarain
09/20/2023, 7:59 AMIt is using consolidate average exchange rate for translation into reporting currency.
Nawarain
09/20/2023, 8:00 AMUSD is the group currency
c
CD
09/20/2023, 9:41 AMDid you read the documentation link that was posted above? I can recommend reading the entire section, any answers here will be repeating that