Process CPQ Cloud Orders Using AutoInvoice

Oracle CPQ Cloud integrates with the Receivables Invoice Service to create and process Receivables transactions from CPQ Cloud orders using AutoInvoice.

The quote-to-cash process includes these related operations in Receivables:

  • Perform a credit check on the customer order.

  • Create and transfer order lines to the AutoInvoice interface tables.

  • Generate transactions using AutoInvoice.

  • Generate credit memos using AutoInvoice for returns and canceled orders.

Customer Credit Check

If applicable, verify that the customer account has sufficient credit to cover the order. If the credit authorization is granted, then you can create and transfer order lines.

Create and Transfer Order Lines

Once the necessary credit authorization is received and the order is finalized, you can submit the order to Receivables for invoicing using the Receivables Invoice Service.

You can submit these orders:

  • Order lines with payment terms.

  • Order lines for goods, services or subscriptions.

  • One-time or recurring order lines.

    A recurring order line includes the billing frequency (for example, monthly or quarterly), the amount to bill for each billing period, and either the transaction start and end dates or the number of transaction periods. The Receivables Invoice Service populates the AutoInvoice interface table with the number of invoice lines necessary to satisfy the details of the recurring order.

Generate Transactions

Run the Import AutoInvoice program to create transactions according to your billing business requirements.

AutoInvoice and CPQ Cloud process order lines in this way:

  1. AutoInvoice selects all eligible transaction lines and groups them into transactions according to the assigned grouping rule.

  2. After successful creation of transactions, AutoInvoice notifies the CPQ Cloud callback service.

  3. CPQ Cloud updates the status and invoice information of the applicable order lines.

  4. Transaction lines that fail validation remain in the AutoInvoice interface tables. Use the AutoInvoice workbook to correct errors and resubmit AutoInvoice.

Create and Generate Credit Memos

If necessary, you can cancel an existing order. Canceling an order generates a call to the Receivables Invoice Service with a credit memo request. This creates credit memo lines in the AutoInvoice interface tables for the corresponding invoice lines.

When canceling a recurring invoice:

  1. Issue a credit memo line with identifiers for the order and order line to identify the applicable invoices in Receivables.

  2. The Receivables Invoice Service updates the recurring bill plan information to indicate the order is canceled.

  3. Run the Import AutoInvoice program to create and apply credit memos to the invoices already created in Receivables.

  4. The Receivables Invoice Service deletes future-dated invoice lines from the interface tables according to the effective cancellation date.