Have encountered an annoying SuiteTalk problem:
I...
# suitetalkapic
cja
12/03/2020, 3:26 PMHave encountered an annoying SuiteTalk problem:
In data returned by SuiteTalk for a transaction, the subsidiary is EUR, currency is EUR and exchangerate is 1, but the values for amount and rate on the lines are the GBP values, not the EUR values.
Any ideas how to get it to return EUR values?
m
Marc Reicher
12/03/2020, 5:45 PMSOAP or SuiteQL?
c
cja
12/03/2020, 7:47 PMSOAP
m
Marc Reicher
12/03/2020, 10:41 PM-
Marc Reicher
12/03/2020, 10:41 PMis your root subsidiary in GBP?
j
Jon Kears
12/04/2020, 4:56 AMdo you have multi-book?
c
cja
12/04/2020, 3:47 PMOne World
cja
12/04/2020, 3:47 PMHere are three transactions:
INVGB131195
Subsidiary: GBP
Transaction: GBP
main line exchangeRate: 1
item lines amount: GBP
item lines rate: GBP
item lines fxAmount: GBP
INVGB111654
Subsidiary: GBP
Transaction: EUR
main line exchangeRate: 0.90559
item lines amount: GBP
item lines rate: GBP
item lines fxAmount: EUR
INVIE000002
Subsidiary: EUR
Transaction: EUR
main line exchangeRate: 1
item lines amount: GBP
item lines rate: GBP
item lines fxAmount: EUR
I would expect the last one, INVIE000002, to have item lines amount and rate in EUR, since that is the currency of the subsidiary. Or for its main line exchange rate to be the rate from EUR to GBP.
cja
12/04/2020, 3:50 PMThe parent and grandparent and greatgrandparent (root) subsidiaries are all GBP
m
Marc Reicher
12/04/2020, 5:19 PMyeah the SOAP API shows the
amountc
cja
12/05/2020, 4:45 PMSo then would you agree with this:
Currency names:
Root subsidiary: CRO
Transaction subsidiary: CSU
Transaction: CTR
Values:
main line exchangeRate: exchange rate from CTR to CSU
item lines amount: in CRO
item lines rate: in CRO
item lines fxAmount: in CTR
?
m
Marc Reicher
12/07/2020, 6:20 PMI would agree with everything there except
item lines rateMarc Reicher
12/07/2020, 6:20 PMI'm not sure I know what you mean by
item lines ratec
cja
12/07/2020, 7:31 PMThe rate field on transactions lines where mainLine == false
m
Marc Reicher
12/07/2020, 9:55 PMI haven't actually tested that. Do you have one of those transactions in your environment? If so, curious what the SOAP API returns. In general, this is my understanding of the transaction schema found here https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/schema/search/transactionsearchrowbasic.html?mode=package:
1.
amountfxAmountexchangeRatefxAmountc
cja
12/08/2020, 10:41 AMThank you - I agree with your 1,2,3
cja
12/08/2020, 10:42 AMMy problem is I need the rate in the transaction currency. If I divide fxAmount by the quantity then I often get a slightly different value to what is shown in the UI, due to rounding
cja
12/08/2020, 10:56 AM2 Views