[Tracy Yaklyvich, MBA]

??Hi.  Can someone please remind me how to run a trial balance report with non-consecutive account numbers?  Thanks!

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————

[Gerald Buenafe]

Hi Tracy,
I don’t think you can.  It is always a range.

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Barbara Gavron]

,

Will the accounts be the same all the time or will they change frequently? ?If they will stay consistent you could always create a Row Format in MR (and probably most other reporting packages that work with GP) that lists just the accounts you want to see and run one out of there. And the advantage of that would be that it can be easily exported to excel.

If the account numbers change from instance to instance this may not be effective time-wise, but depending on the number of accounts you are querying you could make it work.

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[Sally Diehl]

Tracy ~

I agree with Barbara’s option.  One other possibility is if the accounts share a common segment other than the first segment.  For example is the second segment is Department, and you wish to see all accounts from one department, then using the segment filter on the standard trial balance will produce the report.

Sally?

——————————
Sally Diehl
RSM – Sr. Director, Technology Consulting
sally.diehl@rsmus.com
612.629.9058
Minneapolis, MN
——————————
——————————————-

[Sally Higgins]

Hi – what order are you trying to do them in? You can do an Excel report and put them in the order you’d like.

——————————
Sally Higgins
efs consulting, inc
——————————
——————————————-

[Jennifer Hershberger]

Hi Tracy – 

Your answer is Navigation List! 

If you’re in the financial section, you select the Accounts Navigation List. Once it loads, check the accounts you want for your report. Then click on Reports. Select Print Trial Balance. You’ll then have the option to Include Details, and what year. When you click the Print button, you’ll have the opportunity to print to screen, printer or to a file.

Viola! A trial balance with non-consecutive account numbers. 

Enjoy!

——————————
Jennifer Hershberger
Software Consultant
QCI
Johnston IA
——————————
——————————————-

[Tracy Yaklyvich, MBA]

that’s it Jennifer!  Thanks so much.  ?

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————
——————————————-