Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
oy vey, I thought I knew this sort of software well but I was clearly wrong....
I'm using 2 queries in an event like below.
First Query - gets a list of new orders that contains CustomerNo and the email address of the user who created the orders…