Generate Open Orders Report Data (OE99)

The Generate Open Orders/Unprocessed Invoices Report Data (OE99) extracts and summarizes the necessary data from the Open Order files and creates a temporary data file for reporting purposes. The generated file is available through ODBC for reporting via Crystal Reports, Microsoft Excel, etc.

• At the same time, the extended Price is calculated for each Order line by applying the pricing routine. The extended price is then stored in the Total Outstanding field of the temporary file that is created.

• Only one instance of OE99 can be run at a time, i.e. if you are running OE99, you cannot open a second instance of OE99 and run it concurrently.

• Note: Any Orders or Invoices that are created as OE99 is running are included in the temporary file.

The following list defines every field on OE99:

• Last Updated - displays the date and time on which this report was last run.

• By - displays the User ID of the Operator logged into Enterprise when OE99 was last run.

• Status - displays the Status associated with the previous run of OE99.

• Select Transaction Types to Include in the File - select from the following list of transaction types the transactions you want to include in OE99:
  • Open Orders
  • Open Quotes
  • Unprocessed Invoices
  • Unprocessed Direct Bills
  • Unprocessed Credit Notes
  • Unprocessed Prebills

• Processing - once you click Generate, this field displays the transactions currently being processed.

The following table outlines the functionality of the button on OE99:

Button Label	Icon	Functionality
Generate		Generates the Open Orders report file.