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 / Microsoft Dynamics AX (Archived) / Purchase Order Fully R...
Microsoft Dynamics AX (Archived)

Purchase Order Fully Receipted But Items Still Appearing in Net Requirements

(0) ShareShare
ReportReport
Posted on by feelyd 260

HI ,

I have a Purchase order which is closed off, and the delivery remainder is zero, but for one of the items the quantity is still appearing in the NET requirements.

This is one example it's also happening on a number of sales orders.

Would like to get rid of the requirements, is there a update or script which anyone has , to remove the net requirments ?

Thanks in advance,

*This post is locked for comments

I have the same question (0)
  • feelyd Profile Picture
    feelyd 260 on at

    Going into this a bit deeper it looks like the following

    1. PO line created (stock transaction created in the background) InventTrans/InventTransOrigin

    2. PO line was Confirmed

    3. PO line was the deleted after

    4. Stock Transaction looks like it was left in the background tables  InventTrans/InventTransOrigin

    So even though the PO has been fully receipted , the InventTrans entry is still open.

    That is why it's appearing on master planning

    So it looks like the table needs cleaned up in the background (InventTrans/InventTransOrigin)

  • fatihgork Profile Picture
    fatihgork 3,817 on at

    Hi D Feely,

    Have you seen that record actually in InventTransOrigin and InventTrans tables?

    I know it exists still in PurchLine even though you delete the line after you confirm it once, it just flags it as deleted when you delete a confirmed PO line.

  • Verified answer
    feelyd Profile Picture
    feelyd 260 on at

    yes it exists in both the Invent Trans tables, just looks like something went wrong with the integrity of the data.

    I have manually removed the invent trans records and now the master planning jobs are behaving correctly

    So all good.

    Thanks for you replies.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans