Forums › Cached › Customization › Searches / List Views

This topic contains 1 reply, has 0 voices, and was last updated by michoel 8 years, 5 months ago.

  • Author
    Posts
  • May 25, 2016 at 1:41 pm #5253 Score: 0

    MCS
    • Contributions: 0
    • Level 1
    • ☆

    I have a scenario where I would like to bring back any Journal Entries where two of the System Notes Fields and corresponding New Values equal each other when another field equals a specific value. In this scenario, it would be when when the ‘JE Creator’ field and the ‘Document Status’ field both have the same ‘SET BY’ user, and the ‘NEW VALUE’ in the ‘Document Status’ field is equal to ‘Approved for Posting.’ I’ll attach a screenshot of this scenario. I am attempting to show any Journal Entries that did not go through an approval process. If anyone has any ideas how I might be able to apply a filter for this in a saved search it would be greatly appreciated.

    Thanks,

    Max

    Attached Files
    This is a cached copy. Click here to see the original post.

  • May 25, 2016 at 6:41 pm #5254 Score: 0

    michoel
    • Contributions: 0
    • Level 1
    • ☆

    I can’t test this, but I think something like the following could work –

    Criteria – Standard(Use Expressions = T)( System Notes : Field is Document Status AND
    System Notes : New Value is Approved for Posting ) OR
    System Notes : Field is JE Creator
    Criteria – SummaryCount – System Notes : Set By equal to 2
    ResultsInternal ID (Summary Type = Group)
    System Notes : Set By (Summary Type = Group)

  • Author
    Posts

You must be logged in to reply to this topic.