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!
Need to link transaction (invoice) search to a custom record to retrieve emp goals
I have created a custom record (Goals-Employees) to store monthly employee goals and I need to be able to run a transaction search against invoices to measure how they are performing over any period of time.
Custom Record Goals-Employees
Fields
Employee (type list/employee)
Month End (type date)
Goal 1, etc are integer fields
Data for this month would show:
Chris Corcoran
01/31/2012
10
15
25
Since the transaction record is not linked to the invoice and therefore is not available as a link for saved searches I created a custom transaction body field on the invoice called “GoalLink” as a type List/Record using the above custom record (Goals-Employees).
0