I refer to the same question I posted on 11/12/99 which was replied.

What is the field name to extract ** completed ** under backorder and unit price
column of the OE-order detail screen.? When I extract the details based on the 'Status' of the OELINE'R it gives me the particular items as Not completed. But the inquiry of the same order is saying completed for all the line items. All what we need to establish is a report similar to that of Order inquiry screen's detail section.

Appreciate your assistance.

Hello Devon,

There is no field that will print the text ** completed **. However, there are 2 fields that you may use to determine whether an order or a line on an order is complete:

From the Header section: Order complete (Y/N), and from the Detail section: Completed (Y/N).

You could create formulas based on these fields to print the text.

Thanks for your prompt reply.
It is strange enough that on OE inquiry the order is displayed on the header as "Completed" But when the same information is extracted from QR (from OEHEAD) it says not completed. The report that I am interested is with the following columns.

Item code , Description (from IC)
Orig. Order Qty (from OELINE)
Shiped to date (do)
Pending Qty (orig. qty-shipped to date)
Status of completion (y/n from OELINE)

Sort order : Category , Item code
Totals : sub tot. for category and one grand total
Selection formula excludes a particular category.
Ranges are set for Order Number

On the looks of it it sounds a very simple report.
It is starange to see that the items are duplicated on the report and I tried a
workaround to total per each item and to print only the totals. But that total counted the
duplicated entries shown on the report. My data integrity is fine.
Using QR 6.5(990428) on a Novell network with WSM 6.1A patched for latest.

Thanks in advance for your prompt response.

Hello Devon,

Do you have the Document type field on the report? If you do not, I suggest that you add it.

It sounds as if you are reporting on Orders and Invoices/Credit notes. That may be causing what appears to be duplication.