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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Orphan record in Inven...
Finance | Project Operations, Human Resources, ...
Answered

Orphan record in Inventtrans table

(0) ShareShare
ReportReport
Posted on by Willem van Duren 230

Good afternoon!

We have a report of an item showing a purchase order in 'Net Requirements' form (ReqTrans), which is actually not there. I debugged it, and it seems to come from an inventory transaction which is on ‘ordered’ statys.

I tried the consistancy check on inventory transactions for this item, but without result. I see that the inventtrans "Ordered" record for this InventtransId is an empty record in the inventtrans table. The two original ones (which are closed and invoiced) are also there:

pastedimage1668788280844v2.png

What can I do in this case? I am thinking:

- I tried in Dev environment to delete the InventTrans record for the orphan line, this works: it is being removed from net requirements. However: I am not sure if this is a risk.

- Report it to Microsoft and ask them for a solution?

Hope someone can help me. Thank you.

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Willem,

    Do you have this issue in your production environment? If so, you will not have direct database access. Is this the sole inventory transaction with this issue or are there more? You can write a runnable class and run the script to delete this record. If you create a deployable package with one runnable class, you can use the custom scripts functionality to get the class imported without downtime. First test it carefully in a staging environment and check if there is any impact or not before doing the same on a production environment.

  • Willem van Duren Profile Picture
    Willem van Duren 230 on at

    Hi Andre! Yes this is the only one. I will create a script to remove it. I am not sure what to test to see if has impact. Do you have suggestions for that?

    I opened the related inventtransId transactions, the net requirements, purchase order, related loads and all seems fine.

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    Try to open a support case on MS.

    If is a Kown issue, they will fix it for you.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Willem,

    In addition, check the on-hand information. The PO was fully invoiced already?

  • Willem van Duren Profile Picture
    Willem van Duren 230 on at

    Hi André,

    On hand look fine. Purchase order is fully invoiced.

    I will remove the invent transaction in production using a script. Thanks for the help!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans