Data Import Export Framework - Financial Dimension 0 does not exists

Views (3599)

dolee

11,279

Like(1)

Report

There *seems* to be a bug in Data Import Export Framework when importing financial dimensions. When importing ledger journal lines I get a "Financial Dimension 0 does not exists" error.
I have made a guess on how it was suppose to work and made some code changes below:

In the DMFDimensionHelper::generateDynamicDimension method, add a new variable for LedgerStructure Table. Then comment out the exists join to ledgerChartOfAccountsStructure and join it with ledgerStructure instead.

                

/*
  exists join ledgerChartOfAccountsStructure where
    ledgerChartOfAccountsStructure.DimensionHierarchy == dimHierarchy.RecId &&
    ledgerChartOfAccountsStructure.ChartOfAccounts == LedgerChartOfAccounts::current()
*/
  exists join ledgerStructure where
    ledgerStructure.DimensionHierarchy == dimHierarchy.RecId &&
    ledgerStructure.Ledger == Ledger::current()
{
    i ++;
    dimAttributeList = conIns(dimAttributeList,i,dimAttribute.Name);
}

Please feel free to comments on the error or this fix.

This posting is provided "AS IS" with no warranties, and confers no rights.

This was originally posted here.