DimensionAttributeValueCombination AX 2012 R2- Orphan Records?

(0) Share

Report

Posted on by David Vanechaute

I am seeing records in the table DimensionAttributeValueCombination with a value of 0 for AccountStructure and MainAccount. They show the same DisplayValue as other records in the table with ID's that link to DimensionHierarchy and MainAccount tables by RecId

Example-

AccountStructure DisplayValue LedgerDimensionType MainAccount recVersion Partition RecId

0 65010-CUST- Account 0 1 5,637,144,576 5,637,157,572
5,637,146,890 65010-CUST- Account 5,637,145,577 1 5,637,144,576 5,637,152,843

Should the records with a value of 0 be here and if not, what might of caused it?

Thanks,

David

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Brandon Wiese 17,788 on at

Like (0)

Report

Yes, this is normal as long as the LedgerDimensionType is 0. It should not occur for LedgerDimensionTypes of 1 or 2.

Also, none of those DimensionAttributeValueCombination records should be referenced from any GeneralJournalAccountEntry.LedgerDimension field.

Was this reply helpful? Yes No