Skip to main content
Business Central forum
Answered

Value that cannot be found in the related table while inserting data into Item Journal Line from API using Postman

editSubscribe (0) ShareShare
ReportReport
Posted on by 551

I have developed a custom API Page for Item Journals and I tried to insert data to the Item Journal Line using Postman. There I got the following error

"The field Journal Batch Name of table Item Journal Line contains a value (DEFAULT) that cannot be found in the related table (Item Journal Batch).
pastedimage1670321298536v2.png
Any help would be appreciated
Regards,
Tamilarasu Arunachalam 
  • RE: Value that cannot be found in the related table while inserting data into Item Journal Line from API using Postman

    Hi Manan,

    I already have the value default in the Item Journal Batch table.

    pastedimage1670324288017v1.png

    Anyways Thanks for your help

    Regards,

    Tamilarasu Arunachalam

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,180 Super User on at
    RE: Value that cannot be found in the related table while inserting data into Item Journal Line from API using Postman

    Hi

    means that you must enter the DEFAULT value in the Item Journal Batch table, but it is not present now

    DAniele

  • Verified answer
    Manan_Shah Profile Picture
    Manan_Shah 1,457 on at
    RE: Value that cannot be found in the related table while inserting data into Item Journal Line from API using Postman

    Hi Tamilarasu,

    Please check weather Item Journal Template have batch Name as "DEFAULT". 

    Please follow below steps to check it. 

    1) Search for Item Journal Template. 

    pastedimage1670322846683v1.png

    2) Click on Related then click on Template under it you can find it's Batches. 

    pastedimage1670322912662v2.png

    pastedimage1670322932318v3.png 

    If there is no Batch then you need to create it. As Default. 

    Hope this help. 

    Many Thanks,
    Manan

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans