query

  1. A7.3 Running a Query through a World Writer Program

    So I made a Custom Query in a custom library through WRKQRY so I could have a specific report needed for my production plant for WO creation help. (Basically just a report that shows what is committed and needed for replenishment) QUERY: REPORTS63A LIBRARY: TYLER I'm currently trying to find a...

  2. E9.1 Connection between Excel/Power BI to JDE

    Hello! How can you make a connection between Excel/PowerBI and JDE? I am trying to query data from JDE so I don't have to keep logging in, running a report, and finally exporting it to my desktop. Thanks in advance!

  3. E9.2 Querying Multiple Tables in Query Manager

    I am new to JDE and have searched for this topic, but have not found a definite answer. Is it possible to query multiple tables using the Query Manager in JDE? I would like to create a query that would drive a watchlist which would notify me if field values in the Address Book table differ...

  4. E9.2 Non-APPL dependent queries and watchlists?

    Hello Team, I'm trying to understand a little bit better the capabilities of the UDOs Queries and Watchlists. I see that a query would be -in essence- an application-based filtered fetch. From a couple videos and guides, I see that they always create a query using an application (I guess it...

  5. 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...
Back
Top