Optimal Number of Metadata Records to Import

Close Management and Consolidation Sync has been tested for the number of records that can be successfully imported to Financial Consolidation and Close in cloned metadata saved searches. The following table shows the test results per individual entity:

Saved Search Type	Total Number of Imported Records
Item	200,000 parent and child items
Vendor	100,000 parent vendors
Subsidiary	120 parent and child subsidiaries
Location	5,000 parent and child locations
Income Statement Accounts	5,000 parent and child accounts
Balance Sheet Accounts	5,000 parent and child accounts
Class	22,500 parent and child classes
Customer	300,000 parent customers 75,000 parent and child customers
Department	15,000 parent and child departments

Saved Search Type

Total Number of Imported Records

Item

200,000 parent and child items

Vendor

100,000 parent vendors

Subsidiary

120 parent and child subsidiaries

Location

5,000 parent and child locations

Income Statement Accounts

5,000 parent and child accounts

Balance Sheet Accounts

5,000 parent and child accounts

Class

22,500 parent and child classes

Customer

300,000 parent customers

75,000 parent and child customers

Department

15,000 parent and child departments

Note:

The number of records you can successfully import to your Financial Consolidation and Close may differ from these test results. This depends on the total number of records you have in your account and the complexity of your metadata hierarchy.

If you attempt to process more records than listed above, the import may fail. To process more records for an entity, you can skip running the default metadata saved search for that entity. For instructions, see Returning Metadata Hierarchy Based Only on Cloned Saved Search.

Related Topics