Archived Release Notes

Accredo 7 – Version 7.0.13.110

Bug Fix

ALL - All Modules

Fix slowdown introduced by adding Progress Bars to Document saving. Replace with spinner activity to prevent "Not Responding" message from Windows.

DI - Data Interchange

Fix SPRuleData object not respecting ReadOnly permission.

Fix GLBatchData object handling for Read Only fields.

Price Book import - Fix supplier comment field size issue. Was allowing 20 char only.

IC - Inventory Control

Fix ApplySort/CancelSort in IC Stocktake.

IN - Invoicing System

Fix Progress dialog accumulation in Batch Reprice resulting in slow down or Out of Handles errors.

SP - Special Pricing

Fix exception message: Call to GetRecordCode double clicking the Inactivated Rules results list.

Accredo 7 – Version 7.0.13.109

Improvement

CB - Cash Book

Update Cashbook Statement Import definition CBANZ.pfi for change made by ANZ Bank on 12 May 2025 to their export format for Opening and Closing Balances. Updated definition is available in https://accredo.co.nz/additional-downloads/ and will be included in the 7.0.13.109 Server and Demo install files.

MB - Max Basic

Added SetEnvironmentVariable(EnvVar: String, Value: String) to the Environment functions group.

SetEnvironmentVariable function sets the value of an environment variable which may be retrieved using GetEnvironmentVariable.

Environment variables persist within a session and across company logins.

Bug Fix

AP - Accounts Payable

Shipment Insert invoice for Additional Cost trigger terms update based on Transaction Date.

AR - Accounts Receivable

Fix Progress Caption for AR Apply Default Terms from AR Customer Group.

CO - Company

Fix introduced Company Image position issue.

IC - Inventory Control

Saturn only, fix initial filtering of Bin Code lookup on IC Manufacture Batch.

Fix ICBinCodeData TD customisation issue.

IN - Invoicing System

Fix missing IN/OE TrackngQuantity flip-signing in Document Designer Tracking objects.

Fix exception message: tblMemTrkDtlGrid: Cannot modify a read-only dataset. Deleting an INInvoice created from an OE Order on Packing Slip generation basis where Product is tracked and no longer available.

MB - Max Basic

Fix byte field assertion failure.

OE - Order Entry

Fix missing IN/OE TrackngQuantity flip-signing in Document Designer Tracking objects.

RE - Report Engine

Fix incorrect application of sort on load for some report layouts.

SP - Special Pricing

Ensure Created and Modified information is reset during Duplicate for SP Rules.

TD - Table Designer

Fix ICBinCodeData TD customisation issue.

Exclude TD custom fields with Quantity domain from CO UOM Validation of Quantity fields.

WS - Web Service

Fix Endpoint /Table_ARADDR not returning correct skip token.

Fix web service Where Clause generation from skip token where the skip token includes an * or a ?.

XConv - Prophet Conversion

Allow for more than 255 fields due to SUP files.

Accredo 7 – Version 7.0.13.108

Improvement

ALL - All Modules

Fields not visible due to permissions now also cannot be filtered or sorted on.

AP - Accounts Payable

Ensure Shipment line Manually Apportioned Additional Costs field is updated on change of Product Code when no ICCost record is found.

CO - Company

Enforce company minimum password length limits when syncing System users.

Show error hint when Company Background picture cannot be found.

EM - Email and HTML editor

Derive default email template name when saved from subject.

Added logging for Http and SMTP emails. To log errors in Diag.Log, set Mail diagnostics level to 1 in View > Preferences > Trouble Shooting. To log success messages (i.e to confirm Accredo has sent the email from our end) set diagnostics to 2.

FD - Form Designer

Fix FD tab captions not handling ampersand when in a tab.

Allow moving Custom Form in design window Layout tab to extend it.

MB - Max Basic

Make File Encoding menu more obviously a menu.

Improve handling for external pdf files when AppendPDFs and MergePDFs function is used.

Allow QuotedString function to accept variant as first parameter, previously required a string.

RD - Report Designers

Make File Encoding menu more obviously a menu.

Allow Custom Report DrillDownCode and DrillDownTable properties to be set in code.

SYS - System

Enforce company minimum password length limits when syncing System users.

TD - Table Designer

Make TD Custom fields added to Transaction files available to Transaction Lists.

Refactor aliasing code to improve custom table constraint check speed.

WS - Web Service

Web Service Monitor grid views now have a print button.

Allow read access via Report\Queries permission for data object access via WS.

Detect Company Locked and return 503 (Service Unavailable) as Response.

Web Service Skip Token generation will now detect if the order by and key fields are the same.

XX - OLEDB/ODBC

Add ForceAnsi .ini option to ODBCDriver.

ZIP - Backup

Allow 7z verification phase of backup to be cancelled.

Note: Snapshot backups cannot be cancelled once in progress.

Bug Fix

ALL - All Modules

Relax Price checks to allow for Foreign Currency -> Base Currency -> UOM round-off.

Fix premature validate of Exchange Rate Date.

AP - Accounts Payable

Fix incorrect prompt on cancellation for Insert after Save in Transaction form.

Fix Form level period inference not updating edit button on AP/ AR Allocate Transaction Form.

AR - Accounts Receivable

Fix incorrect prompt on cancellation for Insert after Save in Transaction form.

Fix Form level period inference not updating edit button on AP/ AR Allocate Transaction Form.

CB - Cash Book

Fix incorrect prompt on cancellation for Insert after Save in Transaction form.

Fix DrillDown and Open issues with CB Banking Items List,

Fix null Variant to date error when doing period inferencing.

CO - Company

Company Minimum Password length setting allows up to 40 chars to match System setting.

Add support to delay COM activation until TfrmCustomMain.WMStart. Improve COM Server startup diagnostics.

Fix Merge and Alias To Code error reporting issue.

Update User Word Lookup when System User is added to Company.

EM - Email and HTML editor

Fix emailing via Microsoft 365 web requiring SMTP server address to not be blank.

Fix email content getting lost when Mailer form is moved to main window.

FD - Form Designer

Fix descending sort not being tracked by list grid.

Fix FD table designer multipart descending index issue.

GL - General Ledger

GL report designer - restrict Selection filter in Iterator to GLACCT fields included in the report cache.

Fix Find by Transaction ID on GL Transaction List.

IC - Inventory Control

Fix possible "Invalid Pointer Error" for Report Only options on IC Price Updates.

Fix Total recalculation not happening on data level ICComponentData save.

Fix Party Name not being populated for IC Product Quantity form.

Fix Lots/Bins picked from the lot picker for tracking on a Manufacture batch quantities incorrectly flipped to negative.

Fix speed issue marking a Stocktake as processed when there are many variations.

Fix StockValue incorrectly visible without Cost Price permission in Mercury.

Fix Lot Picker on IC Bin Movement Pick To batches making quantities negative.

Fix lurking instances of access to IC Costing information when IC>Product>Cost Prices permission is set to None.

IN - Invoicing System

Exclude line fields EffectiveSellPrice/EffectiveSellPriceBs from UOM validation check.

JC - Job Costing

Fix Site Address not pulling address co-ordinates from Customer delivery address, and ensure co-ordinates are saved from site address when delivery address is added or updated from JC Job.

Fix JC Batch Report missing UOM fields for Posted JC Batches.

Fix lurking instances of access to JC Costing information when JC>Jobs>Cost Prices permission is set to None.

Add TriggerField property to Estimate line event.

MB - Max Basic

Fix issue when using AddFileLink function with GSRTHD or GSTTRAN account files.

Fix missing filter automation on transaction lists.

Fix ICProductData.Barcode.Empty not emptying as expected.

Add Byte Field support to Max Basic.

CopyTable method on Memtables did not bring through indexes if there was no currently selected index on original table. Now fixed.

Require CO\Scripts permission set to Write for access to Geocode Script Editor.

Require CO\Scripts permission set to Write and SP\Settings set to Write for access to the SP Script Editor.

Fix period inferencing issue in Shipments incorrectly considering IC available periods as well as AP.

OE - Order Entry

Exclude line fields EffectiveSellPrice/EffectiveSellPriceBs from UOM validation check.

Prevent QuantityOrdered, QuantitySupplied, QuantityBackOrdered changes when LineStatus is Processed or Cancelled.

Leave Cancelled lines as Status Cancelled during GenerateInvoice.

PO - Purchase Orders

Fix introduced Access Violation on Field Exceptions in Purchase Orders.

RD - Report Designers

Fix drill down for screen reports from Memo report layouts to memos.

RE - Report Engine

Fix SQL based document report layouts (IN Invoice / OE Order / PO Order / AP Shipment layouts) not applying implicit sort for grouping document lines due to hardcoded sort.

Make Totals Only work with "flat filing" for csv or tab delimited format.

Fix drill down for screen reports from Memo report layouts to memos.

Fix 'not registered' errors for memos on ID Domain tables: CBSMITEM, GLACTREC, ICADHEAD.

SQL - SQL

Fix SQL engine TRedundantCriteriaFolding optimiser. Issue was resulting in exception message: Replace Node failed, was not found in Expression.

Fix SQL built in functions MinNumber and MinDate from always returning null.

SYS - System

Update User Word Lookup when System User is added to Company.

TD - Table Designer

Make AllCustomFields also bring in related fields so currency field checks don't fail.

Fix custom field insert issue in memo form.

WS - Web Service

Fix missing automation objects (AccredoHttpRequest) from web service worker.

Add Field Dependencies for APShipment and POOrder on Line to ensure order of ExpenseCode -> GstCode so that GstCode specified can override GstCode default per ExpenseCode.

Add Field Dependency ordering for ICStockTake endpoint.

Fix period inferencing issue in Shipments incorrectly considering IC available periods as well as AP.

Accredo 7 – Version 7.0.13.107

Improvement

AP - Accounts Payable

Include all fields in ARCustomer and APCreditor report layouts.

AR - Accounts Receivable

Include all fields in ARCustomer and APCreditor report layouts.

CB - Cash Book

CBASB.pfi updated to handle 2 or 3 digit suffix and with or without Opening/Closing balance files included following change to ASB export format.

GST - GST

Update MyIR link from GST Return form.

IC - Inventory Control

Trigger Line.BeforeSave event in IC Batch forms and IC Stock Transfers on change of Product Code for consistency with other Line.BeforeSave events.

Enable sorting on the IC Lot Picker.

Make Store Person code available in IC Pending Stock movement grid and Pending Stock Motion report layout.

IN - Invoicing System

Add Allow Credit Limit exceeded selection to IN Post Invoices form, enabled when user has Control permission for AR > Customers > Credit Limits. If selected invoices exceeding the Customer Credit limit which could be posted individually will be included in batch posting.

MB - Max Basic

Trigger Line.BeforeSave event in IC Batch forms and IC Stock Transfers on change of Product Code for consistency with other Line.BeforeSave events.

Improve memory usage when using a large snippet script.

Added new GetScriptOutput function to the script group.

GetScriptOutput returns the content of the Print stream as a StringList object.

Example of use:

Print "1"

Print 2

Print "Three"

Dim OutputLog as Object

OutputLog = GetScriptOutput

Print OutputLog.Text

Add Modified property to form objects, returns True if values have been modified.

Improve WS response when binary data is returned.

OE - Order Entry

Add Attach Links selection to Batch email Confirmations.

SA - Sales Analysis

Make Customer Credit Limit available as a Customer field in Sales Analysis.

WS - Web Service

Fix potential thread race condition in WorkerWatchDog DoIdleCheck and Worker ThreadPool scheduling.

Web Service watch dogs will now detect, log and recover (when possible) from exceptions occuring with their execution.

Bug Fix

AP - Accounts Payable

Fix introduced issue with From Period / To Period selection ranges on Documents tabs.

Fix issue with located Contact record in Phone Lookup displaying wrong or no PartyName.

AR - Accounts Receivable

Fix introduced issue with From Period / To Period selection ranges on Documents tabs.

Fix Credit Limit permission not applied to AR Customer Form correctly.

CO - Company

Fix issue with located Contact record in Phone Lookup displaying wrong or no PartyName.

Fix issues with Phone List and Email Lost not including Company Contacts on rebuild.

EM - Email and HTML editor

ValidEmail now checks for consecutive dots.

Fix html designer rendering issues.

Fix triggering of Mail Events for batch emails when default for the form is Unselected and Trigger Mail Events is selected at runtime.

Exclude Weblinks from Batch Email of documents when Attach Links is selected.

Fix AV when printing html document without a template.

Fix HTML Invoice Email Design not resolving Hyperlinks.

FD - Form Designer

Fix FD memory table designer Unicode domain issue.

GST - GST

GST Transactions - update GST amount when Tax Regime or Date changes.

IC - Inventory Control

Fix IC Manufacture Batch Entry Serial No delta issues when Product is not serial tracked or when quantity is changed to <> 1/-1.

Saturn Only. Make ICStockTransferForm.InwardsTracking toolbar available for Shortcuts.

Fix Tracking swap lines Assertion failure.

Fix issue in tracking generation when calculating Tracking Date for Lot Tracked products. Lot Tracked products which are not expiry tracked will now correctly use oldest LotDate in tracking generation.

Fix Part creation on Manufacture Batch to ensure Quantities are rounded to Line UOM Quantities.

Validate tentative lots for lot date and expiry date matching on save and post where multiple tracking lines for the same lot are entered but dates do not match.

Fix rounding issues when calculating Parts quantity from UOM Quantity where UOM Code is not base - Manufacture Batch & Order Entry / Invoice Entry.

Allow clearing bin code when using the ICProductBinData object in Saturn.

Fix LineBreak not getting toggled correctly on IC Batches and IC Components for Narrative lines.

JC - Job Costing

Fix rebuild of Phone and Email lookup tables not including JC Job Person.

MB - Max Basic

ValidEmail now checks for consecutive dots.

Remove printer name capture from Add to Report List.

Fix Access Violation executing an empty script file from a shortcut.

Fix triggering of Mail Events for batch emails when default for the form is Unselected and Trigger Mail Events is selected at runtime.

Make PrinterName automation work at data level directly as well as via Printer sub object.

Decrypt imported encrypted script when building procedure list in Script Editor.

Fix Functions that use ByRef slow looping when executed in Script Editor due to debugging.

Make OpenForm function work for ICPARTHD and ProductCode. Opens the IC Component Form.

Fix date functions to handle issues with September dates and "MMM" date format introduced by change in Windows 11 24H2 to use "Sept" instead of "Sep" for "MMM" format for month in dates.

OE - Order Entry

Make Manual Kitsets behave like an individual product for supply/backorder when Supply Whole Manual Kitsets setting is selected. Fixes handling when component does not allow backorder but kitset would be back ordered.

PO - Purchase Orders

Fix error on load of deleted PO Order where currency differs from currency of IC Cost record for Product and Supplier.

RD - Report Designers

Fix text alignment and spacing issues for print to screen, printer and pdf.

Guard against range check error caused by textwidth calculation making assumption about text content.

Fix introduced issue with OTF font output to PDF.

Fix loss of design-time PDF handling hooks if errors found during preview initialisation.

Fix introduced issue handling Line Feed followed by Carriage Return causing lock up.

Fix memo component loading to handle UTF encoding.

Fix designed report pagination issue for repeating bands where Split Across is false.

RE - Report Engine

Fix File Export issue with export not respecting loaded Output Folder.

Fix potential form creation AV issue for screen reporting.

SP - Special Pricing

Fix inactive SP Rule handling for Select Rules.

SQL - SQL

Fix Query Layout tab not populated when a saved SQL Query is loaded in the SQL Query Builder.

Fix change tracking string truncation and introduced VarFromData corruption issue.

Fix SQL Query cast to wide char (NChar) when cast size specified > 256.

SYS - System

Fix "Could not convert variant of type (Null) into type (OleStr)" error when SMTP username is cleared.

TD - Table Designer

Fix XML metadata reader corrupts Custom U (UString) length to 1.

WS - Web Service

Fix issue with web service monitor initial login where logged in user is valid.

Fix Web Service race conditions under high load leading to licencing issues.

Fix /developerdoc endpoint in Mercury web service throwing Access Violation.

Add multithread database protection to function TTokenInfo.HasCompanyLockRequest to avoid possible race conditions.

Add multithread database protection to the System Watch Dog.

Fix Web Client QR Code printing issues.

Fix issue during RefreshToken which had the potential to leave the token cache exclusively locked resulting in a 'dead' web service. Fix Group Locks Exception - remove Group Lock Check for web service build.

Fix Web Service lock up during Shutdown or Pause when request are in progress.

Accredo 7 – Version 7.0.13.106

Improvement

ALL - All Modules

Stop document / batch forms opened via drill down closing with launching form.

Sort Printer list drop down alphabetically.

AP - Accounts Payable

If Update JC Sell Prices from Shipments is selected and Shipment Line includes a Job Code allow and update changes to JC Sell Price and Sell Discount Percentage when Shipment is Reopened for Additional Costs.

AR - Accounts Receivable

Add Interest Rates Decimal setting (maximum 9 decimal places) for Interest charged on debtors overdue accounts.

Add ARCONTCT to files selected for Change tracking for Sales App. If you use the sales app go to Navigator > Setup > Company > Configuration > Change Tracking, edit and select Add Tables for Mobile App > Sales App from the toolbar to update your tracked tables.

EM - Email and HTML editor

Add better logging for MS Graph errors.

FD - Form Designer

Add confirmation prompts to delete menu options and when creating default field editors.

IC - Inventory Control

Saturn only. Relax requirement for no dispatched Transfers for Location when turning on Bin Tracking.

Add Tracked Serial not Specified Report layout.

For tracked products allow Adjustments for positive unspecified lot no / serial no when Quantity In Stock for unspecified will not exceed zero.

Ensure Prune History for Inventory Control respects individual Product Retain Years Tracking setting.

Add BatchID to Manufacture Sheet filename.

JC - Job Costing

MB - Max Basic

Improve code recorded for Document selections which may be read-only subject to permissions.

RD - Report Designers

Fix speed issues rendering pdf files and unicode characters.

RE - Report Engine

Add selection for Accredo vs Custom tables to TD Customisation report layout.

Fix speed issues rendering pdf files and unicode characters.

SYS - System

Surface Event client name and Event client user to SY Audit Log.

WS - Web Service

Add confirmation prompt for Delete Button in Web Service Config.

Timed out requests will indicate correct Status Code/Message in the response stats.

Fix Web Service Max Workers being reset on restart of web service.

Add improvements to web service/worker to detect 'stuck' workers and with additional logic to help identify the causes.

Bug Fix

ALL - All Modules

Fix introduced issue loading Balances/Activity tabs. Issue was elapsed time dependent and therefore intermittent.

Fix invalid period range when pruning leaves behind a non-historic document.

Fix Quoted CSV output for report layouts/ file exporting to quote quotation marks.

AP - Accounts Payable

Saturn only: Fix Branch / Department in transaction header not being applied to first dissection when there is no default on Analysis code.

Fix Saturn dissection Branch Name/Dept Name in dissections not syncing on change triggered from header or analysis code.

Fix changes to Sell Discount Percentage in Shipment Line not included in Update JC Sell Prices on Update Costs from AP Shipment.

AR - Accounts Receivable

Fix Saturn dissection Branch Name/Dept Name in dissections not syncing on change triggered from header or analysis code.

Mercury only. Fix AR Transaction customer balances control focused on base currency rather than customer currency.

CB - Cash Book

Fix CB Reconciliation report handling for Opening Statement balance and Unreconciled values when run for a period before a reconciled statement can be located.

Fix Saturn dissection Branch Name/Dept Name in dissections not syncing on change triggered from header or analysis code.

CO - Company

Fix timing issue with User Access Times triggering 5 minutes early.

Fix Phone No Lookup exception when searching for a phone no in COUser.

EM - Email and HTML editor

Fix HTML Invoice decoding text doesn't end up with <br> and %nbsp displayed.

FA - Fixed Assets

Fix Edit button not enabled on FA Depreciation Defaults.

FD - Form Designer

Handle grid and mem table race condition.

GL - General Ledger

Fix MYOB export to handle tab characters in string fields by stripping tabs from text fields for export.

Fix introduced "Cannot generate a financial report "A component named "expStdBalancePeriod" already exists" error generating a financial report from the wizard.

IC - Inventory Control

Fix Invoice tracking issues when a doing Cash Sale without having done Save first or Post via data scripting without first having done Save.

Fix introduced Open failed "'...\SPCTRL.pdb' Win32 Error. Code:2. The system cannot find the file specified" error saving products with UOM details in a system without Special Pricing.

Add support for LargeInt fields in SQL queries and filters.

Add missing ICPERS dependency for recovering ICCTRL.

Use Price List rounding when automatically applying markup via IC Post Transaction.

Automation for tracking is now available for post lines events e.g. ICStockTransferForm.Transaction.BeforeSave.

IN - Invoicing System

Fix shipper line position issue for OE/IN email templates when printing a document design which iterates Shipper lines.

Fix Invoice tracking issues when a doing Cash Sale without having done Save first or Post via data scripting without first having done Save.

Fix incorrect prompt on cancellation for Insert after Save in IN Invoice Entry form.

Fix Grid line transitory read only field in appended line when there is an event script hooked to LineAfterSave.

JC - Job Costing

Exclude Standing Invoices and Quotes from candidate invoice list for Job Invoicing > Generate Invoice.

MB - Max Basic

Fix Grid line transitory read only field in appended line when there is an event script hooked to LineAfterSave.

Automation for tracking is now available for post lines events e.g. ICStockTransferForm.Transaction.BeforeSave.

Fix change to filter not being detected for Save List View when Display Inactive selected.

Fix encrypted script permission check issue at the command line. Encrypted scripts functional from the command line.

System user requires encrypted script read permission.

Fix import of encrypted scripts.

OE - Order Entry

Fix shipper line position issue for OE/IN email templates when printing a document design which iterates Shipper lines.

Fix Grid line transitory read only field in appended line when there is an event script hooked to LineAfterSave.

PO - Purchase Orders

Fix Grid line transitory read only field in appended line when there is an event script hooked to LineAfterSave.

RD - Report Designers

Fix Symbol fonts Wingdings or Symbol incorrectly mapping to Unicode.

Fix Memo component font colour not applied.

Always Embed fonts in PDF's to ensure pdf's can be read on Apple devices, required due to improved handling of unicode in pdf generation.

RE - Report Engine

Fix File Export output folder selector button not enabled.

Fix Excel percentage totals calculation resulting in #VALUE! or Div/0 on grouped Aged Trial Balance.

SYS - System

Fix password sync issue for Importing Users. Existing System User passwords are not changed, Import just adds the company to the user list. For new system users password is imported from the first company.

Fix display preferences not saving for Reminder List.

TD - Table Designer

Fix Invariant Failed RetainYearsTracking 0 error extending ICPROD in TD.

Fix TD Customisation Report parsing of Key Parts.

WS - Web Service

Fix issue where deletion of an expired Basic token during request would not delete the underlying access token.

Fix Accredo Table Handler when requests switch from all rows to a single selection on the same table - reuse of freed field.

Basic Auth for SSL connections will now enforce the Allow Basic Auth setting when Trusted Only.

Reduce set of non writeable fields for Custom Tables (allow write to LineNo in custom tables).

XConv - Profax Converison

Fix Profax and Prophet Converters not creating GSRTSM records.

XConv - Prophet Conversion

Fix Profax and Prophet Converters not creating GSRTSM records.

Accredo 7 – Version 7.0.13.105

Improvement

ALL - All Modules

List Views now provide an option to save grid customisation or not.

Make space for the horizontal scroll bar in memo headers.

CB - Cash Book

Add Bank Account From / To selections and filter to the Cashflow report layouts. Note that Budget figures are not broken out by bank account.

CO - Company

Add ModuleCode and Permission selections to Setting Log.

EM - Email and HTML editor

Company Contact Lookup control added to Accredo Mail Editors in place of Word Lookup button. Select a contact to insert their email address or to append the email address after other addresses enter a semi-colon ; after the email address(es) already selected before selecting a contact.

Added a Compose Mail button to the Global Toolbar. The button opens a new mail message using the users email settings for Compose.

Fix Contact selection in Accredo Mailer not populating Full Name column.

FD - Form Designer

Remove spurious CustomTitleBar property from FD forms.

Capture stack traces for FD coding errors.

IC - Inventory Control

Add warnings in UI on save of a Product when UOM Codes are changed or deleted and Pending Transactions, Parts or SP Breaks using the UOM Code exist.

Fix IC Manufacture Batch Unit Name not updating when UOM Code is changed.

MB - Max Basic

Fix Excel worksheet trailing space issue when specifying sheet name via scripting. Preserve trailing spaces in Worksheet selection.

Added AddNewYear function:

AddNewYear([YearName: string, PeriodStyle: string, PlusAdjustment: Boolean, InitialStatus: string, StartDate: Date, EndDate: Date, Periods: Number])

All parameters optional and if none are specified a new year using the applicable defaults is created.

StartDate will only be used by the function if it is a new company i.e no existing periods.

EndDate and Periods will only be used if PeriodStyle is Custom.

Usage:

AddNewYear("YearEnding Custom", "1", True, "O")

AddNewYear

PeriodStyle param can be one of the following

'1', '12 Month'

'2', '4/4/5 Week'

'3', '4/5/4 Week'

'4', '5/4/4 Week'

'5', '52 Week'

'6', '13 Period'

'8', 'Single Period'

'9', '2 Period'

'A', '6 Period'

'7', 'Custom'

Add support for local timezone offsets when formatting dates in MaxBasic using "iso8601Tz" as the format string parameter.

Sample code:

Dim aDateTime as Date

aDateTime = Date + Time ' now

' format from DateTime variable

Dim isoDate as String, isoDateTz as String

isoDate = FormatDateTime(aDateTime, "iso8601")

isoDateTz = FormatDateTime(aDateTime, "iso8601tz")

Print "iso8601 DateTime:" & isoDate

Print "iso8601Tz DateTime:" & isoDateTz

' Convert to DateTime from string

Dim aTimeOnly as Date, aDateOnly as Date

aDateOnly = DateValue(isoDateTz)

aTimeOnly = TimeValue(isoDateTz)

Print "Parsed Date: " & aDateOnly

Print "Parsed Time: " & aTimeOnly

Add Index and FindExact method to Supplier sub object for ICProductData object.

Add Caption for List Views, caption is prompted for on Save, defaults to the List View name and is displayed as the Title / Tab name. Cation can be edited in the Shortcut for the List View.

Allow FindExact on Location grid in IC Product Form automation.

OE - Order Entry

Disconnect Invoice from Order if all order lines are deleted from the invoice.

Set OE Line Status to Unprocessed on change of line type from Narrative to Sticky Narrative.

PO - Purchase Orders

Relax Inactive code checking when a PO is Marked Unprocessed.

RE - Report Engine

Fix Freeze Excel Headers handling for Reports/Scripted Reports with New Page On Group Break preference selected.

SP - Special Pricing

Added Applying boolean to SP Context to be able to distinguish Query from Apply (price applied to document or transaction).

SQL - SQL

Implement ReplaceRegEx and MatchRegEx MaxBasic functions for SQL.

WS - Web Service

Add Show Workers checkbox, defaulting to off, to Show Logged in Users. Add optional ShowWorkers parameter to GetLoggedInUsers.

Per entity AddLink endpoints added.

Added AddNewYear function:

AddNewYear([YearName: string, PeriodStyle: string, PlusAdjustment: Boolean, InitialStatus: string, StartDate: Date, EndDate: Date, Periods: Number])

All parameters optional and if none are specified a new year using the applicable defaults is created.

StartDate will only be used by the function if it is a new company i.e no existing periods.

EndDate and Periods will only be used if PeriodStyle is Custom.

Usage:

AddNewYear("YearEnding Custom", "1", True, "O")

AddNewYear

PeriodStyle param can be one of the following

'1', '12 Month'

'2', '4/4/5 Week'

'3', '4/5/4 Week'

'4', '5/4/4 Week'

'5', '52 Week'

'6', '13 Period'

'8', 'Single Period'

'9', '2 Period'

'A', '6 Period'

'7', 'Custom'

Add Permissions for WS Tokens and enforce on View Logged in Users and views in Web Service Monitor. Access & Refresh tokens will be hidden on Web Service Monitor if user does not have token permission. Token Deletion via Token View Cache now permissioned by SY\Perm\Web Service\Tokens>Write.

Make Web Service Monitor more resilient to Authentication issues including reconnect capability.

Fix issue in Token Watch Dog relating to calculating the interval to the next Token Check.

Mask Tokens and Client IDs when logging (or response tracking) in Web Service.

Bug Fix

ALL - All Modules

Fix Force User Exit issue "exception message: Ancestor for 'chkIncludeAll' not found."

AP - Accounts Payable

Fix Allocation form handing of switch between MDI and Tab/Maximised.

Make Bank Account control on AR Receipt and AP Payment wider.

Fix enabling of Refresh button on Allocation form when no credit transactions are present.

AR - Accounts Receivable

Fixed issue of AR Transaction Discount being read only for an AR Receipt if an AR Invoice was created or viewed first in the same edit session.

Fix Allocation form handing of switch between MDI and Tab/Maximised.

Make Bank Account control on AR Receipt and AP Payment wider.

Fix enabling of Refresh button on Allocation form when no credit transactions are present.

EM - Email and HTML editor

Fix token locking issue when auto refreshing via web service.

Remove unnecessary token locking.

FD - Form Designer

Fix issue with legends painting behind bars in multi-series graph.

Fix introduced Graph index issue.

IC - Inventory Control

Saturn only. Bin Count lines now update tracking as changes are made when Bin Count Status is Counted. Previously only updated on save.

Fix permission visibility of Supplier Effective Cost Price on IC Product > Supplier costs.

Make BinCode available to ICManufactureBatchData object in Saturn.

Fix introduced "Cannot open IC Components - AccountCode not found" error when first product code does not have Components.

Fix INLINE missing record revision error aliasing Serial Nos with Serial No in line.

For Serial Tracked Sales product with no other tracking auto generate tracking for Adjustments. Note that in all other cases where tracking is required Adjustment do not generate tracking.

Fix Saturn only issue merging Bin Codes for a bin tracked location: exception message: tblICBnMvLn: Cannot perform this operation on a closed dataset.

Fix exception message: Field types do not match - copying dmICManufacture.tblUsageDetails (Description U) to rptICManufacture.tblUsageDetails (Description) when printing an ICManufacture Transaction.

IN - Invoicing System

Fix IN/OE Header Tab sequence.

Fix Assertion failure saving an edited invoice generated from an OE Order on Packing Slip generation basis.

Fix incorrect attachment name when emailing an invoice as a packing slip.

JC - Job Costing

Fix issue invoicing a foreign currency job from Job Invoicing when rate for date is not found in the Exchange Rates table.

Fix missing drill down from JC Transaction Form to source JC Batch.

MB - Max Basic

Fix re-entrancy issues in product and bin tracking related to script events.

Fix List View recording of clearing Customer or Creditor code in Document Lists.

Fix List View not capturing sorts.

Make BinCode available to ICManufactureBatchData object in Saturn.

Fix Ccc/Bcc fields getting overwritten by ForceSMTP.

Fix InputCode SetSubset registration to take variant parameters instead of string. ClearRange after setting indexname on a Dropdown control via scripting.

Fix JSON to string Unicode issues.

Add Storeperson automation property to OESalesOrderListForm and INInvoiceListForm objects.

OE - Order Entry

Fix IN/OE Header Tab sequence.

PO - Purchase Orders

Prevent clearing Line Status on PO Line.

Fix introduced error "UOMSupplierStandardCost of 0.000000 <> SupplierStandardCost of XX.000000 * UOMMultiplier of 1.00000000" on Save after Edit for a PO Order. Occurred when Supplier Standard Cost has been entered for a Product on the PO Order.

RD - Report Designers

Fix missing format selection for Batch Document emailing.

Fix Access Violation generating custom report from the Wizard when grouping is applied.

Fix white space after image in footer of document designs.

RE - Report Engine

Fix Group total labels not included when printing to Excel Worksheet.

Fix issue printing to Excel or in Excel format for Grouped report Grand Totals exceeding Excel Sum formula parameter limit.

SP - Special Pricing

Fixed Field Types do not match error printing SP Rule Edit Report.

SQL - SQL

Fix join algorithm used where the fields being joined on have different LeftPadded values.

SYS - System

Fix Demo system handling for adding a company when Regional Settings are not NZ or AU.

TD - Table Designer

Fix issues with changing the name of a custom field in use for a custom domain.

WS - Web Service

Fix WS AddFileLink endpoint for change of Application Setting COPrivateLinks.

Fix Skip Token Generation used in ExecuteSql for custom tables not working.

Fix token locking issue when auto refreshing via web service.

Fix Wide String support in MemTableToJson used in the UserReminders WS endpoint.

When Setting MaxWorkers via configuration endpoint or Monitor current workers will only be shutdown if the resulting MaxWorkers in lower than the current value.

Add missing Web Service Field Dependency for COMemo data object.

Allow for a ICStockTakeCount with CountStatus of 'C' to be inserted by the web service for a counted stock take.

XConv - Accredo Conversion

Fix conversion issue caused by presence of system files in data directory.

Fix TD prompt firing during conversion.

Accredo 7 – Version 7.0.13.104

Improvement

ALL - All Modules

Make open details button available on all Budget maintenance forms.

CB - Cash Book

Improve Statement Matching to flag match transaction in the future relative to the Statement Period with Action "Future" and handle Find locating transactions which are in the future better.

CO - Company

Document Defaults form, disable Edit PDF Document button unless a PDF Document design is specified.

DI - Data Interchange

Added CopyCostPrices and CopySellPrices methods to ICComponentData.Price sub object.

EM - Email and HTML editor

Add PDF & HTML Document option to Mail Message formats for Printing Invoices individually. Creates a Mail Message using the Default HTML Document specified in IN Settings > Email tab and attaches a PDF using the Invoice Document design file specified.

Improvements to Invoice HTML Designer wizard.

Include shipper information in Invoice HTML Designer wizard.

GST - GST

Added a GST Transaction Period layout under Navigator > Reports > Goods and Services Tax > Add Layout uses Period selections rather than GST Return selections to report GST Transactions.

IC - Inventory Control

Apply MaxDigit checks on TransactionQuantity and CostValueExclusive when posting IC Tranactions.

Add ICMFHEAD (IC Manufacture batch), ICADHEAD (IC Adjustment Batch), ICRTHEAD (IC Receipt batch), ICSTKHD (IC Stocktake), ICCNTHD (IC Count) to tables which can be tracked.

In Saturn only also add ICBNCTHD (IC Bin Count) and ICBNMVHD (IC Bin Movement) to tables which can be tracked.

MB - Max Basic

Added EnsureRefreshToken function in the Web function group, with the following signature

EnsureRefreshToken(Provider: String, User: String [, ExpiryWithinDays: Number]): Boolean

Provider: values are "O" - Office 365 or "P" - MS Graph

Will return true if RefreshToken will not expire within the number of days given, False otherwise.

If a refresh token will expire within ExpiryWithinDays days, then an authentication prompt will be presented to the user to complete login. The function will only return once this information has been entered. If ExpirywithinDays is not specified, then the logic for expiry will change to "expired if more than 67.5 days (75% of 90) have passed since first issued" which is what we do in the Batch Emailing case.

In all cases, we will assume RefreshTokens expire within 90 days of being first issued (which is currently the case for MS JWT tokens).

Sample usage:

msgbox(EnsureRefreshToken("P", "DEMO", 3))

Add UOMDecimals(UOMCode:String) MaxBasic function in the Number group. Returns number of decimals places used to display UOM quantities for the UOM Code.

OE - Order Entry

Add OriginalAmountOrdered and OriginalAmountOrderedBs (i.e. ExclusiveAmountOrdered+ ExclusiveAmountInvoiced) to OE Orders and OE Data panel.

Relax OE Generate Invoice Per Order or Customer constraining candidate Invoices to System Period when prompting for Invoice to Generate to. Scripted generate and Batch generation are unchanged.

RE - Report Engine

Swap the position of Printer and Format selection in Report selection dialogs for better workflow since Printer enabled depends on Format selected.

SYS - System

Enable system level grid customisation for Show Logged In Users.

Add /NONETWORKEXE command line and SYSTEM.CFG parameter. If parameter is applied prevents AccredoSaturn / AccredoMercury exe's being run from a network location.

Relax Use SSO restriction for Mail Token maintenance form.

WS - Web Service

Add read only for fields to metadata.

Add Unicode Attribute to Web Service Metadata.

Batch Request validation of an included host in a request URL will allow for implicit matches between specified and non-specified standard SSL (443) and non-SSL (80) ports.

Bug Fix

ALL - All Modules

Fix clearing/reverting column sort potentially also reverting applied filter.

Fix issue with sleepy form behaviour in tabbed mode switching to maximised /un-maximised unexpectedly.

AP - Accounts Payable

Fixes to read only state for Exchange Rate and Refresh / Lock Rate buttons on Receipt Only and Invoice Only Shipments after Posting or reopening for Additional Costs.

Fix introduced CB Transaction Drill Down issue for AP Payments from unconsolidated Banking Summaries.

CB - Cash Book

Fix Statement Import applying import changes to CB Statement Header when cancelled.

Fix introduced CB Transaction Drill Down issue for AP Payments from unconsolidated Banking Summaries.

CO - Company

Fix OE Access Read permission incorrectly required in order to Drill Up from Quote to Invoice.

DI - Data Interchange

Ensure Maximum Quantity and Minimum Quantity on ICProductData are Read Only in Saturn and Read/Write in Mercury.

EM - Email and HTML editor

Fix Format Painter handling for multiple lines.

Change Outlook detection algorithm to account for multiple defaults. To handle instances where both Outlook and another Mail Client are registered.

FD - Form Designer

Fix FD Calculator font size property not working.

GST - GST

Fix GST Reminders not getting checked.

IC - Inventory Control

Fix introduced issue causing UOM to revert to Base UOM in batches and documents on edit when "Use Strict UOM Quantities" is not selected and strict quantities fail.

Saturn Only. Fix Duplicating an IC Transfer Batch with 2 or more lines causing Accredo to lock up.

Further fixes to UOM Quantities and UOM Unit Cost Price calculation in IC Manufacture Batches.

Fix Sales Tracked Serial No showing as Available after post from JC Batch. File Recovery corrects affected serial nos.

Fix Lot or Serial Tracking Detail created for Manufactured product where UOM Code is not base UOM. Add File Recovery to correct from ICTransaction. Overall data is correct but this was resulting in File Recovery warnings.

Fix issue posting Manufacture Batch with Lines having UOM Code and mis calculation of UOM Cost Price in batch line. IC transaction is correctly posted. File Recovery will fix affected batch lines.

Retain Lot No in Manufacture Batch header on duplicate contra.

Fix IC Batch posting incorrectly applying Batch Created and Modified values to posted IC Transactions.

Add check to catch Retain Years Tracking set to zero on IC Product. Add file recovery code to fix any Products where Retain Years Tracking is set to zero by resetting to default value of 99.

Saturn Only Fix IC Transfers using User Branch and Department not Branch and Department for Location.

Fix Unit Cost Price on IC Receipt Batch not editable.

IN - Invoicing System

Fix Kitset Usage lines picking wrong UOM Multiplier when the SaleUOMCode is not the UOMCode specified in the Components. Invoice save correctly caught the error.

JC - Job Costing

Fix introduced issue with Approved JC Tran Cost and Sell without Special Pricing. Note: JC Batches not affected.

MB - Max Basic

Further fixes to FormatNumber handling of comma for thousand separator vs divide to thousands.

Fix Null string comparison when using OldValues object in Master event scripting.

Add support for alternative Excel file schema urls, to fix "Can not find workbook in OPC" error reading Excel file.

Saturn only. Fix dependence on User having a Default Location code for creating ICBinData object.

Fix incorrect LinkId being returned when using the AddFileLink function.

OE - Order Entry

For Packing Slip Generation Basis ensure that deleting an Invoice from the Order correctly resets InvoiceID on the OE Order to the last (non-deleted) Invoice ID for the Order.

Fix Kitset Usage lines picking wrong UOM Multiplier when the SaleUOMCode is not the UOMCode specified in the Components. Invoice save correctly caught the error.

RD - Report Designers

Fix possible exception message: Error creating window device context printing reports containing many Unicode characters.

Fix Report Designer Wizard Selections tab Input Type not populating Input options correctly when date parameters are present.

RE - Report Engine

Fix "Bad variable type" warning printing to Excel Worksheet with custom Foreign Currency amount field.

SQL - SQL

Fix Access Violation in SQL Criteria Generator when a MaxBasic function is used that does not have a mapped SQL function.

ExecuteSql now supports returning unicode strings.

Fix logic in query engine when determine if a predicate should be excluded due to having a cast expression.

TD - Table Designer

Remove DosDate field type in TD.

WS - Web Service

ExecuteSql now supports returning unicode strings.

Fix Table endpoint not returning rows when the 'ID' field is a non-unicode string.

Added Unicode support for Object & ExecuteSQL handlers when building skip tokens.

Update AccredoWebConfig64.exe with WebService install.

XX - Install Scripts

Update AccredoWebConfig64.exe with WebService install.

XX - OLEDB/ODBC

Fix ODBC Unicode column metadata.

Accredo 7 – Version 7.0.13.103

Improvement

AP - Accounts Payable

Added Find Order button to Add Order Lines form on AP Shipment.

CB - Cash Book

For AP Cash Purchase inserted to match an Unmatched Statement line from CB Reconciliation prevent changes to Payment Date triggered by change to Invoice date.

EM - Email and HTML editor

Check for expiry of refresh token and prompt for login before batch email when using Microsoft 36 web for email.

Add html formatting to source viewer.

GL - General Ledger

GL Report Wizard generates DrillDownCode and DrillDownTable properties for Account Code and Account Name, and in Saturn for Branch Code, Branch Name, Department Code and Department Name.

Fix introduced issue with Find in GL Batches Account field not using a GL Code field.

IC - Inventory Control

Improve when Lot No is entered for outward tracking and location (Saturn only) is bin tracked.

Add Tracking Transaction Detail report layout under Reports > Inventory Control > Tracking Reports > Add Layout.

Improve Stock Transfer (Saturn only) handling of pending tracking detail for tracked products and locations.

IN - Invoicing System

Accumulate Packing Slip No's in INHEAD Packing Slip No field (to limit of available size) when Invoice Lines relate to multiple OE Packing Slips. i.e. Generate Invoice per is set to Order or Customer.

JC - Job Costing

Make custom number fields added to JCJOB available to the Job Totals panel in the JC Job Form.

MB - Max Basic

Reduce record reads required when adding a single link using AddFileLink function.

Add SetConfigValue function to Environment functions group.

Added UOMActive boolean function to Accounting functions group. Returns True if UOM Status is Active, False otherwise.

OE - Order Entry

RE - Report Engine

Table Designer Customisation report layout now reports custom fields in the order they are added to the table rather than alphabetically ordered.

Work around screen report rendering issue in Remote Desktop app for Windows due to virtual video driver returning physical size of device context as 10 x 10 mm.

SP - Special Pricing

Add Find ID button to SP Rule List.

SYS - System

Updated Web Service client provisioning email to send scannable/saveable QR code. This can be scanned with the device camera or loaded from saved files on the device.

TD - Table Designer

Make custom number fields added to JCJOB available to the Job Totals panel in the JC Job Form.

WS - Web Service

Revert company access tokens to system tokens on failed login.

Bug Fix

ALL - All Modules

Fix Transfer from Sub Ledgers not excluding other unposted GL batches from the results Batch List.

Fix replication of toolbar shortcut buttons on Move to / from Main Window.

Fix MDI Window sizing issue on Move to Main Window from floating window.

Fix "Cannot focus a disabled or invisible window" error saving a List View with a dot in the Name.

AP - Accounts Payable

Fix stored Unit field in Document and Batch lines being lost on edit for non-UOM Products when UOM is active and optional.

EM - Email and HTML editor

Fix email token lock issue and change token locking model to use ID's.

Fix out of resources error caused by spellcheck running too frequently in Invoice HTML Designer.

Fix SMTP port timing issue.

IC - Inventory Control

Fix IC Single Count permission issue.

Fix customisation of fields on Tracking band of Product Tracking Reports.

Fix IC Manufacture Batch component lines revering to Base UOM code (and basifying so quantities are still correct) on Edit.

Fix Mercury only error "Setting 'IC\Perm\Transfers not found" on Quantities tab with Pending Manufactures.

Fix permission checks for drill down from IC Pending Transactions on Quantities tab.

Fixed misallocation and miscopy of Unicode Calculated Fields resulting in Access violation, e.g. for TransactionPartyName in IC Transaction lists.

Fix exception message: Field types do not match - copying dmICStocktakeEdit.Details (Description U) to frmICFind.tblMemStockDetails (Description).

IN - Invoicing System

Fix stored Unit field in Document and Batch lines being lost on edit for non-UOM Products when UOM is active and optional.

Fix JC Job Invoicing to apply TransactionType, ComponentCode, CostCentreCode to IN Line after Product Code to prevent loss of that information.

Fix Job Invoicing Due Date and Discount Date calculated against System Date rather than specified Document Date.

JC - Job Costing

Fix JC Job Invoicing to apply TransactionType, ComponentCode, CostCentreCode to IN Line after Product Code to prevent loss of that information.

Fix Job Invoicing Due Date and Discount Date calculated against System Date rather than specified Document Date.

Fix exception message: Field index out of range when duplicating a posted JC Batch.

MB - Max Basic

Fix MemoryTableBuilder not honouring Alignment.

Fix IC Single Count permission issue.

Added new "Unique public variable names" setting to View > Preferences > Trouble-shooting tab. If selected (recommended) then public variables with the same name as a MaxBasic function are disallowed.

Fix memo data navigation object issue.

OE - Order Entry

Fix stored Unit field in Document and Batch lines being lost on edit for non-UOM Products when UOM is active and optional.

PO - Purchase Orders

Fix stored Unit field in Document and Batch lines being lost on edit for non-UOM Products when UOM is active and optional.

RD - Report Designers

Fix Report Designer and HTML editor code editors unicode issue.

Fix issue with report designer writing files using incorrect encoding.

RE - Report Engine

Fix changes to Printer Settings not applied to Printer in Print dialog.

SP - Special Pricing

SP Rule Effective Margin % Calculation on Rule where there is only one break to allow for UOM Code in break.

SQL - SQL

Fix initialisation of empty string parameters in query engine.

XConv - Accredo Conversion

Fix Conversion potentially losing INHEAD Packing Slip No on Invoices generated from OE and then edited to add non OE sourced lines.

XX - OLEDB/ODBC

Fix various ODBC SQLWCHAR vs SQLCHAR issues.

Fix ODBC lacking support for WChar and WVARCHAR parameters.

ZIP - Backup

Fix System customisation backup recursing in the presence of MyImages.bmp.

Accredo 7 – Version 7.0.13.102

Improvement

JC - Job Costing

Allow Standing Purchase Orders to be associated with Standing Jobs, and PO Requests for Quotation to be associated with Quote Jobs.

PO - Purchase Orders

Allow Standing Purchase Orders to be associated with Standing Jobs, and PO Requests for Quotation to be associated with Quote Jobs.

XConv - Accredo Conversion

Fix Converters for Locking issue.

XConv - Mercury2Saturn

Fix Converters for Locking issue.

XConv - Saturn2Mercury

Fix Converters for Locking issue.

XX - OLEDB/ODBC

Improve ODBC Error Messages to include Driver Version.

Bug Fix

IC - Inventory Control

Fix Bin Tracking report layout in Saturn including Non-Diminishing Products.

Fix automation error in Mercury with ICStocktakeSingle form.

WS - Web Service

Fix SPEnquiry WebService endpoint for Unicode CustomerName issue.

XConv - Accredo Conversion

Fix conversion for version 6 incorrectly validating Serial No and Lot No.

XX - OLEDB/ODBC

Fix missing V7 metadata causing Assertion failures.

Fixed connection issue with Unicode ODBC driver when used from PHP / Zend.

Accredo 7 – Version 7.0.13.101

Improvement

EM - Email and HTML editor

Add Payment Terms and Discount Terms to HTML Invoice wizard.

Help - HTML Help

File and index differences V6 to V7 documented in the help.

JC - Job Costing

Allow IN Quotes and IN Standing Invoices for Normal JC Jobs when Allow IN Sourced Invoice Lines is selected. Track in JCINV and display on Job Documents tab. Insert menu on JC Job Document tab updated for additional options.

MB - Max Basic

Make MaxBasic Sub and Function Procedures in EDI Import designer and built in Export / Import designers available outside the band / tab they are defined in.

SP - Special Pricing

Fix "Field types do not match" error opening a Rule from SP Rule List.

Bug Fix

CB - Cash Book

Fix possible Access violation importing Bank Statement in 32-bit client.

MB - Max Basic

Fix ListView shortcut with usercode removed not appearing for any user.

SQL - SQL

Fix SQL Query Builder handling of criteria specified in the QBE grid. Unicode parsing issue.

Fix SQL Unicode issue causing some reports (Job Status report, some others) not to load band records until re-run after regenerate.

TD - Table Designer

Fix "exception message: List index out of bounds (10)" saving a Table from TD in a company which does not have all modules present.

WS - Web Service

Add support for ShortInt fields in web service.

XConv - Accredo Conversion

Remove spurious warning in TD Custom tables conversion "converted with warnings: Custom Domains must have the Lookup field selected".

Accredo 7 – Version 7.0.13.100

New Feature

ALL - All Modules

Added support for white listed environment variables in Link, Image and Export file paths. White list under Company Settings - Misc tab. Selecting a file from a white listed path automatically replaces with the environment variable.

Added ExpandEnvironmentVariables MaxBasic script function - see help for details.

Add Unicode support to Accredo. Selected fields have been changed from String to UString (i.e. Unicode). This allows entering and storing a much wider range of characters e.g. macrons, accents, Chinese, Japanese and Korean character symbols.

Unicode is a universal character encoding standard. This standard includes roughly 100000 characters to represent characters of different languages. While ASCII uses only 1 byte the Unicode uses 2 to 4 bytes to represent characters. Hence, it provides a very wide variety of encoding but at a cost in data size.

Fields which are now Unicode: Customer & Creditor Names, Address 1 through 5, Product Detail (not Description), Contact Names. Note that the Domains for the fields have changed.

TD also supports UString fields.

Buttons associated with controls (e.g. on lookup controls, amounts etc) are now the same size as those in toolbars.

Added SQL based Transaction lists under the Maintain tab in the Navigator for AR, IC, CB, AP, FA, GL, and JC modules.

Default to restricting master file code valid characters to A-Z, 0-9 as for Serial and Lot Nos. Add settings for permitted Special Characters and Allow Space to module settings. Currently for AR Customer, IC Product, AP Creditor and JC Job Codes. A report of codes which violate the settings is available.

Added Create List View wizard to SQL List forms. Get your list selected, filtered, sorted and grid customised as desired for a specific task then use Create List View to record that and add to the Navigator. List View permission under Company > Scripts controls access, no other scripting permission required, List View shortcuts are automatically associated with the creating user and may be deleted by the user.

EM - Email and HTML editor

Support XOAuth2 authentication for SMTP to allow Microsoft 365 web email options.

HTML Invoice documents for email. Currently for single email only, no batch printing option. Select Destination - Mail Message then Format - HTML Document.

Default HTML Invoice design setting added to IN Settings > Email tab.

Invoice HTML Designer with Wizard under Setup > Invoicing System.

Example HTML Invoice design included.

IC - Inventory Control

JC related fields added to IC Product for JC Transaction Type, JC Cost Centre and JC Component. If set these default in JC transactions and proxies when the product is selected - overrides values in batch header or document panel. The new fields are on the IC Product - Supplemental tab which is the IC Product - Suppliers/Bar Codes tab renamed.

IN - Invoicing System

Added IN, OE and PO settings to control replication of Memos and Links on document workflow stages:

IN - Invoice from Quote

OE - Back Order from Order / Order from Quote / Invoice from Order

PO - Order from Request for Quote

Options are Leave / Move / Replicate. Default is Leave.

JC - Job Costing

Added Job Person table. Job Person code can be assigned to a Job or a JC Batch. Users may have a default Job Person Code assigned. Job Person selection added to Job List and Transaction Batch List.

OE - Order Entry

Added IN, OE and PO settings to control replication of Memos and Links on document workflow stages:

IN - Invoice from Quote

OE - Back Order from Order / Order from Quote / Invoice from Order

PO - Order from Request for Quote

Options are Leave / Move / Replicate. Default is Leave.

PO - Purchase Orders

Added IN, OE and PO settings to control replication of Memos and Links on document workflow stages:

IN - Invoice from Quote

OE - Back Order from Order / Order from Quote / Invoice from Order

PO - Order from Request for Quote

Options are Leave / Move / Replicate. Default is Leave.

TD - Table Designer

Added a Toolbar to Custom tabs on forms where Accredo tables have been extended with TD. Shortcuts can be assigned to the toolbar.

Improvement

ALL - All Modules

Default to excluding Deleted documents from Document lists and Tabs with an explicit selection to include them. This means that History and Both Current and History selections exclude Deleted by default.

Memo Lists Type selection changed to a check list box.

Sorting Columns by clicking column header is now a three way cycle: Sort ascending, sort descending, clear sort (or revert to default sort is one is applied).

Added calculated HasLinks and HasMemos fields to grid in SQL based Document, Transaction and Batch Lists.

Save customisation for grids, toolbar buttons and custom tabs now groups users to select from as follows (subject to permissions): Global; Current User; Users or Groups with saved customisations; other Groups (and Roles for grid customisations); other Users.

Accredo form titles / tab captions now indicate Document Class or Transaction Type.

Added Drill Down button to Module Memo lists, User Memo list and Reminder List - drills down to the Account Code the memo is for.

Alt+- while in Tabbed mode opens the context menu for the active tab.

Memo Form - moved the Open Source button into the Form Toolbar.

AP - Accounts Payable

Added Refresh to the AP Approvals grid to refresh loaded transactions for changes made sice loading.

Added Regenerate button to the AP Approvals form, available when not editing, returns to the Selection form with selections loaded.

Added Merge1 through Merge4 60 character unicode "merge" fields to batch email grids and made these available in the Email Editor under a new Custom object. Values can be imported/exported into/from the grid.

Add Consolidate Emails On and Consolidate Attachments settings and options OE Email Confirmations, PO Email Purchase Orders and AP Email Shipments.

AR and AP Allocation forms now default Period to Current Period for the module if System Period is later than current period.

Added Period/Receipt Period/Invoice Period Names as available fields to AP Additional Costs layout.

Ensure IC Integration set to Not Integrated ignores IC Integration Basis for AP Shipments.

AR - Accounts Receivable

AR and AP Allocation forms now default Period to Current Period for the module if System Period is later than current period.

Added settings for Receipt Discount to Credit Terms tab in AR Settings.

Receipt Discount Calculation (default Selected) controls calculation of discount from Net Receipt based on customer discount terms.

Receipt Discount Allocation (default Unselected) controls whether Discount must be allocated when customer has discount terms set.

Add Default Order No Required AR setting applied to Inserting new Customers.

CB - Cash Book

CB Bank Reconciliation added Show/Hide Reconciled Transactions toggle to the horizontal toolbar between the grids.

Added Default Regime Code for Bank Accounts. If multiple Tax Regimes are used you can specify the Regime Code to default for CB Transactions for the account, regime code can still be changed at the transaction entry form.

Include Statement ID and Reconciled indicator on CB Transaction Form.

CO - Company

Added buttons to CO User Form to Add User as Sales Person, Add User as Store Person and Add User as Job Person.

SYUser and COUser SMTP Name now stored as fields in the User tables, previously stored as settings.

Add events for COScriptEventForm: OnOpen OnClose BeforeSave AfterSave.

Add an Add User to System button on Users, Groups and Roles form, enabled if Use Single Sign On is selected in Company Settings.

Provide company settings for Nominated Links and Images folders. Options are Company Settings are now System / Company / Nominated. If Nominated is selected the folder path must be specified and be a white listed Environment Variable.

Add Tasks > Company > Enter Memos entry to Navigator for CO Memo Form. Form was already available via other paths.

Company and User email settings updated for new Authentication options. Company settings can be enforced or User level selection permitted. Refer to the help for details,,

DI - Data Interchange

Add explicit transaction type specific Insert methods to data level transaction objects (e.g. InsertReceipt, InsertJournal, InsertInvoice, InsertCredit for ARTransactionData) and deprecate the Insert method (i.e. no longer document but still allow for backward compatibility).

EM - Email and HTML editor

Add Format Painter button to HTML Email Editor.

Allow paste of embedded images.

Remove Mail Integration from View Preferences.

Company Mail Settings updated with Web Mail settings and optionally centralised control for Compose, Send Batch and Send Mailer options.

User Email tab Mail Options for Compose, Send Batch and Send Mailer.

Added Paste as Plain Text (Ctrl+Shift+V) button and Context menu option to HTML email editors.

User Email Settings changes for Mail Options. May be restricted from Company Mail Settings. No Mail preference stored in Registry in V7.

HTML Source may be edited and saved in HTML Email editor.

Clear Formatting and Clear Tags buttons in HTML editors detect selected text and only change formatting within selection. If nothing is selected, then entire document is used as selection.

FD - Form Designer

In FD Designer when you edit a memory table a new Upgrade button has been added. Clicking the button prompts for confirmation and will convert all non Unicode domains to the equivalent Unicode domain if one exists. E.g. Name -> Name U, Address Line 1 -> Address Line 1 U etc.

Include detail of function parameters when a function is inserted from the Functions menu or when # is entered after a Function Name in code editors.

Set working directory for FD and RD when form or report opened in designer by Shortcut > Open Source.

GL - General Ledger

GL Budget Form added a Budget Code selection to Copy Budget Amounts dialog.

Add Default Font selection to GL Financial Report Wizard, The default font is loaded from and saved to Report Properties. Font sizes are calculated as the report is generated.

Add LineNo to GL Iterators for simplified reference to a specific iterator.

Post Status selection for All Batches in Batch Lists for IC, JC and GL now excludes Deleted Batches, use the explicit Deleted selection to view deleted batches.

GL Financial Report Wizard In the Actual > Year menu added options for

Full Year Balance, Full Year Balance Percent, Full Year Balance incl Adjustment and Full Year Balance Percent incl Adjustment.

IC - Inventory Control

Add Total Weight and Total Volume to IC Component Maintenance, and buttons on toolbar to update Weight and Volume on the Manufactured Product from the totals.

Add Weight and Volume / Extended Weight and Volume / Total Weight and Volume to IC Batches,

Add support for Links and Memos on IC Part headers (ICPARTHD).

Add LastTransactionPeriod based Serial and Lot History Pruning so that history prunes in complete Lots and Serial Nos.

Post Status selection for All Batches in Batch Lists for IC, JC and GL now excludes Deleted Batches, use the explicit Deleted selection to view deleted batches.

IC Product Form - none permission for IC > Products > Tracking hides the tracking group on the Product tab.

Added IC Setting to General tab for Generate Outward Tracking. Default is Selected. Strongly recommended if Bin Tracking in Saturn is in use so picking is directed.

Component Of form is available from the Navigator with a Product Code selection, and is script enabled.

Ensure IC Integration set to Not Integrated ignores IC Integration Basis for AP Shipments.

IN - Invoicing System

Add Category Indexes to INHEAD and OEHEAD to support list selections.

Add OrderNo selection to JC Job Invoicing form and to the Form and Data objects. Defaults from the selected Job and may be edited. OrderNo is passed to the generated invoice.

Add IC Store Person Code to IN Invoices and OE Sales Orders.

Improve handling of Packing Slip Count on Processed Orders, and Packing Slip Count to INHEAD for invoices generated from OE.

Allow Default Job Code to be specified for Standing Invoices and Quotations.

JC - Job Costing

Add Time Required to JC Job alongside Date Required field.

Insert and Duplicate on JC Job now Prompt for Job Type. Matching methods added to form and data objects for scripting with the old Insert and Duplicate methods retained but deprecated (i.e. not documented but still functional for backward compatibility).

Add OrderNo selection to JC Job Invoicing form and to the Form and Data objects. Defaults from the selected Job and may be edited. OrderNo is passed to the generated invoice.

Make Job Name for Default Job Code available to AR Customer and AP Creditor Document tab grids, PO Order List, AP Shipment List and JC Batch List.

Post Status selection for All Batches in Batch Lists for IC, JC and GL now excludes Deleted Batches, use the explicit Deleted selection to view deleted batches.

Job Person selection added to JC Job List.

JC Batch List is now SQL based with Job Person selection.

Add Job Person Code as a JA analysis Type and Job selection.

MB - Max Basic

Add support for Unicode script files. Default Encoding is now UTF8 with BOM.

Saving a file that was loaded as Windows 1252 will retain the Windows 1252 encoding rather then changing to the default encoding.

Added AfterPrint event to INInvoiceData, OEOrderData, POOrderData and APShipmentsData objects. Note: AfterPrint event will automatically put the document in edit mode (if it can be edited). Any changes made to the document inside the event will not require an explicit save. Aborting inside the event will abort any changes made by the user, but not the actual print (which has already happened by this stage), and not the change of the PrintStatus.

FormatNumber now supports terminating comma for format to Thousands.

e.g. in a financial report format $,0,_);($,0,)

Added ConvertAscii function with the following signature

ConvertAscii(UnicodeString: string [, CodePage: Number]) as string

Codepage is 1252 if not explicitly specified.

Report Writer Wizard / SQL Query Builder Wizard added new Selection Styles - FromEqualOrAll and ToEqualOrAll. Use as a pair where a single prompt is wanted for Between parameters in the query which if left blank will select From First to Last.

Add WasInserting property to data level masterfile objects.

Include detail of function parameters when a function is inserted from the Functions menu or when # is entered after a Function Name in code editors.

Added ActivePageName string property to Automated forms with Tabs.

Added MaxBasic functions in Script group:

LinkAccountFiles returns a string list of Tables that are Account files for Links.

MemoAccountFiles returns a string list of Tables that are Account files for Memos.

Add LinksPath and ImagesPath properties to the Company object.

Added OnOpen events for IC > Update Prices forms:

IC Supplier Cost Update

IC Reprice from Components

IC Global Price Update

IC Price List Copy

OE - Order Entry

Add Category Indexes to INHEAD and OEHEAD to support list selections.

Add Consolidate Emails On and Consolidate Attachments settings and options OE Email Confirmations, PO Email Purchase Orders and AP Email Shipments.

Add IC Store Person Code to IN Invoices and OE Sales Orders.

Added new Always Number on Generate setting for Order Entry:

Selected, (default and recommended) the next computer generated Packing slip number will be assigned on Generate Invoice if not assigned previously.

Clear, Packing slip numbers are not assigned on Generate Invoice (i.e. V6 and earlier behaviour.

Note: Selected on conversion from prior releases.

Improve handling of Packing Slip Count on Processed Orders, and Packing Slip Count to INHEAD for invoices generated from OE.

PO - Purchase Orders

Added PO Setting - Allow Ordering Discontinued Products, default unselected, and enforce the setting on Purchase Order entry.

Add Consolidate Emails On and Consolidate Attachments settings and options OE Email Confirmations, PO Email Purchase Orders and AP Email Shipments.

RD - Report Designers

FormatNumber now supports terminating comma for format to Thousands.

e.g. in a financial report format $,0,_);($,0,)

Include detail of function parameters when a function is inserted from the Functions menu or when # is entered after a Function Name in code editors.

Added optional URLExpression property to Picture Components. The image is clickable in pdf's if one is specified.

Set working directory for FD and RD when form or report opened in designer by Shortcut > Open Source.

RE - Report Engine

Display the current printer in print dialogs and allow printer selection from dropdown. Printer is used for Destinations Screen and Printer and for Mail Message or Disk File when Format is Adobe PDF.

SA - Sales Analysis

IC Store Person added as an SA Analysis Level and Document selection.

SP - Special Pricing

Added SP Rule List Form. SQL based list for reviewing rules. Rules may be opened in SP Rule Edit Form for edit using open details.

SYS - System

SYUser and COUser SMTP Name now stored as fields in the User tables, previously stored as settings.

Added Word Lookup to Company List, to locate Company by words in name.

Added System > Prune Audit log option the System menu. Requires Write permission for the Audit Log. Only the ACCREDO system user will have that permission level following data conversion.

Mail Feature Request and Mail Defect Report options under Help menu cc your QSP if QSP email address has been entered under File >Licensee Details,

TD - Table Designer

UpgradeTables function improved validation and non destructive by default.

UpgradeTable(TableName: String, TemplateName: String, [UpdateFields: Boolean, ReplaceSchema: Boolean])

Optional parameters not specified (or false) means

From the template schema, add a new table or add fields to an existing table or add indexes to an existing table or make string fields bigger (all non-destructive operations).

UpdateFields = True means:

Change Field types and sizes to match the template schema - could lose or corrupt data.

ReplaceSchema = True means:

Make the old table match the template schema and best effort with copying data. i.e drop fields, indexes and change fields types and sizes.

Prior version TD Custom tables can be loaded in Table Designer for upgrade to V7 if required. Registered Custom tables are upgraded automatically during V7 data conversion.

Added MaxBasic script function TDExtensible returns a string list of TD extensible Accredo tables.

WS - Web Service

Added FilterSort to Token Cache screen, applied clientside so filtering what is viewed not what is returned.

The following endpoints have been surfaced to the web service:

JCJobPerson

SPRuleListForm

JCBatchList

ARTransactionList

APTransactionList

ICTransactionList

CBTransactionList

GLTransactionList

FATransactionList

Add LinksPath and ImagesPath properties to the Company object.

XX - OLEDB/ODBC

Unicode enable the ODBC & OLEDB Drivers.

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.