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

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Entity key for project...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Entity key for project invocies

(0) ShareShare
ReportReport
Posted on by junior AX 1,552

Hi,

I want to be able to export project invoices(I want to export lines so that I don't do a composite entity)

I created a new entity and made the main datasource is ProjInvocieOnAcc and it's inner joined ProjInvocieJour 

And ProjInvoiceJour is inner joined with PSAProjProposalJour

But what should the entity key be in this case..it seems nothing is unique in all of these tables.

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,663 Super User 2026 Season 1 on at

    Hi Junior AX,

    If you use a data entity for export only, the entity key is not important. You can choose any field or combination of fields. The entity key is used during import to find an already existing record or create a new one.

    Ensure the data entity will be set to read only and choose your own field(s) for the entity key.

  • junior AX Profile Picture
    junior AX 1,552 on at

    Hi Andre,

    If it was for import what would the entity key be?

    Would those be enough:

    TransId,ParmId,ProjInvocieId,InvocieDate, ProjInvoiceProjId,ProposalId,ProjId?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,663 Super User 2026 Season 1 on at

    Hi Junior AX,

    You can't import directly in the invoice journal tables. Besides, if you have multiple tables with their own unique indexes, you must create a data entity per table.

  • junior AX Profile Picture
    junior AX 1,552 on at

    Hi Andre,

    Why I can't import directly to invoice journal?

    And When u say "if I have multiple tables with their own unique index then I need to create a data entity per table"...do you mean I can't create a single entity with tables joined with each other? Do you mean I need to create a single entity with entities inside it? Or did I miss understand your statement?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,663 Super User 2026 Season 1 on at

    Your initial question was about exporting the data. You shouldn't attempt to import data directly in transaction tables using Data management. You should import in worksheet tables, like the invoice proposal and then post the invoice.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 679 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 332 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 238 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans