Accredo A80 – Version 8.0.14.101

---

New Feature

ALL - All Modules

Encrypt all string fields at rest.

Note: Backups increase in size approximately 5-fold due to loss of empty space in stored strings.

Context (right click) menu for Filter / Sort for Grids with Column glyph indicating if a filter and/or sort is applied.

From Column Headers, available in List Grids and Live Edit grids.

Add Field to Filter

Clear Field from Filter

Open Filter/Sort

Clear All Filters

Sort Ascending

Sort Descending

Clear Sort

From Field in Grid, available in List Grids only.

Add Value to Filter, for numeric values operator defaults to ±

Clear Value from Filter

Note: This is also available for List Grids in FD forms automatically if Filter is available

Add Calculate Totals button (shortcut Alt+=) to list grid toolbars. Calculates totals for numeric grid columns where Total is selected in grid customisations. Totals can be toggled on/off and the GridTotalled state is recorded for List Views.

Added a Grid Total Row colour Preference under View > Preferences > Colour, default is light green.

Totals for List grid can be accessed in MaxBasic via a GetTotalValue(FieldName: String): Number method on the grid sub object when GridTotalled is true.

AP - Accounts Payable

Add ability to Hide Transactions in AR and AP where the transactions Contra and are Unallocated. Hidden transactions are marked Inactive, excluded from Statement printing, and hidden by default in Transaction Lists.

AR - Accounts Receivable

Add ability to Hide Transactions in AR and AP where the transactions Contra and are Unallocated. Hidden transactions are marked Inactive, excluded from Statement printing, and hidden by default in Transaction Lists.

FD - Form Designer

Grid totalling support added for List Grids in FD.

IC - Inventory Control

In subscription systems, Manufacturing and in Saturn Warehouse Management (bin tracked locations) are not part of the base Inventory Control Module, they are available as IC Extensions.

To support this change there is a new Allow IC Manufacturing setting, it is unselected by default for new IC modules and disabled in subscription modules unless the IC Manufacturing Extension is installed. For perpetual IC modules converting from V7 (or earlier) this setting will be selected.

Unselecting the setting will remove manufacturing parts and set component mode to None for diminishing products, and delete any manufacture batches. Kitset components for non-diminishing products are not affected. Manufacturing options are removed from the navigator.

The bin tracked selection for IC Locations is not available in subscription modules if the Warehouse Management extension is not installed.

MB - Max Basic

Added SystemAnyPresent(ModuleCodes) MaxBasic function and SystemAnyPresent WS EndPoint. May be used to check for presence of a module at the system level. See help for documentation.

SYS - System

Add support for Subscription systems, modules and users.

Add Build and System status indicators to Status bar.

Build status indicator (left of build number):

Green tick - current SHP build,

Yellow warning - an update is available

Red x - communication failure.

System status indicator (right of build number):

Green tick - Perpetual Licence or > 14 days to subscription expiry.

Yellow alarm - for subscription modules, users or systems with expiry pending within 14 days.

Red x - Communication failure.

Build status

Up to date

Update available: (xxx) (date)

Error (xxx)

System status

Perpetual

Current (date)

Expiring (date)

Expired (date)

Error (xxx)

Added Mobile App Extensions (Mobile Sales, Mobile Stock) which must be present in a system with WS for the V8 (or later) Accredo Sales and Accredo Stock apps to connect. For existing perpetual systems with WS these are available on request with the V8 upgrade, thereafter available on subscription. This allows us to track usage of the apps and provides a revenue stream for improving them.

WS - Web Service

Added SystemAnyPresent(ModuleCodes) MaxBasic function and SystemAnyPresent WS EndPoint. May be used to check for presence of a module at the system level. See help for documentation.

System and Company About endpoints now return the subscription expiry and last accessed dates.

 

Improvement

ALL - All Modules

Added optional Recurrence for Reminders.

When selecting visible fields in report layouts or grid customisations, Sort fields and Apply or Apply and Save will sort to the top in selection order.

Added Close Other Tabs/Windows option. In Tabbed View, right click the Tab to keep and select Close Other Tabs. In Window View or Classic Maximised view Alt+- or click the "hamburger" icon in the top left hand corner to access the System menu and select Close Other Windows.

Index Memo files by TargetUserCode.

Add signature key to Company datasets to prevent accessing files from another dataset by copying or restoring into a company.

Complete datasets can be rekeyed to make them uniquely keyed from the Company Maintenance form toolbar, datasets containing mixed keys can be rekeyed on application with authorisation via an unlock code obtained from Accredo.

Add support for Time Zones for Created and Modified DateTime. Created and Modified Date and Time fields are converted into DateTime fields and stored as UTC. Calculated Created Date, Created Time, Modified Date and Modified Time return values in Local Time.

Add options when dismissing a Reminder to either inactivate the reminder or convert it to a memo. Added a User Preference for Dismiss Reminder to allow a default behaviour to be set.

Make Customer Name, Product Description, Job Name etc available to customise into Transaction Lists.

AP - Accounts Payable

Add Supplier Cost Basis to AP Creditor with options for Supplier Cost / Supplier Standard Cost. Data conversion populates according to the current AP Setting which becomes the default for new Creditors.

Surface Report Totals Only Option to runtime selections dialog. No change to scripted property.

Warn on Close of Generated AP Payments if Electronic Payments Summary has not been Exported .

Add Unallocated selection to AR and AP Transaction List form.

Added Trading Name to Company Details, AR Customer and AP Creditor. Included in Customer and Creditor Word lookup fields by default. Example documents updated to include Trading Name if it has a value.

Hide AR Customer Balances and Graph tabs when user has None permission for Customer > Balances, Customer > Budgets and Customer > Sales.

Hide AP Creditor Balances and Graph tabs when user has None permission for Creditor > Balances and Creditor > Budgets.

Add Amount Due to AP Payments Due report, Unallocated Amount less Hold Amount if any. Visible by default

AR - Accounts Receivable

Add/Edit Rule button added to AR Customer Form > Banking/Delivery tab if CB is present.

Add Unallocated selection to AR and AP Transaction List form.

Added Trading Name to Company Details, AR Customer and AP Creditor. Included in Customer and Creditor Word lookup fields by default. Example documents updated to include Trading Name if it has a value.

Hide AR Customer Balances and Graph tabs when user has None permission for Customer > Balances, Customer > Budgets and Customer > Sales.

Hide AP Creditor Balances and Graph tabs when user has None permission for Creditor > Balances and Creditor > Budgets.

CB - Cash Book

Save Rule match values preferentially to Match 1, then Match 2 etc for ease of filtering/sorting in Rules list. e.g. if Rule is entered with values for Match2, 3 or 4 only they will save out to Match1.

CB Rules List improvements, Rule selection is now a check list box. Separate (mutually exclusive) selections for Customer, Creditor, Analysis Code and Transfer To with scripting backwards compatibility.

Add/Edit Rule button added to AR Customer Form > Banking/Delivery tab if CB is present.

Open on Default Bank Code in the Bank Account Maintenance form.

Add 'Unreconciled' as a selection to CB Transaction List.

CO - Company

Add ModuleCode field and index to COCTLOG for Settings tracking.

Update Country Names and Currency Codes for ISO changes.

Change COUser and SYUser tables to use new SMTPServerUsername domain char 120.

Saturn Only

Add Company Settings for Special Characters for Branch and Department Codes, and IC Settings for Special Characters for Location Codes. Defaults for new systems are A-Z, 0 to 9 are the only valid characters. Data conversion populates with any Special Characters currently in use. Note that the following characters , - ? * can not be selected as Special characters for Branch or Department codes since they conflict with GL Financial Report characters for specifying Branch and Department ranges.

Add Show Password button on Password login and Password change dialogs.

Added Trading Name to Company Details, AR Customer and AP Creditor. Included in Customer and Creditor Word lookup fields by default. Example documents updated to include Trading Name if it has a value.

EM - Email and HTML editor

Batch emailing for Invoices (IN Email Invoices and IN Email Printed Invoices) now supports HTML Document and PDF and HTML Document formats.

HTML Document defaults as Email Template from IN Settings and Email body cannot be edited.

Consolidate options are not available when HTML document format is selected.

Added an Edit Before Send selection to single print document dialogs when destination is Mail Message. If not selected then the email is sent immediately on Run from the Print dialog.

GST - GST

Increase font size on BAS Return form.

Help - HTML Help

Removed user guide pdf and link to user guide since this is no longer produced.

File and Index comparison for version 8 to version 7 documented in the help.

IC - Inventory Control

Add User Preference for UOM Enquiry Default, If UOM is Active select from Base UOM (default), Sale UOM, Purchase UOM, Manufacture UOM.

Sets the UOM Code in Product Maintenance > Quantity and Location tabs, and for Product Quantities and Product Tracking Quantities forms to the specified UOM Code for the selected Product.

Increase Unit domain to 8 characters to match length of CO UOM Name, and update calculated Unit Name.

Allow UOM codes to be both Base and Other UOM. BaseUOM is now an explicit selection in UOM Code Maintenance rather than implicit for fixed multiplier of 1. When used as Base UOM Multiplier is forced to 1. The constraint for single base UOM code per UOM Group is relaxed.

Add Unit Selling Price to IC Pending Transactions grid on IC Product > Quantity Tab.

Make COUOM change Trackable.

Added UOMID to ICUOM and made it change trackable.

Added Manufacture UOM Code to IC Products, allows specifying a UOM Code to default when Manufacturing a Product.

Saturn only. Add Print Status to ICTransfers with PrintLog support.

Saturn only for Bin Tracked Locations. Add Generate From selection to Bin Codes, selected by default. If unselected then the Bin will be excluded when Generating Outwards tracking, but may be selected manually from the Lot and Bin picker.

Saturn with Bin Tracked Location only. Added an IC Setting: Generate from Bin with Smallest / Greatest Quantity available, default is Smallest Quantity which minimises "orphan quantities". This sort applies within bins of the same priority when not overridden for lot selection.

Add Creditor Inactive as a field to the IC Supplier Costs grid and hide Supplier Costs for Inactive Creditors by default.

IN - Invoicing System

Add ShipperCode to OEHEAD and INHEAD tables. ShipperCode is populated automatically if all ShipperLines for the document have the same ShipperCode.

Show Packing Slip No in IN Invoice Matches grid for Find Document by Number.

All Shipper fields (including any TD Custom fields) made available to OE Order / IN Invoice Shipper grid.

JA - Job Analysis

Surface Report Totals Only Option to runtime selections dialog. No change to scripted property.

JC - Job Costing

Make Creditor Name available to JC Job Transactions tab, not visible by default, join only done if relevant, i.e. if field is visible or filtered/sorted on.

Extend Customer Order No check per the IN Setting to include JC Job and JC Job Invoice form.

Add Find OrderNo to JC Job List.

Reduce space used by the Job Defaults panel on document forms, and move Job Code to be first field in the panel.

MB - Max Basic

Add optional Options: StringList parameter to OAuth2TokenFromResourceOwner and OAuth2TokenFromRefreshToken functions to support passing OTPCode. See help for example usage.

Added GetPrintContext function which will return a PrintContext object when used in the AfterPrint event.

PrintContext has the following properties (all of type string):

AccountCode

AccountFile

Destination

Format

EmailAddress

EmailSubject

EmailTemplateName

FileName

PrinterName

ReportFileName

Title

Saturn Only. Added InputBinCode function and ScriptedForm.InputBinCode method.

New DateTime functions added:

LocalDateTimeToUTC(LocalTime: DateTime) - Converts a local timezone datetime to UTC

UTCDateTimeToLocal(UTCTime: DateTime) - Converts a UTC datetime to local timezone datetime

TimeZoneOffset - Returns the current local timezone offset in minutes

OE - Order Entry

Add ShipperCode to OEHEAD and INHEAD tables. ShipperCode is populated automatically if all ShipperLines for the document have the same ShipperCode.

All Shipper fields (including any TD Custom fields) made available to OE Order / IN Invoice Shipper grid.

PA - Purchase Analysis

Sales Analysis and Purchase Analysis separated into two modules following requests for PA without Invoicing. No change to existing perpetual subscriptions but each is a module for Subscription systems.

PO - Purchase Orders

Add a new PO Setting Allow Zero Value Orders. The default is unselected both during conversion and for new companies. If unselected then Purchase Orders cannot be saved without a non-zero Ordered Amount, Request for Quotation and Standing Orders are not affected.

Add Supplier Cost Basis to AP Creditor with options for Supplier Cost / Supplier Standard Cost. Data conversion populates according to the current AP Setting which becomes the default for new Creditors.

Add selection on Purchase Order List for Authorisation Code. Index POHead by Authorisation code.

RD - Report Designers

Add Decimal 1 through 6 as Domains for Float fields for easy formatting to specified number of decimal places.

RE - Report Engine

Surface Report Totals Only Option to runtime selections dialog. No change to scripted property.

Default runtime filters and sorts for Report Selections can be saved in Report Layouts.

SA - Sales Analysis

Surface Report Totals Only Option to runtime selections dialog. No change to scripted property.

Sales Analysis and Purchase Analysis separated into two modules following requests for PA without Invoicing. No change to existing perpetual subscriptions but each is a module for Subscription systems.

SP - Special Pricing

Add BreakID to SPBreak table and make SPBreak change trackable.

SYS - System

Improved System password security settings:

Split System Settings > Single-Sign On tab into General and Passwords tabs

Password complexity settings

Optional Multi-factor Authentication - Added support for MFA using the time-based one-time passwords (TOTP) standard and Google and Microsoft Authenticator compatible URIs.

Optional Disallow password reuse within X months

Add Allowable Session Types per User.

Users may be flagged as Exempt For OTP when Require OTP for Win is selected in System Settings. Changing this requires control permissions on 'SY\Perm\Users' and SY\Perm\Users\Password'.

Change COUser and SYUser tables to use new SMTPServerUsername domain char 120.

New setting added called "Sync Connectivity to System" to Web Service Settings in the Monitor. If setting is true (default) then the connectivity settings will be written from the web service configuration JSON file to the System settings SYCTRL on WS startup.

Add support for removing modules from a company which removes the related module data with system level permission to control this.

Add Send Assistant to send error reports via Accredo Error Report Server when a mail client is not available to the Error logger.

Add Show Password button on Password login and Password change dialogs.

Extend System > Company Maintenance permission to four levels with the new Control level allowing removal of modules from existing companies and Validate Company Modules.

No change to User permission level applied during conversion so only the ACCREDO user will have the permission initially.

Licence Statement moved from Help menu to a Licence tab on the Licensee Details. When the tab is focused the Print button prints the License Statement.

Privacy policy updated. Available in Licensee Details.

TD - Table Designer

Make ICPEND / JCPEND extensible and do flow through from source table as done for ICTRAN / JCTRAN. Values cannot be edited in ICPEND / JCPEND must be edited at source and replicate to ICPEND / JCPEND. File recovery will update flow through values in ICPEND and JCPEND after fields are added.

TD Table Designer updated.

Add Tracking Fields toolbar option now adds Created Timestamp and Modified Timestamp fields in place of separate Date and Time fields.

Change Tracking fields toolbar option removes Created Date and Created Time and replaces with Created Timestamp, removes Modified Date and Modified Time and replaces with Modified Timestamp. On save data is combined into the new fields and calculated fields are available for backwards compatibility.

Add Decimal 1 through 6 as Domains for Float fields for easy formatting to specified number of decimal places.

WS - Web Service

Added Session Limit to Web Client details.

New setting added called "Sync Connectivity to System" to Web Service Settings in the Monitor. If setting is true (default) then the connectivity settings will be written from the web service configuration JSON file to the System settings SYCTRL on WS startup.

Add optional Options: StringList parameter to OAuth2TokenFromResourceOwner and OAuth2TokenFromRefreshToken functions to support passing OTPCode. See help for example usage.

When updating an entity via a json POST/PUT or PATCH all sub objects will be updated after the main objects fields.

Added a per Web Client setting Create Refresh Tokens. System upgrade will set to Selected for all Web Clients. Getting access token via WS will not include the "refresh_token" key in the response if Refresh Tokens for client is not ticked. If OTP Enabled is selected for the Web Client with OTP Prompt Interval set to 0 (i.e. OTP is required every time an Access Token is required) then Create Refresh Tokens is unselected.

Image & File GET endpoints now validate file extensions from the CO File Upload extensions.

Set jpg as a valid File Upload extension for Links during data conversion.

Exclude Basic authentication requests from OTP checks.

XConv - Mercury2Saturn

Converters for Version 8. Add System level conversion to Mercury2Saturn (and Saturn2Mercury) converters for easy upgrade path.

XConv - Profax Converter

Profax and Prophet converters updated for Version 8.

XConv - Prophet Conversion

Profax and Prophet converters updated for Version 8.

XConv - Saturn2Mercury

Converters for Version 8. Add System level conversion to Mercury2Saturn (and Saturn2Mercury) converters for easy upgrade path.

 

Bug Fix

AP - Accounts Payable

Ensure (Payment) Discount is set read only correctly for AP shipment and AP Transactions based on sign of Transaction amount.

IC - Inventory Control

Calculated SupplierEffectiveStandardCostPrice in ICCost grid was incorrectly a Cost Price instead of an FX Cost Price. Corrected in V8.

SP - Special Pricing

SP Who Code domain increased to 20 char to handle maximum size of AR Address Codes.