Written by: Todd Kimpton
When you're using NetSuite's saved search feature, you expect consistent and accurate results. So, when the numbers don't add up, it can be quite disconcerting. Let's take a closer look at a common issue — a saved search displaying one number on results, which matches the printed CSV output, but when emailed with results as a CSV, it shows a multiple of the original number.
This scenario often happens when the column in question is in an item saved search, with the summary type set as Sum for the formula {transaction.quantity} - {transaction.quantityshiprecv}. Even when you change the summary type to Maximum and use the formula SUM, the issue persists.
Possible Causes
There could be several reasons for this discrepancy:
1. Sublist Line Count: NetSuite counts each line of a transaction as a separate entry in a saved search. If the transaction has multiple lines (for example, multiple items on a sales order), the quantity shipped/received will be multiplied by the number of lines in the transaction.
2. Joined Searches: If you're using a joined search, and a record on one side of the join has multiple related records on the other side, NetSuite will return one row for each related record. This can result in the quantity being multiplied.
3. Summary Type: The summary type in the saved search could be adding up quantities from multiple transaction lines or related records.
Troubleshooting Steps
Troubleshooting Quantity Discrepancies in NetSuite Saved Searches.
Here's how you can troubleshoot and resolve this issue:
1. Check the Transaction Lines: Verify if the transaction in question has multiple lines. If so, consider creating a separate saved search for the sublist items to avoid double-counting.
2. Review Joined Searches: If you're using a joined search, look for any records that have multiple related entries. You might need to adjust your search criteria or filters.
3. Confirm Summary Type: Ensure that the summary type in your saved search is set correctly. If you're dealing with transaction quantities, you might want to use 'Group' instead of 'Sum' to avoid adding quantities multiple times.
At Etter+Ramli (E+R), we're committed to helping you navigate this puzzle with ease. Our 'Managed Success' methodology offers a comprehensive approach to NetSuite administration, backed by a team of certified experts. From technical development needs to new release updates, we've got you covered.
Etter+Ramli as the Trusted, Independent Managed Services Provider for NetSuite
Using NetSuite Managed Services could be your growing company's best strategic move. NetSuite Managed Services offers a comprehensive solution, granting companies access to a team of experienced NetSuite administrators and consultants to manage their NetSuite ERP. Typically, this service is more affordable than hiring in-house staff. When you use managed services, your systems are always up-to-date. In the world of IT, systems are consistently upgraded and patched and come with a slew of security protocols. It is a lot to handle, but your teams can handle this when implementing managed services.
The goal is to ensure your NetSuite instance supports your business’ growth.
For over 20 years, Etter+Ramli (E+R) has helped several companies optimize their NetSuite software solution. With a 95% customer satisfaction rate, Etter+Ramli can provide your company with world-class support, Certified NetSuite experts, and a value-based pricing structure.
Etter+Ramli As Your Extended NetSuite Team
Etter+Ramli is an Independent Managed Success Provider for NetSuite clients. We are NOT partnered with Oracle NetSuite and do not take commissions. We bring our knowledge, expertise, and passion for success to our clients. We help clients Buy, Deploy, Grow, and Abandon NetSuite. We engage as a client-side managed service to ensure our priorities align with our clients.
To explore the benefits of retaining Etter+Ramli as your Managed Success Provider, contact Todd Kimpton or visit the website for a free consultation today.
Subscribe to our Newsletter: SuiteWords of Etter+Ramli to stay up-to-date with the latest trends on NetSuite, tips n' tricks, productivity solutions, and events.