FAQs When Reversing Joint Venture Distributions

Why does the Create Invoices for Joint Venture Distribution Reversals process end in error when creating credit memos?

One possible cause is that the accounting date is earlier than the original invoice accounting date. Credit memos and debit memos must use an accounting date that's the same as or later than the accounting date on the original invoice. If you enter an earlier accounting date when running the process, it can't create the credit memos or debit memos.

Rerun the process using an accounting date on or after the original invoice accounting date. For more information about the Accounting Date and Transaction Date parameters, see Prepare Reversed Distributions for the Creation of Credit Memos.

Another likely cause is that the Import AutoInvoice process produced errors in the generated credit memos. Therefore, the process to update credit memo information in the reversed distributions couldn't update the data, resulting in the affected reversed distributions being set to Error status.

The issue is most likely caused by an incorrect accounting date, which is used in the sequence of processes to create credit memos as described in the following table:

Process	How the accounting date is used
Create Invoices for Joint Venture Distribution Reversals	For the Accounting Date parameter, users must enter a date that is the same as or later than the accounting date on the original invoices. If not entered, the last day of the current open period is used. This date is sent to Receivables for the credit memos.
Import AutoInvoice	For the Default Date parameter, although it’s required to enter a date to run the process, this date is ignored for joint venture credit memos. Instead, Import AutoInvoice uses the Accounting Date from the Create Invoices for Joint Venture Distribution Reversals process. The AutoInvoice process produces errors in the generated credit memos if the resulting date is earlier than the original invoice accounting date.
Update Receivables Credit Memo Information in Distributions	Updates the reversed distributions only after a credit memo is created. If the credit memos are in error, this process changes the affected distributions to Error status.

To resolve this issue:

1. In the Billing work area, select the Manage AutoInvoice Lines task and use the spreadsheet to update the accounting date for the affected credit memo lines. You must enter a date that is the same as or later than the accounting date of the original invoice.
2. Resubmit the Import AutoInvoice process.
3. Confirm that the import lines were processed without errors and that the credit memos were created.
4. Rerun the Process Joint Venture Adjustments process in the Update Receivables Credit Memo Information in Distributions mode. Set Process Distributions in Error to Yes.