Optimal Number of Metadata Records to Import to Profitability and Cost Management
Profitability and Cost Management Sync has been tested for the number of records that can be successfully imported to Profitability and Cost Management 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 |
|
Project |
10,000 parent and child projects |
|
Customer Project |
10,000 parent and child customer projects |
|
Employee |
50,000 parent employees |
The number of records you can successfully import to your Profitability and Cost Management 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 in Profitability and Cost Management Sync.
Related Topics
- Metadata Export to Profitability and Cost Management
- Supported Metadata Saved Searches in Profitability and Cost Management Sync
- Accounts Metadata in Profitability and Cost Management Sync
- Class Metadata in Profitability and Cost Management Sync
- Customer Metadata in Profitability and Cost Management Sync
- Customer Project Metadata in Profitability and Cost Management Sync
- Department Metadata in Profitability and Cost Management Sync
- Employee Metadata in Profitability and Cost Management Sync
- Item Metadata in Profitability and Cost Management Sync
- Location Metadata in Profitability and Cost Management Sync
- Project Metadata in Profitability and Cost Management Sync
- Subsidiary Metadata in Profitability and Cost Management Sync
- Vendor Metadata in Profitability and Cost Management Sync
- Creating the Hierarchy of Metadata in Profitability and Cost Management Sync
- Returning Metadata Hierarchy Based Only on Cloned Saved Search in Profitability and Cost Management Sync
- Account Type Mapping in Profitability and Cost Management Sync
- Item Type Mapping in Profitability and Cost Management Sync