My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Please note that on Friday, January 9, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 60 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Comments
-
@Patrick Fresnosa-Oracle I understood, the Customer Balance from the Balance field is the Customer Balance in the Company Currency. I saw it in the A/R Aging Report
-
@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