web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Movement Journal Trans...
Microsoft Dynamics AX (Archived)

Movement Journal Transactions Stuck

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

A movement journal was deleted but the Net Requirements form still showed records of that journal, thus throwing of the demand. Upon some investigation, I noticed that there was no journal header record in the InventJournalTable, which was correct. However, I noticed orphaned journal line records in the InventJournalTrans table. I deleted those records from the InventJournalTrans table in test, reran master scheduling and noticed that Net Requirement records were gone. 

  • Do you know if this is a known bug when journal lines are not being deleted along with the journal header?
  • Is it ok to remove such orphaned records from InventJournalTrans table and is there anything else that needs to be checked?

Thank you!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,976 Super User 2026 Season 1 on at

    Hi D.,

    I'm not aware of a bug. You could try to reproduce this. Deleting the records from the table InventJournalTrans would be OK using the table browser in AX or using a job (x++ logic). You have to check if related InventTrans and InventTransOrigin records are also deleted or do now have orphaned records. Then also check the current on hand (or InventSum table).

  • Community Member Profile Picture
    Community Member on at

    I went ahead and created a job to clean up records records in InventJournalTrans, InventTransOrigin and InventTrans tables in the reverse order. I'll create another job to check for any other potential orphan records beyond this journal and I'll keep an eye if this problem resurfaces.

    It's possible that something might've happened that interrupted the deletion process as I was able to find only a fraction of records from the original journal.

    Thank you!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans