Reviewing the Item Ledger/Account Integrity Report
Select Inventory Reports (G41111), Item Ledger/Account Integrity Report.
The Item Ledger/Account Integrity report (R41543) displays these types of discrepancies between the F4111 and F0911 tables:
Item ledger detail records exist with no corresponding general ledger detail records.
Item ledger does not balance with the corresponding general ledger detail.
The report displays summary lines that represent specific totals by:
Document type
Document number
Key company
The report also displays the solutions to the discrepancies. A blank report indicates that no discrepancies exist. You can run this report as many times as needed because no tables are updated.
If you use summarized journal entries for work orders, the program ignores material issue transactions (IM), completions (IC), and scrap transactions (IS) against those summarized work orders because they are not actual work orders.
Certain types of general ledger (GL) batches, such as procurement and sales, require exceptions to the basic program logic that the system uses to create the report. These batches contain multiple types of journal entries that are not appropriate for the report. To ensure that the program selects only the inventory entries, you set up exception rules in UDC table (41/IN). The exception rules must be entered in the Description-1 field for the document types that the organization uses. This table explains the types of exception rules:
Rule |
Description |
|---|---|
Rule 0: Used for Manufacturing Issues of Material |
Exception rule 0 is necessary because the F0911 table uses frozen standard costs and the F4111 table uses the inventory costing method that the user has chosen. If the methods are not the same, set up this code. For documents to which the integrity check applies, this rule ensures that if records exist in the Item Ledger table, they also exist in the Account Ledger table. |
Rule 1: Used for Sales Invoices |
Exception rule 1 is necessary because journal entries such as revenue or loss entries, taxes, freight, and intercompany settlements are written to the Account Ledger table when sales transactions take place. The program checks AAI 4240 from the F4095 table to determine which object accounts to include. The program compares only journal entries with these object accounts in the Account Ledger table to the journal entries in the Item Ledger table. |
Rule 2: Used for Purchase Vouchers |
Exception rule 2 is necessary because journal entries such as favorable or unfavorable price variances, taxes, and freight are written to the Account Ledger table when purchase transactions take place. The program checks AAI items 4330, 4340, and 4350 from the Distribution/Manufacturing - AAI Values table to determine which object accounts to include. The program compares only journal entries with these object accounts in the Account Ledger table to the journal entries in the Item Ledger table. |
Rule 3: Default Rule |
This is the default rule used by all other inventory transactions. If the Document Type is not defined as a Rule 1 or Rule 2 type in 41/IN UDC table, Rule 3 applies. |