web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Duplicate value in vie...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Duplicate value in view "Dimensionattributelevelvalueallview"

(0) ShareShare
ReportReport
Posted on by Pola 182

Hii All,

I'm creating a view that links between eneral journal account entry and dimension attribute value combination and dimension attribute level value all view.

my question is 

I have in table general journal account entry -> ledger dimension "XXXX" for transaction contain (Main account + Cost Center).

what I expect to see in dimension attribute level value all view -> two recorded one for the main account and another for the cost center.

and that what happened in almost all transactions except a few transactions I found the system recorded 4 lines in dimension attribute level value all view -> 2 lines for the main account and 2 lines for the cost center, and the difference between the 2 lines in each dimension is group ordinal field.

can anyone tell me how to avoid the duplicated values!!.

I have the same question (0)
  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi Pola,

    Could you please share the join you are using for this?

    I think you need to join with GeneralJouranalEntry table as well and filter by Ledger field for the current legal entity.

  • Pola Profile Picture
    Pola 182 on at

    I'm joining the GeneralJournalEntry with GeneralJournaclAccountEntry normally.

    GeneralJournalEntry is the first table in my query.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi,

    For the duplicate values that you see, is the GeneralJournalEntry\Ledger value the same?

  • Pola Profile Picture
    Pola 182 on at

    no, just in table dimension attribute level value all view

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Please share your entire query so that we can help you better with this.

  • Pola Profile Picture
    Pola 182 on at

    my query is

    -General Journal Entry. recid == General JournalAccount Entry.generaljournalentry

    -General JournalAccount Entry.ledgerdimension == Dimension Attribute Value Combination.recid

    -Dimension Attribute Value Combination.recid == Dimension Attribute Level Value All View.valuecombinationrecid

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Can you try this query and check the Recid values from both GeneralJournalEntry and GeneralJournalAccountEntry for the duplicate values? Is they are different, that means they are separate entries.

    select generalJournalEntry.RecId, generalJournalAccountEntry.RecId, dimensionAttributeLevelValueAllView.DisplayValue,
from generalJournalEntry
	join generalJournalAccountEntry
		join dimensionAttributeLevelValueAllView
			where dimensionAttributeLevelValueAllView.Valuecombinationrecid == generalJournalAccountEntry.LedgerDimension
			   && generalJournalAccountEntry.generaljournalentry 			== generalJournalEntry.RecId;

  • Pola Profile Picture
    Pola 182 on at

    i tried this query in the same happen,

    also note that the recid is the same in the four lines.

    the issue here is all accounts amounts are very right except one account who showing each line in more than one line in my query, when I validate the records I found that each two lines are the same except the GroupOrdinal field.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Can you try joining DimensionAttribute as well?

    select generalJournalEntry.RecId, generalJournalAccountEntry.RecId, dimensionAttributeLevelValueAllView.DisplayValue,
from generalJournalEntry
	join generalJournalAccountEntry
		join dimensionAttributeLevelValueAllView
			join dimensionAttribute
			where dimensionAttribute.RecId									== dimensionAttributeLevelValueAllView.DimensionAttribute
			   && dimensionAttributeLevelValueAllView.Valuecombinationrecid == generalJournalAccountEntry.LedgerDimension
			   && generalJournalAccountEntry.generaljournalentry 			== generalJournalEntry.RecId;

  • Pola Profile Picture
    Pola 182 on at

    Hi dear,

    I did as you mention the same happen,

    as I see this issue don't relate to the query it is in the standard view itself "dimension attribute level Value All View, this view sees for some ledger dimensions two or three times.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans