Skip to main content

Lookups

A lookup is any predefined value that was not defined in a setup window. Use the Oracle Payables Lookups window to review and maintain sets of values, or lookups, that you use in Payables.
In some fields, you must select a value from a predefined lists of values. Sometimes the values on the list are items you have defined in a setup window, such as supplier names, payment terms, or tax codes. Other predefined sets of values are lookups, which you can view, and in some cases, update, in the Oracle Payables Lookups window.
A lookup category is called a lookup type, and the allowable values for the lookup type are called lookup names. For example, names of invoice types, such as Standard, Prepayment, Debit Memo, and so on, are lookup names for the lookup type of Invoice Type.
You can add lookup names to some lookup types. For lookup types that you can modify, you can define up to 250 lookup names. For example, you can define additional values for Source, which you specify when you import invoices. You cannot change lookup name values after you save them. To remove an obsolete lookup you can disable the code, enter an end date, or change the meaning and description to match a replacement code.
You can view all Payables lookups in the Oracle Payables Lookups window. However, you can't modify most lookups. For example, the Payables application uses lookups that you do not use for data entry, such as lookups that list exceptions in the Exceptions section of the Expense Report Import Report.

Comments

Post a Comment

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc...
1 comment
Read more

Overview of Encumbrance Accounting

With General Ledger you can record pre-expenditures commonly known as encumbrances. The primary purpose of tracking encumbrances is to avoid overspending a budget. Encumbrances can also be used to predict cash outflow and as a general planning tool. To use the full capabilities of encumbrance accounting, you must enable the budgetary control flag for a set of books. When you enable the budgetary control flag, the system automatically creates encumbrances from requisitions, purchase orders and other transactions originating in feeder systems such as Purchasing and Payables. When you do not enable the budgetary control flag, you can still enter manual encumbrances via journal entry, but you cannot generate encumbrances from requisitions and purchase orders. You have two options for using encumbrance data to monitor over-expenditure of a budget: After actuals and encumbrances have been posted, you can generate reports to show over-expenditures. You can also can use funds checking to preve...
Post a Comment
Read more

Apply/Unapply Prepayments Window Reference

Payables provides two ways to apply prepayments to an invoice. You can do either of the following: i-> Create or query an invoice and apply one or more prepayments to the invoice. ii-> Create or query the prepayment and apply it to one or more invoices. Selecting an Invoice and Applying it to a Prepayment When you select an invoice and choose the Apply/Unapply Prepayment option in the Invoice Actions window, the Apply/Unapply Prepayments window opens. It automatically displays all prepayments that have been applied to the invoice, and all available Prepayment distributions that you can apply to the invoice. Payables displays prepayment item type distributions that meet the following criteria: same supplier, and invoice currency as the invoice. The prepayment's Settlement Date is on or before today's date. The prepayment's date is on or before the date of the invoice. The prepayment is type Temporary with a status of Available. If you use Automatic Offsets, you can se...
Post a Comment
Read more