Completing the Contract/Service Billing Postconversion Integrity Checklist

Access these integrity reports from the Billing Control Reports menu (G48S33).

These integrity reports apply to the JD Edwards EnterpriseOne Contract/Service Billing system:

Report Name (Program Number)

Description

Workfile Control Report (R48S710)

This report identifies records in the Billing Detail Workfile table (F4812) that are not correct based on other information within table F4812.

Workfile History Control Report (R48S711)

This report identifies records in the Billing Workfile History table (F4812H) that are not correct based on other information within table F4812H.

G/L Link to Account Ledger Control Report (R48S720)

This report verifies that the information contained in the G/L Link table (F48S912) accurately represents the information that has been written to the Account Ledger table (F0911).

Account Ledger to G/L Link Control Report (R48S721)

This report verifies that each record in the Account Ledger table (F0911) that was created by the revenue process in the Service Billing or JD Edwards EnterpriseOne Contract Billing system has at least one corresponding record in the G/L Link table (F48S912).

Billing Workfile to G/L Link Control Report (R48S730)

This report identifies integrity issues between the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) and the G/L Link table (F48S912).

G/L Link to Billing Workfile Control Report (R48S731)

Prerequisite: Create G/L (R48198).

This report identifies records that are missing from the Billing Detail Workfile table (F4812) and the Billing Workfile History table (F4812H), based on data contained within the G/L Link table (F48S912).

Invoice Summary to Workfile Control Report (R48S751)

This report verifies that the amounts in the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) match the amounts in the Invoice Summary Work File table (F4822).

Invoice Summary to Customer Ledger Control Report (R48S761)

Release 8.10 and above.

This report verifies that the amounts in the Invoice Summary Work File table (F4822) match the amounts in the Customer Ledger table (F03B11).

Customer Ledger to Invoice Summary Control Report (R48S771)

Release 8.10 and above.

This report verifies that each invoice transaction in the Customer Ledger table (F03B11) that originated in the Contract Billing or Service Billing system has at least one corresponding source transaction in the Invoice Summary Work File table (F4822).