Recently, we have added our dimensions to DimensionSetEntity and DimensionCombinationEntity to enable user to enters dimension separately in Excel. For example consider Cost Center dimension. User must be able to enter cost center in excel template for account and offset account. When account or offset account is ledger, dimensions are added to main account correctly after publishing the excel and those related field is remained filled. But when the account or offset account type is not ledger which means needed to enters default dimensions, the values are not saved and not shown in the financial dimensions. Actually after publishing excel these fields become blank. All the things have been applied for DimensionSetEntity is same as DimensionCombinationEnitity. I check account and offset default dimensions, It seems default dimension are not being filled by excel template.
is there any form in D365 which user can enters financial dimension separately in an excel and it works properly?
