5 Reviewing Item and Quantity Information
Enter 1 to display quantity in primary units of measure along with quantity in transaction units of measure
1: Print a completion report
Form Name FormID Navigation Usage
Work With Direct As Of Entry
W41112AA As Of Processing (G4122), Direct As Of Entry
Review transactions.
Direct As Of Entry W41112AB On the Work With Direct As Of Entry form, click Add.
W41112A As Of Processing
(G4122), Item Ledger (Running Balance)
Review multiple transactions and balances.
Working with Transaction Records
5.6.5 Updating Balance Forward Records for Inactivity in the Fiscal Year
To include items with no transactions in the current fiscal year in the balance forward records, select As Of Processing (G4122), As Of Updating.
The Item Ledger As Of Record Generation (R41542) program creates records in the Item ASOF File only when a record exists in the Item Ledger table. If no transaction occurs during the year for an item, the system does not create a record in the F4111 table. Therefore, the system does not subsequently create a record in the F41112 table.
To include records of prior year activity, run the As Of Updating (R41548) program after you run the R41542 program. The R41548 program searches for an item record in the Item ASOF File and then determines whether a corresponding record exists for the next year. If a record does not exist for that year, the program inserts a record, carrying forward the cumulative amounts and quantities. The program continues to fill in any gaps until processing is complete for the year that is specified in the processing options.
For example, if the first generation of the F41112 table occurs in 2007 and you specify 2010 in the processing option, the program starts with 2007 balances. If item 1001 had transactions only in 2007, the program creates records for 2008, 2009, and 2010, carrying the 2007 balances forward.
5.6.6 Setting Processing Options for As Of Updating (R41548)
Processing options enable you to specify the default processing for programs and reports.
5.6.6.1 Defaults
1. Year
Enter a four-digit fiscal year (for example, 2008) through which the file is to be
updated. If you leave this processing option blank, the system enter the current year as the default. The R41548 program will not run if you enter an invalid year.
5.6.7 Entering Individual Transactions
Access the Direct As Of Entry form.
Working with Transaction Records
Figure 5–15 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.
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.
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.
Working with Transaction Records
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.
5.6.8 Reviewing Multiple Transactions and Balances
Access the Item Ledger - Running Balance Summary form.
Figure 5–16 Item Ledger - Running Balance Summary form
To review transaction history that is summarized by each fiscal period, you can use the running balance version of the item ledger. The summarized running-balance version enables you to review transaction history by the general ledger date rather than by the transaction date. The system displays the summarized information from the F41112 table only.
You also can review the individual transactions for each fiscal period by accessing each fiscal period's detailed information. The system displays information from the F41112 table and the F4111 table. You can review this information when you are preparing to reconcile the inventory and when you are tracking the original versus the general ledger document type for a transaction.
Ending Period
Enter a user-defined name or remark.
Period Quantity
Future use. The historical quantity, in primary units of measure, on the bill of material.
Cumulative Quantity
Working with Transaction Records
5.6.9 Reviewing the Item Ledger Detail Print Report
Select As Of Processing (G4122), Item Ledger Detail Report.
The Item Ledger Detail Print report (R41540) lists the cumulative transactions from balance forward records prior to the GL date that you select in the processing options.
The GL date that you select is based on the user-defined GL dates that you set up in the processing options.
5.6.10 Setting Processing Options for Item Ledger Detail Print (R41540)
Processing options enable you to specify the default processing for programs and reports.