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) / Missing Purchase Lines...
Microsoft Dynamics AX (Archived)

Missing Purchase Lines/Items in Form but not on Table

(0) ShareShare
ReportReport
Posted on by blue_dreamer61@yaho... 1,606

Hi,

There are items in the Purchase Orders that are not displaying in the PurchaseTable Form. But when I checked the PurchaseLine table, the item is there. For example, there are 2 items in PO 1234 using the PurchTable Form, but when I look in to the PurchLine Table, there are actually 3 items.

I already removed all customizations in the PurchaseTable form but nothing happened. Where should I start checking? please help.

Thanks!

Chester

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on at

    Hi Wenchester,

    Can you check, if the record exists in InventDim table for the InventDimID assigned in your purchLine table records. This type of behaviour is seen when the tables used on the form data sources are joined and the related records do not exists.

    Hope that helps.

    Regards,

    Rachit Garg

  • blue_dreamer61@yahoo.com Profile Picture
    blue_dreamer61@yaho... 1,606 on at

    Hi Rachit,

                          Yes I tried that before posting to this forum but the InventDim Id assigned to the item exists in the InventDim table. I'll trying other fields missing relation as of the moment.

    Thanks,

    Chester

  • Verified answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on at

    Also worth checking that the field IsDeleted on purchLine is not marked as "true". It should be "false". 

  • blue_dreamer61@yahoo.com Profile Picture
    blue_dreamer61@yaho... 1,606 on at

    Yes, right the item showed when I unchecked the IsDeleted column, but how can I totally delete the item from the PurchLine table? I was trying to delete the item from the released products but I was not able to do so because of dependent Purchase Lines. That's why I really need totally delete the item from the table.

  • Verified answer
    blue_dreamer61@yahoo.com Profile Picture
    blue_dreamer61@yaho... 1,606 on at

    I just found out that you can delete the purchline items in the PurchLine table by deleting its versions first.

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