Workflow Solution

ERP Workflow solution base on Windows Workflow Foundation.

Workflow Designer

Workflow Monitor

Message Syntax

Field Reference:　
Order No: <%SalesOrderEntity.OrderNo%>　
Amount: <%SalesOrderEntity.NetBalAmt%> (<%SalesOrderEntity.Ccy%>)　
Posted By: <%SalesOrderEntity.PostedBy%>　
Posted Date: <%SalesOrderEntity.PostedDate%>　

Loop:　
<%RepeatEachRecord_Begin.SqlQuery2%>　
Line No: <%SqlQuery2.Line_No%>　
Item No: <%SqlQuery2.Item_No%>　
Qty: <%SqlQuery2.Qty%> <%SqlQuery2.Uom%>　
Unit Price: <%SqlQuery2.Price%>　
<%RepeatEachRecord_End.SqlQuery2%>　

Runtime Variable:　
<%SessionEntity.UserId%>　　

SQL Query:　
Select Line_No, Item_No, Qty, Uom, Price from SLORDD Where Order_No = '<%SalesOrderEntity.OrderNo%>' Order By Line_No

Guide

• Run against with SQL Server to create a new workflow database　
• Tracking_Schema.sql Tracking_Logic.sql SqlPersistenceService_Schema.sql SqlPersistenceService_Logic.sql