Are you or your small team charged with managing GP for an organization with lots of GP companies and similar tasks daily, weekly or monthly? If you’re performing the same task more than once (ok twice) there’s opportunity for automation because you have better things to do with your time! I’m the sole admin for 49 GP databases and I’ll show you how I use SQL to automagically open the GP fiscal period for a new month, run an automatic daily AR aging process and more across our entire GP enterprise.
Participants will learn how to:
1.Create a SQL process to automatically open the new fiscal period for one or more GP companies;
2.Use SQL to automatically ‘age’ all accounts receivable customers daily;
3.Automatically generate an AR Aging and email it as an attachment directly from SQL
This session is geared for an audience with an intermediate skill set.
This session will be available for CPE credits pending completion of session survey post event.