Does anyone perhaps have an idea how to set up a Generic Inquiry that would be sent automatically on a daily basis to specific recipients via email and would include information about Sales Orders—specifically when the ship date was changed, what the previous ship date was, what the updated ship date is, and who made the change?
Please note that Audit History is enabled for Sales Orders.
+20Hi
To achieve this requirement, we would likely need to develop a custom inquiry at the code level. This would involve retrieving data from the relevant audit or change history tables and structuring it appropriately to display:
The user who made the modification
The date and time of the modification
The specific fields that were changed
The old and new values (if required)
A custom development approach would give us more flexibility and allow us to present the information in a structured and user-friendly format.
+9Hi
As
Alternatively, I suggest using a Business Event to monitor the Ship Days and send a notification in real time.
1. Create a generic inquiry based on SOLine. Be sure to include all key fields as well as ShipDate and LastModifiedUser.
2. Create a business event based on the GI and select the trigger condition 'Field Changed' for the ShipDate. Be sure that the ShipDate field is listed on the Tracked fields tab.
3. Create an Email Notification subscription on the business event. In the email notification you can insert the Previous and new values of the ShipDate along with other fields in your email message.
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
