Has anyone used a view other than External_Invent_Part_Issue_Pub or Internal_Invent_Part_Issue_Pub to define a Base Flow. We would like to use something like CUSTOMER_ORDER_JOIN_CFV to utilize some custom fields. To date I have not managed to use any view other than those suggested in the Base Flow wizard. Any comments most welcome.
Solved
Demand Planner - Base Flows
+2Best answer by Jur
This is the rather simple query,, the most logic is applied in the IAL (e.g.: district/sales code in this case). It’s important that the selected fields are in this order. If you need any other filters etc, you must use the groups.
This topic has been closed for comments
We are using an custom IAL as for our Base Flows. This allows us to define each field (site, part_no, date, qty) exactly how we want it, and include our historic data in addition to the data in IFS. You are able to change the SQL statement yourself as long as the queried fields are in the correct order.
+2Your reply has lifted my spirits that a solution to my issue is possible. Would you be prepared to send me your SQL statement for a Base Flow definition that uses an IAL just for clarity. Finally is your IAL live data or replicated daily, weekly etc.
Thank you so much for your response
This is the rather simple query,, the most logic is applied in the IAL (e.g.: district/sales code in this case). It’s important that the selected fields are in this order. If you need any other filters etc, you must use the groups.
+7A common and effective solution!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.