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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
How to show account split for transaction containing a specific account
I am trying to build a report or saved search or analytics wherein I want to see all the GL accounts used in transaction lines when such transaction lines contain a specific GL account.
Example: Document JV#1111 has 4 transaction lines with GL accounts like xxx11,xxx12,xxx13,xxx14. There is another Document Bill#2222 having 3 transaction lines with GL accounts like xxx11,xxx15,xxx22.
I want to run a report to pull all the seven transaction lines (from document JV#1111 and Bill#2222) when I mention the common GL account xxx11 which is part of both the transactions.
Under standard Transaction Detail report, there is a column as 'Split' but this does not give the account line number if there is morethan 2 lines.
Tagged:
0