Does anyone know if there is a formula that would ...
# accountingd
DX
05/13/2019, 9:00 AMDoes anyone know if there is a formula that would convert base currency amount to USD amount in a bill payment saved search?
o
Olivier Gagnon (DXC)
05/13/2019, 12:31 PMWhat is USD to you? Is is a base current, transaction currency, or just some random currency as far as the system is conercern?
d
DX
05/14/2019, 1:32 AMthere are multiple transaction currency e.g. thai baht, Sing $, AUD$. USD is the currency I want to convert them to
DX
05/14/2019, 1:54 AMalso, I have a custom field and a script that converts the transaction currency to USD (script provided by SuiteAnswers; I modified it a bit) at the time a bill is saved. However, the field will only be updated when it's saved. I was thinking if there is a way to update this field for all past transactions as well. If this can be done, I can just source this field in my saved search. Any ideas?
a
ABJ
05/14/2019, 2:58 AMTry to run a mass update (maybe create a custom check box field for the purpose of updating the record.). Mass update will run as well the scripts running on the record.
d
DX
05/14/2019, 3:42 AMif I create the custom checkbox solely for the purpose of updating those records, will there be any impact if I remove it later on when the records are updated?
a
ABJ
05/14/2019, 4:02 AMYou can remove that later
ABJ
05/14/2019, 4:02 AMThat will not affect the updated record...
d
DX
05/14/2019, 6:26 AMWhat event type should I use for Vendor Payment in the script? It doesn't seem to update the amount even though the checkbox gets updated..
a
ABJ
05/14/2019, 6:27 AMyou can keep it empty to cover both create and update,
d
DX
05/14/2019, 7:10 AMIts returning the following message:
Your mass update is complete, and has been successfully performed on 0 records. 3 records failed with following IDs and messages:
1232966: fromCurrency
1241741: fromCurrency
1244869: fromCurrency
DX
05/14/2019, 7:11 AMvery helpful error message 😕
DX
05/14/2019, 7:51 AMfound it. setting that event type to blank causes it to fail the update 🤔
a
ABJ
05/14/2019, 8:08 AMhttps://netsuite.custhelp.com/app/answers/detail/a_id/10563 - maybe the event type is not defined on the script itself.
ABJ
05/14/2019, 8:08 AMIf Event Type is left blank, the script will execute only on the events specified in the actual .js script file.
ABJ
05/14/2019, 8:09 AMyou can add edit for now as event type, then run the mass update
o
Olivier Gagnon (DXC)
05/14/2019, 2:13 PM@DX ok there this evolved fast, so just for safety let me point out a few things: 1) You cannot edit the currency of a Bill that has payments applied to it 2) You cannot edit the currency of transactions in closed periods. If you don't have closed periods, you should be worried 3) changing the currency of transactions will have significant GL Impacts 3) you can only set the currency to one that is set on the Vendor
d
DX
05/15/2019, 1:51 AM@Olivier Gagnon (DXC) got it. I'm not changing any transaction currency though. I'm just translating whatever existing foreign currency amount to USD in a new custom field because I got a requirement from a user where he wants to view the USD equivalent of the transaction amount in his saved search. Currently, the search only shows the transaction currency.
o
Olivier Gagnon (DXC)
05/15/2019, 11:30 AMI see... I would say you'd be better served exporting those in your base currency then, at report-time, just multiplying all the values by your chosen exchange rate. There is no value in the effort to hard-update all the transactions
2 Views