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.
I need to export invoices that are from yesterday's date and the related Sales Order begins with a J.
I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL.
I'm able to get the below SQL…