Use the Find Expenditure Items window to enter search criteria for expenditures and expenditure items. You can enter information in multiple fields and on multiple tabs when you define the criteria for a search. This capability enables you to query specific expenditure items that you want to adjust or review. This section describes some of the attributes you can use to search for expenditure items.

At the header level, you can enter the following information to limit the expenditure items queried:

• Operating Unit

• Project Number

• Project Name

• Task Number

• Task Name

• Award Number (when Oracle Grants Accounting is enabled)

• Award Name (when Oracle Grants Accounting is enabled)

• Cost Code (when cost breakdown planning is enabled for this project)

• Cost Code Name (when cost breakdown planning is enabled for this project)

• Transaction ID

• Expenditure Organization

• Expenditure Type Class

• Expenditure Type

• Expenditure Item Date Range

In addition, you can enter find criteria:

• Expenditure Tab:

  • Expenditures Region:

    For Expenditure Category, select the expenditure category of the expenditure item you want to find.

    For Expenditure Ending Dates, select the expenditure ending dates of the items you want to find. You can enter a date range, or either a start or end date.

    For Expenditure Batch, choose an expenditure batch name if you want to find expenditure items grouped and entered by batch.

  • Other Region: Choose the transaction source, work type, and costed processing status of the expenditure items you want to find.

• Billing Tab:

  • Billing Status Region:

    For Billable, choose Yes to view only billable expenditure items.

    For Billing Hold, choose Yes to view expenditure items that are on hold indefinitely. Choose No to view items that are not on hold. Choose Both to view items that are on both one-time hold, and on hold indefinitely. Choose Once to view expenditure items that are on one-time hold.

    For Billed, choose Yes to view expenditure items that have appeared on an invoice, regardless of invoice status. When you choose this option, Oracle Projects retrieves expenditure items from project invoices that have a status of Unapproved, Approved, Released, and Accepted.

  • Processing Status Region:

    For Revenue Distributed, choose Yes to view only revenue-distributed expenditure items, or choose Partial to view expenditure items that have partially distributed revenue.

  • Bill Group:

    Specify the bill group to view expenditure items that are grouped for invoicing. You can update the bill group for the expenditures that are not billed. To update the bill group for a single expenditure item from the Reports menu select the Update Bill Group option.

• Resource Tab:

  • Labor Region: Choose the employee number, employee name, job, or assignment associated with the expenditure items that you want to find.

  • Other Region: Choose the resource organization, non-labor resource, WIP resource, or inventory item associated with the expenditure items that you want to find.

• Supplier Tab:

  • Choose the supplier number, supplier name, invoice number, invoice line number, receipt number, or payment number associated with the expenditure items that you want to find.

  • The payment number is used to search for expenditure items only in the following cases:

    1. If cash basis accounting is implemented, you can query for expenditure items from expenditure inquiry using payment number as payments are directly interfaced to Oracle Projects.

    2. If accrual based accounting is implemented, only when a payment discount is interfaced to Oracle Projects, the payment number field is used to query the associated expenditure item in expenditure inquiry.

  • Enable the Include Related Tax Lines check box if you also want to query the related tax expenditure items when you query supplier cost expenditure items.

    Note: You can enable the Include Related Tax Lines check box only if you enter a value in the Invoice Line Number field.

  • Enable the Unmatched Reversing Items that Require Adjustment check box if you want to search for unmatched reversing expenditure items from Oracle Purchasing and Oracle Payables that require manual adjustment. For information about manually adjusting unmatched reversing expenditure items, see Manually Adjusting Unmatched Reversing Expenditure Items.

• Cross Charge Tab: You can search for expenditure items by entering the following Cross Charge criteria in the cross charge tab:

  • Cross Charge Type

  • Cross Charge Processing Method

  • Cross Charge Processing Status

• Provider/Receiver Tab: You can use the provider/receiver tab to search for cross-charged expenditure items using provider and receiver organization find criteria. You can specify information for the provider and the receiver in the following fields:

  • Organization

  • Operating Unit

  • GL Dates

  • PA Dates

• Capital Tab:

  • CIP/RWIP Region:

    For Capitalizable, choose Yes to view only capitalizable expenditure items.

    For Grouped CIP, choose Yes to view expenditure items that have been grouped into CIP asset lines.

    For Grouped RWIP, choose Yes to view expenditure items for tasks that are set up for retirement cost processing.

    Enable the Expensed check box to view only expensed expenditure items.

  • Capital Events Region: Choose an event number to search for expenditure items associated with the capital event. Alternatively, enable the None check box to query expenditure items that are not associated with a capital event.

• Exclude Net Zero Items: Enable this check box if you want to exclude net zero expenditure items from your query. Net zero items consist of an original item and a reversing item for the amount of the original item. Together, the amounts for these two items net to zero. This check box is located at the bottom of the window.