https://netsuiteprofessionals.com logo
Join Slack
Powered by
Team, I have the following difficult case with Cu...
# general
a
Team, I have the following difficult case with Customer Balance. Maybe you could help me? In NetSuite, the Customer has the adjustment $ 6805.96. The exchange rate is 1.298904 During the integration, we received this transaction, but the transaction amount is $5470.769 and the currency is unknown. I tried to calculate this amount with the exchange rate ($5470.769 * 1.298904 = 7106.00. But not $ 6805.96). The amount $ 6805.96 we received in the fxAmount field. Is it possible that NetSuite calculated $ 6805.96 using the exchange rate of the parent subsidiary?
m
Is this using the SOAP API? `fxAmount`: transaction currency amount `amount`: amount in the currency of the root (top-level) subsidiary
a
Yes, SOAP API
m
Hi Andrii Yes as I said, it is the consolidated xchange rate. Try to do 5470.769 * Consolidated exchange rate.
a
Okay, thank you a lot!
@battk @Maxhuva Team, I investigated the solution to use the consolidated exchange rate, but the customer has 99,000 lines of consolidated exchange rates. Maybe you know another way how to receive the appropriate consolidated exchange rate? Also, I found the recommendation to request <ns15:fxbalance xsi:type="ns18:SearchColumnDoubleField"/> instead of <ns15:balance xsi:type="ns18:SearchColumnDoubleField"/>. But how I can determine in which case I should request the fxbalance instead of balance?
b
you probably want to do a search on the consolidated exchange rate
a
how to find the appropriate consolidated rate? the customer has a lot of rates(
b
have you looked at the filters available to you?\
a
I wanted to see rates via the Customer to compare which rate I should use to understand how to fill in the filter here https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/schema/record/consolidatedexchangerate.html
But the Customer cannot provide a list of rates
I don't know how to use the filter in this case (
Maybe you could provide a cue hot to do it?
b
probably want to start with going through how exchange rates and consolidated exchange rates work in netsuite.
basically you will need to understand how one currency is worth a different amount of another currency depending on the moment of time
so when you are doing your search for the consolidate exchange rate, you will need to determine which exchange rate at which point in time you are interested in
a
thank you!
@battk I got acquainted with specifications and I have two questions: 1. How to understand when I should receive the consolidated exchange rate? I think to use the following logic. If I receive the fxAmount field instead of the Amount field, I should retrieve the consolidated exchange rate. Is it correct or not? 2. And the second question. Does NetSuite apply the consolidated exchange rate to the transaction or to the particular period?
b
any of the fx related columns gives you the amount using the currency from that transaction
for your second question, the answer is it depends on what is setup on the transaction search
a
battk  [11:59 AM] any of the fx related columns gives you the amount using the currency from that transaction <<< Yes, you a right. But each transaction has an exchange rate, and also I can receive the consolidated exchange rate. Currently, we use the exchange rate from the transaction. Due to new logic, we should use the consolidated exchange rate only if we receive an amount in the fxAmount field.
b
not really sure what you are trying to say. You should always have a value in the fxamount column
a
@battk I am a little confused. From NetSuite I receive the following data: The transaction exchange rate: 1,298904 Amount on UI in NetSuite: USD 6805,96 The transaction amount that we received from NetSuite: 5470,769 (currency we didn't receive). I tried to calculate 5470,769 * 1,298904 = 7106. But I don't understand, why in NetSuite on UI the amount is 6805,96. I was able to download fxAmount = 6805.96 for this journal entry, but there is no field for fxAmountRemaining
On forum I found the information that in the request for receiving documents I should send <ns15:balance xsi:type="ns18:SearchColumnDoubleField"/> instead of the <ns15:fxbalance xsi:type="ns18:SearchColumnDoubleField"/>
But I am not sure that it can help us
b
im not sure what information you are getting
explicitly tells you what happens to the amount
and how it is calculated
and hopefully you learned from your prior research that the exchange rate from a transaction is not the same as the consolidated exchange rate used by the search
a
yes, sure
But I cannot understand when I should apply the consolidated exchange rate
instead of the exchange rate
b
there are 5 options for consolidated exchange rate for transaction
all are detailed in the link ive tried getting you to read 3 times
one of them does not use consolidated exchange rate
a
@battk Could you please clarify what does mean the following field fxAmountRemaining?
I tried to receive it via API, but NetSuite doesn't return it
b
amount remaining using the currency of the transaction
a
How I can receive this field via API?
b
wrong term
its a search column
not a field
a
Could you provide an example how to find it?
b
make a transaction search in the ui
add the amount remaining as a column
add the amount remaining (foreign currency) column to compare it to
a
I opened a payment, but cannot find the same field in settings
b
what settings?
a
payment payment -> customize form
b
ill once again emphasize that amount remaining is not a field
its only a search column
its also a mistake to assume all transactions have an amount remaining
a
yes, I found these search columns
thank you
@battk The Customer has two amounts: $ 6805.96 5470.77 How NetSuite calculates the Amount (foreign currency) field?
The exchange rate = 1.298904 (AUD -> USD) The consolidated exchange rate = 0.76988 The transaction amount = 4211.84 Amount = 4211.84 * 1.298904 = 5470.77 But I don't understand how NetSuite calculates $6805.96
Could you help me to understand how this amount is calculated?
b
its the other way around
amount is calculated from foreign currency amount
its why i dont think you fully grasp currency
and also why the consolidated exchange rate is likely not the correct value
a
I found the solution. The payment was created on December , 2020. The consolidated exchange rate was 0.76988. Thus, 4211.84 / 0.76988 = 5470.77 On March, 2021 the consolidated exchange rate = 0.618845. Thus, 4211.84 / 0.618845 = 6805.96. This amount is correct. As I understood, the Amount (foreign currency) can change every month according to the monthly consolidated rate. Is it correct?
b
the amount foreign currency will never change
unless the transaction changes
a
Then I don't understand how the amount $6805.96 was calculated according to the consolidated exchange rate 0.76988
4211.84 / 0.76988 = 5470.77 (it is not a 6805.96)
But for the current consolidated rate, everything is the same 4211.84 / 0.618845 = 6805.96
b
whats the consolidated exchange rate type of your search
a
current
b
are there any period filters
a
message has been deleted
The payment was created in December 2020
b
the date when the payment was created is irrelevant information when the consolidated exchange rate type is current
a
Thus, NetSuite uses the consolidated exchange rate for the current period, in my case it is march, 2021. Is it correct?
b
are there any period filters
a
No
b
If no period or date is selected, the current rate for the date you run the search or custom KPI is used.
a
I understood, thus is 0.618845
Thank you!
4 Views
Open in Slack
PreviousNext
Powered by