3.1 Invoice Options and Common Options for Payables and Procurement
Key Takeaways
Invoice options are set per invoice business unit; many can be overridden on the supplier site, which then takes precedence.
Receipt acceptance days are added to the goods received date when installments are recalculated, and recalculation uses the most recent of the invoice date, terms date and that adjusted receipt date.
Oracle's discount allocation methods are All invoice lines, Tax lines and single distribution, and Single distribution, and they are set in invoice options.
Common Options default the liability, prepayment, bill payable, conversion rate variance, discount taken, miscellaneous, freight and prepayment tax difference distributions.
Offset segments can be None, Primary balancing segment, or All segments except natural account.
Many hands-on items open one of two business-unit-scoped pages and ask what an invoice will do:
- Manage Invoice Options controls how invoices are entered, matched, discounted and approved.
- Manage Common Options for Payables and Procurement provides default accounts and cross-module options.
These pages answer two published objectives: Manage Invoice options and Set up common configurations.
Manage Invoice Options
Invoice options are settings and default values that control how invoices are processed for an invoice business unit. Many can also be set on the supplier site. Where a supplier value exists, it wins.
Invoice entry options
| Option | Effect |
|---|---|
| Require invoice grouping | An invoice group name is mandatory |
| Allow document category override | Users can change the document category when ledger sequencing is by ledger or legal entity |
| Allow adjustments to paid invoices | Cancel or add lines to paid invoices, or rematch to a different PO if not finally matched. Distributions still can't be modified. |
| Allow remit-to supplier override for third-party payments | Users can change the remit-to supplier on installments |
| Recalculate invoice installments | Recalculates installments during validation |
| Hold unmatched invoices | Places a Matching Required hold on invoices not matched to a PO or receipt. The supplier site can say Yes, No or Default from Payables Options. |
| Enable invoice account coding workflow | Starts the account coding workflow when an invoice gets a distribution variance hold |
| Prevent deletion of invoice attachments | Attachments can't be deleted after approval or validation |
| Enable duplicate invoice hold during validation | Validation re-evaluates duplicate conditions and releases the duplicate hold when they no longer apply |
| Receipt acceptance days | Days added to the goods received date when installments are recalculated |
| Invoice currency, payment currency, pay group, payment priority, payment terms, terms date basis, pay date basis | Defaults (also available on the supplier) |
| Accounting date basis, budget date basis | Default dates for accounting and budgetary control |
The terms date basis values are Goods received, Invoice, Invoice received and the system (current) date. The pay date basis is Due or Discount. It decides which date a payment process request compares to the pay-through date.
How installments are recalculated
Installments are created at entry from the payment terms and terms date. If Recalculate invoice installments is enabled, validation rebuilds them:
- Start date: the most recent of the invoice date, the terms date and the goods received date plus receipt acceptance days.
- Terms on an unmatched invoice: the invoice's payment terms.
- Terms on a PO-matched invoice: the more favorable of the invoice and PO payment terms, compared by the terms' rank.
- Manual edits win: installments aren't recalculated if a user has manually edited or split them.
- Forced recalculation: installments are recalculated regardless of the option when Exclude tax from calculation is enabled and a user manually changes the tax.
Worked example. An invoice is dated 2 March, matched to a PO, and the goods arrive on 10 March. Receipt acceptance days is 5 and the payment terms are Net 30. Recalculation starts from the latest of 2 March and 15 March (10 March + 5 days), so it uses 15 March. The due date becomes 14 April.
Matching, discount and prepayment options
- Matching: Allow final matching, Allow matching distribution override, Transfer PO distribution additional information, and the default quantity and amount tolerance sets (section 4.1).
- Discounts:
- Exclude tax from calculation and Exclude freight from calculation shrink the discountable amount.
- Always take discount takes the discount whenever you pay.
- Discount allocation method has three values:
- All invoice lines: prorates across all lines. For receipt-accrued PO lines the discount goes to the price variance account.
- Tax lines and single distribution: prorates the tax share across tax lines and sends the rest to the Discount Taken distribution. Not allowed when tax is excluded from the calculation.
- Single distribution: credits the Discount Taken distribution from Common Options. Use it with automatic offsets when you want the discount spread across balancing segments.
- Prepayments:
- Default payment terms for prepayments.
- Settlement days, added to the system date to set the settlement date. A prepayment can't be applied before its settlement date.
- Use distribution from purchase order: the natural account comes from the supplier's prepayment distribution and the other segments from the PO.
- Show available prepayments during invoice entry.
Approval and other options
- Enable invoice approval and Require validation before approval.
- Accounting preference:
- Account regardless of approval status
- Require accounting before approval
- Require approval before accounting
- Allow force approval, used with the Force Approve privilege (section 4.2).
- Interest: create interest invoices, minimum interest amount, and the interest allocation method.
- Payment request defaults and self-service invoice options for Supplier Portal invoices: limit an invoice to one PO, allow backdating, allow unit price changes, require attachment.
Manage Common Options for Payables and Procurement
This page serves invoice and requisitioning business units. It has six groups of options.
Default distributions
| Distribution | Use |
|---|---|
| Liability | Default liability account for new invoices, unless the supplier site assignment has one. It must have the account type Liability. |
| Prepayment | Default prepayment account, unless the site assignment has one |
| Bill payable | Account for future-dated payments, unless the site assignment has one |
| Conversion rate variance gain and loss | Variances on inventory items accrued at receipt (invoice vs PO or receipt rate) |
| Discount taken | Used when the discount allocation method is Single distribution |
| Miscellaneous and freight | For those line types. If blank, the charges are prorated across item lines. |
| Prepayment tax difference | Tax differences between a prepayment and the invoice it is applied to (used when Applied Amount Handling is Recalculate) |
Automatic offsets (offset segments)
Without offsets, an invoice has a single liability entry and a payment a single cash entry, even when the expense lines span several companies. Offset segments has three values:
| Option | Liability line account is built from | Result |
|---|---|---|
| None | The header liability distribution as is | One liability line; cross-company balancing relies on GL intercompany or intracompany rules |
| Primary balancing segment | Balancing segment from the charge distribution, other segments from the liability distribution | Balanced by primary balancing segment |
| All segments, except natural account | Natural account from the liability distribution, all other segments from the charge distribution | Balanced by every segment except the natural account |
Offsets also apply to conversion rate variance, nonrecoverable tax, withholding, and on payments to cash for pooled accounts, discount, realized gain or loss and bills payable. Oracle warns that changing offsets after accounting exists can cause inconsistencies, so decide early. Receiving uses the same option to derive the receiving inspection account.
Other common options
- Currency conversion:
- Require conversion rate entry. Without a rate, foreign-currency invoices can't be accounted or paid. You can run Apply Missing Conversion Rates to fill gaps.
- The default conversion rate type.
- The realized gain and loss distributions.
- The page's currency settings affect invoices. Manage Payment Options affects payments. The conversion rate type is shared by both pages.
- Expense accruals: Accrue expense items at Receipt or at Period end. Inventory items always accrue at receipt.
- Self-billed invoices: gapless numbering and a buying company identifier for pay on receipt.
- Legal entity information: VAT registration member state and number, and the bill-to location.
Invoice options have Recalculate invoice installments enabled and Receipt acceptance days set to 5. A PO-matched invoice is dated 2 March, its terms date is 2 March, goods are received on 10 March, and the terms are Net 30. Nobody edits the installments. What due date does validation produce?
1 April, because recalculation always starts from the invoice date
9 April, because receipt acceptance days are only added to the invoice date
14 April, because the start date is the latest of the dates, which is 15 March
25 April, because acceptance days are added after the 30-day term
A business unit uses automatic offsets with Primary balancing segment. An invoice's header liability distribution is 10-000-2100-000, and its expense lines charge 10-200-6100-000 and 20-300-6100-000. Which liability accounts are created?
One line to 10-000-2100-000 for the full amount
10-000-2100-000 and 20-000-2100-000, each for its line's amount
10-200-2100-000 and 20-300-2100-000, each for its line's amount
10-200-6100-000 and 20-300-6100-000 credited back to the expense accounts
A business unit wants every cash discount credited to one Discount Taken account so that automatic offsets can spread the discount across balancing segments. Which setup does this?
Exclude tax from calculation set to Yes, with discount allocation method All invoice lines
Single distribution, with the Discount Taken distribution in Common Options
Discount allocation method Tax lines and single distribution, with tax excluded from the calculation
Always take discount, with the discount account on the supplier site assignment
Sections you finish are checked off in the contents.