E1: 41: Asking For Item Ledger as of Record Generation Program (R41542) To Offer an Option To Populate Item Asof (F41112) Based on Transaction Date From Item Ledger (F4111) (Doc ID 2976063.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

As per E1: 41: As Of Processing (P4111 / P41112 / R41760 / R41540 / R41542) (Doc ID 625402.1), currently:

“The Item ASOF (F41112) file is primarily populated by the Item Ledger As Of Record Generation program (R41542). The Direct As Of Entry (P41112A) can also accomplish this. Item Ledger (F4111) records are included in Item ASOF (F41112) records according to their G/L Date in addition to other keys.”

Asking for Item Ledger As Of Record Generation program (R41542) to offer an option to populate Item ASOF (F41112) based on Transaction Date from Item Ledger (F4111).

Here is the business case:

You can do a Transaction in the past, but cannot post that transaction in closed period.

Let's say we need to do a correction in December 2022.

The GL Date will be in the current month.

Let's say September 2023.

The As Of table will show an incorrect Balance as of December 2022 until now August 2022.

We cannot use the AS OF table, because we cannot trust it.

Therefor we need to create and maintain an AS OF Balance outside JDE.

Changes

Cause

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