Finance | Project Operations, Human Resources, ...

Export Invoice data from Dynamics 365 F & O

(0) Share

Report

Posted on by Finance and operation

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.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

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/.../

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi

Please check this which is quite similar to what sukrut aswered,

alexvoy.blogspot.com/.../overcome-natural-key-for-table.html

Uday

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can use the existing entities:

"Sales invoice headers V2" (for CustInvoiceJour)

"Sales invoice lines V2". (for CustInvoiceTrans, not CustTrans!)

Was this reply helpful? Yes No
Finance and operation 10 on at

Like (0)

Report

Thank you Sukrut

Was this reply helpful? Yes No
Finance and operation 10 on at

Like (0)

Report

Thank you Uday

Was this reply helpful? Yes No
Finance and operation 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No