Current eMessage > Software Update > November 2018
Software Update
Custom Grid Reports can be a real time-saver
by Julie Riecken, MACC’s Training Support Manager
Some MACC clients have accounts where the network tiers have been disconnected, or USPs have been outdated on those networks, but the account is still active. In the past, it’s been a little tricky to find those “abandoned” accounts. The good news is, we have a suggestion – use the Custom Grid Reports.
First, you’ll want to select the Account Custom Grid Report in the Report Type drop-down. Next, select the fields you want included on the report. I recommend at least Account Number, Full Name, Active Networks, and Active Services. Be sure to select the Active Accounts Only checkbox at the top of the screen. (Note: Active Networks and Active Services may be at the bottom of the list of available fields, unlike the screen shot here.)
Click View to launch the report. Your results will display blanks where there are Active Accounts with no Active Services (such as Account #1441 in the following example), and Active Accounts with no Active Networks or Active Services (such as Account #1450 in the following example).
Export the listing to a .CSV to perform further filtering. You may want to take action on these accounts such as disconnecting the account tier if it is no longer needed.
For additional information, please contact your Software Support Representative.
Article Archive
October 2018
AM tax form processing
July 2018
Drop insert refresher
June 2018
Templates – the sequel
March 2018
Keep your numbers in order
February 2018
Best practices for inventory batch processing
January 2018
Custom Grid Reports
2017 Articles
December 2017
Year-end AM reminders
November 2017
Fall plant cleanup
October 2017
AM tax form processing options
September 2017
Simplify service agreements
July 2017
PSAP Templates Available in CM 17.1
June 2017
A small settings change can be a real lifesaver
May 2017
Am I forgetting something?
March 2017
eBill processing – Keeping Customer Master up-to-date
February 2017
Tips for implementing the new ‘My Time’ feature in Customer Master
January 2017
Get a great start to 2017!
2016 Articles
December 2016
Year-end AM reminders
October 2016
2016 tax form processing options
September 2016
Customizing Customer Master
June 2016
477 Reporting – how to be prepared
January 2016
Get 2016 off to a great start