AR Customer Collection Status Mass Change

From time to time, the Bursar’s Accounts Receivable team asks for a mass change to Customer’s Collection statuses. When this happens, they provide a spreadsheet with the customer numbers, new collection status codes, and other information. See the attachment(s) to this page. One is an excel SQL template which, when populated correctly, will automatically create the SQL required to update the Customer file. Note that such changes must be approved (by email is usually ok) by the manager/supervisor of AR prior to the changes being run in Production. The SQL script should be tested in a test environment and the results reviewed and approved by AR personnel. Once tested and approved, the script can be run in Production via the Script Runner process.