I created a discussion in March related to returning the most recent case user notes in a case saved search, that we solved (Case Audit saved search - definition is below the blue text) in April.
The Case Audit saved search worked perfect when spreadsheet notes were .csv imported it into NetSuite. It also worked perfect if the UI was used to add a User Note from inside a Case and selected the "Case Audit" Note Type(part of my Case Audit saved search). Many notes have been successfully added using the UI and are properly displayed on my Case Audit saved search.
I ran into an issue this week that User Notes were added to 4 Cases and selected the "Case Audit" Note Type and these newest notes on the 4 cases are NOT pulled into the Case Audit saved search. The previous User Note for each of these 4 cases IS pulled in to the Case Audit saved search. I expected the newest notes to be displayed in the Case Audit saved search.
I created another troubleshooting User Notes saved search Case User Notes trying to identify a difference between the user notes entered. It is a simple straightforward search that just lists the User Notes created this week & excludes the automated notes.
My results demonstrate that for these 4 cases, the "Company" was somehow attached to the User Notes. The Company is not attached to the User Notes that DO appear in my Case Audit search.
Results are in the Attached excel export. I have masked some information. "SAMPLE" screen shot here.
Can anyone suggest where else I could look for what is different about the Case User Notes on these for Cases and what may be the cause of them not being returned on my Case Audit search (below).
THANKS for any hints.
APRIL SOLUTION TO MY MARCH Question; here for review convenience:
This CASE AUDIT Search is intended to list all Open Cases and the most recent Case User Note that has not been auto generated.
No Summary Criteia
I also used some highlighting
Saved Search Results:
User notes can be added as the case is worked or during a review meeting in an extracted spreadsheet and BE SURE TO TEST a csv upload.
Import Type: Communications
Record Type: Notes
Data Handling = ADD
MY Import mapping: