The Audit trail function

The Audit trail function in the voucher transaction inquiry form fetches the transaction entries posted in the general ledger and reports. It gives the facility to show who posted the transaction, when, and from which document type. The following screenshot shows the Audit trail option of Microsoft Dynamics 365 for Finance and Operations:

There is a creation date and time that represents the actual date when the transaction was posted. However, this is not the financial posting date, which may be different from the creation date and time.

The main source of the transactions is the transaction database. The transactions are replicated to the cube database or database warehouse every night at midnight. The report information is then pulled out from the cube DB and the DB warehouse. If we are on July 1, the report will get information till the end of July. Let's assume that on July 1, a user posts a transaction dated June 30.

If we run the report again on July 1, which pulls information from cube DB, it will not consider the posted transaction on June 30 since it is not considered in the replication. It will be included with effect from the next replication, which will take place on July 2 at midnight.