---
title: "Set up data entry workflow SQL triggers"
slug: "set-up-data-entry-workflow-sql-triggers"
tags: ["Flow", "Data Entry Wokflow", "DEW"]
status: "update"
updated: 2026-07-07T07:09:00Z
published: 2026-07-08T07:54:23Z
canonical: "docs.staedean.com/set-up-data-entry-workflow-sql-triggers"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Set up data entry workflow SQL triggers

You can set up an SQL trigger to start a data entry workflow automatically when a record is inserted or updated in a D365 F&SCM table.

This is especially useful if you have third-party integrations that import data into D365 F&SCM. It ensures that all new or updated data, whether manually entered or imported, follow a structured and controlled validation and approval workflow.

> [!NOTE]
> **Note**
> 
> When a record is inserted or updated in a D365 F&SCM table for which data entry workflow SQL triggering is set up, the table event (Insert or Update) is logged in the Data synchronization log. To start a data entry workflow, you must process the logged table events from the data synchronization log. This processing is done based on the Workflow template SQL trigger assignment.

## Flow diagram

[Embedded content](https://viewer.diagrams.net/?tags=%7B%7D&lightbox=1&highlight=0000ff&edit=_blank&layers=1&nav=1&title=Set%20up%20data%20entry%20workflow%20SQL%20triggers.drawio&dark=auto#R%3Cmxfile%3E%3Cdiagram%20name%3D%22Page-1%22%20id%3D%220%22%3E5Vhbc6s2EP41fuQMBps4j3FOcjKdNE3H00nPU0eGBXQsEBHCl%2F76roQwN9u1SZo20zzE0mp3Jb5vV7swcm%2BT7TdBsvhnHgAbOXawHblfR44zticO%2FijJrpRMPSOIBA2MUi1Y0D%2BhsjTSggaQtxQl50zSrC30eZqCL1syIgTftNVCztq7ZiSCnmDhE9aXvtBAxqX02rZr%2BQPQKJadhYRUukaQxyTgm4bIvRu5t4JzWY6S7S0whV0FS2l3f2R1fy4BqTzHwOkbGB%2B53FVPiyYILE7mm5hKWGTEVysb5BZlsUwYzsY4DCljt5xxoe3cMAwd30d5LgVfQWPF1n%2F7lQpD5aPcfU1YYXZfSCKkkYKQsG0c0zzUN%2BAJSLFDlbgB%2B8SAvKkp8oyocnJl5ru2BTHxEe0d1xjiwMCop7%2FlIH5Z%2FlBR5tiMLIGZY4MSFBn%2BW%2Fz6qAJU0CgCkZc7MJquSkX0FxBJrISkGDaJ4gEl3EfF%2BxykVWRW%2FsqstnnFn9tAwVB7mkvBizSAwIB9GZ9LG1zwhvF5GXOzPnPjLnVOm7r9%2FALucNqg73CGTM7JEBHzZFnkbfQIo1GKY1E%2B11xhQPEOuTHyhAaBcjDXUfPMcyopVwsMwqb%2BY2d5b5dyvfSieTucgOC9PQGfYIMCtMT7NCZphNHjeCRRsZIu80ybeEydOKBrHEZ6uEtJQn20eS1A8yvgtaDiuLGK%2Btr%2BgMtQH0HlCv4gGdrrhotVyPAKHeq1a9hK1pF7f67j97mfJp0gn7WDfH9%2FXRDkvYhOntcz3%2F7p4SpKXl%2B8p1Xwx%2FWDNXZLxxD0Kl8%2F8HkhfKM17VcL9LAwUy5kzCOeEnZXS%2BdY9DK1aqqzism5X4i1vpZUULYvqdrJI%2BdVpP8AKXemMSCF5O3Ua8d7ACEpNGlVSvr4SIrd4zkZ8lTeYwQzhfwDsDUoPbNg9h2Pzby%2FkU7pOfFXkX6WvgKkwY1qRNRhGMlz6mshUvm7AuHLtJp%2BN5joyddta7YzM9MBERGBYco7HH0CGJF03Wb4UCxpUzwg2TUUMk5TmTc8PytBHa0Tux2trtdpPjr6zml9HJQnONP6upMbJR7GqpMee0wGlvT29UZhSFU3PqyWhypJpx9Z2AMCs%2FCSOuH8g4Xd7RT2IU3ZgcJ%2BjNQbzD1M%2FROFxZaQZJg3iiJ8zXhTQ0f0bpZe1ztZ1T7WfhdL8hMdn%2FeRgfGf7vj21807d3xX53R8H%2FZO1Ei1uiW7S4P36jj%2B5o1oOqCt7iE6G9ZbOCd7C2BLvmm2FW%2FuGho1ecm4vxoU980q7PaIe2NZPhfw62GAu58d8Mm%2FBXj1YepSxCefHfFpD%2FHvkF8Aurl2LPuLd5yFTgNYqfAwzOHC3q7P3Ph%2FypzXY%2B6JfyriBr6xep%2BduKsPuuRwWn%2BILgmqv%2Ba7d38B%3C%2Fdiagram%3E%3C%2Fmxfile%3E)

## Related

- [Process data synchronization log - Data Entry Workflow](/process-data-synchronization-log.md)