Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Custom Price List updated with Currency fluctuations
I want to update a price list each day with the correct price. The base price is in USD and I want a list to be updated each evening with correct price from the NS Canadian dollar exchange rate. I do not want to do an export/import process but a suite script. Is this possible and how would we go about setting up the script.
It would look something like this (bad form js) function ????
{
//only execute when run from the scheduler
if ( type != 'scheduled' && type != 'skipped' ) return;
var priceUS = nlapilastpurchaseprice;
var exchangeCAD = nlapiExchangeRate(USD, CAD, Today );
var priceCAD = priceUS * exchangeCAD;
0