Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Can not insert a recor...
Finance forum
Suggested answer

Can not insert a record into Inventory journal lines table

(1) ShareShare
ReportReport
Posted on by Mirza 13
Hello,
 
I get an error message when I try to cancel a credit note.
Error message:
  1. Can not insert a record into Inventory journal lines table
What could be causing this error message?
I am using Dynamics D365 for finance and operations.
 
Thanks,
Mirza
Categories:
Dynamics 365 Administration
  • Suggested answer
    salman ahmad Profile Picture
    salman ahmad 95 on at
    Can not insert a record into Inventory journal lines table
    Hi Mirza it looks like some customization issue you can ask the dev team to debug.

    Further can you please also try to add the Quantity as it seems missing in the warning
  • Mirza Profile Picture
    Mirza 13 on at
    Can not insert a record into Inventory journal lines table
    Hi,
     
    In addition to the error I already sent, the only thing the system gives me is a warning.
    I am sending a full screenshot below.
     
     
    To explain the process to you. I have already posted a credit note. Now I want to cancel it. When I try, I get this error message.
    In the posted credit note, a service item with quantity -1 and list price is used.
     
    Never had this kind of error message.
     
    Thanks,
    Mirza
     
     
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Can not insert a record into Inventory journal lines table
    Hi,
    As Martin said, usually there is not only this one error message, most of the error messages will tell you the reason for the error and even how to fix it. So you can check again if there is only this one error message.
    Can you provide more information (e.g. full error screenshots, system settings, etc.) to help us better solve the problem? At this time, the information you have provided is not sufficient to support us in proposing a solution.
    Best regards,
    Kevin
  • Martin Dráb Profile Picture
    Martin Dráb 228,212 Most Valuable Professional on at
    Can not insert a record into Inventory journal lines table
    Is it the only infolog message and isn't there any link?
     
    By the way, I moved this thread from the Dynamics 365 general forum, because it's about F&O and not D365 in general.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans