Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ApplyPrepaymentForAnInvoice

Offsets an invoice balance by allocating available prepayment amounts, updating invoice totals and remaining prepayment balances.

Input

Name Type Description
InvoiceNumber String The unique identifier assigned to a supplier invoice. It is used to track and reference the invoice in the system during processing and payment.
BusinessUnit String The name of the business unit responsible for the invoice. This helps categorize the invoice by organizational segment within the company for reporting and approval purposes.
Supplier String The name of the supplier issuing the invoice. It identifies the external entity from which goods or services were purchased.
PrepaymentInvoiceNumber String The unique identifier for the prepayment invoice associated with the supplier. This invoice serves as a record of advance payments made to the supplier.
InvoiceIncludesPrepaymentFlag Bool A flag indicating whether the invoice includes prepayments. If true, the invoice amount incorporates the prepayment amount and any related taxes, simplifying the reconciliation process.
PrepaymentLineNumber Integer The specific line number on the prepayment invoice that corresponds to the payment being applied. This helps identify the exact prepayment entry for accurate application.
PrepaymentApplicationAmount Decimal The amount of the prepayment to be applied to the supplier invoice. This ensures that the correct portion of the prepayment is credited to the invoice balance.
PrepaymentAccountingDate Date The accounting date used for the prepayment application. This date determines the financial period in which the prepayment is recorded in the accounting system.

Result Set Columns

Name Type Description
Result String The result returned after the execution of the stored procedure. It provides feedback on whether the operation succeeded or failed or whether any errors occurred during processing.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454