Results 1 to 2 of 2

Thread: Advanced Query - Problem with required filter criteria

  1. #1
    New Member
    Join Date
    Sep 2019
    Location
    Sonoma County
    Posts
    1

    Advanced Query - Problem with required filter criteria

    Hi,

    I'm trying to create an advanced query for a watchlist that tells me when an item has an on-hand balance in a primary location.
    Using the application P41273, Form W41273A. One View Item Location Trace.

    The query uses primary location QBE, Class Code QBE, and Quantity on hand QBE, in addition to Document Company. Document company is on the header of this form, and it's a required field. The problem is that, even though I have it included in the query, and set to a company number, I'm getting an error saying "Required filter criteria not entered", and it's highlighting that field on the form header.

    It kills my watchlist, since the query won't return any value unless i go in and manually populate that form header, despite the fact that it's included in the query.

    Does anyone know why this would be?

    P41273
    P41273
    Attached Images Attached Images

  2. #2
    Since the company number can be defaulted in with a processing option, as a work around, I would setup a special version to run your query and worklist against that defaults that value in from the processing option.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.