Entering Individual Transactions

Access the Direct As Of Entry form.

After the system generates the F41112 table, you can review item transaction and balance information for a specific fiscal period on the Work With Direct As Of Entry form. You might have to enter individual transactions if the F41112 table has been purged or if some records were damaged. You can use the R41542 program to enter these transactions.

Important: Enter only those item quantities that actually exist in the Item Ledger table (F4111). If you add entries that do not match records in the F4111 table, the Item Balance/Ledger Integrity report will have errors. In addition, you will not have an adequate audit trail to reconcile any differences.
Fiscal Year

Enter a number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form).

Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 2008, and ends September 30, 2009. The end of the first period is October 31, 2008. Specify the year 08 rather than 09.

Item Number and Location

Enter the item number and location information.

Cumulative Amount

Enter the total amount of all transactions in the item ledger for an item.

If cumulative amounts and quantities for the previous year are in the system, the system displays them after you enter the fiscal year, branch/plant, and item number on Direct As Of Entry form. If the system does not display this information because no balance-forward records exist for the previous year, you can enter them manually. However, any amounts that you enter must match the previous year's totals.

Cumulative Quantity

Enter the cumulative total quantity from all transactions in the item ledger for an item.

Amount

Enter a number that represents the net amount posted during the accounting period. The system uses the accounting periods from the F0010 table. The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last day of the period.