Recommended Queries

Departmental cash balance

Dept ID %
Fund Code %
Business Unit

Payment and transaction information, by Check #, for Vouchers, Expense Reports and/or Employee Advances.

Check # %

Provides users with information relating to deposit refunds

Begin Date
End Date
Dept ID

Open Items (Employee Advance) Balance Information

Empl ID %
HR Home DeptID %
As of Date

Provides a list of all internal auxiliary category codes to be used with internal auxiliary suppliers.

No prompts

Provides a list of requisitions that have been entered for the auxiliary
but not yet approved and where they are in the process.

Dept ID %
Project ID %
Fund %
*From Date Entered
*To Date Entered
*Business Unit
Supplier %

Provides a list of all internal auxiliary suppliers.

No prompts

Provides the original encumbrance amount, expenses to date
and remaining balance for each line on an internal, auxiliary PO.

PO Number %
Dept ID %
Fund Code %
Project ID %
*Purchase Order Date>
Supplier ID %

Provides a sum of expenses for the auxiliary by supplier ID and purchasing category.

Department ID %
Fund Code %
Fiscal Year
Accounting Period - Start
Accounting Period - End
Project %

Provides a list of auxiliary invoices that have been charged to a department’s internal, auxiliary PO.

Department %
Fund Code %
Project %
Supplier ID %
Invoice %
PO Number %
*Invoice Date - Start
*Invoice Date - End

Provides a list of outstanding receivables for auxiliary customers by auxiliary bill source.

*As of Date
Selling Dept ID like %
AUX Customer ID like %

Provides a list of items (bills) waiting to be invoiced in OMNI Financials.

Bill Source %

Provides a list of items (bills) that have been invoiced in OMNI Financials.

Bill Source %
Customer ID %
*Begin Date
*End Date

Provides a list of invoices and payment history for an auxiliary customer.

Customer ID %
*Acctg Date - Start
*Acctg Date - End
Bill Source %

Provides a list of all internal auxiliary purchase orders for a specific department
available to be used by internal auxiliary billers.

Dept ID %
*Start PO Date
*End PO Date
Project ID %
Fund %
*Business Unit
Supplier %
Supplier Name %

Provides a list of the auxiliary customers in OMNI Financials shared by all departments.

No prompts

Provides a list of accounts receivable invoice payments processed for auxiliary customers.

*Entered Date - Start
*Entered Date - End
Deposit ID %
Payment ID %
Customer ID %
Customer Name1 like %
Customer Name2 like %

Used to review Direct Journal Deposits and ARD Journal history.

*Jrnl Start Date
*Jrnl End Date
Fund %
Dept ID %
Project %
Account %
Journal ID%

Used to review payments processed through Transact for eMarket, cashier, and auxiliary customers.

*Cashnet Business Date Start
*Cashnet Business Date End

Used to review batches of deposits processed by Deposit Accounting.

*Begin Acct Dt
*End Acct Dt

Used to review the current day deposit postings with Chartfield information.

*Journal ID

Used to review history for all generated journals with vouchers listed by Chartfields, Journal Date, and Journal ID.

Fund %
Dept ID %
Project %
*Jrnl Start Date
*Jrnl End Date
Account %
Journal ID %
*Business Unit

Used to review history for all travel expense journals with Chartfields and Journal Dates.

Dept ID %
Fund %
Project %
*Jrnl Date From
*Jrnl Date To
Journal ID %
*Business Unit
Account %
Report ID %

Used to review opem items for open cash advances.

Empl ID like %
Dept like %
Fund like %
Project like %
*Begin Date
*End Date

Detailed acquisition and custodial (off-site) information for assets

Dept ID %
Fund ID %
Project ID %
Tag # %
PO ID %
Voucher ID %
Business Unit

Assets inventoried in current fiscal year by Department

Business Unit
Last date of prior FY
Dept ID

Provides accounting entry setup for Item Types.

Dept ID %
Item Type

Journal detail of payments on Accounts Receivable charges. DOES NOT include detail
of what specific charges were paid by the payments.

Dept
Fund
Person/Org ID
Journal Date