Welcome to the Sage 50 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.
Hi all,
I need to write a query to pull all AP invoices that are currently open. Writing the SQL is no problem, but I don't really know which tables I should be looking in or what criteria I should be using for my WHERE clause.
Can anyone get…