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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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.