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.
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.
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?
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.
Hi Andre,
If it was for import what would the entity key be?
Would those be enough:
TransId,ParmId,ProjInvocieId,InvocieDate, ProjInvoiceProjId,ProposalId,ProjId?
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.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156