The Workfile to G/L Link Control Report
You use the Workfile to G/L Link Control Report (R48S730) to identify integrity issues between the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) and the G/L Link table (F48S912).
Table F48S912 stores key information from workfile transactions and the subsequent journal entry created in the Account Ledger table (F0911). This table is used for reporting and audit purposes.
You use data selection to specify which records to evaluate.
You should run this report after you have run the Create G/L Entries program (R48198). Any G/L batches that have been created in the JD Edwards EnterpriseOne Contract Billing or Service Billing system that have not been through the Create G/L process might cause discrepancies on the report.
The Workfile to G/L Link Control Report views table F4812 and table F4812H as if they were a single table.
Only revenue-related transactions are processed.
The report groups records in the F4812 and F4812H tables by billing control ID (BCI). The report selects all of the transactions in the F48S912 table that have the same billing control ID and accumulates the amounts from the F48S912 records.
Records that the report identifies as having integrity issues are listed with the appropriate error message on the report.