@channel Anyone able to set the EXCHANGERATE value...
# suitescriptb
Brian Brown
10/27/2021, 8:55 PM@channel Anyone able to set the EXCHANGERATE value on a PURCHASEORDER in PAGEINIT context? It looks like the client script sets the EXCHANGERATE field, and I can see that in the UI. But then a split second afterwards it seems native NetSuite overwrites my change and sets the EXCHANGERATE back to the proper rate informed by its native currency exchange rate table.
b
battk
10/27/2021, 9:34 PMi cant imagine why you would want to change the exchange rate
battk
10/27/2021, 9:34 PMbut there are only specific circumstances where you would want it during pageInit
battk
10/27/2021, 9:35 PManything that changes the currency, like setting the vendor, would overwrite your exchange rate
battk
10/27/2021, 9:39 PMeven then you need to keep in mind you wont be able to change the exchange rate for the base currency
b
Brian Brown
10/27/2021, 11:20 PMThis client actually purchases currency quarterly. So they need a set exchange rate. As opposed to NetSuite's daily variable rate.
Brian Brown
10/27/2021, 11:20 PMGood question though.
Brian Brown
10/27/2021, 11:20 PMThanks @battk you've given me an idea. Possibly use a sleep or wait function somehow.
Brian Brown
10/27/2021, 11:20 PMTo wait until native NetSuite writes the EXCHANGERATE... ensuring my script executes last!
b
battk
10/27/2021, 11:22 PMthe currency field on a transaction is not supposed to represent the purchase price of a currency
b
Brian Brown
10/27/2021, 11:22 PMI appreciate your input @battk but I'm not sure you understand the business requirement.
Brian Brown
10/27/2021, 11:22 PMWas really interested in talking Suitescript.
Brian Brown
10/27/2021, 11:23 PMthx regardless
Brian Brown
10/27/2021, 11:24 PMgonna try beforeLoad UE to see if that will get it... as opposed to pageInit in a CS
Brian Brown
10/27/2021, 11:24 PMthat may just do it
s
Sciuridae54696d
10/28/2021, 1:08 PM@Brian Brown i think what you're looking for is not to run it during pageInit, but after postSourcing...
b
Brian Brown
10/28/2021, 2:59 PMahhh ok @Sciuridae54696d Maybe that would work!
Brian Brown
10/28/2021, 2:59 PMlet me give it a try!
Brian Brown
11/03/2021, 7:22 PM@Sciuridae54696d postSourcing worked flawless! Ty!
keanu thanks 1
25 Views