MPA account distributions not open when creating invoices

Summary:

When our users create multi-line invoices using the spreadsheet upload, many of the Multiperiod Accounting Accrual Account combinations are not open and the row status is then "Insert failed". We then go to Manage Account Combinations and open these distributions up. Is this expected behaviour or are we missing a setting somewhere?

Content (please ensure you mask any confidential information):

The error seems to refer to a validation error but I have checked all of our cross-validation rules and can't see any that would impact this. Does anyone else have this issue?

Version (include the version you are using, if applicable):