Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.