Cross-posted in the TNEW group:
The "CustomerNotes" generated by TNEW aren't always used, but when they are they almost always contain items that should be actioned. However, I don't yet have a good way to report on only those web orders that contain customer notes (Single Sale Order Listing includes all web orders whether or not notes exist). I've submitted an enhancement request, but want to put some functionality in place on my site ASAP.
Is there a web order post-hook local procedure I can use for this? I wasn't able to find one, but to me this would be the most elegant solution -- create a stored procedure that runs after an order is saved that checks the notes field and creates a CSI if it was in use.
If there is no built-in post-hook functionality, then I guess I'm stuck with a maintenance job or regularly-scheduled utility report. It looks like I would just have to add a row to T_CUST_ACTIVITY while being mindful of the T_NEXT_ID entry used for that table. Can anyone see an issue with that, or better yet, has anyone done something like this already that they would care to share?
Hi Nick,
Take a look at the stored procedure LWP_VALIDATE_CART. You can execute this at certain points in the TNEW cart life cycle by configuring the system table LTR_TNEW_VALIDATE_CART.
You could also use a transaction service interceptor.
Cheers,
Patrick.
I did know about LWP_VALIDATE_CART, but it's not clear to me how I would set a "validation point" for after the order has been paid/saved. Is that a possibility?
There was an enhancement request a while back to add a validate point after the cart is saved, but it was never adopted. A service interceptor would almost certainly do the trick though.