Receivables Invoice Installments

The Receivables Invoice Installments section allows you to manage the payment schedule for an invoice. You can use this section to split an invoice into multiple new installments or update the due dates and amounts of existing installments.

Total Installment Amount Validation & Upload Actions
When adding or modifying installments, the sum of the Original Amount for all installments on an invoice must exactly match the Entered Amount found on the main invoice header.

To successfully pass this validation, the system must calculate the sum of all installments during the upload. Therefore, every installment line must have an upload action. Even if you are not making any changes to an existing installment line, you must still set its Installments Upload Action to Update. If a line is left blank, it will be excluded from the calculation, and your upload will fail.

Simultaneous creation and updating is not supported.
When creating a new invoice, you cannot populate the Installments section at the same time. Attempting to do so will display an error during upload.

Recommendation: First, create the invoice and upload it to Oracle. Once the invoice is successfully created, perform a subsequent upload using the Installments section if you need to change it.

Editable Columns

Only the following columns can be populated or modified. Use these fields to drive the creation or modification of your installments:

Column Name Instructions

Column Name	Instructions
Installments Upload Action	Defines the action to take for the row. Enter `Create` to add a new installment. Enter `Update` to modify an existing installment, or to simply include an unchanged existing installment in the upload.
Sequence	The sequence identifier for the installment. For New Installments: Leave this cell blank. For Existing Installments: This cell must contain the existing sequence number to successfully apply an update or include it in the sum.
Due Date	The date the installment payment is due.
Original Amount	The monetary amount due for this specific installment.

Installments Upload Action

Defines the action to take for the row. Enter Create to add a new installment. Enter Update to modify an existing installment, or to simply include an unchanged existing installment in the upload.

Sequence

The sequence identifier for the installment.
For New Installments: Leave this cell blank.
For Existing Installments: This cell must contain the existing sequence number to successfully apply an update or include it in the sum.

Due Date

The date the installment payment is due.

Original Amount

The monetary amount due for this specific installment.

Read-Only Columns

The spreadsheet also includes several read-only columns. These are retrieved directly from Oracle to provide you with the current status of the installment. These fields cannot be edited:

Installment Status
Amount Paid
Dispute Amount
Dispute Date
Installment Amount Credited
Installment Amount Adjusted
Pending Adjustment Amount
Installment Balance Due
Payment Days Late

Steps to Manage Installments

Locate the Receivables Invoice Installments section in your worksheet.
Identify the installments you need to create or modify.
For completely new installments, set the Installments Upload Action to Create and leave the Sequence blank.
For all existing installments (both those you are changing and those remaining exactly the same), set the Installments Upload Action to Update and ensure the Sequence is populated.
Adjust the Due Date and Original Amount for the required lines.
Double-check that the Original Amount across all listed installments adds up perfectly to the invoice header’s Entered Amount.
Upload the worksheet to apply the changes to Oracle.

Example 1: Updating installments for two invoices

The following example illustrates how to manage installments across two invoices. We are updating one existing installment and creating four new ones for each invoice. As required, the sequence number is populated for the updated row, while the sequence column is left blank for the new rows.

Example 2: Updating a single invoice with a new installment

The example below demonstrates how to add a new installment to a single existing invoice. To ensure the sum of all installments continues to equal the total Entered Amount of the invoice, the original amount on the fifth installment is reduced to accommodate the new row. Notice that the Upload Action for all existing rows is set to Update, even for the first four rows where no changes were made. The new installment row is set to Create with the sequence column left blank.

Example 3: Creating and Updating installments with minimum columns at Header

The example below shows the minimum required columns at Header to complete installments successfully.