Understanding the Inbound Multisite Consolidations Process

To successfully upload multisite consolidation information from a non-EnterpriseOne source site to EnterpriseOne, you must create a custom program that provides proper data to fields in the F1001Z1 and F1002Z1 tables. The system processes these tables to create consolidation information in the F1001 and F1002 tables. The field names in these tables correspond to the field names on interactive forms in the JD Edwards EnterpriseOne General Accounting system.

See Mapping Fields for Inbound Multisite Consolidations.

At the target site, when you process the tables by running the Process Inbound Consolidations Data program (R1002Z1), the system reads the F1001Z and F1002Z1 tables and creates records in the F1001 and F1002 tables. If necessary, you can revise existing transactions or add new transactions. You can also purge the F1001Z1 and F1002Z1 tables.

You can run the Process Inbound Consolidations Data program in proof or final mode. In proof mode, the system prints a report that displays the transactions that are written to the F1001 and F1002 tables. In final mode, the system prints the report and writes the transactions to the tables. The system writes error messages to either the work center.

After processing the inbound data, you should run these reports:

• Prior Period Balance Integrity

• UDC Value Control

• Obj/Sub Value Control

• BU/Accounts Monthly Comparison

• Consolidated Balance Sheet

• Consolidated Income Statement

After you process the inbound consolidations and revise them, if necessary, you can generate journal entries for the summarized account balances, verify that they are accurate, and process them.