Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Make database log in D365FO

(1) ShareShare
ReportReport
Posted on by 73
Hallo,
I have question..
 
i wanna make log every update on table Purchline 
I read people using standard d365fo features like system administration > database log > database sutup > KLIK NEW
 
//
 
 
but I don't know how to see which table I want to log the database in which setup, because there are so many
 
is there any solution to help me? or how do i use this function correctly?
 
 
need advise..
thanks
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    Make database log in D365FO
    But this is not suggestable because it is a transaction table which actually impacts the complete performance. So can you tell us exact requirement?
  • Suggested answer
    NikolajSorensen Profile Picture
    NikolajSorensen 1,730 on at
    Make database log in D365FO
    To enable logging of the purchase order lines, you should enable the below two options as shown and then check in the "Trade" section.
     
     
    In there you will be able to find the "PurchLine" table.
     
     
     
    However I do not recommend setting up database logging on a transactional table such as the purchase order lines.
    This will likely have a performance impact on your D365 environment.
     
    It of course depends on the volume of transactions, but overall I am very hesistant to implement database logging on transactional tables.
    Make sure you approach this with caution, testing and monitoring.
  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    Make database log in D365FO
    Hi Dodi,
     
    I think its based on the configuration key mentioned on the table. Identify the label given for the configuration key.
    For PurchLine table configuration key will be Trade - So under Trade you can find the PurchLine table.
    Also, on the bottom you have two check boxes - "Show all table " and "Show table names" - Check both this to see the table names.
     
    Thanks,
    Girish S.
     
     
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,900 Most Valuable Professional on at
    Make database log in D365FO
    Notice the message on the top - the system is telling you what to do. You must press Clean up log button and set up a periodic job to delete old logs.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans