Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

How to write data to VendInvoiceJourHeaders using web api or postman?

Posted on by 10

I am using postman to create a record in VendInvoiceJourHeader in D365 but getting following error. 

 : "message": "Write failed for table row of type 'KT_VendInvoiceJourEntity'. Infolog: Warning: Matching record for the read only data source 'VendInvoiceJour' does not exist." 

When I talked with the D365 consultant in the office , he replied following message to me.

"From the application point of view, the Vendor invoice journal tables are not supposed to be written by systems outside of D365. The records created were resulted from posting an AP invoice which is a process triggered within D365.Hence it is not a surprise that you can’t write to this table through OData."

I have a buiness need where in both VendInvoiceJourHeader  and VendInvoiceJourLines recods needs to be inserted using a web api. 

Can anyone explain what is missing here/what exactly needs to be done inorder to export data into D365 > VendInvoiceJourHeader  and VendInvoiceJourLines

  • Nalini Profile Picture
    Nalini 10 on at
    RE: How to write data to VendInvoiceJourHeaders using web api or postman?

    Sorry, I am new to this platform so was not fully aware where I can choose forum on the form. Thank you for adding the screenshot. 

    In D365 UI I see "Finance and Operations"  and URL to access is xxxxxx-ut2.sandbox.operations.dynamics.com/

    Main issue is still there.. I need to create a record in both VendInvoiceJourHeaders and VendInvoiceJourLines using a web api but it gives following error. 

     : "message": "Write failed for table row of type 'KT_VendInvoiceJourEntity'. Infolog: Warning: Matching record for the read only data source 'VendInvoiceJour' does not exist." 

    Thanks

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator on at
    RE: How to write data to VendInvoiceJourHeaders using web api or postman?

    Hi Nalini,

    You created the question in the dynamic CRM form. I do not think it should be there. Are you facing the issue in the Dynamic 365 Customer Engemebnt or in the Power Platform?

    pastedimage1671325001501v1.png

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans