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 saved search for expense report line items
I'm baffled - I can't figure out how to get a search that will pull expense report lines. It seems that if there's multiple lines in an expense report using the same expense category I get the total of the category. For example, let's say there are 4 flights in a single ER. Each has a unique memo description, date, and amount. My saved search results will combine all four and give me the memo from the first line.
For example, ER101, main line date 5/30/11, main line memo May flights:
Line 1, date 5/5/11, memo PDX-OAK, amount 312.12
Line 2, date 5/7/11, memo OAK-PDX, amount 312.12
Line 3, date 5/12/11, memo PDX-SNA, amount 418.34
0