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.
I am looking for the correct way to access aging info for each customer in my instance of Sage 50. I currently run a query that pulls info from the customer table (odbc), and am wondering if the aging information is in a separate table, and how to go…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
