Financial Reporter Watermark
Question: I'm trying to insert a 'DRAFT' watermark on some of my reports in Financial Reporter. How do I do this?
Answer: Choose the AdagioPDF or AdagioV2PDF (preferred) printer to print the reports. Enter the watermark as part of the printer properties. You can save the profile so it's easily available after you've got the watermark looking the way you want.
Restore Deleted Invoice Batches
Question: Is there a way to restore cancelled or deleted batches in the Invoice module? From the Batch Audit List I can see that the batches were deleted and I am also able to see the contents in the Deleted Invoice Audit List.
Answer: No, sorry, there is no restore function in Invoices 9.3A. The data structure does not allow it. However, there is a new option in the Security Group: Delete Batch, that can be set to prevent the accidental deletion of batches.
Combining Financial Statements
Question: I'd like to produce combined financial statements from five companies. Most do not have the same chart of accounts, although this is something I'd like to change. How can I do this?
Answer: The module for producing combined financial statements is Adagio FX Pro. To simplify the process of creating the new reports, we recommend using the Toolkit for Adagio to normalize the chart of accounts in the various companies.
Then, moving forward, the entire process of retrieving the general ledger information and producing the statements can be automated.
Adagio FX looks and works just like Adagio Ledger, except you can't post to it, only report from it. A nice thing about FX is that you don't have to re-create the Ledger financial statement specs - they can be ported over to FX.
Also, another nice thing is that when someone uses FX, they are in a COPY of the data, so they can't do any harm and they also can't conflict with other users, particularly if someone needs to run a Data Integrity Check.
GridView Most Recent Record
Question: Is there a way in GridView to summarize a view and get as a result the most recent record for certain columns? For example, from the OE Sales history table, I want to be able to do a Summary Filter and get the most recent Unit Price sold by customer, by item.
Answer
: Create one View that lists all the details, sorted by a composite field called CustItem and a secondary sort DESCENDING on date.
Then create a second View with the same fields except for Unit Price and an identical composite field. This one is sorted and summarized by CustItem. Create a calculated field that pulls the Unit Price from the first View. Because it is sorted Descending, it will pick the most recent Unit Price.
Sort By Batch Number
Question: My GL batches (under Edit Batches) are being sorted alphabetically by description instead of numerical by batch number. How do I get it to sort by batch number?
Answer: The two sorting options should show at the top of the Edit Batches window. Select the radio button for Sort By Batch number.
Print Multiple Batches In Ledger
Question: I used to be able to select multiple batches and do a "Listing" to print them all in one shot. Now when I select more than one batch, "Listing" becomes greyed out. Is there a setting somewhere to change it so that I can print multiple batches in Ledger again?
Answer: It sounds like your batch list is being sorted by Description rather than by Batch number. If it is sorted by Description, then you will see the Listing button disabled when multi-selected batches because there is no guarantee that the batch numbers will be consecutive. Try resetting your batch list to sort by Batch number and the option should be available.
You can find more tips like this in the Softrak Technical Support Forum at
www.softrak.com, by signing into the Client Portal.
|