Viewing and Downloading UET Data

View, edit or download unquality event log entries recorded in the QUAL.LOG file for further analysis using a variety of spreadsheets, databases, statistical analysis programs, and data warehousing systems. From the UET Log Viewing/Download window, you can also drill down to the system records and transactions associated with any unquality event log entry.

To view and download UET data:

  1. From the Events > Unquality Event Tracking menu, select UET Log Viewing/Download to display the UET Log Viewing/Download window.

You can also display this window by pressing Shift-F5 from any Solar Eclipse window.

  1. Complete the following fields, as needed, to enter criteria for selecting the events to view or download:

Field

Description

Tracker

To select entries associated with a tracker, enter the tracker ID.

Entity

To select entries associated with a customer, vendor, or branch, enter the entity name.

Product

To select entries associated with a particular product, enter the product description or number.

UET Code

To select entries for a denoted UET code, enter the UET code.

Order

To select entries associated with an order, enter the transaction ID

Branch

Enter the branch for which to select entries. To select all entries that match the other criteria, regardless of the branch, select All. This field is required.

Start Date

Enter the beginning date for which to download events.

End Date

Enter the end date for which to download events.

Downloaded

Select one of the following

  • Yes - Selects log entries that have been previously downloaded.

  • All - Selects all entries that match the other selection criteria, regardless of whether they have been previously downloaded.

  • No - Does not select previously downloaded log entries.

Order Type

To select entries for one order type, select Sales, Purchase, or Transfer.

To select all entries that match the other selection criteria, regardless of the order type, use the default option All.

Category

To limit the selected log entries to a business category, select Customer, Vendor, or Internal.

If you leave this field blank, the system populates the field when you enter the Unquality Event Code.

  1. Click Update to display the results.

The system displays the following view-only information for each selected entry:

Field

Description

User

The ID of the user who generated or entered the unquality event.

Date

The date when the unquality event was entered.

Time

The time when the unquality event was entered.

Description

Data describing the log entry, including the event code, the entity name, the order number, the product, the quantity off, the days off.

More Options in the UET Log Viewing/Download Window

The following options are available in the UET Log Viewing/Download window:

To...

Select this menu option...

expand the summary description of an entry.

File > Expanded Description

display the UET Log Entry window for the selected entry.

File > Edit Item

download the selected entries to a location on your computer.

The system displays Save dialog box. Enter the File name and click Save The system then prompts for a data format. For more information about the different formats, see Downloading Customer and Vendor UET Data.

File > Download to PC

See Also:

Unquality Event Tracking Overview