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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
Save $30 - limited to first 1,000 registrants
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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