When looking at the detail listing report, in Adagio Leger, for our bank, where we issue manual cheque batches from, we would like to know why the cheque numbers do not show up. We are not currently using the Bank Reconciliation feature in Adagio, so to do our manual bank reconciliation, we require this information, but we’re unsure how to get it to appear. When we create manual cheques, the cheque number is assigned automatically, so I'm sure that there must be a way to see this, but I know know how to get it.

Thank you!!

Hi Amber,

If you are using the Detail Listing report in Adagio Ledger to look at check-related information, you have to send the check number to the GL reference or description from AP. This is an option you set in the Adagio Payables program and in the Company Profile, on the Integration tab. You can choose from a number of different fields for either the GL Reference, the GL Description and if using Adagio Ledger 90A, a second GL Description. If you have Adagio Payables 81A, you can even select 'user defined' GL descriptions, containing one or more check fields and optional accompanying text.

If you find that one of these integration settings contains the check number (or document number), then this is where you will find the check number within the GL transactions and the Detail Listing report.

If you find that none of these integration fields list the Check number (document number), then this explains why you don't see the information in GL. You need to set this up and that will allow future check postings to update GL. This will not retroactively fix all the GL records that are missing check numbers.

Thank you for the info, but I now have another question. I've added %vnm%dno%ref to show the Vendor name, document number (chq number) and reference number (for audit purposes). When I look at the detail listing now, I'm getting the vendor name and part of the document number, then the reference number below. Is there a way to increase the number of characters that display on the Detail Listing in Adagio Ledger? I will be extremely happy if I can see all three of the items above.

Thank you!
Amber

Hi Amber,

There is a maximum of 40 characters for the GL description. The 3 fields you selected for the User-Defined information exceeds 40 characters, so that is why you see information cut off. You won't be able to get the full text for all 3 fields.

If you are using Adagio Ledger 90A, there are 2 separate GL descriptions of 40 characters each. Perhaps you could send the vendor name to one GL description, and the reference and document number to the other description?

As the Vendor Name is the longest piece of information, it should be listed last in the sequence of information. So instead of what you have, use something like %dno%ref%vnm or %ref%dno%vnm. With either of these, you will get the full reference and document number, and about 15-20 characters of the vendor name, which should be enough to identify the vendor.