News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Financial dimension En...

Finance | Project Operations, Human Resources, ...

Unanswered

Financial dimension Entity "FINANCIALDIMENSIONVALUEENTITY" not working properly.

(0) Share

Report

Report

Posted on by Khurshid Wali

922

Hi,

I am facing an issue while trying to retrieve financial Dimension Values for Store Dimension. It is standard and mapped to RetailStore Table.

Here are all the dimensions visible on the DimensionDetails form.

but on Entity only 5 are visible.

I noticed Values appear here after I edit and save the DimensionDetails page. after some debugging, I found that it is not populated on the DimensionattributeValue table in the first place.

What is the standard way to populate the financial dimension tables?

Else I have to use BackingEntity table to get all the possible dimension value.

Regards,

Khurshid Wali

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

Financial dimension Entity "FINANCIALDIMENSIONVALUEENTITY" not working properly.

Hi Khurshid,

I checked an export and noticed the same in an 10.0.35 environment. The DimensionAttributeValue table should not have all dimension value records, only when they are used. For that reason, this entity is only exporting the dimension values when they were actually used.

If you need a data entity with all store values, you can consider creating a custom data entity.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans