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.