Database Logging setup - Customer on Hold

(3) Share

Report

Posted on by JB-21051227-0

Hi there,

Is there a way to see who changed a customer's "On hold" status on dynamics 365 finance and operations, i.e. staff 1 put them on hold, staff 2 took them off hold. I understand that the usual go to would be Database Logging, but is this possible, and if so, what module and table would I select?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

Hi @JB-21051227-0,

Yes, it's possible to track who changed a customer's "On hold" status in D365FO, but only if Database Logging was already enabled for that field before the changes happened. Otherwise, D365FO won’t have a history of the changes retroactively.

To Enable or View Logging for It:
Go to: System administration > Setup > Database > Database log

Click "Configure"

Find the table: CustTable

Expand it and select the status field

If it’s already enabled, you can view logs:

Go to: System administration > Inquiries > Database log

Best regrds,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

Another option, without the use of database logging, going forward, you can enable the workflow to streamline any critical changes on the customer master. https://learn.microsoft.com/en-us/dynamics365/finance/accounts-receivable/customer-workflow

But for the past changes, if you did not enable the workflow or database logging, you would not have a good history.

Was this reply helpful? Yes No
Suggested answer

Yng Lih 1,560 on at

Like (3)

Report

Hi,

You try to setup the database log. Below is the guideline:

Tick Show all tables and Show table names.

Under General Ledger, tick CustTable > Blocked

Tick Update

If this information was helpful, kindly mark it as 'Verified'. Thank you. :)

Was this reply helpful? Yes No
JB-21051227-0 53 on at

Like (0)

Report
I appreciated all of you helping me, and I like the idea of the workflow. However, for the logging I only have these options available, naturally with their subsequent tables. Do I select one of these first?

Administration

Asset management

Bank

Case online request configuration key

CIS Payroll

Cost accounting

Country/Regional specific features

Currency

Data import export framework

Data validation checklist

Electronic banking

Email approval

Enterprise Portal

Event

Expense management

Fixed assets

Fixed assets (Russia)

General ledger

General ledger - advanced

General ledger - advanced II

Human resource I

Human resource II

Human resource III

Intercompany

Lean manufacturing

Manufacturing execution

Marketing automation

Master planning

Microsoft Outlook synchronisation

Not specified

Obsolete elements of Vendor Collaboration

Planning Optimisation

Process Distribution

Process manufacturing

Procurement I

Procurement II

Product configuration

Production series I

Production Series II

Production series III

Project

Public sector

Quality management

Questionnaire I

Quotations

Registration employees

Reporting Services

Resources

Retail

Sales and marketing series

Sales management

Sensor Data Intelligence

Service management

Subscription

System

Telemarketing

Time and attendance

Time and attendance payroll

Trade

Trade agreements

Warehouse management I

X++ development

Was this reply helpful? Yes No
Verified answer

Anton Venter 20,345 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

It's under the General Ledger node.

I find it easier to just use the table names.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @JB-21051227-0,

You need to select these two options "show all tables" and "show table names" and then you can search the CustTable Table.

Best regards,

Was this reply helpful? Yes No