R12: AP: How is GL Date for an Invoice Cancellation Calculated? (Doc ID 1959443.1)

Last updated on MAY 12, 2022

Applies to:

Goal

Why is the GL date for cancellation not the same as the original invoice date?

For example:

INVOICE CREATION: an invoice is created on 06-JAN-2012, with all the distribution lines showing the GL/AP date of 06-JAN-2012. 

INVOICE PAYMENT: the payment for the invoice was made on 03-FEB-2012.

  Both Jan-12 and Feb-12 periods are open in the AP and GL calendars.  In addition, all of the periods from Jul-13 are open in the AP and GL calendars.

INVOICE PAYMENT VOIDED: the payment is voided using Payments > Entry > Payments.  While voiding the payment, the user gave the Payment date and Payment GL date as the original Payment date - 03-FEB-2012

CALENDAR PERIOD CLOSED: the FEB-12 Period was then closed in the GL and AP calendars, which left the Jan-12 period open, along with the periods from Jul-13 open in the AP and GL calendars.

INVOICE CANCELLED: after the payment was voided, the invoice was cancelled. The cancelled GL Date associated with the invoice is now 01-Jul-2013, instead of the original Invoice Date of 06-JAN-2012.  Why?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.