Record is missing in the Dimension Attribute Value Combination table

Finance and Operations/AX Technical Forum
1

Hi,

For some reason there is no related record in the DimensionAttributeValueCombination table based on the GeneralJournalAccountEntry.LedgerDimension = DimensionAttributeValueCombination.Recid . Not sure how it didn’t create an entry in the DimensionAttributeValueCombination table.

Now I am trying to create a record in the DimensionAttributeValueCombination based on the GeneralJournalAccountEntry.LedgerDimenion.

Is there a class/method that I can use to create the lost record in the DimensionAttributeValueCombination table?

I am trying to use the DimensionServiceProvider::buildDimensionStorageForLedgerAccount() method and it does create an entry in the DimensionAttributeValueCombination table but its Recid is not the same as GeneralJournalAccountEntry.LedgerDimension.

I am missing entries in both the LedgerJournalTrans and the DimensionAttributeValueCombination tables. Anybody have any inputs for me how can recreate the entries in the tables please?

We are on AX 2012 feature pack.

Thanks!