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 / Microsoft Dynamics AX (Archived) / BP Error: Fields with ...
Microsoft Dynamics AX (Archived)

BP Error: Fields with 'LedgerDimension' in name should have relationship to the 'LedgerDimensionBase' table

(0) ShareShare
ReportReport
Posted on by Sagnik Majumder 792

Hello all,

I had created a data entity in D365 FO and corresponding Staging table was also generated. But when I compiled it, it gave me a Best Practice error:-

C:\AOSService\PackagesLocalDirectory\...\SomeDemoStaging.xml(0,0): BPErrorDimensionNameDAVCRelation: BP Rule: [BPErrorDimensionNameDAVCRelation]:Path [dynamics://Table/SomeDemoStaging/TableFieldInt64/LedgerDimension]:
BPErrorDimensionNameDAVCRelation: Fields with 'LedgerDimension' in name should have relationship
to the 'LedgerDimensionBase' table.

I found out that I do have a Int64 field named 'LedgerDimension' whose EDT is 'DimensionDynamicAccount'.

Now how can I resolve this BP error?

I tried searching in the community and I found this thread with an opposite problem, but has no solution.

Please suggest.

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,976 Most Valuable Professional on at

    Hi Sagnik, please pay attention to what you set as tags (= categories) for your questions. "Fields with 'LedgerDimension' in name should have relationship to the 'LedgerDimensionBase' table" is very specific, it isn't a good name for a category of questions.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 237,976 Most Valuable Professional on at

    The fist question you should ask is if you really want LedgerDimension already in the staging table, or it should be generated by the entity when putting data from staging to target (by LedgerDimensionDynamicAccountSetBasedResolver). You can look at how it's handled by LedgerJournalEntity.

  • Sagnik Majumder Profile Picture
    Sagnik Majumder 792 on at

    Hi Martin,

    I will look after the tags in the future for sure.

    Now, regarding your suggestion, I dont understand why I need to look into the Staging table. I haven't created it. I have created only the Data Entity. The staging table and the two Privileges are created automatically. I have no LedgerDimension field in my DataEntity and I dont even know why its there in the Staging table.

    I have gone through LedgerJournalEntity and its 'copyCustomStagingToTarget' method.

    Frankly, I am not willing to write this whole method in my data entity because I dont think I need so much and I dont want to care about Staging table. As long as my data entity fetches and creates records, I am fine and happy with it. What do you suggest?

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,976 Most Valuable Professional on at

    The staging table is created if you tell the wizard to create it for you. If you don't want it, don't enable data management features.

  • Sagnik Majumder Profile Picture
    Sagnik Majumder 792 on at

    Yes you are right. I need Staging table only if I need Document management features (Asynchronous integration / DIXF). As i am using only OData services (Synchronous integration), hence I wont be needing the Staging tables.

    I have now created a new DataEntity without Staging tables; all Best Practice errors are gone and it works perfectly as well...

    Thanks!!

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans