@Patrick Fresnosa-Oracle Patrick, during the integration process, we receive the Amount (Foreign Currency) field for transactions. But, in our application, we should calculate the Amount (Foreign Currency) to exchange rate that refer to the Company currency, And we cannot understand which exchange rate we should use,…

If you need additional information, let me know

? I sad to hear that, thank you for your help

This is just new test account

I found. 0.707090762735977 * 2 = 1.41

Maybe I found, Could you provide a formula for how to receive 1.41?

@Patrick Fresnosa-Oracle I checked once again, but I cannot find a rate(

@Patrick Fresnosa-Oracle Maybe the rate from Euro to USD in another menu?

I don't see Euro to USD conversion is 0.705. (((

Thank you!

@Patrick Fresnosa-Oracle Could you provide an answer? Thank you!

@Erick Dela Rosa-Oracle Erick, could you see the Base Amount field that I depicted on the screen? I found the following article - https://blogs.sap.com/2020/01/07/vat-code-with-base-amount-different-from-invoice-amount/ Is it possible to receive from NetSuite the same?

@Erick Dela Rosa-Oracle What about other fields?

Okay, thank you!

We are going to receive via API (SOAP)

@Pauline Joy Cac-Oracle Unfortunately, I have only a brief description of these fields and I cannot understand which fields from NetSuite I should retrieve.

@Patrick Fresnosa-Oracle Last month I created two invoices: the first for $1000 the second 200 euro. The exchange rate between USD and EUR was 1.33. Thus, the fxBalance = 1000 + (200 * 1.33) = 1266 This month the fxBalance is 1286 because the exchange rate this month is 1.43. But, in previously created invoice I see the…

@Patrick Fresnosa-Oracle What is the best balance to take during the integration process? I mean Balance or Balance (Foreign Currency). Currently we use the Balance and have some discrepancy. But when we start to use the Balance (Foreign Currency) we don't have any discrepancy. I think the appropriate way to integrate the…

Thanks a lot!

I found a solution. Amount Remaining (foreign currency) = (Amount Remaining / Consolidated Rates) / Rate Example: Amount Remaining (foreign currency) = (Amount Remaining / Consolidated Rates) / Rate 99.00 = (394.48 / 2) / 1.9922964

@Mikko De La Fuente-Oracle @Erick Dela Rosa-Oracle Team, Sorry to come back to this question again. Maybe there are some alternative ways to get Amount Remaining (Foreign Exchange)? Currently, we receive the Amount and Amount Remaining fields via API. But the Customer wants to see in my application the Amount (foreign…

Thank you!

@Erick Dela Rosa-Oracle Erick, I received the following SOAP response. Does this field that I designated on the screen correspond to this field? (https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/script/record/cashsale.html)

@Mikko De La Fuente-Oracle @Erick Dela Rosa-Oracle Team, Could you help me?

@Mikko De La Fuente-Oracle , @Erick Dela Rosa-Oracle Could you help me?

I understood. Thank you!

@Mikko De La Fuente-Oracle Thank you for the information. What is Enhancement # 550725 - Web Services (WS) > Expose Amount Remaining (Foreign Exchange) ? Could you provide a path how to find it in NetSuite?

@Mikko De La Fuente-Oracle I found the solution. The payment was created in December 2020. The consolidated exchange rate in December was 0.76988. Thus, 4211.84 / 0.76988 = 5470.77. In March, 2021 the consolidated exchange rate = 0.618845. Thus, 4211.84 / 0.618845 = 6805.96. This amount is correct. As I understood, the…

We cannot understand what exchange rate we should use to receive the $ 6805.96

The Customer has two amounts:$ 6805.96 5470.77How NetSuite calculates the Amount (foreign currency) field?