Enhancements and revisions in Adagio PurchaseOrders 8.1C (2013.05.17)
Note: "PO" refers to Adagio PurchaseOrders 8.1C and "POA" refers to Purchase Orders for Adagio 8.1A/8.1B.
The changes and improvements for Adagio PurchaseOrders (PO) compared to Purchase Orders for Adagio (POA) with this release are significant. To make it easier to review the various changes that have been made, we have grouped them by function in this release note.
General Enhancements
Fully compatible with Windows 7 and 8. All screens are rendered correctly when Aero themes are used.
Standard Adagio "look and feel". Standard generic features, as described below.
Installs the AdagioPDF printer driver.
Supports the features in Adagio ePrint.
Date fields accept just day, or month and day, for faster entry.
Calculator in numeric fields by pressing the "c" key or down arrow in the field.
Excel Direct button added on grids, including the Documents list, vendors and items. (but not sundry vendors and items). It is invoked by Alt-X.
Search on multiple criteria in the smart finder.
Grids and finder have option to show Active records only.
The 'Alphabetically sorted field list' option allows you to sort field lists in the Column Editor for finders, smart finder and Filters, or list in native order, where more important fields tend to be near the top of the list.
The 'Set view for all users' option in the Column Editor allows you to configure grid and finder configuration for all users in one step.
Sizeable screens for Purchase Orders, Receipts, Vendors and Items, etc. allow to add and see more fields on grids.
Added User Preferences, allowing you to set certain options by user that were previously global.
You can now specify a desktop background color, image and/or text constant to display on the Adagio desktop.
The 'Auto-advance smart finder' option controls whether the focus is on the previously found grid entry or on the search criteria field when the smart finder is opened.
Supports Implied Decimal option when entering numeric fields.
The 'Remember report settings?' saves setting for next time the report is printed.
Optional Fields function added to the File menu (although PO does not support them in document entry at this time).
Grids and finders now display translated field values instead of the raw data values.
The Adagio Column Editor is available on all finders and grids, in some cases were this was not implemented in POA.
Column Editor settings are saved by grid, by user, by company database.
Active Users function added.
Help | About dialog now has a 'System Info' tab showing loaded DLLs and their versions.
Adagio menu includes PurchaseOrders so you can open other instances.
The F1 key now launches Help when no windows are open.
New program icon and toolbar buttons.
Link entries have been added in tables in the data dictionary to support GETEXTERNALDATA in GridView for enhanced linking.
Exception errors including Access Violations in the \Softrak\PurchaseOrders\PurchaseOrders.error.log file.
Station Logs maintained for each station (or Remote Desktop Services user), including last date/time Adagio run, Adagio User, last Adagio application run, data path and extension, Windows version, and other OS information such as settings and memory.
The System Status function create a snapshot of detailed information about your Adagio installation and packages it in a zip file.
Links to "what's new" video on the web the first time you open the program after installing or upgrading.
Better support on dual monitor systems, with correct positioning and remembering screen position.
The System Status function (or chksys.exe) supports Purchase Orders, including the List Versions function.
Document Entry
Document Styles and Filters for purchase orders and other documents.
Find vendors by Name and Phone Number when entering purchase orders and other documents.
Find items by Description when entering details on purchase orders and other documents.
You can have multiple documents open, including purchase orders, receipts and requisitions. This also allows you to access other menu functions when entering documents.
From the Open Purchase Orders inquiry grid on the Header screen (opened by clicking the "i" icon beside the vendor field), while entering a purchase order, you can open another existing purchase order for the same vendor.
Transaction Entry Templates (similar to OE) on the Maintenance menu and in Security Groups. Note: use templates instead of security functions found in POA.
Copy of POs and Requisitions can be done from the Document List screen rather than having to open the document and click the Duplicate button.
Print button added to the Edit/Inquiry/History List screens.
The grid showing quantities by Location on the Document Detail screen can be configured with the column editor.
Added warning fields on details, such as *under stocked*, rather than displaying a warning message.
The pop-up windows that appeared during entry have been replaced. For example, the Base Price Info pop-up window that appeared for updating the IC Item base price when the Markup Factor is greater than 1 has been replaced by showing fields on the screen instead. Similar changes have been made for these pop-ups: Re-Order Information, Add To Event Budget? And Allocate to job costing?.
When entering item details on a purchase order, the Item Number field is the first active field so you do not need to tab through the Vendor Type and Vendor Code fields.
Manual proration opened an additional screen of details in POA. Manual proration amounts in PO are entered in the 'Allocated misc.' field on the detail dialog, opened from the details grid.
Posting receipts writes to a label file for use by the IMS LabelPrint product (if it is installed and data for it exists in the Adagio data folder for the company).
Posting
Creates a Ledger 9.0 version batch for retrieval into Ledger. Contains more information for the G/L than the older version batch.
Added a second description field 'Send to G/L description field 2' to the GL interface to send additional fields to the second description field in the Ledger batch and through to posted transactions in the G/L.
Added 'User defined format field 1' and 'User defined format field 1' on the Ledger Interface tab in the Company Profile. This allows you to format the G/L Description fields sent to the G/L using fields from documents in PO.
PO correctly handles invoices for purchase orders with multiple vendors (such as miscellaneous charges for the courier) having different transaction dates. The GL transactions have dates to match the invoices.
Edits / Inquiries (including History)
Company Profile tabs and field positions have been improved and changed extensively from POA. A separate technical tip describes the reorganization.
Copy on most Edit functions, including Sundry Vendors, Sundry Items, Event Budgets, Ship To and Bill Addresses, and Pickup Addresses.
Edit and view Vendor functions now include fields and features added in various Payables upgrades, including: Alerts, email addresses, website, FOB Point, Optional fields, Invoice Number Format, and T5018 fields. Includes new fields for use by Adagio PurchaseOrders: Send Method (Print, Fax, Email), Print Spec, Fax Spec, Email Spec and Email Cover, and 'Receive to location'. The Transactions tab shows current and historical transactions in Payables and PurchaseOrders. The EFT tab has been added (if Adagio EFT is installed).
Edit and View Items functions now include Alerts and Optional fields.
The Document Inquiry function and View in Document Entry include Previous / Next buttons.
The Document Inquiry function includes a tab for Requisitions and the Inquiry menu includes View Requisitions.
The Restore function from History now copies a document to create a new purchase order (in the same way that OE Restore from history works), instead of moving back a collection of documents (PO, receipts and invoices) from History to Current in POA.
The Notes window is now sizeable for vendors and items.
View Items function now supports View with Sales and Costs, and includes the many tabs and fields not available in the Edit Item function in POA.
Custom GridView views on the Inquiry menu.
The Purchase Orders Current and Archived Document grids on the Transactions tab in the Edit and View Vendor functions include documents where the vendor is not the primary vendor on the purchase order. This enhancement was also implemented in Payables 8.1E (2013.01.31). It will be included in a future release of BankRec. Note: in those releases the Transactions tab will no longer show the grids if POA is used rather than PO.
Reports
Added Report Favorites and Report Sets.
Uses the Crystal Reports print engine to print reports.
Supports ModRP and CustomRP, report color, date, default preview zoom factor, default preview window state (full or partial), and other options.
Added an option to close print dialogs after printing reports.
You can set the Document vs. Report default printers separately (in Workstation Options).
Comment lines in report footers.
Set date and time formats separately on report header/footer and details.
Shading of header/footer and subtotals, with control of shade color and luminosity from full color pallet.
Print reports to file in Excel, HTML or Word format. Print reports to PDF file.
The Outstanding Purchase Orders report has been redesigned. In POA, it was similar to the Purchase order/receipt/return Listing. It is now based on details and allows listing only outstanding items on partially received purchase orders.
Added 'Calculate As Of' date to the Outstanding Receipt Invoice List so the report can be backdated. You can list all the purchase orders where the goods have been received but no invoice has yet been received as of a date. This allows you to the reconcile receipts clearing account in the G/L. The receipts clearing account manages goods that have been received but not invoiced, since the receipt of goods adds to the value of on-hand inventory without the offsetting liability in payables.
Added Positive and Negative options to the Outstanding Receipt Invoice List to allow printing just negative Quick Receipts (i.e. returns).
The G/L Transaction report has an option to print the new second description field.
Spec Designer and Print form documents
Uses the Adagio specification designer and standard printing procedures for purchase orders and other documents.
Invoice/Adjustment documents can be printed. Use the specification designer to create them. Templates are included. Sample specifications are included in the sample data.
When printing purchase orders and other documents you can sort lines by Line number, Location/Picking Sequence, or Location/Item Number.
Print purchases orders uses the default Print/Fax/Email specifications, Send Method and Email Cover from the vendor (requires Payables 8.1E or higher).
Uses the Receive To Location from the vendor (Payables 8.1E or higher) to default the Location on the header for the vendor when creating a purchase order. It overrides any Location in the entry template.
Print purchase orders and other documents to file in Text (.txt) or Rich Text (.rtf) format. Print to PDF if Adagio ePrint is installed.
The option 'Use vendor PO' has been added to the PurchaseOrders Printing dialog. Select this option to use the specification from the Payee/PO tab in the vendor to print the purchase order instead of the specification selected on the dialog.
Import/Export
Added Import Sundry Vendors, Sundry Items, Pickup Addresses and Contract Costing functions.
Open Database
The Open dialog options to remember Adagio User Id and Password and default them when logging into Adagio. The saved information is authenticated by the Windows user name. Only that Windows user will be able to log in with the saved credentials.
The Previously Opened list is saved by user rather than globally for all users.
The Open Data screen can be sized horizontally to allow you to see the full data path.
Logon date warning if date > 30 days from Today to help prevent accidentally entering a purchase order with a future date.
Auto-open functions on startup by user.
Auto-process import on startup.
On the Open Database dialog you can now use Alt-B to open the browse and Alt-F (for Favorites) to open the previously opened list.
The number of Previously Opened databases (saved by user) has been increased from 25 to 100.
Data Integrity Check
Application Integrity Check (phase 2) in DataCare.
The DIC checks outstanding Vendor and Job balances when Day End has not been run, whereas POA did not.
There are additional checks that were not done in POA, and rebuilding of new errors reported. Note: Thus PO will likely find errors on a database where POA reported no errors. Errors from additional checks should not be a cause for alarm and can be rebuilt.
Backup
Backup data to vitalEsafe on the internet.
The speed of backup to zip file has been improved by approximately 25% across a LAN and approximately 400% with local data.
Email
Email Covers have a Preview so you can expand codes for a purchase order to see what it will look like.
Day End and Maintenance
The Generate Purchase Orders from IC function supports the Reorder Quantities by Location added in Adagio Inventory 8.1C.
The Generate Purchase Orders from IC function supports Alternate Units of Measure.
Day End is much faster.
POA required all users out of Purchase Orders, Payables and JobCost (if used) before Day End could be processed. Adagio PurchaseOrders allows users to be in those modules. Users can be entering and posting documents, except Invoice/Adjustments.
Integration
Styles on GL Accounts, vendors, items, JobCost Estimates and OE documents in finders require Ledger 9.0D, Payables 8.1C, Inventory 8.1C, JobCost 8.1C and OrderEntry 8.1E or higher versions.
Filters on Edit/View vendors and items (not sundry vendors/items) require Payables 8.1C, Inventory 8.1C or higher versions).
Supports Active flag in Vendors and Items (not sundry vendors/items) when entering purchase orders and other documents, and in the vendor and items functions.
Vendor Code entry respects Adagio Payables’ Company Profile settings for Uppercase, Auto-fill and Vendor Code Format.
PO sample data with Adagio JobCost integration is installed in \softrak\purchaseorders\jcsamdata if you have JobCost installed.
Install
The auto-workstation install is supported (run \softrak\purchaseorders\purchaseorders.exe and workstation install will be started automatically if one is required).
Problems in Purchase Orders for Adagio fixed in Adagio PurchaseOrders
The Generate Purchase Orders function now correctly handles Alternate Units of Measure.
Receipts in POA used the original entry date from the header on the document instead of the receipt date. This caused the Item Valuation report in Inventory to be incorrect when printed backdated.
If the ‘Update base price on entry’ option was selected in the Company Profile, POA only showed the Base Price Info pop-up window if the Markup factor on the item was greater than 1.0. IC Base price information is now displayed on the Document line detail screen. Note also that this feature has been enhanced for Automatic markup so that it always works for IC items, not just when the markup value is a specific value or the discount/markup pricing works a particular way.
Day End in POA created empty an batch in JobCost if there were no JC related documents processed.
Day End in POA did not set batches in JobCost to Ready to Post when this was set to default in the JobCost Company Profile.
The Alternative Price List item was not updated with the cost from a receipt even though the 'Update price list cost price' option was enabled.
Home currency fields in Header/Details/Totals records were using source decimal fields in POA. This caused problems in multi-currency databases for currencies that do not have 2 decimals, such as Yen.
The Exchange Rate could be changed on details for Home Currency vendors, resulting in a corrupt GL batch file that could not be retrieved into Adagio Ledger.