ANS-0010 · SAVED SEARCHES & FORMULAS
How to Resolve NetSuite Assembly Item Search Summary vs. Drill Down Discrepancies
Ensure accurate drill-down results for NetSuite Assembly Item searches joined to member items and transactions by a simple column addition.
Short answer
To resolve discrepancies between Summary and Drill Down results in NetSuite Assembly Item searches, add the "Transaction : Line Sequence ID" to the search's Results Columns. This ensures each line item is uniquely identified, preventing data aggregation issues and displaying correct drill-down data.
Scenario
When performing an Assembly Item search that includes joins to Member Item and Transactions, users may encounter a situation where the Summary Results do not match the Drill Down Results. This discrepancy typically arises when the exact same Assembly Item is present on multiple lines of an individual transaction, causing the drill-down view to misrepresent the aggregated data.
Solution
To resolve this issue and display the correct results in the Drill Down, add the "Transaction : Line Sequence ID" to the Results Columns of your saved search. This action ensures that each line item within a transaction is uniquely identified, thereby correcting any discrepancies between the Summary Results and the detailed Drill Down Results.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support