Hi I had a question about the program. We post in detail to the GL. Since our last GL update, on the bank account number the checks are in alphabetical order instead of by check number order. Is there a way we can change it so that the order is by check number instead of alphabetical.

Hello jhenry,

Have you made any changes with your Payroll program? I believe that the g/l transactions are sorted by account/ department / fiscal period / date / reference. Have you changed the fields you are sending from Payroll to the G/L? or the order in which they're being sent?

My sort order is Account, department, fiscal period, source code, date, description. I am not sure if the order was changed when we got the last update. Is there a way that the sort order can be changed?

I'm not asking about the payroll account. I am asking about the general checking account. When I print out a detail listing of the GL, the order it prints out is in alphabetical. It used to print out in order by check number before I got the lastest update sent by your company.

Hello jhenry:

In one of the Updates to Ledger, we added the ability to choose the sort order of the Detail List. The report always sorts in account / department / fiscal period order. After that though, you can choose to sort on description, date, reference or source code. Perhaps this is the change you've noticed?

Hello jhenry:

I understand that you are looking for a list of the checks that have been generated by payroll. Normally the check number will be in the Reference field of the Ledger transaction.

Does that help?

How do we change the sort options?

Hello jhenry:

Assuming you are running Adagio Ledger 6.8B (020619), then you change the Detail Listing sort options in the drop-down lists in the group titled "Within fiscal period sort by" on the Print Detail Listing dialog.

Does that help?

Hi jhenry

To further clarify the other suggestions...

To change the options when printing the Adagio Ledger Detailed listing, after selecting the report you will be taken to the 'Print Detail Listing' print options screen. In the 'Within Fiscal Period sort by' section, you can choose to sort by 3 different criteria: Source Code, Date, Description and Reference. Your second and third 'sort by' options will change depending on what you have chosen for your first sort.

In your case, it sounds like sorting first by Reference or Description field would give you the results you are seeking.

If this does not give you what you are looking for, what Andrew was suggesting in his earlier posts is to check the settings in the program that is generating the checks to see if perhaps someone has changed what is getting sent to the GL Reference and/or Description fields. In each 'sub-ledger' module's Company Profile, there is usually an option to 'Send to G/L' for the reference and description fields.

In Adagio Payables for example, this option is found in the Company Profile|Integration screen. In 'Send to G/L reference field' you can send:

Vendor Name, Document description, Document number (i.e. Check number) and Document reference (this could also contain the check number - it depends on what you enter in your original AP transactions).

For the 'Send to G/L description field', you have the same choices as above.

You can also choose to 'Include batch in G/L description', which would show up on your detailed listing as well.

If you are still having difficulties, please do not hesitate to post another response here.

Regards,