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

Find out who cancelled PO

(0) ShareShare
ReportReport
Posted on by 1,559

Hi Friends,

A PO was approved, then cancelled, how can we find out who cancelled PO?

Is there an event logged somewhere? There is no modifiedby field in PurchTable.

Many thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    guk1964 Profile Picture
    10,888 on at

    In Dynamics AX AOS for a table there are  fields like ModifiedBy and ModifiedDateTime - these are system field and can  be enabled for the table. 

    You could activate change control

    Or add an if condition into the validate writing method in the form data source to capture e.g. a reason code or user id

    Or enforce digital signature

    Or set security to limit who can delete , or who can access which orders

    You could also try to restore the order https://sangeethwiki.blogspot.ae/2017/05/recover-deleted-purchase-order-in-ax.html#!/2017/05/recover-deleted-purchase-order-in-ax.html 

    However I suspect this is Ax 2009 code i.e.pre- PO change control.

    Use database log. I am generally averse to using this but for  a rare event like PO delete it  makes sense but limit it to that event only. You can then view when a user does delete a PO  from the AX table SysDatabaseLogas  which has column for Username.deleted_po_1

    .........

  • Ganriver1 Profile Picture
    1,559 on at

    Thanks Magic1949!

    For future, we certainly will look into your suggestion.

    For now, is there a way to find out? PO was going through a workflow, it's approved before deleted.

    We are on AX 2012 R3.

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