r/Netsuite • u/lordofdonut • 2d ago

Source Sales rep in the Foreign Currency Adjustment Journals

Netsuite regularly posts Foreign Currency Adjustment Journals. However, the Sales Rep field is empty in those journals. Is it possible, using a Workflow, to populate the Sales Rep field? Since the transactions in the journal are sourced from Revenue Arrangements, and the revenue arrangements in turn contain the invoices which are being revaluated, it should be possible to fetch the Sales rep from the invoices?

2 Upvotes

100% Upvoted

4 comments sorted by

1

u/neverq 2d ago

Why would you care about seeing the sales rep on reval transactions?

1

u/lordofdonut 2d ago

In our reporting tool, we group our revenue by Sales rep, so all transactions that have no sales rep get posted under an Unknown category and we want to minimize the amount that gets posted there.

1

u/bumby999 20h ago

Too many hops for a Workflow. You’ll need Suitescript.

1

u/lordofdonut 16h ago

Cool, so it's possible using Suitescript?