query

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...

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!

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...

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...

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...