JDE product · Reporting

Any report from JD Edwards.
Without a ticket to IT.

Users join JDE tables themselves, check the result and export it to Excel. With their own JDE permissions.

Today: three windows, three exports, one spreadsheet.

Data BrowserF0101

The Data Browser only ever exports one table. We stitch the rest together in Excel with VLOOKUP.

Export · 1 table
Data BrowserF03B11

Every new report means a ticket. By the time it is done, the question has gone away.

Export · 1 table
Data BrowserF03012

Someone pulls the month-end list by hand, every single month.

Export · 1 table
FlexQueryF0101 ⋈ F03B11 ⋈ F03012

FlexQuery joins JDE tables.
Without SQL.

Pick a template or a table, join further tables, filter, done. FlexQuery reads only through AIS, as the signed-in JDE user. Nobody sees more than in JDE.

Four steps, not one line of SQL

Pick a template or a table

Before, after

Drag the handle.

One table per exportSeveral tables in one query
New reports through ITThe business builds them itself
Merging in ExcelFinished result from JDE
Monthly lists by handThe schedule sends the file
TodayWith FlexQuery
SELECT FlexQuery
WHERE Access = Read-only through AIS, with the JDE user and their permissions
AND JD Edwards = No JDE modification needed
AND Runs on = Your server, Windows or Linux
AND Licence = Per JDE environment

Everything FlexQuery does

21 features

Building queries

Templates for typical questions

Open items per customer, receivables aging, open payables, inventory value per branch and more.

Building queries

Search in plain language

“open orders” finds the matching JDE tables and business views.

Building queries

Joining tables

Joins are suggested and checked for matching data types.

Building queries

Appending a second table

Read tables with the same columns one below the other (union).

Building queries

Filters with relative dates

“today minus 30 days”, lists, ranges, also on group totals.

Building queries

Calculated columns

Formulas with text, dates and conditions across source columns.

Results and output

Familiar Data Browser look

Paging, query by example (QBE), sorting, subtotals.

Results and output

Completeness checked

Every result is checked against the count in JDE; if a row is missing it is marked as failed.

Results and output

Charts

Bar, column, line, pie or key figures from the complete result.

Results and output

Excel, CSV, XML

Download with your number and date formats from the JDE profile.

XML with Extracts
Results and output

Report books

Up to 12 queries in one Excel workbook or a PDF with cover page and charts.

Automatic delivery

Schedules

Queries and report books run at fixed times.

Extracts
Automatic delivery

Targets

File share, SFTP server or e-mail.

Extracts
Automatic delivery

Notification

Mail when something went wrong, with a history per run.

Extracts
Sharing and administration

Sharing with users and roles

Share queries with colleagues, JDE users or JDE roles.

Sharing and administration

Transfer between environments

From development to production, with approval if you wish.

Sharing and administration

Launched from JD Edwards

As a link or embedded in JDE, signed in with the JDE session.

Sharing and administration

Audit log for administrators

Who queried, shared or transferred what.

AI assistant

Query from a question

Describe the list in your own words; FlexQuery checks the proposal like a hand-built query.

from 3.0
AI assistant

Translating SQL

An existing SELECT becomes a FlexQuery query.

from 3.0
AI assistant

No JDE data to the AI

Only your text and table descriptions are sent, never data, names or passwords.

Your path with FlexQuery

FlexQuery itself shows how many queries, report books and schedules your team uses.

  1. Stage 1

    First query

    With a template such as open items per customer, on day one.

    Your progressThe first list without a ticket.
  2. Stage 2

    Own queries

    The business joins tables itself and shares queries in the team.

    Your progressFewer report requests to IT.
  3. Stage 3

    Report books

    Month end, receivables, inventory: several queries in one file.

    Your progressOne file instead of many exports.
  4. Stage 4

    Runs on its own

    Schedules deliver lists and books on time.

    Your progressNobody has to remember any more.

FlexQuery on video

The real product with demo data: build a query, check the result, export, schedule. Try FlexQuery free of charge in your development or test environment, with your own JDE data.

See FlexQuery in your environment?

Tell us briefly what it is about. We will get back to you within two working days.

Talk to us