Receivables Invoice Installment Creation Using a REST API

Create Receivables invoice installments using the Receivables Invoices REST API. This feature enhances flexibility for users to automate the installment creation process, and adapt payment schedules to customer needs.

Use the new custom action splitinstallments in the Receivables Invoices REST API to create and manage the Receivables invoice installments.

Steps to create or update invoice installments:

1. Use Get a Receivables Invoice REST API
   • to find the invoice for which you want to create new installment.
   • to find the sequence number and installment ID of the installments for which you want to make an update.
2. Use the custom action splitInstallments
   • to create a new installment.
   • to update installment amount and due date of existing installments.

Business benefits include:

• Increases finance team efficiency by reducing manual intervention in managing invoice installment schedules.
• Allows faster customer response and improved payment flexibility.
• Increases the flexibility in managing the invoice installments through extensions.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

• You can create or update invoice installments in the following scenarios:
  • invoice is in ledger or foreign currency
  • invoice is accounted or not
  • invoice is printed or not
  • invoice is partially paid or fully unpaid
  • receipt is unapplied
  • credit memo is applied or unapplied
  • an adjustment is applied to an invoice
  • a dispute is created and approved on the invoice
  • collection strategy is run
  • promise is created against the installment
  • notes are created for the installment
  •  
• You can't create or update invoice installments if
  • the profile option AR_UPDATE_DUE_DATE is set to No
  • the invoice isn't complete
  • the invoice is in pending approval status
  • the invoice is selected for automatic receipt batch and the batch is pending approval
  • the invoice is part of a balance forward bill
  • the invoice is included in a bill receivable
  • an adjustment on the installment is pending approval
  • a dispute on the invoice is pending approval
  • the invoice installment is closed
• Key considerations
  • You can't update the installment amount to be less than the amount that's already been applied to it.
  • You must create a new installment with an amount greater than zero.
  • You can update the amount of an existing installment to zero.
  • You can't update the due date or amount of a closed installment.
  • You can't delete an installment.
  • You can update the due date to a date that's on or after the transaction date.
  • The sum of the installment amounts must equal the transaction amount.
  • The open promises in Advanced Collections on the updated installment will be automatically cancelled once an existing installment is updated.

Key resources

• Refer to the following documentation on how to find an invoice using REST API:
  • Get a receivables invoice section of REST API for Oracle Fusion Cloud Financials on how to query an invoice.
  • Find Invoices that are Overdue section of REST API for Oracle Fusion Cloud Financials on how to find overdue invoices.
• Based on Idea 761967 from Receivables and Collections Idea Lab on Oracle Cloud Customer Connect.

Access requirements

No new access requirements.