Hi
We have an issue where when we import general ledger journal lines into D365 F&O using DMF, the data project job runs successfully. But when we look at the journals in the General ledger forms, some [Account] fields are blank e.g., bank accounts, vendor accounts, customer accounts
Upon investigation, we can see the values are visible in the data entity staging table, but not in the GL journal, for example vendor account record "ABC-VEND-004"
Further investigation led us to the table DimensionDataEntitySFKCache and we can see for these records the field [ResolvedReference] is blank.
More investigation led us to the DimensionAttributeLevelValue and DimensionAttributeValue tables:
It looks like the value "ABC-VEND-004" exists in the [DisplayValue] field of the DimensionAttributeLevelValue table, but the value in the [DimensionAtttributeValue] (a record id) does not exist in the related table DimensionAttributeValue (the [RECID] field). In the Table browser it looks to be blank (see picture), but in the table there is a record id present, but that record id does not exist in DimensionAttributeValue
My questions are:
- Has anyone seen this before?!
- Should there be any "orphaned" records in the DimensionAttributeLevelValue tables (we have lots!)?
- To resolve it, should we add records into the DimensionAttributeValue table?
- Is there another way to resolve? We have tried posting using these records but they have not "fixed" themselves
- Or, am I way off base in my analysis and there is something else going on?!
Many thanks in advance for your assistance!
