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

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms