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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Sourcing Data from Custom Record?
I've created a custom record to store FX rates (for purposes of calculating commissions). There are two important fields on this record
[LIST]
[*]Currency - this is the native currency list
[*]Commissions FX Rate - a custom decimal field
[/LIST]
I have another custom record, our Contract record, which has these fields (among others):
[LIST]
[*]Customer Currency: native currency list, value is set by sourcing from the customer record
[*]Commissions FX Rate Contract - the field I want to populate
[/LIST]
I want to source the "Commissions FX Rate" value into the "Commissions FX Rate Contract" field when the currencies match in the "Currency" and "Customer Currency" fields.
0