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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Enable database loggin...
Microsoft Dynamics AX (Archived)

Enable database logging for Purchase Orders

(0) ShareShare
ReportReport
Posted on by Mahmoud Dimassi 415

Hi,

Does anyone know how to enable purchase order header and body lines logging?

What i have done is go to System Administration-->Setup-->Database-->Database Log Setup, and added Procurement I -->"Purchase Requisition" and "Purchase Requisition Lines" with (new trans,update,Delete, and Rename Key). When i create/make changes to the purchase order header or body, the logging is empty. Any advise? Much Appreciated...

*This post is locked for comments

I have the same question (0)
  • Verified answer
    DavidSturt Profile Picture
    DavidSturt 4 on at

    Purchase Requisitions are different than Purchase Orders, and they also use different tables.  Please open the database logging wizard again and click on the 'Show all tables'option.  Then  under 'Trade' select 'Purchase Orders' and 'Purchase Order Lines'.  Then continue through the wizard, similar to the way you did for requisitions.

  • Suggested answer
    Mahmoud Dimassi Profile Picture
    Mahmoud Dimassi 415 on at

    Thanks David,

    That worked for me.

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

    Hi Mahmoud,

    Are you really in the need of this logging? Note that all changes will cause additional records in the database log. Who will look at it? What us the purpose? It is not recommended to have database logging enabled on tables with high volume of data entry. It will be unwieldy to look at changes then.

    You could consider activating Change management instead. This will enable saving each version of a PO confirmation. There is also support to compare PO versions.

  • Mahmoud Dimassi Profile Picture
    Mahmoud Dimassi 415 on at

    Logging is traceability. On many occasions troubleshooting starts with understanding changes and updates that took place. I find the logging in AX is extremely helpfull and usefull.

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

    Hi Mahmoud,

    I do agree database logging can help. It is very suitable for master data and setup tables. Depending on the number of purchase orders and lines, you could get too many records which no one will look at anymore. Also each update action has a new record. Imagine someone enters a PO line. Then updates the discount. 10 minutes later he updates the warehouse, then the vendor calls for an update on the delivery date.... and so on.

    Have you ever considered enabling change management on the purchase orders? This will result in less versions and better support for comparing versions.

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

    By the way.... if the answer from David helped you, please mark his answer, so this thread will get the status answered.

  • Suggested answer
    Danish Ali Profile Picture
    Danish Ali 884 on at

    Absolute agree.

  • Suggested answer
    Kamilabanu Profile Picture
    Kamilabanu 10 on at

    Worked for me

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

News and Announcements

Season of Giving Solutions is Here!

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

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans