Enhancements and revisions in Adagio Receivables 9.1A (2013.06.06)
New Features
Adagio ePrint users can view a PDF of invoices and credit notes from the transactions grid in the Edit/View Customer function. The documents open in the new Adagio PDF viewer. The PDF can be sized and zoomed. Clicking the next transaction in the grid opens it in the same viewer window.
Adagio ePrint users can attach unpaid invoices when emailing, faxing or printing statements from the Print Statements function or when editing individual customers. When emailing, invoices are attached as PDFs. When faxing, they are appended to the end of the fax. When printing, the statement is printed, followed by the invoices.
You can attach a PDF document, such as a promotional offer or product literature, when emailing, faxing or printing statements or dunning letters from the Print Statements / Letters function or from the edit customer function when sending a statement. For statements or letters in the email queue, you can attach other types of documents as well, such as Word or Excel. Attachments are shown in a tree view on the Edit Email Entry dialog. Right-click on the tree to add a document. Default folders for attachments can be specified in new fields 'Attachments statements folder' and 'Attachments letters folder' added on the Statement / Reports tab in the Company Profile. These folders are relative to the ePrint relative folder path (or to the data folder if ePrint is not installed). The defaults are \Attachments\Statements and \Attachments\Letters.
The email queue grid can now show the total number of attachment files. The fax queue grid can now show total the number of pages in the fax.
You can now create a Favorite report for the Print Statements/Letters function. This is useful for saving options when attaching paid invoices or other documents to statements or letters.
You can now create a Favorite report for posting journals even when there are none on file to print. Added 'Last sequence only' option to print dialog for all posting journals. This option is remembered for Favorites and is useful when printing posting journals from a Report Set. Added 'Clear posting journals' option for posting journal Favorites in Report Sets.
You can now create a Favorite report for batch listings even when there are no batches on file. When printing the Favorite directly or within a Report Set it defaults to the entire range of batches.
Added Specific Due Date terms. Allows you set the due date to any date in the future. Adagio OrderEntry 8.1E (2013.03.22) or higher supports Specific Due Date terms. A future release of Adagio Invoices will support the Specific Due Date terms. Note: Specific Date Terms should not be used in until you have installed the OrderEntry and/or Invoices versions that support it, otherwise Due Date and Discount Date will not be correct in those modules.
Added Tax Group and Tax Status to the customer defaults in the Company Profile.
Added 'Oldest unpaid invoice date' field to the customer for use in filters. It is updated by the Calc Customer Aging function. The value written is the document date of the invoice, regardless of whether the function was done by Document Date or Due Date.
Supports the Auto-fill GL account and department options in Ledger 9.1A. Supports Uppercase and Auto-fill Vendor options in the 'Payables vendor' field on the Accounting tab in the customer.
Added the batch description to the window title of the batch entry grid window. Also added the description to the entry dialog window title. This helps you keep your place when entering transactions.
The Spacebar now toggles the Ready to Post status on the batch grid.
Added the option 'Don't show this message again' on the confirming message when batches are set Ready to Post, or Not Ready to Post.
The Posting Sequence field is now one of the default fields on the Batch Status Inquiry grid.
Added support for Job and Estimate styles in finders for Adagio JobCost users.
If Receivables is integrated with Adagio JobCost at the Phase-Category level, the finder and smart finder for Job Estimates can now show the customer in the grid so you can see which jobs belong to which customers.
Added %DST code for the User Defined format to send the Distribution Code to G/L Description 1 or G/L Description 2, set on the Integration tab in the Company Profile. If the Distribution Code is blank, then a blank is sent to the description. If Adagio JobCost is integrated the job number is used.
Added the option 'Allow deletion of customers with history?' on the System Options tab in the Company Profile. It is enabled by default.
Added the option 'Show description 2' to the Print/Consolidate GL Transactions report. Transactions with a second description take 2 lines on the report.
If the 'Clear transaction detail by' option in the Company Profile is set to 'Period End', when a Report Set containing a Favorite to print statements is printed, the question 'Update Billing Cycles and Customer printed dates? is automatically answered Yes. If the option is set to 'Billing Cycle', the question 'Clear all paid transactions in the range specified?' is always answered No.
Added 3 new expansion codes for Report Favorite filenames for Adagio ePrint users: %CMP (company name), %CNO (company number), and %EXT (data extension).
General New Features
New splash screen with an updated look.
The Data Integrity Check (DIC) now checks the Common Files as well as the AR files. Previously these files were only checked by DataCare.
In earlier releases of Adagio we added the ability for Excel Direct to create a CSV file for use by other spreadsheet applications, such as Apache OpenOfficeTM Calc, for sites that did not have Excel installed. The spreadsheet program was launched and opened the CSV file created. Excel Direct can now use Windows "automation" (inter-process communication) to send data to other spreadsheet applications, the same way it interfaces to Excel, allowing all formatting to be retained in the resulting sheet. OpenOffice 3.3 or later and LibreOffice® 3.3 or later are supported. This interface must be manually enabled. The file SSI2XL.INI must exist in \softrak\system and must contain the section [Initialization] with an entry <computer name>-UseOpenOffice=1, where <computer name> is the name of the machine that this entry references. Refer to the Readme Help for further details.
A 'Report set' button has been added to the toolbar.
The Help | About function now has a Consultant tab showing the contact information for your Adagio consultant if they have enabled this option at your site.
The Open Data screen can be sized horizontally to allow you to see the full data path.
The F1 key now launches Help when no windows are open.
Problems Fixed
When the 'Auto print posting journal after post' option is enabled, if an error batch was created when you posted, the Print Posting Journal report dialog did not automatically appear.
Posting an unapplied Debit Note to a Balance Forward customer who has a negative total balance caused an integrity error.
Entering a Due Date earlier than Invoice Date is prevented in batch entry.
Corrected a problem with deleting a distribution of unapplied cash (UP) entries in a cash batch if there was CA transaction in the grid.
When integrated with Adagio Time&Billing, if you entered an invoice for a customer with Billing Method set to 'By File' for which no Files (Dockets) had been created yet for the customer, you could not save or cancel the batch entry.
When you Find a customer by Document Number, the finder and smart finder have been improved when there are duplicate document numbers for different customers.
Customer names containing '&' displayed with '&&' in batch grids.
The transaction grid in Edit Customer now correctly sorts misdated transactions, where a date was accidentally entered in the year 2020 or beyond.
Location codes in Adagio Inventory and OrderEntry can only be uppercase. Edit Customer and Customer Ship to was not forcing the field to uppercase.
When Adagio Time&Billing is integrated, the Import Customers function now allows the Billing Method field to be changed on an existing customer with outstanding transactions, as editing the customer allows this.
When adding a Ship To address in a customer, the Tax Group is defaulted from the customer. A Ship To can be saved without a Tax Group.
The 'Print 0 balance customers' option on the Aged Trial Balance report did not include all applicable Balance Forward customers with zero balance.
Transactions posted in Adagio Invoices did not print on the GL Transactions report if Adagio Ledger data was not present.
After converting to Receivables 9.0C and if Adagio Ledger data was not present, depending on the version you converted from, if you printed the GL Transaction report there was an error and the report did not print. If a batch was posted after conversion, the report printed and contained the new transactions but transactions from posting in the earlier version did not appear on the report.
Customers with an extended character (example: É) in the name and thus the short name, did not print on reports in some cases.
The Edit Report Sets menu choice was missing in Security Groups.
Codes embedded in Report Favorites (such as %USR for User) were not being saved in some cases.
If ‘Clear transaction detail’ is by ‘Billing cycle’ and Statements were printed and transactions were cleared for an earlier date than the last ‘Transaction last cleared’ date or, if ‘Clear transaction detail’ is by ‘Period end’ and a Period End was done for an earlier date than the ‘Date of Last Period End’, there may be transactions in History that are dated after the new ‘Transaction last cleared date’/ ‘Date of Last Period End’. They will not be included in backdated aging reports that are dated after the new ‘Transaction last cleared’/’Date of Last Period End’. If you do this same set of steps with 9.1A, the ‘Transactions last cleared’/’Date of Last Period end’ will not be set to an earlier date.
If the Last Year End date was non-blank in the Company Profile, when running Year End this date was the default for Transaction Clearing Date, for clearing completed transactions from current to history, rather than the sign-on date or the last period end date. . If this occurred, the backdated Aged Trial and statements may not include prior period Transactions. And there will be transactions in history that are dated after the ‘Transactions last cleared’/’Date of Last Period end’ date.
Corrected a problem with the Time fields when importing customer notes if the time format was "h:mm".
The error 'Floating point division by zero' occurred if you imported an Excel file that has a header row but with no data (rows).
When exporting customers by Account Set, Billing Cycle or Report Group the section range did not work correctly. Exporting by range of customer was not a problem.
The default width of the 'Inv email' field in customer import template was 30 instead of 160.
The Alt-X key (vs. clicking the Excel Direct button) exported the grid contents to Excel even if user security prevented it.
When recurring charges have been generated to the Maximum Amount specified in the customer, the Create Recurring Charge Batch function no longer generates a zero dollar invoice.
Installing the Adagio SalesAnalysis 9.0B (2013.01.26) Service Pack caused a problem using the smart finder for customers in Adagio SalesCQ. In the event this happened, installing this release of Receivables corrects the problem.
When creating a new multi-currency database or when enabling multi-currency for a single currency database, you are forced to enter a Default Rate Type. This prevents problems retrieving batches in Ledger if the a Rate Type was not set. Note: this means new sites (and for new databases) must run the Adagio MultiCurrency program first and set up a least one Rate Type before creating a Receivables database. This should be done anyway to add a home currency with code that meaningfully matches your currency, such as CAD or USD.
Installs an updated version of the Adagio Data Source (ADS) that corrects the OpLocks Setting shown in station log files <computer name>.log in \Softrak\System\StationLogs. It was reported as Enabled instead of Disabled in some cases.