My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Please note that on Friday, January 9, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 60 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Comments
-
I tried that. I get the NO RESULTS FOUND msg again.
-
I was just about to send the following. Update: The above gave me the following results shown below. NOTE: The highlighted rows are my desired results. The problem I have and can't figure out why is... When I add a Criteria for Location = PR - HOUSTON WH, I get NO RESULTS FOUND.
-
Thank you. I will continue to work on it as well.
-
You have been very helpful. Thank youl. I have discovered a couple things which are probably unique to our situation. However, I have managed to get the Search to now return 2332 of the 2354 expected results. I will try to fine tune it from here. For you reference, below is the criteria that got me to the 2332 results.
-
I had already checked that when I determined the Account Type was Income. All lines were Account Type Income.
-
Uh Oh! I was so happy to see the report did not return a bunch of duplicates I overlooked the fact it is now filtering out too much. It is showing only 337 results. Whereas it should be showing slightly over 2400.
-
AWESOME !!! That fixed it ! Thank you so much.
-
Ivy, Thank you for your reply. I ran the Search to confirm the ACCOUNT TYPE, which turned out to be Income. So, I modified your formula to reflect Income. I am still getting the same result (duplicate results).
-
All, After some investigation I discovered because there was no activity on the 3220-01 account, I was able to rename it to Z 3220-01 and then was able to rename ZZZ1 Sales Taxes Payable LA to 3220-01. Problem has been solved.
-
@Micah Timbol-Oracle Thank you for your response. Before I proceed, I need to ask if it makes a difference that your suggested SuiteAnswer 29986 indicates it applies to Nexuses OTHER THAN United States and Canada. Whereas, I am dealing with a United States Nexus: Louisiana.
-
Awesome!!!! It worked!. Thank you so much.
-
@Dominica Sevilla-Oracle Thank you for this offering. It does return the first payment. I will see about incorporating it into my Saved Search. @Ivy Lopez-Oracle Thank you for your input. It is greatly appreciated.
-
Dominica, I had a thought regarding another possible way to address the shipping amount issue. Is there a way to make the Saved Search return only the first value (payment) when there is more than one payment?
-
Thank you for your prompt reply. I did try using the Account 6200-01 FREIGHT and filtered it via the different fields as mentioned in my last message. None of them worked. ?
-
Please see the 3 attached documents for my responses. NOTE: I also tried using Paid Transaction: Account, Paid Transaction: Account (Main), Paying Transaction: Account, and Paying Transaction: Account (Main) as a criteria filter with no success. As a result I have began the process of creating a resolution via method of…
-
Shipping Cost is empty: Removed all results. Shipping Cost is 0.00: Removed complete invoice that had 0.00 Shipping from search.
-
I wished I had better news. No change. Still showing the amount twice. I am almost ready to consider the possibility of resorting to exporting to Excel to do the running total and final calc's there.
-
Unfortunately, the account #'s for the shipping cost are the same as the inventory items. So, the proposed solution eliminates ALL transactions. ?
-
Dominica, I prematurely clicked the Accept Answer button. I am still testing this process trying to determine why it is not working.
-
Ivy, Thank you so much for your response. I will take your advice / suggestions into account when deciding which route to take.
-
Awesome! It worked. Thank you very much. It is working now!!! ?
-
Jack, My sincerest apologies but your response back on Nov 23 2020 resolved my issue. I forgot to mark it resolved. I have done so now.
-
Sorry for delay. I was out of office Wed - Fri last week. Your response did answer my question. I have marked your response as ANSWERED. Thank you for your help.
-
Ivy, Thank you for responding. We are using NS WMS. Error message: The entered serial number has a different status or is stored in a different location. Verify the entered details.
-
Ivy, thank you so much! Excellent job!
-
Screenshots of Criteria and Results attached.
-
My apologies for delay in responding. Things are really crazy right now. Your response above was helpful.
-
AWESOME! That worked. Thank you SO MUCH! ?
-
I found the answer to my question. I need to go to the Machine Run Time (Other Charge For Purchase items) and update the acct # there. Thank you for your help,
-
PS: I also tried using the FORMULA option.