BeyondERP.Newsletter
Menu

Inquiry page · Sales and marketing

Transaction log

An inquiry page that lists the changes the Sales and marketing transaction log recorded on the tables selected for tracking: who changed a record, when, and whether it was created, updated or deleted.

Business process
Manage system compliance
Menu item
smmTransLog
Main table
smmTransLog
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that lists the changes the Sales and marketing transaction log recorded on the tables selected for tracking: who changed a record, when, and whether it was created, updated or deleted.
What you do hereUse it to answer who changed a tracked Sales and marketing record and when. Microsoft marked this transaction log as deprecated in Dynamics AX 2012, giving as the reason that CRM uses the database logging that is available, so use Database log for new auditing requirements.
ExampleFor example, BEAT's sales manager asks who changed a record of a tracked table last week. The log, filtered on 01.11.2026 to 07.11.2026 and worker Jodie Strand, shows one Update entry on 04.11.2026 at 14:32 with the record's reference number, so the manager knows whom to ask.
Transaction log page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage system compliance
Menu pathSales and marketing › Inquiries and reports › History › Transaction log
Set up firstSales and marketing parameters (Transaction log tab) Microsoft Learn
Used next byDatabase log setup Microsoft Learn
Related pagesDatabase log cleanup Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Read the Sales and marketing transaction log

Find who changed a tracked Sales and marketing record and when.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > History > Transaction log.
  2. Set From date time and To date time to the period you are investigating, or select Show all when you don't know when the change happened.
  3. Choose the Worker who may have made the change, then read Log type, Action and Reference number to find the record.
  4. Open the General tab of the entry to see the primary and secondary description and the reference date of the record.
  5. If the record you expected is missing, check on the Transaction log tab of Sales and marketing parameters that its table is selected under Track changes for and that Days to keep log covers the date.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From date timeStart of the period whose log entries are shown.Checked in Dynamics 36501.11.2026 00:00
To date timeEnd of the period whose log entries are shown.Checked in Dynamics 36507.11.2026 23:59
Show allShows every log entry instead of the date and time range.Checked in Dynamics 365
WorkerLimits the list to the changes made by one worker.Checked in Dynamics 365
Log typeThe tracked table the change belongs to.Checked in Dynamics 365
ActionWhat happened to the record: a new transaction, an update or a delete, the three actions the log can track.Microsoft Learn
Reference numberThe number of the changed record.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The change you are looking for is not in the list.Logging only covers the tables selected under Track changes for and the actions selected under Options on the Transaction log tab of Sales and marketing parameters, and entries are only shown for the number of days in Days to keep log. Select the table and action, then repeat the change. Microsoft Learn
Auditors ask for a change history of a table that isn't in the transaction log.Set up database logging for that table or field with the Logging database changes wizard in Database log setup. Microsoft Learn

Test checklist

  1. In Sales and marketing parameters, on the Transaction log tab, confirm that one table is selected under Track changes for and Track updated transactions is on.
  2. Change one field on a record of that table.
  3. Open Transaction log, set the period to today and your worker.
  4. Check that exactly one Update entry with the record's reference number is listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Read the Sales and marketing transaction logSet the date and time range and the worker first; select Show all only when the period is unknown.The log can be long because every tracked create, update and delete is written to it; a period and a worker narrow it to the change you are looking for.Which change history should BEAT rely on for Sales and marketing records?Reading an empty result as 'nobody changed it'. The record's table may not be selected under Track changes for, or the entry may be older than Days to keep log.Test: Transaction log records an update

Feature management and licence

Licence or add-inOn the live system, Sales manager, Rental manager, Rental coordinator agent, Accounts receivable clerk and Accounts receivable manager use this page; 48 roles can open it in total. No Feature management feature is needed to open it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own log entries and its own transaction log settings in Sales and marketing parameters. Microsoft data model
Can it be undoneReversible: The inquiry changes no data. Turning logging on or off is done in Sales and marketing parameters and can be reversed there. Microsoft Learn
If you change it laterWhat the log contains depends on the Transaction log tab of Sales and marketing parameters: the tables under Track changes for, the actions under Options and Days to keep log. A table you add starts logging from that moment; earlier changes are not recorded. Microsoft Learn
Technical architect

6Technical

Menu itemsmmTransLog Checked in Dynamics 365
FormsmmTransLog Checked in Dynamics 365
TablesmmTransLogShown as “Transaction log” in Record infoKey field: LogDateTime, LogType, LogAction, RefNum, PrimaryDescription, SecondaryDescription, RefDateChecked in Dynamics 365
Roles to set it up and use itTo set it up or change itAuditor AuditPolicyManagerTo use itSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerGive people one of these roles. On this system, 48 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=smmTransLog
Data migrationLoad order: Transaction log has no data entity in Data management. No standard entity is backed by its table (smmTransLog). The entries are written by the system when tracked records change, so there is nothing to migrate; keep the old system's history in an archive if auditors need it.Load first: Transaction log settings in Sales and marketing parametersChecked in Dynamics 365
Table definitionsmmTransLog columns and relations Microsoft data model
Everyone

8Sources