Announcements
No record found.
I would like to export invoice data from dynamics 365 F & O from tables custInvoiceJour and custTran. I trying to create a data entity by using custInvoiceJour as my primary data source and getting error "The natural key for the table custInvoiceJour was not found". I need to export invoice information including dates, invoice amounts (invoice total, tax total, discount total, amount open and amount paid).
How can I do that.
Thank you.
To avoid this error you can use workaround of using any existing entity. Duplicate existing entity remove all datasources and code and add your own datasources which are required in your entity.
Data Entity Wizard doesn't support tables without unique indexes or tables with a RecId based primary indexes so you have to use this workaround.
stoneridgesoftware.com/.../
Hi
Please check this which is quite similar to what sukrut aswered,
alexvoy.blogspot.com/.../overcome-natural-key-for-table.html
Uday
You can use the existing entities:
"Sales invoice headers V2" (for CustInvoiceJour)
"Sales invoice lines V2". (for CustInvoiceTrans, not CustTrans!)
Thank you Sukrut
Thank you Uday
Thank you Nikolaos. I would like to get the open amount and also paid amount for the invoices (both CIV and FIV).
These two entities does not return those. That is the reason i am planning for a custom one. Please share if you know any other entities which already does that.
If you need two more pieces of information, I suggest adding them to the existing entities via extension, instead of developing full new entities from scratch.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 609 Super User 2026 Season 1
Giorgio Bonacorsi 561
CP04-islander 383
