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.
NSC | How to Create a Dataset for Non-Elimination Transactions Using Elimination Accounts
SCENARIO
User is tasked with creating a dataset in NetSuite to identify transactions posted in non-elimination subsidiaries that are not marked for elimination but are using elimination accounts. This is important for the finance team to ensure that elimination accounts are used correctly and only for intended purposes.
SOLUTION
This is possible especially if the account is a non Accounts Payable and Accounts Receivable and users may have unchecked the Elimination checkbox in transactions.
1.) Click on Analytics
2.) Go to Datasets > New Datasets
3.) Select Transaction
4.) Add this to the Criteria:
Transaction > Posting
Transaction Line (Records List) > Eliminate and set it to
Patrick Fresnosa | Advanced Accounting | SRP | Ask a Guru