Finance | Project Operations, Human Resources, ...

Make database log in D365FO

(1) Share

Report

Posted on by Dodi

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 237,768 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

NikolajSorensen 1,792 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

But this is not suggestable because it is a transaction table which actually impacts the complete performance. So can you tell us exact requirement?

Was this reply helpful? Yes No