How do I clean the data from the edoc D365 FO invoice cockpit table "EDIVCInvoiceLog"?

Summary

In this article, you will learn how to delete data from the EDIVCInvoiceLog table. Process data is logged in this table and the table can become large if the software is used for a longer period of time. Old data from the EDIVCInvoiceLog table is not required for ongoing operation. You can therefore safely delete the old data from the table.

Important requirements

• Access to Microsoft Dynamics 365 for Finance and Operations with at least read and write permissions.

Solution

Call up the EDIVCInvoiceLog table directly in your browser. Replace the placeholder with the URL of your environment and the D365 FO company (client):

https://<D365FO_path>/?cmp=<Your_D365FO_Company>&mi=SysTableBrowser&TableName=EDIVCInvoiceLog

Use the default filter functions of Dynamics 365 FO to narrow down the data records. Example: by creation date to select only data older than 4 years.

Delete the filtered records.