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

Last updated on MARCH 12, 2021

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version XE and later
Information in this document applies to any platform.

Purpose

Introduction

The Item ASOF (F41112) file contains records As Of each fiscal period for every unique combination of the following:

Branch Plant
Location
Lot
G/L Class Code
Fiscal Year

This file can be used to generate batch and online reporting for records As Of a specific date. It can also be used to store summary information for clients who purge records from the Item Ledger (F4111) file. To accomplish this, the As Of file must exist and a partial generation must be run before purging Item Ledger (F4111) records.

This functionality is used for the following:

Keep accurate balance forward records from year to year.
Compare and reconcile your inventory balance for different fiscal periods.
Access information about the quantity and cost of an item in any location.
Speeds up access to item ledger.

This document provides details on As Of Processing including how to populate the table, updating balance forward records, online inquiries, As Of Reporting and frequently asked questions.