Archived Release Notes

Accredo 5 – Version 5.0.11.129

Bug Fix

AP - Accounts Payable

AR - Accounts Receivable

Saturn Only. Leave Branch/Location unchanged on change of Customer/Creditor if Customer/Creditor and User defaults for Branch / Location are both blank.

CB - Cash Book

Saturn Only. Leave Branch/Location unchanged on change of Customer/Creditor if Customer/Creditor and User defaults for Branch / Location are both blank.

DI - Data Interchange

Fix "Unexpected end of file in XML" error loading an Excel file to a memory table.

IC - Inventory Control

IN - Invoicing System

OE - Order Entry

PO - Purchase Orders

Saturn Only. Leave Branch/Location unchanged on change of Customer/Creditor if Customer/Creditor and User defaults for Branch / Location are both blank.

WS - Web Service

Fix Range Check error after a server up time exceeding 25 days.

Accredo 5 – Version 5.0.11.128

Improvement

CB - Cash Book

Suppress Branch change hints during CB Rules application.

FX - Foreign Exchange

Add XDR IMF Special Drawing Rights as Currency Code.

GST - GST

Add Tax Regime for Tonga.

IC - Inventory Control

Don't calculate Quantities Before and After for posted Manufacture Transactions.

SYS - System

Update the method getting the Windows default to function with Remote Desktop session only printers passed through as default Windows Printer.

WS - Web Service

Fix Help documentation of objects with an Information sub object.

Bug Fix

AP - Accounts Payable

Fix up negative Shipped/Committed handling for Shipments Lines with Job codes.

CO - Company

Mercury only. Fix COM Login method returning True under Single Sign on when login to System succeeds but Company Login fails.

DI - Data Interchange

EM - Email and HTML editor

Fix ValidEmailAddress function incorrectly treating empty string as valid.

FD - Form Designer

Fix Access Violation with ByRef variable tracename.

GL - General Ledger

Fix GLBudget data object not forcing uppercase on Branch and Department causing issues during import.

IC - Inventory Control

JA - Job Analysis

Fix total incorrectly being read only for calculated fields in analysis reports.

JC - Job Costing

Fix data level behavior for JCJob SiteAddressCode to match UI behavior.

MB - Max Basic

PA - Purchase Analysis

Fix total incorrectly being read only for calculated fields in analysis reports.

RD - Report Designers

SA - Sales Analysis

Fix total incorrectly being read only for calculated fields in analysis reports.

SP - Special Pricing

Special Pricing Script, allow write to TD Custom fields in the Context.

SQL - SQL

Fix handling of non-breaking spaces.

SYS - System

TD - Table Designer

Fix encrypted index issue when generating table schemas.

WS - Web Service

XConv - Prophet Conversion

Accredo 5 – Version 5.0.11.127

Improvement

ALL - All Modules

Detect file recoveries which may run out of memory in 32-bit client and recommend 64-bit client.

EM - Email and HTML editor

Email Attachments added in Batch Printing using Attach Links now appear after the attachment for the document being printed.

FD - Form Designer

Improve rotated image handling in FD component.

IC - Inventory Control

Disable floating point exception for file open dialog to deal with Windows PhotoMetadataHandler issue.

MB - Max Basic

Add AddToSystem method to COUserData to replicate company user to system / add company to existing matching System User.

TD - Table Designer

Add COUOM unlocking support to TD table update handling.

Bug Fix

AP - Accounts Payable

Fix issues with conversion of approval amount and payment method for AP Transactions. Note Approval Amounts are now not converted.

AR - Accounts Receivable

Fix introduced issue with Inserting a Contact from Customer or Creditor maintenance.

CO - Company

Fix intermittent issue in Change Tracking settings with adding fields and needing to increase Heat Limit triggering "tblMemoTrackClone locked" error.

EM - Email and HTML editor

Fix relative link path issue with sub folders when emailing documents.

FD - Form Designer

Update FD form Window menu caption if caption is changed in code.

GL - General Ledger

Fix Period and Year maintenance incorrectly considering GLFirstUntotalledBudgetPeriod and GLFirstUntotalledBalancePeriod settings in last period used.

IN - Invoicing System

Fix relative link path issue with sub folders when emailing documents.

MB - Max Basic

RD - Report Designers

XConv - Prophet Conversion

Fix issues with conversion of approval amount and payment method for AP Transactions. Note Approval Amounts are now not converted.

Accredo 5 – Version 5.0.11.126

Improvement

AP - Accounts Payable

AR - Accounts Receivable

Relax Statement/Remittance Email Required for Accounts with Bill To specified.

CO - Company

Improve prompt for adding Company User to existing System User's Company List.

DI - Data Interchange

EM - Email and HTML editor

Remove remaining references to Internet Explorer for embedding images from HTML editor.

FD - Form Designer

Track Undo when pasting in Designer.

GST - GST

Added a setting for GST Filing to "Use External Browser for Filing" under Company Settings. Default is unselected. If an Unsupported browser error occurs during GST filing select this, and the GST filing authentication will then be done via the user's default browser.

IC - Inventory Control

Print product labels for document lines now rounds up for part quantities.

MB - Max Basic

PO - Purchase Orders

Make ICCategory1 and 2 available to PO Order and AP Shipment lines.

SQL - SQL

Added Instr function to SQL Functions.

Bug Fix

AP - Accounts Payable

Improve whole balance allocation handling for credits.

AR - Accounts Receivable

Improve whole balance allocation handling for credits.

DI - Data Interchange

Fix introduced PriceBook import designer ICCOST display issue.

FA - Fixed Assets

Fix Merge handling for FA Split percentages when Branch or Department Codes are merged in Saturn.

FD - Form Designer

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

RD - Report Designers

RE - Report Engine

SQL - SQL

WS - Web Service

XConv - Prophet Conversion

Fix missing RegimeCode issue in Prophet Converters.

Accredo 5 – Version 5.0.11.125

Improvement

ALL - All Modules

Exclude all balance fields from same sign checking for FX versus Bs paired values.

AP - Accounts Payable

DI - Data Interchange

EM - Email and HTML editor

Increase Email Results Success/Failure field display size.

FD - Form Designer

Further improvements to FD Undo.

GST - GST

Changing GST Regime Interval Unit from Month to Period or vice versa recalculates return dates for current and future GST Returns.

JC - Job Costing

Add FxRatesCache to JCJobForm automation.

MB - Max Basic

SP - Special Pricing

Add UI only warning if before discarding Cost Relative rules without Amount, Percentage or Bypass Minimum Margin.

XX - OLEDB/ODBC

Implement session 'pooling' for SQL Server Linked queries

Bug Fix

AP - Accounts Payable

CB - Cash Book

Fix Analysis Name not loaded fir CB Rule Maintenance Cash Purchase.

CO - Company

Fix Password display labels.

EM - Email and HTML editor

Fix Integer overflow during style calculation,

FA - Fixed Assets

Treat changing depreciation To/From Not Applicable for depreciation as having no effect on Depreciable value. Previously reset Depreciable value to Book Value. This can be done manually with an Adjustment transaction if desired.

FD - Form Designer

Disable pasting of Components from the keyboard when scaled to avoid bad paste behaviour. Components can be pasted without problems from the Context (right click) menu or Edit > Paste.

GST - GST

Fix GST Transaction transfer to GL for Other Regimes using FX values instead of Base currency values..

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

PO - Purchase Orders

RD - Report Designers

RE - Report Engine

SA - Sales Analysis

Fix Access Violation when opening a report with destination set to Excel when Excel is not available.

SQL - SQL

Fix Sql RowLimiter algorithm so that it can be an input into another algorithm.

SYS - System

Fix Password display labels.

WS - Web Service

Make Web Service Monitor single instance.

XX - OLEDB/ODBC

Fix introduced issues registering AccredoDB.dll.

Accredo 5 – Version 5.0.11.124

Improvement

ALL - All Modules

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

CO - Company

Fix introduced email address validation issue when mailbox format is used.

DI - Data Interchange

EM - Email and HTML editor

FA - Fixed Assets

FD - Form Designer

GL - General Ledger

Help - HTML Help

Document TriggerField in PostLines objects as a property rather than method.

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

OE / IN / PO Reports - Back Order, Allocation and Stock On OrderLayouts UOM related fields added to layouts if UOM is Active. Not visible by default.

SYS - System

When Use Single Sign On is selected in a System with existing companies "Import Users from All Companies" now makes Import of Permission Groups optional.

TD - Table Designer

Check for and disallow multiple AutoInc fields in a TD Table.

WS - Web Service

XConv - Prophet Conversion

XX - OLEDB/ODBC

Implement session 'pooling' for SQL Server Linked queries

Bug Fix

ALL - All Modules

AP - Accounts Payable

DI - Data Interchange

EM - Email and HTML editor

FD - Form Designer

Fix FD form scaling blow out when designing on scaled monitor and using Ctrl+S to save.

GL - General Ledger

Ensure GL Batch import uses the current year when PeriodNo is specified. Note that not specifying PeriodNo in the header of the import file will derive the period from the date in the batch lines.

GST - GST

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

PO - Purchase Orders

Fix change of Expense Code in PO Header after lines are present not respecting Product Expense code when updating matching Line Expense Codes.

RD - Report Designers

RE - Report Engine

Fix Paper Source issues: Default printer setup now applies Paper source to document reports without printer settings. Printing from Report preview now applies Paper source setting from its Printer setup (not from Default printer or Document printer settings).

SP - Special Pricing

SQL - SQL

SYS - System

Beta only issue. Fix error accessing View > Preferences

TD - Table Designer

WS - Web Service

Accredo 5 – Version 5.0.11.123

New Feature

XX - OLEDB/ODBC

Accredo ODBC Connector for Power BI The AccredoODBC.mez file is installed with the Accredo ODBC/OLEDB Driver. To use the Accredo ODBC Connect the AccredoODBC.mez file needs to be copied to : Documents\Power BI Desktop\Custom Connectors Then Power BI needs to be set up to allow non certified Data connectors to be seen: File > Options and Settings > Options > Security > Data Extensions Select "Allow any extensions to load" AccredoODBC will then appear in the list of Other data sources.

Improvement

ALL - All Modules

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

DI - Data Interchange

EM - Email and HTML editor

FD - Form Designer

Automatically toggle grid navigator button state for SelectAll, UnSelectAll, SelectOne and UnSelectOne buttons.

GL - General Ledger

IC - Inventory Control

MB - Max Basic

PO - Purchase Orders

Improvements to PO Authorisation on Order From Quote. Pick up users default Authorisation Code if one is assigned, only prompt if Authorisation is required and allow save as unauthorised Open order if PO settings permit.

RD - Report Designers

RE - Report Engine

TD - Table Designer

Add multi-part index checking for custom domains in Alias and Merge.

WS - Web Service

XConv - Prophet Conversion

Add APTRAN TransactionDate/PeriodID date clamping for GST Return consistency.

ZIP - Backup

Allow Ignore Files for System Customizations Backup.

Bug Fix

ALL - All Modules

AR - Accounts Receivable

CB - Cash Book

CO - Company

Fix POOrderEmailResultsForm iincorrectly grouped under AP in Script Events.

DI - Data Interchange

EM - Email and HTML editor

FA - Fixed Assets

FD - Form Designer

GST - GST

IC - Inventory Control

IN - Invoicing System

Exclude posted Invoices and Orders from OrderNo required check on save.

JC - Job Costing

MB - Max Basic

OE - Order Entry

Exclude posted Invoices and Orders from OrderNo required check on save.

PO - Purchase Orders

RD - Report Designers

Fix pre-defined label sizes not loading in 32-bit client label designers.

RE - Report Engine

Fix filename issue when Print dialog is switched from disk file to screen then saved from Report Preview window.

SP - Special Pricing

Fix introduced issue for Initial Sell Price and Sell Relative prices for Manually Costed products.

SQL - SQL

SYS - System

Guard against Theme.GetElementContentRect overflowing Margins causing "Integer Overflow" exception on start-up.

TD - Table Designer

WS - Web Service

XX - OLEDB/ODBC

Guard against permission related multi-thread race conditions in OLEDB and ODBC connections. Show ODBC location in Diagnostic.

Accredo 5 – Version 5.0.11.122

Improvement

ALL - All Modules

Fix Ctrl+Apostrophe Ditto in edit grids to always copy from line above.

AP - Accounts Payable

Add missing Allocation Query grid fields to the Allocation Query report.

AR - Accounts Receivable

Add missing Allocation Query grid fields to the Allocation Query report.

CB - Cash Book

Improvements to CB Bank Reconciliation when conflicting matches are found by Match All. Double click where the Action is Rules? now opens the Select Rules form, you can Select the rule which applies to the Statement line, Delete duplicated rules or Open Details to edit a rule. Double click where the Action is Ambiguous? or Amount? now opens the Fine dialog to locate the relevant unreconciled items. To Unmatch these lines click Unmatch or Ctrl+Down.

CO - Company

Relax Passwords restrictions on User addition, if minimum length password is required then Change Password bust be selected.

DI - Data Interchange

Import Designer check code now checks for valid unique variable names for the fields defined for the import file. Add fields names duplicates uniquely.

GL - General Ledger

GL Report Wizard now generates an empty label component in bandEmpty to preserve line space on print to Excel.

GST - GST

If Provisional Type is set to "N", but expected type from IRD is 103, file a 103 with 0 provisional values.

IC - Inventory Control

Add ICQTY Custom fields to Product & Location Detail layout.

MB - Max Basic

SP - Special Pricing

Reinstate the Apply on Manual Cost Changes setting. For Manually Costed Products and all JC Transactions if JC Integration setting to Enforce IC Cost Prices is Unselected, this setting determines if Special Pricing is enabled whether repricing is triggered by a change to the Cost Price on these lines. In all cases regardless of the SP setting the line cost price is passed into the SPContext for these lines rather than the Valuation cost from IC. We recommend that Apply on Manual Cost Changes is set true if you have cost relative Special Pricing rules applying to Manually Costed products, or to JC with Enforce IC Cost Prices set false.

WS - Web Service

Add optional parameter "DeleteFileAfterResponse" to PlayReportScript endpoint to delete the report file after the response has been built.

Bug Fix

AP - Accounts Payable

Fix "Field TransactionDiscount value changed" error when editing a Credit posted from AP Shipment with discount.

AR - Accounts Receivable

Editing Banking details on AR Receipt incorrectly required Customer > Banking Write access. Now fixed.

CB - Cash Book

CO - Company

Fix introduced Change Tracking Sort failures.

FA - Fixed Assets

Fix File Recovery extending Last History Period and Balances for Inactive Assets with Inactive Transactions past Last History Period.

FD - Form Designer

Fix issue where selecting an existing component from the drop down performed scaling on the already scaled controls,

GL - General Ledger

Fix typo in GL Report Wizard for UnusedYearBudget. GL Report Wizard version incremented.

IC - Inventory Control

MB - Max Basic

OE - Order Entry

Fix introduced issue for partially invoiced Kitsets on Back Orders when Order Quantity is changed.

PO - Purchase Orders

Remove forced PO Order reprice when changing CreditorCode via scripting.

RD - Report Designers

RE - Report Engine

Fix possible overlap of Column Headers and Page Footer on banded layouts.

SQL - SQL

Fix SQL duplicated column issue with a row limiter (First X) with an order by applied to an aggregate column.

TD - Table Designer

Add check for maximum record size when creating a table.

WS - Web Service

Fix object handler issue resulting in double of Data module Locates while building a response where either a skip token or filter has been applied.

Accredo 5 – Version 5.0.11.121

Improvement

IC - Inventory Control

Add Margin Percentage as available field in IC Product list. Calculated for base currency Prices mapped to Selling Prices 1-9 using Valuation Cost price if user has Read permission or higher for Cost Prices.

SYS - System

Add option under File > Error Log, to Prune Invalid Login Warnings.

Bug Fix

FD - Form Designer

Fix issue with boolean font properties.

MB - Max Basic

Fix Folder lock issue when scripts are loaded.

PO - Purchase Orders

Prevent Held Open PO Order from changing to Processed on Shipment Post.

RD - Report Designers

Fix introduced issue with formatting not applied to dates, amounts etc on print to Disk file in Excel format.

RE - Report Engine

Fix introduced issue with formatting not applied to dates, amounts etc on print to Disk file in Excel format.

SP - Special Pricing

Fix introduced issue with Manually Costed Products and Special Pricing causing Sell Price to reset when Cost Price is edited on document or JC Transaction.

Accredo 5 – Version 5.0.11.120

Improvement

ALL - All Modules

AP - Accounts Payable

CB - Cash Book

CO - Company

DI - Data Interchange

Change default COMLockTimeout from 12 hours to 5 minutes (300000 milliseconds). The timeout can be set explicitly. The switch /COMLOCKTIMEOUT sets the number of milliseconds that the application will wait to obtain a lock for the COM session. This can avoid global deadlocks. See Command Line and Config File Switches https://accredo.co.nz/webhelp/#CommandLineSwitches.htm for a full list of switches available.

EM - Email and HTML editor

HTML library updated.

FD - Form Designer

Improve Domain selection in Memory Table Builders.

GL - General Ledger

IC - Inventory Control

MB - Max Basic

PO - Purchase Orders

PO Batch Email added a Filter on Orders.

RE - Report Engine

For Memo Line band on Memo report layouts convert chevrons to tab characters for layout. Note that to align tabs a fixed width font should be applied to Data in Report Preferences for the memo layouts.

SP - Special Pricing

SYS - System

TD - Table Designer

WS - Web Service

Bug Fix

ALL - All Modules

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

DI - Data Interchange

Fix ICStocktakeData fields missing read only flag. Specifically QuantityCounted should not be editable. IC file recovery will correct stocktakes if they are affected.

EM - Email and HTML editor

GL - General Ledger

GST - GST

Reopening a GST Return did not clear the Last Filed Date in the Tax Regime settings. Now fixed.

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

Fix Kitset Available not rounding to UOM Decimals when Multiplier is 1.

PO - Purchase Orders

RD - Report Designers

RE - Report Engine

SP - Special Pricing

Fix loading of customisations to SP Rule Edit report from SP Rule Maintenance form.

SQL - SQL

Beta Only issue: Fix introduced issue in ExecuteSql endpoint for Grouped queries.

TD - Table Designer

Fix Custom Table permission not being checked for access to TD Custom Table Forms.

WS - Web Service

XConv - Prophet Conversion

Improvements and fixes to Prophet converter.

Accredo 5 – Version 5.0.11.119

Improvement

ALL - All Modules

AP - Accounts Payable

AR - Accounts Receivable

Analysis Codes Transaction Tabs - make GL Account Code and GL Account Overridden available.

CB - Cash Book

CO - Company

EM - Email and HTML editor

GL - General Ledger

IC - Inventory Control

JC - Job Costing

MB - Max Basic

PO - Purchase Orders

RD - Report Designers

RE - Report Engine

Include User Code and Name on Reports with date and time of printing.

SP - Special Pricing

Fix Behaviour of Priority Selection on SP Rule List Designer, not defaults blank.

TD - Table Designer

Improve placement of new custom fields on custom tab with existing customisation.

WS - Web Service

ZIP - Backup

Reset CurrentDirectory to SystemPath on Backup / Restore.

Bug Fix

ALL - All Modules

Fix PgUp/PgDn tab switching issue when tabs are hidden or custom tab has tabs.

AP - Accounts Payable

AR - Accounts Receivable

Fix positioning issue for new PrintLabel methods on Masterfile Data objects.

CB - Cash Book

EM - Email and HTML editor

Fix SSL with no username/password issue when batch emailing documents.

FA - Fixed Assets

Fix edit/save with no change to Description/Information tabs incorrectly setting Modified fields.

FD - Form Designer

Added validation to check Dataset name length (maximum is 60 Char) when saving field customisations for FD forms.

GL - General Ledger

Fix Ctrl+= in a GL Batch not updating batch totals correctly when there is an amount in the line.

GST - GST

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

Fix introduced Floating point overflow exception fulfilling non-diminishing quantities.

RD - Report Designers

Fix AfterBand code triggered for skipped labels when Start From Label <> 1.

RE - Report Engine

Fix Issue with exporting report to Excel - "Unable to set the NumberFormat property of the Range class" with Currency formatting.

SQL - SQL

Add parameter validation to SQL MakePeriodID function. Year and Period valid possible ranges are 1-99 in each case.

TD - Table Designer

Improve handling of Field Type changes.

WS - Web Service

XConv - Profax Conversion

ZIP - Backup

Ensure System backup path applies on select Company if Company does not have an explicit Company Backup path.

Accredo 5 – Version 5.0.11.118

Improvement

ALL - All Modules

Add support for orienting images based on EXIF information.

AP - Accounts Payable

AR - Accounts Receivable

Add more titles to contact titles lookup.

CB - Cash Book

Handle un-reconciling and saving statements when a transaction is referenced multiple times.

EM - Email and HTML editor

FA - Fixed Assets

FA Values fields for the Current Book are now available to the Fixed Asset list. This includes Asset Status which is visible by default.

FD - Form Designer

Handle change of currency code for number edit and fix Access Violation on calculator accessed from Number Edit.

GL - General Ledger

GST - GST

When Regime Interval Units is set to Month ensure NextTaxDate and NextProvisionalDate are end of month dates.

IC - Inventory Control

IN - Invoicing System

MB - Max Basic

OE - Order Entry

Kitset component discontinued / not backorder allowed will hint on OE Order Entry.

TD - Table Designer

Prevent reordering of Accredo fields in Table Designer.

WS - Web Service

XX - Install Scripts

Accredo Remote Support client AccredoTeamViewer.exe updated to Version 15.19.3 QS on Website and FTP.

Bug Fix

ALL - All Modules

Fix period dropdown keypress issue with +/- not stepping forward/back as expected.

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

CO - Company

FD - Form Designer

GL - General Ledger

GST - GST

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

PO - Purchase Orders

RD - Report Designers

RE - Report Engine

SP - Special Pricing

SYS - System

Improve Select Company handling to handle Force User Exit for Companies without Company Code in the Company lookup.

TD - Table Designer

WS - Web Service

XConv - Prophet Conversion

Fix conversion issue for GST Returns with missing dates.

Accredo 5 – Version 5.0.11.117

Improvement

ALL - All Modules

Calculator is now Tax Regime aware when dropped from a control on a form with a Regime Code and the Tax buttom will use the current default GST rate for the Regime. A Regime selector has been added to the calculator to determine the Tax rate to use for the Tac functions, defaulting to base Regime if there is no context.

AP - Accounts Payable

AR - Accounts Receivable

Changes to allow deprecation of Cheques with Banks in NZ phasing out cheques. When a Media Code is inactivated any Active Customers with the Media Code will reset to use the Default Media Code from AR settings. See help and next newsletter for more information.

CB - Cash Book

Assorted changes to allow deprecation of Cheques with Banks in NZ phasing out cheques. Banking Summary Selections handle inactive or deleted Cash/ Cheque / Other media codes. Settings updated to handle Inactivating / Deleting CASH / CHEQUE /OTHER media code. Scripting backward compatibility for changes to allow cheque deprecation. See help and next newsletter for more information.

CO - Company

Assorted changes to allow deprecation of Cheques with Banks in NZ phasing out cheques. Allow Inactive / Delete for CASH CHEQUE and OTHER media codes. The usual checks for in use/never used apply. When a Media Code is inactivated any Active Customers with the Media Code will reset to use the Default Media Code from AR settings. Scripting backward compatibility for changes to allow cheque deprecation. See help and next newsletter for more information.

DI - Data Interchange

FA - Fixed Assets

FX - Foreign Exchange

Posting/Patching via web service can now specify Master even when no exchange rate can be retrieved as long as exchange rate is specified in JSON.

GL - General Ledger

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

Add InclusiveAmount and InclusiveAmountBs to Order and Invoice Lines, not visible by default.

RD - Report Designers

GoToError extended to errors when running Reports and Documents from the Designer.

RE - Report Engine

SYS - System

Trigger Accredo warning about running from a Network location which running from a symbolic link to a network location.

TD - Table Designer

WS - Web Service

Bug Fix

ALL - All Modules

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

DI - Data Interchange

EM - Email and HTML editor

FA - Fixed Assets

Beta only. Fix issue with 0.01 cent round off on Asset Depreciation.

FD - Form Designer

GL - General Ledger

Fix GL Reporting error "A record already exists with that AccountPeriodBranchDepartment" when current year is shorter than future year.

IC - Inventory Control

IN - Invoicing System

JA - Job Analysis

Fix Analysis Report handling of Filters on Time.

MB - Max Basic

OE - Order Entry

PA - Purchase Analysis

PO - Purchase Orders

Saturn only. Require Default Location Code on Purchase Order for Generate.

RD - Report Designers

RE - Report Engine

SA - Sales Analysis

Fix Analysis Report handling of Filters on Time.

SP - Special Pricing

Launching Price Query Invoice/Order lines "Special Pricing Information" was not initialising Minimum Margin resulting in Special Prices with Margin < 0 being displayed as disallowed even if minimum Margin was less. Correct price was still selected, display issue only.

SQL - SQL

TD - Table Designer

WS - Web Service

Accredo 5 – Version 5.0.11.116

Improvement

ALL - All Modules

AP - Accounts Payable

Swap Navigator ordering of Revaluation and Transfer to GL.

AR - Accounts Receivable

Swap Navigator ordering of Revaluation and Transfer to GL.

CB - Cash Book

Swap Navigator ordering of Revaluation and Transfer to GL.

CO - Company

DI - Data Interchange

Add handling for Excel CONCAT function in Import from Excel.

EM - Email and HTML editor

FD - Form Designer

GL - General Ledger

Make GLACCT TD extensible.

GST - GST

IC - Inventory Control

JC - Job Costing

Swap Navigator ordering of Revaluation and Transfer to GL.

MB - Max Basic

OE - Order Entry

Make all fields from the OE Line available to be customised into the Customer Back Orders list.

SYS - System

Add current permission level description to User Permissions tabs.

TD - Table Designer

WS - Web Service

Bug Fix

ALL - All Modules

Fix calculation of Weight and Volume when UOM code is forced to rebase due to direct edit of Quantity in conflict with selected UOM code.

AP - Accounts Payable

AR - Accounts Receivable

Fix AR Customer BalanceTotalIncludingFuture not testing for Balances permission.

CB - Cash Book

Fix missing Restore Defaults functionality when customising Unreconciled for Statement report.

CO - Company

EM - Email and HTML editor

Fix html escape char issue.

FD - Form Designer

GL - General Ledger

GST - GST

IC - Inventory Control

IN - Invoicing System

MB - Max Basic

OE - Order Entry

RD - Report Designers

Fix Excel export error if expression component calls a function directly.

RE - Report Engine

Display tab character as chevron in report layouts.

SP - Special Pricing

SQL - SQL

WS - Web Service

Accredo 5 – Version 5.0.11.115

New Feature

MB - Max Basic

Add Format Code option to Context menu. Formatting applied is blank line between functions/subroutines, two space indentation, and line continuation indentation, capitalisation.

Improvement

ALL - All Modules

Add Prune Tracking option in Setup utilities.

AP - Accounts Payable

AR - Accounts Receivable

Omit transfer to GL for untransferred FX Revaluation at EOP if user does not have GL Permission.

CO - Company

Add User Preference for Update date at midnight. Selected by default.

DI - Data Interchange

EM - Email and HTML editor

Validate email addresses before send.

GST - GST

Add support for IE Ireland tax regime.

IC - Inventory Control

IN - Invoicing System

Add action handler for /ININVOICE/ManualInvoice.

JA - Job Analysis

Analysis Report Runtime loading of report will now fix missing FieldTypes for a field in the same way the design time loading does.

MB - Max Basic

OE - Order Entry

Add PackingSlipNo to available fields in OE Backorders form.

PA - Purchase Analysis

Analysis Report Runtime loading of report will now fix missing FieldTypes for a field in the same way the design time loading does.

RD - Report Designers

RE - Report Engine

Excel Worksheet destination for report printing now depends on Excel being detected. Disk file to Excel file is available regardless.

SA - Sales Analysis

Analysis Report Runtime loading of report will now fix missing FieldTypes for a field in the same way the design time loading does.

SQL - SQL

WS - Web Service

Bug Fix

ALL - All Modules

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

CO - Company

Fix introduced "A record already exists with that Line (1) code" error when inserting a new CO Price List record.

DI - Data Interchange

FD - Form Designer

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

RE - Report Engine

SYS - System

TD - Table Designer

Fix change of focus in Saturn on IC Product Location tab on edit.

WS - Web Service

XX - OLEDB/ODBC

Fix 64-bit issue in AccredoDB driver using Linked Queries in SQL Server.

ZIP - Backup

Accredo 5 – Version 5.0.11.114

Improvement

ALL - All Modules

CB - Cash Book

Updated CBNational.pfi Statement import definition to handle header line if included.

CO - Company

Add ARPERS to list of trackable tables for Sales App at Heat Limit 3.

DI - Data Interchange

GL - General Ledger

Add CashFlow and AIM fields from GL Accounts to GL Report layouts.

IC - Inventory Control

MB - Max Basic

Add ValidTaxNo, ValidBankAccountNo, FormatTaxNo and FormatBankAccountNo to String Functions. Currently only for NZ Bank Account Numbers and Tax Numbers.

SYS - System

WS - Web Service

ZIP - Backup

Fix System backups other than System Data requiring exclusive access.

Bug Fix

ALL - All Modules

Fix Tracking log selections not Auto Selecting correctly.

CB - Cash Book

CO - Company

DI - Data Interchange

EM - Email and HTML editor

FA - Fixed Assets

FD - Form Designer

Fix Sort button state in FD grid navigators.

GL - General Ledger

Fix Narration not included in Detailed transfer of FA to GL.

GST - GST

IC - Inventory Control

IN - Invoicing System

Fix SQL List sorting for calculated fields.

JC - Job Costing

MB - Max Basic

PA - Purchase Analysis

Fix Document No selections in Sales and Purchase Analysis reports to accept Alpha Numeric input.

RD - Report Designers

RE - Report Engine

SA - Sales Analysis

Fix Document No selections in Sales and Purchase Analysis reports to accept Alpha Numeric input.

SP - Special Pricing

Fix issue with SP Rule Lists determining size for Description fields.

SQL - SQL

SYS - System

Fix possible issues with SMTP Password size mismatch when importing System Users. Fix prompt to add as System User when Company User is added silent failure.

TD - Table Designer

WS - Web Service

Accredo 5 – Version 5.0.11.113

Improvement

CO - Company

Add Company Setting for Regime Interval Unit, default is Months but Period can be selected if their Periods do not align with calendar months, for example 4/4/5 week period structure, and they have an arrangement with the IRD to report based on their financial period end.

DI - Data Interchange

Extended ARStatementReportData object to allow StatementDate and Period to be specifed.

FD - Form Designer

GST - GST

IC - Inventory Control

JC - Job Costing

Added optional Consolidate WIP for Related Jobs setting to Navigator > Setup > Job Costing > Settings > Integration tab, default Unselected. If selected the decision for whether related Jobs have WIP to transfer to GL is made at a consolidated level i.e. Sum(ActualCosts for related Jobs) - Sum(RecoveredCost or RecoveredSell for related jobs) > 0. Selecting or Unselecting the setting will apply the change to Active and Hold Jobs at next transfer to GL and will potentially result in GL batches for prior periods.

MB - Max Basic

PO - Purchase Orders

PO Order Line Ordered Amount now extended from UOM values for better rounding.

RD - Report Designers

TD - Table Designer

WS - Web Service

Bug Fix

AP - Accounts Payable

AR - Accounts Receivable

Fix introduced Budget Split issue for non GL masterfile budgets.

DI - Data Interchange

FA - Fixed Assets

FD - Form Designer

Fix SetRange issue when a sort is in place.

GL - General Ledger

Allow empty for GL Account Analysis GST Code.

GST - GST

IC - Inventory Control

IN - Invoicing System

Fix Other GST Regime handling for Kitset GST codes.

JC - Job Costing

Fix introduced Budget Split issue for non GL masterfile budgets.

MB - Max Basic

OE - Order Entry

Fix Other GST Regime handling for Kitset GST codes.

PO - Purchase Orders

Fix layout style for PO Order report layout.

RD - Report Designers

Fix alignment issues when printing designed document or report containing HTML memo component.

SP - Special Pricing

Fix record revision not updated for SPBreak records edited via the SPRuleData object. Note SPRule record revision was updating correctly.

SYS - System

Fix authentication issue for SMTP mailing at the System level.

TD - Table Designer

WS - Web Service

XConv - Accredo Conversion

Fix conversion handling for other Tax Regimes for GST Code T, now converts correctly to GST Code G.

XX - OLEDB/ODBC

Fixed 64-bit Access Violation with high addresses.

Accredo 5 – Version 5.0.11.112

Improvement

AP - Accounts Payable

AR - Accounts Receivable

Default Period selection for Document tabs on Customer, Creditor and Contact Maintenance forms, changed from All Periods to Range of Periods with From Period set to earliest of first available period for the module or the period of the earliest current (unposted) Document and To Period set to last available period for the module.

CB - Cash Book

CO - Company

Print button added to Reminder List grid.

DI - Data Interchange

Price Book Import Report, added Excel and Disk file destinations.

IC - Inventory Control

Add Confirm Generated Counts option to IC Generate Counts form, Available when generating for Uncounted Products on the Stocktake.

JC - Job Costing

Added buttons to JC Transaction Form: CompleteForWIP / ReopenForWIP Mark Fully Invoiced / Clear Fully Invoiced And Scripted Methods to JCTransactionForm and JCTransactionData CompleteTranForWIP([PeriodID]) ReopenTranForWIP MarkTranFullyInvoiced(Boolean) Buttons and methods require Write or greater permission for JC Invoicing Task since the same operations can be performed from there with that permission level. Modified values for the transaction are not when methods are called. Transaction does not need to be editable or in edit state.

MB - Max Basic

Scripted form, carry FileName into InputFileSave dialog when browsing.

TD - Table Designer

Bug Fix

AP - Accounts Payable

Ensure AP Shipment Line GLAccountCode and Narration fields are read only once Invoice has been posted.

CB - Cash Book

Fix CB Bank Reconciliation test for conflicting rules not picking up rules with differing analysis.

DI - Data Interchange

Fix Pricebook import handling for BeforeSave validation on IC Product e.g. where a Product is being made inactive as part of an import.

EM - Email and HTML editor

Email and HTML editor, fix Invalid Pointer error when html with embedded images is sent, Embedded images are not supported and will be stripped on send, images should be inserted using Add Image.

IC - Inventory Control

JC - Job Costing

MB - Max Basic

RD - Report Designers

Fix ColorRGB assigned to Report Designer component color property not translating to string as expected.

SP - Special Pricing

SYS - System

Fix introduced issue with entering Install key from Licensee Details form.

WS - Web Service

Web Service PDF printing requires a local or available default printer,. Attempting to Print to PDF DIsk File via web service will fail with 500 error if this condition is not met. The default printer is now configured through the Web Service monitor inside the Accredo application. This setting has been removed from the Web Service configuration tool.

Accredo 5 – Version 5.0.11.111

Improvement

ALL - All Modules

AR - Accounts Receivable

Right justify Invoice Packing Slip No, Invoice Order No and Invoice Quotation Reference fields in the AR Customer Transaction tab.

CO - Company

DI - Data Interchange

Wrap COM paths with spaces in quotes rather than using short names since short names may not work if 8.3 names are turned off.

EM - Email and HTML editor

Improve email address validation handling of commas.

FA - Fixed Assets

Add Open File Location button to Image tab toolbars.

GST - GST

IC - Inventory Control

JC - Job Costing

Add JCTRAN UninvoicedSellBs calculated field.

MB - Max Basic

OE - Order Entry

Improve Insufficient Stock hinting for kitsets in Order Entry.

RD - Report Designers

SQL - SQL

SYS - System

If SSO (Single Sign On) is turned on, but the only System User is the ACCREDO master user require Company level log-in for any Company with active users other than the ACCREDO user.

WS - Web Service

Handlers for Invoice from Quote / Order From Quote added.

Bug Fix

ALL - All Modules

Catch Floating point division by zero error when discount (sell discount in AP and PO) is set to 100% and markup is edited.

AP - Accounts Payable

CB - Cash Book

Fix saving of TD Custom fields added to CBSMITEM from CBBankingItems Form or Data object.

CO - Company

EM - Email and HTML editor

IC - Inventory Control

IN - Invoicing System

Fixed possible "Invalid Column Name XXXX or table correlation name YYYY" error in filtered SQL list when a record in the list is changed from another window.

JC - Job Costing

MB - Max Basic

MI - Mobile Interfaces

Fix Kitset expansion for OE Orders in WebService.

PO - Purchase Orders

Fix Job lookup not refreshed to include Quote Jobs when PO Order is duplicated as Request For Quotation.

RD - Report Designers

Fix introduced issues with GIF, WMF and EMF images on documents and custom reports.

RE - Report Engine

Fix issue with Grand Totals on reports not populated on Print to Excel.

SYS - System

Fix COM server using WIN sessions when using SetSystemPath and no valid ini file or registry entry for system path available.

TD - Table Designer

Fix saving of TD Custom fields added to CBSMITEM from CBBankingItems Form or Data object.

WS - Web Service

Accredo 5 – Version 5.0.11.110

Improvement

AP - Accounts Payable

CB - Cash Book

Added StatementID, StatementLineNo and PeriodReconciled as available fields for the transactions band on the CB Unreconciled Transactions layout, making it easy to see if a transaction which is unreconciled as at the period reported on is on a statement, and reconciled subsequently.

FA - Fixed Assets

Add Serial Number to FA Opening Values.

FD - Form Designer

GL - General Ledger

GL Tutorial: Saturn Report showing Branches across page added to Help under Tutorials > Report Designer Tutorials.

GST - GST

Add Manually File option for Complete but Unfiled NZ GST Returns which have been filed externally from Accredo, marks return Filing Status as Manually Filed.

Help - HTML Help

IC - Inventory Control

Change Pending Transactions for Transit Location before Dispatch of a Stock Transfer to both be treated as Transfer Out (one positive, one negative) so they net out in the Quantities. File recovery will update the pending transactions and quantities affected, or they will adjust over time as the Transfers are posted.

IN - Invoicing System

If JobCode is specified on an Invoice, change of Customer will not apply Customer's Sales Person, Price Code and Discount Code to the Invoice, in Saturn this also apples to Customers Branch Code and Location Code if specified.

JA - Job Analysis

Improve speed reporting to Excel for "Totals Only" reports.

JC - Job Costing

MB - Max Basic

PA - Purchase Analysis

Improve speed reporting to Excel for "Totals Only" reports.

SA - Sales Analysis

Improve speed reporting to Excel for "Totals Only" reports.

TD - Table Designer

WS - Web Service

Implementing JSON Batching as per Odata V4.01 for json request/response formatting.

Bug Fix

ALL - All Modules

Fix possible A record already exists with that Layout (..) code - Error message.

AP - Accounts Payable

AR - Accounts Receivable

Fix race condition for AR and AP allocations.

CB - Cash Book

Fix Cash Flow handling for corner cases with AR Receipt discounts.

CO - Company

FD - Form Designer

Fix DateTime sorting for Mem Tables in 64-bit application.

GL - General Ledger

Generate GST Adjustments and Transfer to GL for GST Rounding on BAS Return form.

GST - GST

IC - Inventory Control

JC - Job Costing

MB - Max Basic

Fix DateTime sorting for Mem Tables in 64-bit application.

RD - Report Designers

Fix introduced issue with TIF files not displaying in Documents and Custom Reports.

SP - Special Pricing

SYS - System

Fix issues with SMTP passwords at System User level. If problems with email authentication are experienced edit and save of the System User record will attempt to correct encryption state, or re-enter the SMTP Password for the user.

TD - Table Designer

Fix Smallint overflow with large TD record sizes.

WS - Web Service

XConv - Accredo Conversion

Fix Smallint overflow with large TD record sizes.

XX - OLEDB/ODBC

Fix PowerQuery ODBC error "Field 'TYPE_NAME' must have a value" querying ICQTY.

ZIP - Backup

Fix cancel button on Backup not working after backup is running.

Accredo 5 – Version 5.0.11.109

Improvement

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

CB Rule List when Rule Type Withdrawal or Deposit is selected, Analysis Code may be selected to filter for Rules which use that code.

CO - Company

DI - Data Interchange

Added Print and PrintSheet methods to ICStocktakeData object. Added Print method to ICStocktakeCountData.

FA - Fixed Assets

FD - Form Designer

GL - General Ledger

Filter out inactive zero balance GL Reconciliation Report entries.

GST - GST

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

JC Job Maintenance Invoice Documents grid - Add Created / Modified Fields from INHEAD.

MB - Max Basic

OE - Order Entry

Position Discontinued hint on the Product Code rather than at the bottom of the form.

RD - Report Designers

Add Company Report Preference (default for designed documents and reports) and Report Designer Property for PDF Image Max DPI, and if required downsample images as pdf files are generated.

RE - Report Engine

Make Start New Page on Main Group Break implicitly treat Account as a Group Break for Account Sequence style banded layouts. For Transaction Sequence style banded layouts only consider grouping on the first band for Main Group Break.

SYS - System

WS - Web Service

Bug Fix

ALL - All Modules

Fix ZipForge errors when backing up System Folders.

AP - Accounts Payable

AR - Accounts Receivable

CB - Cash Book

CO - Company

DI - Data Interchange

EM - Email and HTML editor

Fix SMTP signature with images issue.

FA - Fixed Assets

Mercury only issue, Fix FA Asset re-grouping journal to GL having wrong signs.

FD - Form Designer

Fix indexing issue for Surrogate Combo with COPERIOD as lookup source.

GST - GST

Fix BAS Return Form Calculations for Boxes G8 and G19. Net GST was correct.

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

PA - Purchase Analysis

Fix population of lookups on Analyse grid in Analysis Report Designers when Analysis Type is changed.

PO - Purchase Orders

RD - Report Designers

Fix Report Designer splitters for QBE and Query Results.

SA - Sales Analysis

Fix population of lookups on Analyse grid in Analysis Report Designers when Analysis Type is changed.

SP - Special Pricing

SQL - SQL

SYS - System

Import Users fixed to add company to existing System Users company list.

TD - Table Designer

Fix error message when schema size limit of 65535 bytes is exceeded.

WS - Web Service

Accredo 5 – Version 5.0.11.108

Improvement

ALL - All Modules

File recovery cleans up Permissions created during conversion for Roles and Users which have a Permission group.

AP - Accounts Payable

Add Open to Shipment Statuses. An Unprocessed Shipment may be set to Open which will prevent Post Invoice / Post Receipt until the Status is changed back to Unprocessed.

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

Added a Find by Order Number button to the IN Invoice List and OE Order List.

SP - Special Pricing

Added new SP Setting "Sell Relative Mixed Basis Prices". Selected, for Sell Relative Rules, if the Context Sell Price Basis differs from the GST Basis for the Price Code in the Rule, e.g. Customers price list is Inclusive and Price Code specified in the special price rule is Exclusive, or vice versa, then GST is automatically added / deducted. This means you can use one sell relative rule to return the same effective price regardless of whether the Context is working with Inclusive or Exclusive Sell Prices. Designed to work with the standard SPDefault.pfs script. If your Pricing Script has been modified to handle mixed basis do not turn this on as well.

TD - Table Designer

Allow data level events to modify custom fields on Accredo Tables which are read only for the user at form level.

XX - Install Scripts

Demo Data updated to September 2019 with Mobile Apps Navigator tab for Mobile Sales Demo reporting.

Bug Fix

ALL - All Modules

Fix Memo Account Name not displayed when a saved memo is opened.

AP - Accounts Payable

Fix handling of Discount in Divide Amount mode for Add Order Lines on AP Shipment.

CO - Company

EM - Email and HTML editor

FD - Form Designer

Fix introduced issue with setting Hook Control to a Grid.

GST - GST

Fix All GST behaviour for Other GST Regimes.

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

Fix OrderedCostBs calculation for Manual Kitsets.

PO - Purchase Orders

Fix handling of Discount in Divide Amount mode for Add Order Lines on AP Shipment.

RD - Report Designers

Fix alignment issues when printing designed document or report containing HTML memo component.

SQL - SQL

Fixed introduced issue in singleton select.

SYS - System

TD - Table Designer

WS - Web Service

XX - OLEDB/ODBC

Accredo 5 – Version 5.0.11.107

Improvement

ALL - All Modules

AP - Accounts Payable

Make Duplicate Contra / Duplicate as Credit for FX transactions and documents both retain and fix the source exchange rate.

AR - Accounts Receivable

Make Duplicate Contra / Duplicate as Credit for FX transactions and documents both retain and fix the source exchange rate.

CO - Company

DI - Data Interchange

Make the TotalCosts fields available to the ICComponentData object.

IC - Inventory Control

Hide Tax grid on Products and Analysis codes unless Other Tax Regimes have been added.

IN - Invoicing System

Make Duplicate Contra / Duplicate as Credit for FX transactions and documents both retain and fix the source exchange rate.

JA - Job Analysis

Added Include Inactive Jobs selection to Job Selections in Job Analysis Report Designer. Defaults selected and may be added to a report as a runtime selection.

MB - Max Basic

SYS - System

TD - Table Designer

The TDTableDesignerForm LoadTable and SaveTable methods now support an optional parameter FileName: String. Used in LoadTable([FileName: String]). FileName must be a fully specified path and file name of an existing custom or Accredo table. Used in SaveTable([FileName: String]). FileName must be a valid custom or Accredo table filename. The same rules as in the UI apply. If the parameter is not given or is an empty string, then the Open and Save Dialogs will be executed as happens in the form normally.

WS - Web Service

Image endpoint added.

Bug Fix

ALL - All Modules

AP - Accounts Payable

CO - Company

Fix issue when Company User Limits are applied with which user is reported as locking a process.

DI - Data Interchange

Add missing unmapped PriceCodes and Markups to Price Book Import.

EM - Email and HTML editor

Fix User Email setting for SMTP Only (BCC, CC) not applying in Accredo Mailer when Use SMTP Mailing is selected.

IC - Inventory Control

JC - Job Costing

Fix introduced issue in Saturn with Job Customer Code not replicated to JC Usages in IC.

MB - Max Basic

Fix HTTPRequest object handling of gzip compressed responses.

OE - Order Entry

Fix introduced issue triggering OELine events on duplicate Order.

PO - Purchase Orders

SQL - SQL

Fix GST tablename case sensitivity for permission check in SQL.

SYS - System

Fix issue when Company User Limits are applied with which user is reported as locking a process.

Accredo 5 – Version 5.0.11.106

New Feature

WS - Web Service

Add ReportLayout endpoint to web service to retrieve information about available layouts.

Improvement

ALL - All Modules

AP - Accounts Payable

Added Drill Up button on AP shipment lines which have been posted as Receipts, drills up to the IC Receipt transaction.

CO - Company

Reduce I/O on open company.

DI - Data Interchange

Make SerialNo available to ICManufactureBatch data object.

EM - Email and HTML editor

FD - Form Designer

GL - General Ledger

GST - GST

IC - Inventory Control

IN - Invoicing System

OE Back Orders layout, and for OE Allocations layout make OEHead Category fields available.

JA - Job Analysis

Add to Navigator option from within Report designers will populate the Shortcut User List from the Report User List.

MB - Max Basic

OE - Order Entry

OE Back Orders layout, and for OE Allocations layout make OEHead Category fields available.

PA - Purchase Analysis

Add to Navigator option from within Report designers will populate the Shortcut User List from the Report User List.

RD - Report Designers

Add to Navigator option from within Report designers will populate the Shortcut User List from the Report User List.

RE - Report Engine

Fix Report Layout to Excel error: Could not convert variant of type (Null) into type (OleStr) when using Totals Only and there are no values for the group. e.g. grouping on a category when some records do not have a category assigned.

SA - Sales Analysis

Add to Navigator option from within Report designers will populate the Shortcut User List from the Report User List.

SYS - System

Add From Address to email settings for System Users. If not specified, From Address will fall back to the User's email address.

TD - Table Designer

WS - Web Service

Bug Fix

ALL - All Modules

Fix possible "Range check error" with Window handles.

AP - Accounts Payable

AR - Accounts Receivable

Fix Customer / Creditor word lookup for Contact Fields other than Contact Name. Rebuild words in settings or run file recovery if affected.

CB - Cash Book

Fix Payment Due date defaulting for AP Cash Purchases inserted from CB Bank Reconciliation.

CO - Company

Fix locking issue for Alias and Merge when User Count is restricted by Company.

DI - Data Interchange

EM - Email and HTML editor

Fix introduced Mailer error in Beta.

FD - Form Designer

Fix "tblMemoryTable1: Domain definition 'POPostStatus' not found" error opening V4 custom form in V5.

GL - General Ledger

Fix Posting of GL Batches from Results window for Import from Subsidiary.

GST - GST

IC - Inventory Control

IN - Invoicing System

Fix Invoice Form state after immediate Cash Sale from an unsaved invoice.

JC - Job Costing

Fix handling of Discount for Invoice As Quoted using Pro-Rate or Difference setting.

MB - Max Basic

OE - Order Entry

Fix "Field 'Markup (%)' cannot be modified" exception for Kitset with positive and negative components on an OE Order when there are insufficient quantities.

PA - Purchase Analysis

Fix empty date formatting from SQL reports.

PO - Purchase Orders

RD - Report Designers

Fix introduced issue in V5 where OutputDirectory is not remembered within a session.

RE - Report Engine

Fix introduced issue in V5 where OutputDirectory is not remembered within a session.

TD - Table Designer

Fix Co Text Code domain registration issue.

WS - Web Service

XX - Install Scripts

Improve Firewall rules created by the Web Service installer.

ZIP - Backup

Accredo 5 – Version 5.0.11.105

Improvement

DI - Data Interchange

Ensure user permissions relating to access to sub objects are applied at the data level.

Bug Fix

AP - Accounts Payable

Fix AR and AP GST Payments Reconciliation report speed issue opening the report selections.

AR - Accounts Receivable

IC - Inventory Control

Fix File Recovery triggering basify for Accredo tables containing Product Code, UOM Multiplier and UOM Quantity when UOM is Active and table has been extended using TD to add a domain IC Product Code custom field.

SP - Special Pricing

Fix introduced issue for Special Pricing Maintenance form where Quantity Breaks are not enabled.

SYS - System

Fix assignment of Web Sessions for Web Service when legacy CM module is present.

TD - Table Designer

WS - Web Service

Ensure Regime and Currency caches are cleared when switching Companies.

XConv - Accredo Conversion

Fix conversion for Company without a Tax Regime.

Accredo 5 – Version 5.0.11.104

Improvement

ALL - All Modules

AP - Accounts Payable

Created and Modified Date / Time / User fields made available to AR Customer / AP Creditor Document tabs.

AR - Accounts Receivable

Created and Modified Date / Time / User fields made available to AR Customer / AP Creditor Document tabs.

CB - Cash Book

CO - Company

IC - Inventory Control

IN - Invoicing System

Change of UOM Sell Price was recalculating UOM Sell Price. Now fixed.

JA - Job Analysis

Add support for expressions for Custom calculated fields referencing other Custom calculated fields in Analysis Reports. In particular this is significant for calculating meaningful total percentages on custom calculations. Notes: * Fields are referenced as Calculated_Custom_n with n assigned sequentially as custom fields occur in the field list. * A custom calculated field can only refer to a custom calculated field defined 'before' it in the field list (i.e. lower numbered). * If a custom calculated field is reordered in the field list this may mean other calculated fields referencing it may reference a different field. ie. Expressions are not updated when calculated fields are reordered.

MB - Max Basic

Add Permission under Company\Scripts\Set Stamp User to Allow SetStampUser function to be used by user other than ACCREDO, default permission is None.

PA - Purchase Analysis

SA - Sales Analysis

SP - Special Pricing

Added Inactivate Rules process under Tasks > Special Pricing > Inactivate Rules. If Inactive Criteria is selected all rules with an Inactive Criteria, e.g. a rule referencing a now inactive Customer or Inactive Product will be made Inactive, note that any Criteria which are not found are considered Inactive. If an Expiry date is specified then additionally any Rules with an End Date prior or equal to the Expiry date will be Inactivated. Requires Write or Control permission for Rules.

WS - Web Service

New setting for the web service has been added - AllowBasicAuth - No, TrustedOnly & Yes. For TrustedOnly the Remote IP must be in the trusted IP list (regardless of using SSL or not). Tokens generated from a basic request will use up a license until the token is expired.

Bug Fix

ALL - All Modules

Fix Alarm trigger not firing in grids where movement on field exit is to a different row.

AP - Accounts Payable

AR - Accounts Receivable

Fix Credit shipment posting issue with Whole Balances allocation, "AP Period (none) not available for posting"

CB - Cash Book

CO - Company

DI - Data Interchange

Fix COM session allocation for new systems without legacy CM module.

EM - Email and HTML editor

Fix "Range check error" using Spell check in the Mail Editor.

GL - General Ledger

GST - GST

Fix Floating Point Division by Zero exception opening the GST Return forms when rate for earliest return has not been set.

IC - Inventory Control

IN - Invoicing System

MB - Max Basic

RD - Report Designers

Fix Mercury Only IC Manufacture batch sheet iterator issue.

RE - Report Engine

Fix report preferences not saved / loaded for non-customisable layouts such as the CB Reconciliation layout.

SP - Special Pricing

Fix exact match corner case for SP Who / What / Where selections.

SYS - System

Fix syncing of passwords from System to Company Users when System User password is changed at login prompt.

TD - Table Designer

XConv - Accredo Conversion

Accredo 5 – Version 5.0.11.103

Improvement

AP - Accounts Payable

Make additional flelds available to customise into the Allocated Transactions grids: AR and AP: Source ID, Source Module, Bill From Account Code AR only: Internal Reference, Job Code, Sales Area Code and Sales Person Code.

AR - Accounts Receivable

CB - Cash Book

Fix CB Analysis Groups balances permission set to none not hiding all balance related fields.

CO - Company

Make Last Modified Date for script file available to customise into the Script Events/Script Shortcuts grids.

DI - Data Interchange

Saturn only add Branch, Department and Location Codes to JC Batch Data Object.

GST - GST

IC - Inventory Control

IN - Invoicing System

For Cash Sales only default Bank Through true if all Banking Line Banking Media are Bank Through and the Customer is Bank Through.

JC - Job Costing

MB - Max Basic

PO - Purchase Orders

Allow PO Authorisation passwords to be reset without old password if user has Control Permission for PO Authorisations.

SP - Special Pricing

Allow TD extension for SPRule table.

SYS - System

Added System Setting to Sync Accredo User Company Ordering. If selected then the Company tab for the Accredo System User is automatically synchronised with the ordering applied to the Company Maintenance form.

TD - Table Designer

Allow TD extension for SPRule table.

XX - OLEDB/ODBC

Bug Fix

AP - Accounts Payable

AR - Accounts Receivable

Fix Analysis Name not displaying for dissections when Creditor or Customer has a GST Override set.

CB - Cash Book

CO - Company

DI - Data Interchange

EM - Email and HTML editor

GL - General Ledger

IC - Inventory Control

IN - Invoicing System

JC - Job Costing

MB - Max Basic

OE - Order Entry

PO - Purchase Orders

Fix permission test for editing posted documents to allow with Write permission for Document, provided Module Setting and Posted Documents permission are set to allow.

RD - Report Designers

Add extended error message for Code 87 print issue, Add retry loop to handle possible timing issue as cause.

RE - Report Engine

SP - Special Pricing

TD - Table Designer

CO Currency Domain for custom fields now has associated Lookup control.

WS - Web Service

Fix "code":400, "message":"Date not valid 01:49:32 PM" when trying to insert a time value into a custom field with type Time.

XConv - Accredo Conversion

Fix conversion issue for JC without IC.

XX - OLEDB/ODBC

Accredo 5 – Version 5.0.11.102

Improvement

ALL - All Modules

AP - Accounts Payable

Add OnPrint Events for ARTransactionForm (print Receipt) and APTransactionForm (print Remittance).

AR - Accounts Receivable

Add OnPrint Events for ARTransactionForm (print Receipt) and APTransactionForm (print Remittance).

CB - Cash Book

CO - Company

Navigator > Setup > Company > Configuration > Mail Settings, added replicated from System button to copy Company SMTP settings from System SMTP settings.

FD - Form Designer

Extend Last x selection in Report and other Designers to Last 9.

GST - GST

Handle negative taxable supplies and GST values in Grossed up figures for GST Return form.

MB - Max Basic

Added HttpFormBuilder to Miscellaneous objects. Added PostForm method to Accredo.HttpRequest object which accepts a HttpFormBuilder object as its parameter.

RD - Report Designers

Extend Last x selection in Report and other Designers to Last 9.

WS - Web Service

Extend odata request support to allow filtering in an expanded sub object.

Bug Fix

ALL - All Modules

Fix Access Violation in Retry dialog when Snapshots are in progress.

AP - Accounts Payable

Fix edit of shipment discounts after post receipts not requiring Update Costs. Prevent edit of shipment discounts after Post Invoice,

DI - Data Interchange

Add missing TransactionQuantity property for ICManufactureBatchData object.

GL - General Ledger

Include GST Code in fields replicated when Adding GL Account from Compare Charts of Accounts.

IN - Invoicing System

Fix GST Override not applied to IN and OE Charges.

JC - Job Costing

Fix Range check error when printing a JC Batch or Timesheet to Excel

MB - Max Basic

Fix Line.OldValues for new line causing "Bad Type for Argument" errors in line event script.

OE - Order Entry

Fix GST Override not applied to IN and OE Charges.

RE - Report Engine

Apply Layout field format to Opening and Closing balances on Cash Flow report layouts.

WS - Web Service

Fix WebService handling of System Paths with spaces in them.

XConv - Accredo Conversion

Accredo 5 – Version 5.0.11.101

Improvement

Bug Fix

Report a fault

Something not working as it should? Please let us know by filling out the necessary details on this form.

Feature request

Want a new feature added or something about your existing system altered to better suit your working practices? Fill out our feature request form.

Downloads centre

Get the latest updates to Accredo Mercury and Saturn here. Release notes for both products are also available.