Balance Explanations doesnt allow to load more than 500K records - that too without Merge/Append

Summary:

For an Inventory Account using Account Analysis method, while trying to import balance explanations (which are more than a million each month), the Load rule failed with the error as below -

“Error: The number of rows in the imported file exceeds the limit of 500000. Please split into multiple files to import.”

When we try to load upload, splitting into multiple files, the data is getting replaced for each file.

It seems load rule “Export” Option allows only Replace and not others like Append or Merge. The current scenario is observed while running a file-based integration with Delimited Numeric Data import type.