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) / Delete a purchase line...
Microsoft Dynamics AX (Archived)

Delete a purchase line, but the record still showing up in the PurchLine table

(0) ShareShare
ReportReport
Posted on by ParkerPeng

Hello everyone:

There is a problem need to help! When I delete a PO line, sometime the record is deleted, but sometimes the record still showing up in the PurchLine table, the IsDelete field populated "Yes".

What's the reason, the purchase line are update:  IsDelete = "Yes"

There are two records in PurchTable form.

But in the DB table, there are 10 records.

 

Thanks!

*This post is locked for comments

  • ParkerPeng Profile Picture
    ParkerPeng on at

    There is no custom function for delete. Thanks!

  • Suggested answer
    Gertjan Profile Picture
    Gertjan 1,200 on at

    Good evening,

    The purchLine is only completely deleted when there is no versioning involved. If versioning is enabled for purchase orders (and you have for example confirmed the purchase order), the purchline has a 'soft delete', leaving the line in the database, but marking it as deleted.

    If you are reporting on the purchLine table directly, you should include a filter on this isDelete field as well. When a line is deleted, the inventory transaction behind the purchase line is always deleted, preventing the purchase order line to be included in your master planning.

    Hope this information helps,

    Gertjan

  • ParkerPeng Profile Picture
    ParkerPeng on at

    Thanks for your help!

    Parker

  • lally Profile Picture
    lally 10 on at

    Hi Gertjan ,

    As you said that if the PO is confimed then it will store PO lines in another tables also , So could i know the all related tables for PO lines .

    Could you share me the all related tables list or share me any link ?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Prashant Singh Profile Picture

Prashant Singh 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans