Heureka! Your suggestion got me on the right track, it was the date field formatting that was the issue. My date field that was setting the $transaction_date was setup to return Y-m-d, but when setting a date field with update_field it must be in Ymd format. So a simple conversion before update_field did the trick!
Thanks @hube2 for leading me on the right track! 🙂
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users