Manual Cheque Payments
Question: When entering payments into a "manual" cheque batch, we currently can only use numeric "cheque numbers". However, electronic payments often have alphanumeric reference numbers. Is there any way to enter alphanumeric reference numbers into the cheque number field? We currently either strip all the letters out of the reference number or use a numeric date (03192016) instead.
Answer: Put a check-mark on the "Alpha-numeric manual check numbers" option in the Company Profile.
Custom Reports Sort Order
Question: How can I re-arrange the custom reports that appear under Reports | Custom Reports to be in a different sort order than they currently appear? In other words, what determines the order in which the reports appear?
Answer: The list is ordered by the File Name, but the Report Title (from the Options) is displayed. If you want to change the display order, change the name of the RPT file.
Financial Reporter Formula
Question: How would I structure a formula so that it will give me the balance of an "account+department" if I would like to list the accounts all in one column and the departments separately in one row? Basically I would like to reference the cell the account is in and a separate cell that the department is in to give me an account balance.
Answer: I think GL!DeptRngMerge.sam in the sample data is what you want. While in the Financial Reporter use File | Import Spec and point to the Sample Data folder to import the sample. Then make the changes to match your account and department structure.
Credit Card Reconciliation
Question: When paying my credit card statement as one lump sum at the end of the month through a wire transfer at the bank separate from Adagio, how do I show which invoices were covered by that one lump sum in Adagio?
Answer: Softrak has a document on their Tech Tips page which describes how to set up Adagio Payables, Ledger and BankRec to deal with Credit Cards.
Also, Link2Points is a software solution that does exactly what you are trying to do with identifying the invoices that are paid by whatever credit cards you are using.
Using AMEX as an example, you select the invoices that are paid by a credit card, and they are transferred to the AMEX vendor's account and show up in the originating vendor's account as being paid by AMEX. Then you do your wire transfer to AMEX and pick off the invoices that have the vendor invoice and vendor name on the invoice listing for AMEX as having been paid.
Link2Points integrates seamlessly into Adagio Payables 8.1 and 9.2.
Financial Reporter Fit To Page
Question: Am I doing something wrong? In Financial Reporter page setup, if I tick "Fit rows to 1 pages tall" it completely ignores my page breaks and just puts all 500 rows onto one page. How do I get this setting to work with my page breaks? I find that I'm constantly changing the heights of my rows if I need to add a row in order for my pages to stay as I've set them.
Answer: You are not doing anything wrong. To date, the features for inserting page breaks and fitting pages to a specific size are mutually exclusive and cannot be used together.
The next release of Adagio Ledger with an updated Financial Reporter program will be able to handle both features on the same statement. There is no release date for this upgrade at the current time, but stay tuned!
You can find more tips like this in the Softrak Technical Support Forum at www.softrak.com, by signing into the Client Portal.
|
Adagio Ledger
