Archive Release Notes

 

Accredo 4 – Version 4.0.10.130

Improvement

RD - Report Designers

Improve image compression and memory use when printing reports with images.

 

Bug Fix

ALL - All Modules

Fix extra keystroke required in grid navigation introduced by a fix in build 129.

AP - Accounts Payable

Fix selections issues with Aged Balances report layouts in AR and AP.

Fix issues with ReadOnly state for DueDate and Discount date.

AR - Accounts Receivable

Fix selections issues with Aged Balances report layouts in AR and AP.

DI - Data Interchange

Fix introduced PB Import issues with Custom fields and selling price/markup fields.

Prevent data level PostStatus edits to Deleted or Posted on all Documents.

EM - Email and HTML editor

Fix issue with embedded images in emails when not using the Accredo mailer.

IC - Inventory Control

Fix Special Pricing issue when UOM Code is set by scanned barcode.

IN - Invoicing System

Fix Special Pricing issue when UOM Code is set by scanned barcode.

OE - Order Entry

Fix corner case where an invoice could be generated with nothing supplied and BeforeGenerate event did not fire.

RD - Report Designers

Improve handling of partially transparent png files in documents and reports.

SP - Special Pricing

Fix SP Price List report handling of Price Code selection.

 

Accredo 4 – Version 4.0.10.129

New Feature

ZIP - Backup

VSS Writer updated to allow Stacktrace capture if required.

 

Improvement

ALL - All Modules

Added Find / Find Next for File Recovery log viewers.

Fix Windows 10 not handling ellipsis correctly when text cannot be fully shown.

AP - Accounts Payable

Exclude Posted documents from Contact exists check.

CO - Company

Fix filtering of Permission band on User report layout.

Add Print to grid for Recovery and Error Log Viewers, Print Report button prints the detail for the selected entry in the grid.

FA - Fixed Assets

Relaxed restriction on FA transfer to GL for future periods.

GL - General Ledger

Make all GL batch Header fields available to the GL Transaction Batches report layout.

Make Ledger Reconciliation Report warn about Untransferred / Unposted transactions.

Improve error handling and reporting for Import Chart of Accounts.

IN - Invoicing System

Exclude Posted documents from Contact exists check.

JC - Job Costing

Display Job Order No on Job Invoicing Form.

Allow JC Batch PostStatus to be set at Data level per the same rules as Form level (Unposted to Open / Open to Unposted).

MB - Max Basic

Environment function SessionCode to return the Session type added.

Cancelling Script Save during Exit Application will now cancel Application Exit.

Make ActivePage property available to the PostLines objects for the Header.AfterChange document events

Added BeforeSave and AfterSave events for the COLinkListForm.

Allow JC Batch PostStatus to be set at Data level per the same rules as Form level (Unposted to Open / Open to Unposted).

OE - Order Entry

Show Packing Slip Number and Document ID on Fulfill Back Orders Query, and make them available to Fulfill Back Orders Results form.

Exclude Posted documents from Contact exists check.

PO - Purchase Orders

Exclude Posted documents from Contact exists check.

RD - Report Designers

Treat transparency in Image files as transparent.

TD - Table Designer

Make UpgradeTable warn if Table has records and fields will be deleted.

Added Custom fields replication from OESHIPLI to INSHIPLI.

ZIP - Backup

Include Version and System information in Backup Comment, i.e. [4.0M] means Version 4 Mercury, [4.0S] Version 4 Saturn. Comment is displayed when restoring.

 

Bug Fix

ALL - All Modules

Fix Copy and Paste shortcuts not behaving correctly in Mail Editor.

Fix balance / budget permission not applied to LastYear values on Balance and Graph tabs.

Fix introduced issue with sorting of Word Lookups losing the word selection.

Fix possible Range check error existing the application.

Fix issue replicating custom FX Amount fields to Transactions from Documents.

Allow dates from 1 Jan 1800 through 30 Dec 1899 to be valid. Note that 31 Dec 1899 is the Null date and can not be entered. Issue was for date of acquisition on a Fixed Asset.

AP - Accounts Payable

Ensure AP Allow Creditor Change on PO setting is applied immediately on Create Shipment.

Fix introduced issue with Shipment Additional Costs Exchange Rate read only while Additional Costs are still editable,

Fix Remittance email template not positioned on Payment object.

Fix "X is not a valid tab index" issue on AP Shipment form.

AR - Accounts Receivable

Apply balances permission check early for print statement from Customer record.

Fix consolidated attachments for batch emailing documents printed in reverse order.

CB - Cash Book

Fix corner case which made it possible for a banking summary to be accepted more than once.

Fix Cash Flow report error relating to split tender banking items of opposite signs.

CO - Company

Reset Import Layout path on Open Company.

Fix error securing system with /Defeat=Y configuration switch.

DI - Data Interchange

Fixed issue in DI designer handling (trailing) spaces in Excel Worksheet names.

Updated Price Book Import to work off Product Data object, fixed assorted issues.

Fix introduced Price Book Importing issues.

Fix FA depreciation code not constrained to Valid Active codes in the data object.

Ensure IsRestricted is reset on navigation to new record.

FA - Fixed Assets

Fix Description and Information tab loading when OnOpen script navigates to a different record.

Include custom fields in FA Asset report layouts.

FD - Form Designer

Fix Access Violations relating to missing MyImages files.

Fix reported SetFocus issue in FD form.

Fix "Shortcut added twice" error when && is used in a button hint.

GL - General Ledger

Fix Unexpected token 'YearBudget' isue filtering the GL Budget Report.

IC - Inventory Control

Markup prices and CopyAllPrices on Component Maintenance were not respecting CostPrice and SellPrice Permissions. Now fixed.

Fix data level scripting error "Data not in insert or edit mode" triggered by editing markup source sell price with Automatically Apply Markups set true.

Fix Description and Information tab loading when OnOpen script navigates to a different record.

Fix UOMMaximumQuantity and UOMMinimumQuantity issue when ICQTY record does not already exist.

Fix JC transactions are not posting discounted Sales Value / Unit Selling Price to IC Usage transaction..

Add file recovery for Transferred Value / Account / Branch / Department used for IC Regrouping batches.

Fix any incorrect Transferred Values used for Regrouping automatically on next IC Transfer to GL.

IN - Invoicing System

Fix "Field 'Source Type' can not be 'Q’" error on save when trying to edit a Posted Quote.

Fix Order from Quote - failing to pick up Discount when lines are added to order before save, Only an issue if Special Pricing is not in use.

JC - Job Costing

Fix Description and Information tab loading when OnOpen script navigates to a different record.

Fix JC transactions are not posting discounted Sales Value / Unit Selling Price to IC Usage transaction..

Fix JC Batch Posting not permitted with Write Access and Posting permission.

MB - Max Basic

Fix validation of StringList parameter passed to MergePDF.

Fix background colour change issue with Save to Excel appended to an existing file.

Reset default script folder on close / open Company.

Fix error attempting to rename temporary file for emailing when file has not been created due to nothing to print.

Fix introduced issue creating script shortcuts in code, flagged as restricted by user with no users unless Users explicitly emptied or added. Workaround is to edit and save the affected shortcuts from the UI.

Fixed issue with setting ActiveProperty in AfterChange event on Document Headers if user tabbed to exit field.

Fix Exit inside Try Catch incorrectly caught as an error.

OE - Order Entry

Fixed introduced error running Order Report without Banking fields visible.

Fix Order from Quote - failing to pick up Discount when lines are added to order before save, Only an issue if Special Pricing is not in use.

PO - Purchase Orders

Fix Mark As Processed for PO Order Data not checking for unprocessed shipments.

Fix introduced issue where making a PO Unprocessed - does not reinstate outstanding values and ICPends. File recovery on PO corrects any affected PO Orders.

RD - Report Designers

Fix Wordwrap True on Expressions with number formats breaking formatting of positive and zero Amounts.

RE - Report Engine

Fix consolidated attachments for batch emailing documents printed in reverse order.

TD - Table Designer

Fix Tab Order not loading for Custom Tab customisations.

Fix possible "Record is unavailable" warning when an Alarm is triggered. Only occurs if a memo table had been extended to add a 'code' field that has memos, and the alarm that is being triggered has a value for the 'code' field.

 

Accredo 4 – Version 4.0.10.128

New Feature

CB - Cash Book

Add Show Cash Flow button to CB Bank Account Maintenance - Transactions tab, and CB Transaction Form, and GetCashFlow method to CBTransactionData object. These Display / Return the Cash Flow by GL Account for the selected Transaction. Cash Flow is shown in Base currency.

Add new Cash Analysis Sequence report layout. Navigator > Reports > Cash Book > Analysis Reports > Add Layout Reports Cash Flow by Transaction in base currency and may be grouped as required.

Add new Cash Flow Period and Year to Date report layout. Navigator > Reports > Cash Book > Analysis Reports > Add Layout Reports Cash Flow Period and Year to date in base currency by GL Account with Opening and Closing balances from Bank Accounts. Selections for Bank Account and Period with an option to include GST which reports Inclusive of GST, or if not selected GST is reported in GL GST Accounts.

 

Improvement

ALL - All Modules

Add option under View > Preferences to Drop down on Double click for Lookups.

Relax requirement to delete future budgets when Inactivating masterfiles.

AP - Accounts Payable

Add InclusiveAmount / InclusiveAmountBs fields to Dissection band for Transaction Sequence reports.

Add a Reopen for Additional Costs option to Shipments available if the user has Control permission for AP Shipments.

Add AP Shipment Setting to Allow Creditor Change on PO Shipments. If selected the Creditor Code may be changed after Creating a Shipment from a PO Order and the link to the PO Order will be retained.

Add APShipmentEntryForm.BeforeAddOrderLines and AfterAddOrderLines events.

AP Shipment Form - Add Total Quantity to the Totals panel.

Subject to permissions and usual restrictions AP Approval related fields on AP Invoice and Credit transactions may be edited after transfer to GL. (Approval Amount, Hold Amount, Approval Discount, Due Date, Discount Date).

AR - Accounts Receivable

Add InclusiveAmount / InclusiveAmountBs fields to Dissection band for Transaction Sequence reports.

Add new AR Setting for Default Credit Limit. Applies to new Customer as they are inserted.

Add Job Name to fields available to AR Aged Transaction and Transaction sequence layouts.

CB - Cash Book

Add InclusiveAmount / InclusiveAmountBs fields to Dissection band for Transaction Sequence reports.

Cash Flow and Cash Flow by Account Class reports improved. Add an option to include GST which reports Inclusive of GST, or if not selected GST is reported in GL GST Accounts. Cash Flow effect is reported in the period of the CB Transaction not when allocated which reduces the "Unknown" value. Unallocated AR and AP sourced transactions are reported in the relevant GL Clearing Account. Where budgets are reported accounts with a budget value but no cash flow actuals are included in the report.

CB Reconciliation Report changed All Periods heading to display Last Available period for CB. Add Show Last Available selection to Reconciliation Report selections (selected by default) to allow Last Available column to be suppressed for year end reporting.

CO - Company

Switch to File Browser style dialog for folder selection in Company setup.

Drop .\ from data paths in Company Menu as redundant.

Add MaxBasic functions to Company function group for OptimiseCompany.

SMTP password maximum length - increased to 120 characters.

DI - Data Interchange

Add PackingSlipNoRequired boolean property to INInvoiceData object. If property is set True in the data level BeforeSave events the next computer supplied number will be applied on successful save.

Add new Accredo.HttpRequest object.

Fix issues with ARContactData and APContactData. FullName now expands as expected, FirstNameLastName and LastNameFirstName are correctly flagged Read Only. Example Import and Export definitions updated.

FD - Form Designer

Add AddPieColor(Color as Number) and ResetPieColors methods to FD and RD graphs.

Add Generate button to FD Memory Table and Table field editors to generate MaxBasic code to create a matching memory table.

A saved memory table definition (created using Memory Table Builder) may now be loaded into an FD Memory Table component.

Make ZipFiles and UnzipFiles functions available in FD context.

GL - General Ledger

Improve test for setting GL Recovery Required when GL Accounts are edited.

Modify default formatting for Page Header from GL Financial Report Wizard based on feedback.

Make the Adjustment Period be available for selection on the GL Ledger Reconciliation report.

IC - Inventory Control

Add IC Stocktake designer and print options dependent on Stocktake type. Designer uses Stocktake Lines for Single or Additive stocktakes or Products (and location) for Basic stocktakes as the iterator. Allows designed alternative to the Stocktake Forms layout.

Saturn only Disallow Minimum Quantity and Maximum Quantity for Inactive Locations. File Recovery will fix them and report the change.. Making a Location Inactive will zero them.

Saturn only. Add UOM selection to Location tab if UOM is Active or Pending. Quantities are displayed relative to the selected UOM code, and Maximum / Minimum Quanrtities are edited relative to the selected UOM code.

IC Stock Transfer Form (Saturn only) - Add totals for Quantity Dispatched, Quantity Receipted and Quantity Adjusted to the Totals panel.

IN - Invoicing System

Batch emailing Invoices - Consolidate emails setting and selection which consolidated by email address, is replaced by Consolidate Emails On selection with options for None, Email, and Customer and Email.

Add Number Packing Slip option to IN Invoice Form toolbar to allocate the next packing slip number and save the invoice.

Add PackingSlipNoRequired boolean property to INInvoiceData object. If property is set True in the data level BeforeSave events the next computer supplied number will be applied on successful save.

Allow Posted Unprinted invoice to be made Manual for print status.

Add BankingLine band to Invoice and Order layouts.

Add new boolean property to INInvoiceData object: DocumentNoFromPackingSlipNo if set True before save and the document has a PackingSlipNo or PackingSlipNoRequired is set true prior to this being set True then PackingSlipNo will be assigned to DocumentNo on save.

JC - Job Costing

Add transient SourceJobCode property to JCJobFormwhich returns the JobCode duplicated from after Duplicate. Property is similar to SourceDocumentID - it is not stored.

Relax Sell Currency matching constraint for related jobs.

Add Job Name to fields available to AR Aged Transaction and Transaction sequence layouts.

MB - Max Basic

Handle Events scripts triggering during script recording.

Add the following OAuth2 functions. OAuth2TokenFromAuthCode(ClientID as String, ClientSecret as String, Scope as String, TokenEndPoint as String, AuthEndpoint as String, UsePKCE as Boolean) OAuth2TokenFromResourceOwner(ClientID as String, ClientSecret as String, Scope as String, TokenEndPoint as String, Username as String, Password as String) OAuth2TokenFromRefreshToken(ClientID as String, ClientSecret as String, Scope as String, TokenEndPoint as String, RefreshToken as String)

Add Refresh Cached Scripts option to context menu on empty area in form toolbars. Refreshes Header.BeforeChange, Header.AfterChange, Line.BeforeSave, Line.AfterSave event scripts and Special Pricing script which are cached for speed. Cache is now automatically refreshed if a script is edited from within the same session.

Group Web functions separately.

The format property will now work with TnDateTime fields in Memory tables.

Add GetPropertyValue Script function which takes an Object as a first parameter, and a Property Name (string) as a second parameter and returns the value of the property.

Add Master.BeforeChange and Master.AfterChange script events for Masterfile maintenance forms.

Add APShipmentEntryForm.BeforeAddOrderLines and AfterAddOrderLines events.

Line.BeforeSave and Line.AfterSave events now return Line.TriggerField.

Add a range of JSON functions to the Web function group: BuildJSON - Construct a JSON Object from an Accredo Object JSONClone - Clone a JSON Object into a new Object JSONCreateArray - Create a JSON Array JSONCreateObject - Create a JSON Object JSONDelete - Delete a property from a JSON Object JSONLength - Returns the length of a JSON Array JSONPop - Removes and returns the last element of a JSON Array JSONPush - Add an item to the end of a JSON Array and return length JSONShift - Removes and returns the first element of a JSON Array JSONSplice - Removes element from a JSON Array JSONStringify - Convert a JSON object to a formatted string JSONToString - Convert a JSON object to string JSONUnshift - Add an item to the beginning of a JSON Array and return length ParseJSONFromFile - Parse from given JSON file into JSON Object Refer to the functions help in the current help file for usage.

Add POAuthorMatrixForm BeforeClose / OnOpen / OnClose events.

Add 'current directory' support to all the SFTP file based methods. These include the following: Get Put Rename Delete RemoveDir MakeDir Size This provides support for relative file paths by setting CurrentDirectory first. Explicit file paths are also still supported by these methods.

Add Generate button to FD Memory Table and Table field editors to generate MaxBasic code to create a matching memory table.

OE - Order Entry

Add BankingLine band to Invoice and Order layouts.

PO - Purchase Orders

Add POAuthorMatrixForm BeforeClose / OnOpen / OnClose events.

RD - Report Designers

Add AddPieColor(Color as Number) and ResetPieColors methods to FD and RD graphs.

Add IC Stocktake designer and print options dependent on Stocktake type. Designer uses Stocktake Lines for Single or Additive stocktakes or Products (and location) for Basic stocktakes as the iterator. Allows designed alternative to the Stocktake Forms layout.

Modify default formatting for Page Header from GL Financial Report Wizard based on feedback.

SP - Special Pricing

Add calculated HasBreaks property to SP Rules for filtering.

Add SP Cost Relative Inclusive Sell Prices setting. If selected then for Cost Relative Rules if the Context Sell Price Basis is Inclusive then GST is added to the Effective price using the GST Code for the Product. This allows one cost relative rule to return the same effective price regardless of whether the Context is working with Inclusive or Exclusive sell prices.

Relax Special Pricing Rule List priority requirement: Rule List Designer: If Priority is ticked as being a selection then its value may be cleared or set to 0 - both meaning no filter on Priority when rules are loaded. SP Rule List If priority was ticked as being a selection then it may be cleared which will show rules for all priorities. Insert Rule from Rule list if priority was ticked as being a selection and the default value was set that value will default. If no value was set as default then the SP Rule default priority of 9 will be applied.

Add EffectivePriceExclusive field to SP Pricelist fields.

SQL - SQL

Add SQL support for Date minus Date returning number of days.

TD - Table Designer

Make Toggle Inactive button available for Lookup fields for on Custom tabs where they conform to the Inactive model as follows: When controls are created for lookup fields, the associated lookup table will be analysed for the following: An Index named ActiveMaster with the first field being a boolean named Inactive and the second the lookup field An Index named Master on the lookup field. e.g. ActiveProduct and Product indexes on ICProd table. If this case is found then the inactive button & inactive menu will be available with behaviour as expected.

 

Bug Fix

AP - Accounts Payable

If AP\UpdateJCSellsFromInvoices is false and Shipment Receipt Post Status is Posted then Reprice for the shipment should show JC Sell Prices and JC Discount unselected and read only i.e. Reprice not permitted for JC Sell or Discount. Now fixed.

Check for IC / JC period available before updating costs from AP Shipment.

Check permissions for AP Generate Payments related to Payment Method earlier. Electronic Banking and Computer Printed Cheques payment method permissions were only being tested at time of Export / Cheque Printing respectively. Change is to check permission before Run for that payment method.

Fix Add Order Lines / AddLinesFromOrder not setting focus to last line added.

Tighten test for Update Costs required from AP Shipment to prevent possible Save without Update Costs where additional costs or duty have changed.

Fix introduced issue preventing entry of Manually Apportioned Additional costs values on shipments.

Fix introduced issue editing Markup % for Job related AP Shipment lines.

AR - Accounts Receivable

Fix issue loading content for batch document emails with Simple MAPI / Livemail.

Fix Access Violation applying Customer filter to Aged Transactions Monthly report in a Report list or Script.

CB - Cash Book

Fix CB Banking Summary BeforeSave event not firing when Save is triggered by Accept Summary or Print Summary.

Close corner case which allowed banked Banking Summary to be deleted.

CO - Company

Prevent Access Violation error on AlignNestedControls.

Fix HTTPS protocol links being changed to CID when used in HTML mailer.

Add Windows error code to "Reading Printer Driver Properties failed" error.

Fix issue with offset on UserGlyph numbering in COScriptShortcutData .

Fix Display issue with Windows scaled and Minimise/Restore of Application.

Fix scaling issue when Windows is scaled with Minimise and Restore affecting Status bar and Toolbar.

Fix Company HTML Signature Image path not displaying image with UNC path.

DI - Data Interchange

Add ICBinLocationData object. This provides a data level equivalent to the ICBinLocnMatrixForm.

Fix reprice not checking post status at data level on document objects.

Allow data level import for Cost Relative Rules with Percentage > 100.

Fix issue introduced in build 126 with Modified not updating from within a transaction for Masterfile edits where subobjects were not updated.

FA - Fixed Assets

Fix introduced FA to GL Regrouping batch not balanced for change to one split line.

Fix Detail Activity schedule reporting where there is more than one transaction for the same activity type.

FD - Form Designer

Example Dashboard updated.

Fix duplicated Tooltips for OK and Cancel buttons.

GL - General Ledger

Fix introduced FA to GL Regrouping batch not balanced for change to one split line.

Avoid load of GLBatch lines for first batch on creation of the object, lines are loaded for first batch navigated to. Fixes speed issue checking for untransferred batches when first batch is very large.

IC - Inventory Control

Add ICBinLocationData object. This provides a data level equivalent to the ICBinLocnMatrixForm.

Fix introduced issue with Allow Back Orders for Non-Diminishing product selected also allowing Back Order for non Backorder Diminishing products.

Fix IC Label printed from Product record in Saturn not passing in the selected Location Code.

Fix LocationCode not printing for IC Label where there is no ICQty record for the location and Product,

Fix enabling of Print button on IC Product Quantities form in Saturn.

Fix exception message: ICCOST missing Record Revision update on ICPROD during AP or IC Prune.

Fix issue removing Counted flag for a Product via the Enter Quantities form not updating the stock take line correctly, File recovery fixes any affected stock take lines.

Fix update of Branch / Department / GLAccounts in ICQTY on transfer to GL used for IC Regrouping to GL.

IN - Invoicing System

Check Post permission at data level for IN Invoice Data object.

Fix read only state for Sales Person Code on duplicated Invoice or Order.

Exclude edited Posted Documents from recalculating totals on save.

JC - Job Costing

Fix Error: "Field 'Account Code' must have a value on save after adding Job links to a newly created and saved Job with an auto assigned Job code.

If AP\UpdateJCSellsFromInvoices is false and Shipment Receipt Post Status is Posted then Reprice for the shipment should show JC Sell Prices and JC Discount unselected and read only i.e. Reprice not permitted for JC Sell or Discount. Now fixed.

Fix introduced JCBatchData.AfterSave event not firing from Forms.

Fix General Access Denied error when setting JCBatch Line UnitCostPrice in script for a ManuallyCosted Product with Enforce IC Cost Prices setting in JC.

Prevent Merge for Jobs with differing SellCurrencyCode.

MB - Max Basic

Fix MaxBasic compiler check code speed issue with many elements per line.

Fix Add Order Lines / AddLinesFromOrder not setting focus to last line added.

Fix introduced JCBatchData.AfterSave event not firing from Forms.

Fix OpenForm function validation of second parameter for ICTFER, CBSTMT, GSTTRAN and ??MEMO forms.

Fix issue with offset on UserGlyph numbering in COScriptShortcutData .

Add backward compatibility for InputList parameter changes which were triggering "Range check error".

Fix AfterChangeScript potentially triggering "tblMemLineClone locked" error when Branch / Department / Location code changes are rippled to document lines. Saturn only issue.

Fix IsRestricted flag not set for OEOrderData during GenerateInvoice.

Fix General Access Denied error when setting JCBatch Line UnitCostPrice in script for a ManuallyCosted Product with Enforce IC Cost Prices setting in JC.

Fix Access Violation applying Customer filter to Aged Transactions Monthly report in a Report list or Script.

Fix issue with display of custom glyphs on scripted form grid toolbars.

OE - Order Entry

Fix introduced issue with Allow Back Orders for Non-Diminishing product selected also allowing Back Order for non Backorder Diminishing products.

Fix introduced Backordered issue for Products flagged to disallow backorders.

Fix IsRestricted flag not set for OEOrderData during GenerateInvoice.

RE - Report Engine

Fix introduced possible Stack Overflow exception when filtering detail on Master/Detail layouts.

Fix "Unsupported function" errors for String functions in Advanced Filters on SQL based report layouts.

SP - Special Pricing

Allow data level import for Cost Relative Rules with Percentage > 100.

Make SP Effective Margin calculation handle Inclusive Selling Prices as expected.

Fix Product Cost Prices not populated for SP Price List reports.

Fix initial special price for Auto Kitset components using quantity zero instead of kitset quantity to probe for price.

TD - Table Designer

Fix exception closing Custom Table Editor after printing from the Editor.

XConv - Accredo Conversion

Fix 3.6 to 4.0 data conversion error: TcnvJCActual36: Field 'Period ID' must have a value.

XConv - MYOB

Fix MYOB converter handling of Australian Bank account numbers.

 

Accredo 4 – Version 4.0.10.127

New Feature

JC - Job Costing

Added Show Invoices button to JC Job Transactions tab toolbar. Button is enabled for Transactions which have been invoiced, and displays the new JC Transaction Invoice Query form which lists the Invoices the transaction relates to with drill down to the related invoice lines.

 

Improvement

ALL - All Modules

Add new Filter Operators: == Literal Equal To ## Literal Not Equal To Which explicitly treat wildcard characters i.e. * ? as literal rather than wildcard characters to enable filtering for fields containing ? or * as characters.

Added a User preference for Enable Delete on document and batch forms. If selected (the default) and User has delete permission the Delete button on the Form toolbar is enabled, if not selected the button is disabled and documents / batches may only be deleted using the document or batch list.

Make filter button available on Category lookups on Master file and Document forms.

Added /DEFEAT config parameter, to enable Oplock Defeating. Currently defaulting False. Add /DEFEAT=Y to System.cfg file in System directory to turn on. Ensure all users are logged out prior to applying switch and all users are on the updated executable. Def column added to Diagnostics > Files to indicate which files have defeats in place.

AP - Accounts Payable

Made APApprovalForm selection properties available to scripting, PaymentDueOnOrBefore, PlannedPaymentDate and PaymentPriorityUpTo.

Add Inactive toggle to Customer / Creditor Code selection on AR / AP Batch Email forms.

If Query mode is selected for Apply Rules on CB Statements then Discount may be entered in AR Receipt and AP Payment transactions as the rules are applied.

Added Show Variations button to AR and AP Transaction Form toolbars.

AR - Accounts Receivable

Add Inactive toggle to Customer / Creditor Code selection on AR / AP Batch Email forms.

If Query mode is selected for Apply Rules on CB Statements then Discount may be entered in AR Receipt and AP Payment transactions as the rules are applied.

Added Show Variations button to AR and AP Transaction Form toolbars.

CB - Cash Book

Add Summary Type selection to CB Banking Summaries list.

Make budget code on Cashflow layouts optional. If not specified, budget is not used.

CO - Company

Add Trouble-shooting Preference to Capture Mailer stack traces.

DI - Data Interchange

Added IsRestricted boolean to Document, Batch and Transaction data objects (currently with the exception of ICTransactionData). IsRestricted is true while Documents, Batches and Transaction are being saved as a result of a system process such as the Invoice created by GenerateInvoice from an OESalesOrder. When IsRestricted is true changes can not be made by an event script to any Accredo fields, but may be made to TD Custom fields in the DataObject.

Made APApprovalForm selection properties available to scripting, PaymentDueOnOrBefore, PlannedPaymentDate and PaymentPriorityUpTo.

Added ShowReadOnly method to mailer object. It takes a filename (eml extension) as a parameter. The given file will then be loaded (using the existing LoadFromEML method), and the mailer will then be shown. The Resend button will display as a "Close" button and form will display in Read Only mode.

Allow edit for JCTransactionID on INInvoiceData for IN Sourced lines. Successfully assigning a JCTransactionID to an Invoice line will populate the following fields on the line from the JC transaction: JC Transaction Type, CostCentre Code, Component Code, Product Code, Description, Sales Group, GL Account Code, Narration, Custom 1, Custom 2. Up to the scripter to enter prices, discounts and quantities to be invoiced.

Added AppendToFile boolean property to data level printing of documents.

Add PackingSlipNoRequired boolean property to OEOrderData and DocumentNoRequired boolean property to INInvoiceData objects. If property is set True in the data level BeforeSave events the next computer supplied number will be applied on successful save.

FA - Fixed Assets

Add an Asset Location selection to the FA Asset report selections.

FD - Form Designer

Added Show/Hide Component order to the Component menu. Show displays a re-sizable component tree below the component palette. Components can be dropped into component containers (panels, group boxes and scroll boxes) and component hierarchy can be changed by dragging and dropping.

GL - General Ledger

Relax period constraint on Transfer to GL from subledgers.

IC - Inventory Control

Made ICProduct - BarCode available to Pending Stock Motion and Back Orders / Allocations report layouts.

Add a UOM Quantities report layout under IC Product Reports to include the quantity fields for the product / location in terms of the selected UOM code with a UOM code selection. Provides a way to report the information which is available on the Quantity Tab when a Quantity UOM is selected.

Added events on ICTransferData for BeforeDispatch, BeforeReceipt, AfterDispatch and AfterReceipt. Fires events in the following sequence: BeforeDispatch / BeforeReceipt then AfterDispatch / AfterReceipt.

IN - Invoicing System

Made ICProduct - BarCode available to Pending Stock Motion and Back Orders / Allocations report layouts.

Added a filter button to Delivery Code / Site Address lookups.

Make Alternate lookup (Alt+F2) available for Delivery Codes / Site Addresses. Alternate lookup is ordered by the sorting order applied in Customer Maintenance for delivery codes. Primary lookup is by delivery code.

Added help topic for taking a Portrait Document design to Landscape. Added example Landscape IN Invoice, OE Packing Slip and PO Order documents available on the FTP site or with Server installs.

Added new OE Setting (not selected by default) to Allow Customer Change After Print. Added new IN Setting (not selected by default) to Allow Customer Change After Print as Packing Slip. Note that Customer change is never allowed after Invoice Print.

Added settings to OE and IN to Allow Packing Slip Number Change After Print. Setting is only effective if Allowing Manual Packing Slip Numbers.

Add PackingSlipNoRequired boolean property to OEOrderData and DocumentNoRequired boolean property to INInvoiceData objects. If property is set True in the data level BeforeSave events the next computer supplied number will be applied on successful save.

Added Shipper and ShipperLine objects to OEPackingSlips and INInvoice email templates. These will point to the first shipper line (if there is one), or empty if not.

JC - Job Costing

Added a filter button to Delivery Code / Site Address lookups.

Make Alternate lookup (Alt+F2) available for Delivery Codes / Site Addresses. Alternate lookup is ordered by the sorting order applied in Customer Maintenance for delivery codes. Primary lookup is by delivery code.

Duplicate / Duplicate Contra for JC Batches / Timesheets / Disbursements now clears Complete for WIP and Fully Invoiced flags for all lines. This is consistent with Duplicate and Duplicate Contra for an individual transaction. The original state of those values is not known for a posted batch since lines are not retained after post and transactions are loaded instead.

MB - Max Basic

Added Add Script Event and View Script Events options to Context Menu on Form Toolbars (right click on empty space in toolbar). Add Shortcut on Script Editor has become a menu with options to Add Shortcut, Add Script Event, View Script Events.

Make Word Lookups filter sort script enabled.

Added optional Default value string parameter to InputList function.

Added OnOpen / OnClose events for GLSubsidiaryForm.

Made script shortcut editor scriptable and added OnOpen and BeforeSave events.

Added events on ICTransferData for BeforeDispatch, BeforeReceipt, AfterDispatch and AfterReceipt. Fires events in the following sequence: BeforeDispatch / BeforeReceipt then AfterDispatch / AfterReceipt.

Expose more workstation preferences to the GetPreference function: GridLineColor, ErrorHintColor, StatusHintColor, ReadOnlyColor, CreditColor.

PeriodDifference function now returns zero if FromPeriod and ToPeriod parameters are the same, and returns a negative difference if FromPeriod > ToPeriod.

Added ObjectProperties function to the Script functions group. ObjectProperties(ObjectName: String[, Expand: Boolean]): Object Returns a StringList Object containing a string list of the properties of the object ObjectName. If optional Expand parameter is true (default false) then sub object properties are also included.

Preserve ScriptArgs passed to a Custom Report if the report is regenerated from the Screen Preview.

OE - Order Entry

Made ICProduct - BarCode available to Pending Stock Motion and Back Orders / Allocations report layouts.

Added a filter button to Delivery Code / Site Address lookups.

Make Alternate lookup (Alt+F2) available for Delivery Codes / Site Addresses. Alternate lookup is ordered by the sorting order applied in Customer Maintenance for delivery codes. Primary lookup is by delivery code.

Added help topic for taking a Portrait Document design to Landscape. Added example Landscape IN Invoice, OE Packing Slip and PO Order documents available on the FTP site or with Server installs.

Added new OE Setting (not selected by default) to Allow Customer Change After Print. Added new IN Setting (not selected by default) to Allow Customer Change After Print as Packing Slip. Note that Customer change is never allowed after Invoice Print.

Added new OE Setting to allow Back Orders of Non Diminishing Products, default is unselected. Manual kitsets are exempted from the setting and backordered based on components as always.

Added settings to OE and IN to Allow Packing Slip Number Change After Print. Setting is only effective if Allowing Manual Packing Slip Numbers.

Add PackingSlipNoRequired boolean property to OEOrderData and DocumentNoRequired boolean property to INInvoiceData objects. If property is set True in the data level BeforeSave events the next computer supplied number will be applied on successful save.

Added Shipper and ShipperLine objects to OEPackingSlips and INInvoice email templates. These will point to the first shipper line (if there is one), or empty if not.

PO - Purchase Orders

Added a filter button to Delivery Code / Site Address lookups.

Added help topic for taking a Portrait Document design to Landscape. Added example Landscape IN Invoice, OE Packing Slip and PO Order documents available on the FTP site or with Server installs.

RD - Report Designers

Added help topic for taking a Portrait Document design to Landscape. Added example Landscape IN Invoice, OE Packing Slip and PO Order documents available on the FTP site or with Server installs.

Added ReportPreview boolean function to Document designers. Returns true if Print Preview was selected.

Preserve ScriptArgs passed to a Custom Report if the report is regenerated from the Screen Preview.

RE - Report Engine

Improve speed when filtering / grouping within a detail band on Master / Detail reports.

SP - Special Pricing

Make ValuationCost available to the Rules Grid. Cost is populated if there is a Product specified in the What (same rule as for Effective Price and Margin).

Explicit silent Abort in SP Pricing scripts now cancels write-back of SP Specials silently, previously always triggered a message.

New Special Pricing setting added "Apply on Manual Cost Changes". Default is false. If Selected, then when the line cost is changed on a Manually Costed product, Special Pricing will be triggered and the line cost price passed in as the initial cost price. Warning: You should only select this option if you require cost relative special pricing for manually costed products i.e. special pricing calculated from the manual cost that is entered on the document line, and do not use Special Pricing to set Special Cost Prices.

TD - Table Designer

Make open details from Custom Lookup Field position on the record from the lookup.

Add Case Insensitive property to TD Keys tab. This allows for a case insensitive lookup on a mixed case field.

Make GLSub TD extensible.

Prompt for confirmation on delete from TD Custom Table Forms.

 

Bug Fix

ALL - All Modules

Fix issue with Email Templates not displaying HTML body when there is Plain Text content.

AP - Accounts Payable

Ensure Update Costs is triggered when Make Receipt Only is selected for an AP Shipment with posted receipts.

Disable Bill To button on Customer and Creditor Transaction form while editing Customer or Creditor.

Fix custom field population on Job Status report for pending transactions.

Handle invalid information in import to Customer / Creditor batch email forms.

Fix "Dataset not in edit or insert mode" exception triggered by Ctrl+D / Ctrl+M shortcut keyed on a shipment when not in edit mode.

AR - Accounts Receivable

Disable Bill To button on Customer and Creditor Transaction form while editing Customer or Creditor.

Fix Customer.PeriodOpeningBalance for Calendar Months statements.

Handle invalid information in import to Customer / Creditor batch email forms.

CB - Cash Book

Fix error printing Banking Summary if Hash Total cannot be calculated.

CO - Company

Fix issue with left aligned images in HTML signatures not displaying.

Fix Preview from Email Editor triggering a warning error message "Mail Contents" has not been specified when no signatures are found.

Fix issue with deleting script events.

Fix Phone Lookup table scanning issue.

Transform phone number in phone lookup prior to checking transformed numbers.

FD - Form Designer

Reinstate missing Height property on Font object.

Handle ID fields in CreateDefaultEditors on FD grids.

Fix custom Variant field issues.

GL - General Ledger

Improved I/O (hence network speed) for GL Reconciliation Report.

Fix Account showed more than once on GL Reconciliation Report for Fixed Assets where Asset and Depreciation both point to the same GL Account.

GST - GST

Fix Branch and Department in GST settings not included in Alias or Merge.

IC - Inventory Control

Fix ICCNTLN missing Record Revision update on ICCNTHD.

Make ValuationCost in Stocktakes and Counts use Cost Price domain not Amount domain.

JC - Job Costing

Remove check for active contact when saving an Inactive Job.

Fix custom field population on Job Status report for pending transactions.

Fix introduced error opening related jobs.

Fix Inactivate Completed Jobs at EOP / EOY check for unposted invoices.

Fix JC Transaction custom fields not loaded in posted JC Batch Forms where there are matching JC Line custom fields.

MB - Max Basic

Fix OnOpen event firing on Move to new window.

Fix issue with application of Format and FormatMode to MemoryTableBuilder fields.

Fix LoadFrom Excel date handling issue.

Memory tables - fixed format mode not applied when exporting to Excel. Also, fixed issue with setting FormatMode against the field in the Builder object prior to CreateTable.

Expose CostMode Property on APShipmentEntryForm Post Lines Object.

Fix Custom glyph display issue on Server 2008 R2.

Fix custom Variant field issues.

OE - Order Entry

Enforce Ordered Quantity setting during Fulfill Backorders query run, i.e. prevent Supply quantity being changed to exceed order quantity.

Fix OE Packing Slip documents Line.EffectiveSellPrice and Line.EffectiveSellPriceBs returning zero.

PO - Purchase Orders

Fix loading of SupplierComment, SupplierStandardCost and SupplierStandardCostDate read only fields on PO Lines.

RD - Report Designers

Handle mapping of Symbol fonts such as Wingdings in designers and pdf's.

Handle loading of Custom Report with invalid "Wizard" content.

Fix introduced AutoHeight band issue causing unexpected wrapping of expressions.

Fix lazy loading issue for PO Order Category Descriptions.

Fix Customer.PeriodOpeningBalance for Calendar Months statements.

RE - Report Engine

Fix introduced reporting issue with JC Reports and Percent Complete.

Fix pass through of Email File Name from Email template when emailed via Print to Screen then emailed.

Fix introduced issue with IC Component Report exception message: Field types do not match - copying dmICCompEdit.tblMemPartDuty (Percent 2) to rptICComponentMaintain.tblMemPartDuty (Percent 1).

Fix Access Violation introduced by lazy loading for printing Product Labels when AR or AP module is not present.

Assorted improvements to speed of pdf generation.

Fix introduced issue with cc and bcc on emails not applying.

Fix "Field 'ShipmentCreditorName' not found." error running AP Shipment Additional costs layout grouped by ShipmentCreditorName.

SP - Special Pricing

Only show Where fields for Special Pricing maintenance if a Where criteria is selected. (Saturn only)

Fix spurious SP Maintenance error “Mismatch between currency code and Who1/Who2 implied currencies" when selecting Rule Type Cost Relative with Who Type of AR Category 1.

SQL - SQL

Fix handling of null parameter in SQL MaxNumber function.

TD - Table Designer

Handle ID fields in CreateDefaultEditors on FD grids.

Fix exception printing the Table Register.

Fix JC Transaction custom fields not loaded in posted JC Batch Forms where there are matching JC Line custom fields.

Fix custom Variant field issues.

XConv - Accredo Conversion

Fix introduced data conversion issue converting from 3.6 or earlier custom field data has not converted.

XX - OLEDB/ODBC

Fix Access Violation in meta data cleanup on driver unload.

ZIP - Backup

Fixed Backup / Restore truncating Datapath to 60 characters.

 

Accredo 4 – Version 4.0.10.126

New Feature

ALL - All Modules

Added Company > AccredoMailer > BeforeSend and AfterSend events. The events are only enabled if Use Accredo Mail Form is selected in Company Mail Settings since that is required in order for Accredo to have control of these events.

Added High DPI Aware preference and Application size selection under View > Preferences > Display. High DPI Aware selected is the default, and scaling of Application size is applied on top of any Windows scaling for your Primary monitor.

GL - General Ledger

Add new GL Ledger Reconciliation Report. Compares Ledger balances with the values posted to the GL and shows Clearing account balances.

MB - Max Basic

Added Company > AccredoMailer > BeforeSend and AfterSend events. The events are only enabled if Use Accredo Mail Form is selected in Company Mail Settings since that is required in order for Accredo to have control of these events.

Added Header.BeforeChange and Header.AfterChange events for APShipmentEntryForm, INInvoiceEntryForm, OESalesOrderEntryForm and POPurchaseOrderEntryForm. These events use the PostLines object which now includes an OldValues sub-object at the header level.

 

Improvement

ALL - All Modules

Make Insert / Edit / Delete on Links tabs work when not in Edit mode for Master.

Add context menu option and delete key support to delete attachments from SMTP and Accredo Mailers.

Enable the Insert and Delete buttons on Links On irrespective of Edit mode.

Added scripted EMailSend property to Document Print objects at Form and Data level to allow immediate Send on Run. Applies to document printing of single documents where an email template property is also available.

Added Sort button to batch label grids.

AP - Accounts Payable

Include Shipment Reference in file name when shipments are emailed or printed to disk file.

Make Show Inactive Customers / Creditors on Customer / Creditor Maintenance form toggle Show Inactive Contacts to match.

Added Setting: Allow Edit For Posted Orders, selected by default. Setting selected plus Control permission for the document are required for edit of non-financial and TD custom fields after post.

Make Comment field in Shipment header editable for posted documents subject to permission and AP Setting.

Make BillFromCreditorCode and Name available to AP Approve for Payments grid.

Added an APGeneratedPaymentsForm.BeforeExport event.

Saturn only. Hint when document lines are updated for change of Branch / Department / Location Code in the header.

Added PaymentMethod property to APGenerateForm and APGeneratedPaymentsForm.

Saturn only. If changing Creditor for AP Shipment / PO Order implies a change of Branch or Location (due to Creditor default values) these now update any matching lines and hint. Consistent with behaviour when Branch or Location is changed manually.

Display Contact ID on Contact Maintenance forms.

Allow edit (subject to usual permissions and restrictions) of Payment Due Date and Discount Date for Shipment sourced Invoice Transactions from the AP Transaction form.

AR - Accounts Receivable

Make Show Inactive Customers / Creditors on Customer / Creditor Maintenance form toggle Show Inactive Contacts to match.

Add calculated Sales Value and Sales Value Bs figures to AR Transactions. These match the Sales Value figures in the balances and are exclusive of GST and Charges.

Example statements updated to exclude nil value transactions and improve debit/credit column formatting.

Display Contact ID on Contact Maintenance forms.

Replicate Receipt Comment to Banking item Comment if Banking Item comment has not been specified.

Make (Dis)Allow Unspecified Sales Analysis Codes disregard Inactive analysis codes when deciding if there are codes other than Unspecified.

Added saMonth option to StatementAging properties in AR Statement Designer to enable calendar Month based aging statements to be designed regardless of your Period structure, e.g. for calendar month based ageing within a 4/4/5 week or 13 period structure. Standard example ARStatementCalendarMonths document is now included with the Server Install, or can be downloaded from the FTP site. Months Aging statements work from Month for Statement Date and calendar months to calculate statement iterators. Note that the Report Design Version has been incremented to 67 with this change. Added Aged Balances Monthly layout under Customer Reports and Aged Transactions Monthly layout under Transaction reports to AR. These reports allowed aged balances and transactions to be reported based on calendar months ageing to match calendar month statements, e.g. for calendar month based ageing within a 4/4/5 week or 13 period structure.

CB - Cash Book

Make CB Auto Payment auto-analysis match CB Transaction Entry behaviour.

Ensure link to AR or AP is broken for unbanked CB Transaction.

Replicate Receipt Comment to Banking item Comment if Banking Item comment has not been specified.

CO - Company

HTML Editor replaced to remove dependency on Internet Explorer.

Workstation Preferences form restructured.

User Email settings restructured so that From / Reply To / CC and BCC email addresses may be specified for SMTP or All mail, and selected to display or not on SMTP Mailer and Accredo Mailer forms.

Script Shortcuts Report under Reports > Company has been removed and replaced by a Script Shortcuts layout in Reports > Company > Scrips > Add layout. If you use this report you will need to add the layout. Script shortcuts layout included a detail band for Users, and a User Selection.

Pick up Company Reporting Preferences for Shade Alternate Rows and Double Spacing for grid and batch reports (i.e. those without saved preferences.)

Default visible fields for Reminder List updated.

Added Partial Match selection for email lookups.

Add events for COPriceListForm.

Display Server Path in File > Diagnostics.

Duplicate users for a shortcut when shortcut is duplicated.

DI - Data Interchange

Added DisableSums, EnableSums and SumDocument methods to Document data objects. Allows document totalling to be disabled while lines are added, edited or deleted then enabled when totals are required. SumDocument can be called explicitly while sums are disabled to force totalling. Save automatically enables sum document. Useful for DI import or other data level manipulation of large documents - totalling can be deferred till all lines have been added greatly improving speed when there are many lines.

Make InsertGlobalNarrative method available consistently on relevant Data and Form sub objects.

Show COM registration paths in Diagnostics.

Added OnOpen event for the EDIPriceBookImport form.

Add WasInserting property to Document data objects.

FA - Fixed Assets

Added separated Gain and Loss fields to the Depreciation Schedule and the Detail Depreciation Schedule (Saturn Only) report layouts.

Added Period Opening and Period Activity fields to the Depreciation Schedule report layout.

FD - Form Designer

Added BarOrientation property to Graph Component, applies to bar graphs only.

Added new FD function ScaleToForm(number of pixels at 100%). Allows anyone setting component position in their code for an FD form to handle Accredo scaling and position appropriately.

Make saved customisations work for InputCustomCode function and method. Note these are separate from Lookup customisations for Lookup fields in Custom tables.

Improve documentation of Font Properties in FD.

Made FD and RD Components help context sensitive. Select component and press F1 for help on the component properties.

GL - General Ledger

Improve column naming for Quarterly Balances from GL Report Wizard.

Add setting to Navigator > Setup > General Ledger > Settings > Import tab Consolidate Segment 2 Effect is to replace non 000 segment 2 with 000 in account codes in imported subsidiary batches.

Add Last Year figures for GL Account graphs.

Speed improvements for Balances tab loading.

Help - HTML Help

Improve documentation of Font Properties in FD.

Made FD and RD Components help context sensitive. Select component and press F1 for help on the component properties.

IC - Inventory Control

Add Enter Quantities option for Single Count stocktakes.

If UOM is Active, make Component Maintenance behave like document lines for Unit i.e. blank if Product has UOM.

Added Sort method to ICStockTakeCountData line sub object.

Make Unit available to IC Stocktake Counts.

DocumentPartyName added to IC Product Quantities grids.

Make Quantity Available and Quantity Theoretical available to Product Balances report. Note that Quantities from ICProd or ICQty are as at end of all transactions not as at report period, only figures from ICBalances are as at end of specified period.

Make Product Balances report layout draw figures from ICQty table rather than ICProd if a location code is specified in selections.

Prompt for confirmation when component lines are deleted in IC Component maintenance. Add a Prompt for Delete Lines button to the Component form Toolbar. Prompt for Confirm / Cancel on Close if there are unsaved changes.

Add Supplier Standard Cost to Supplier Price List report layout.

IN - Invoicing System

Added Setting: Allow Edit For Posted Orders, selected by default. Setting selected plus Control permission for the document are required for edit of non-financial and TD custom fields after post.

Prevent edit of Packing Slip No and Customer Code once Packing Slip is printed. This is an anti-fraud measure to ensure an audit trail will exist. If for some reason changes to Customer Code or Packing slip number need to be made, the document may be deleted (which moves it to history status Deleted) and duplicated to create a new Unprinted document.

Saturn only. Hint when document lines are updated for change of Branch / Department / Location Code in the header.

Make (Dis)Allow Unspecified Sales Analysis Codes disregard Inactive analysis codes when deciding if there are codes other than Unspecified.

JA - Job Analysis

Remove Full Year selection for Analysis reporting as redundant and confusing. Existing reports are automatically converted on load into the designer and at run time to use change the Analysis Range selection on the definition tab from Full Year to Year and the range selection on the Fields from YTDThis to FullYearThis.

Make Document / Job Contact fields available to Analysis designers.

JC - Job Costing

Added DisableSums, EnableSums and SumDocument methods to JCInvoiceAmountsData.

Saturn only change of Branch or Department on Active Job updates matching Branch and Department in estimate lines.

Add Site Address button to PO Order documents, available when a Job Code is selected for the PO.

Drill down to source Batch enabled for JC Transaction form.

UOM Code added to end of JC Estimates Export / Import definitions. If UOM code is specified the Quantities and Prices are treated as UOM Quantity and UOM Prices.

MB - Max Basic

Added new SFTPClient object and replicated most of the methods and properties from the existing FTPClient (where possible) in order to keep scripting the same (as much as possible). SFTP does not do logging like FTP, therefore this object does not have the logging methods and properties. The methods return boolean to indicate error (when false is returned) code and message in the ResultCode and ResultText properties, just like the existing object.

Added Add LoadFromEML and SaveToEML methods to the Accredo Mailer, allowing messages to be loaded and saved in EML format (Electronic Mail Format).

Script Shortcuts Report under Reports > Company has been removed and replaced by a Script Shortcuts layout in Reports > Company > Scrips > Add layout. If you use this report you will need to add the layout. Script shortcuts layout included a detail band for Users, and a User Selection.

Add Module Selection to Script Events form.

MaxBasic functions grouping reorganised for easier location in Menus and Help.

Added Option Window statement to MaxBasic to control how Forms are created using CreateObject. Option Window Normal will open as MDI child, Option Window Floating will open as Floating. The default state for a script is set by the TriggerObject if there is one, falling back to Normal if there is not one. For Toolbar shortcuts the TriggerObject is set the on Form the shortcut is on. To set this for a script or custom form you can check the IsFloatingWindow property at the start and set Option Window accordingly e.g. If MyForm.IsFloatingWindow Then Option Window Floating End If

Tidy up User functions and User Object properties. Added LoginUserCode and User.LoginUserCode and deprecated LoginName, LoginUserName and User.LoginUserName (still works but not documented). Added WindowsUserName and deprecated UserName (still works but not documented).

Make saved customisations work for InputCustomCode function and method. Note these are separate from Lookup customisations for Lookup fields in Custom tables.

Added DisableSums, EnableSums and SumDocument methods to JCInvoiceAmountsData.

Added an APGeneratedPaymentsForm.BeforeExport event.

Added Sort method to ICStockTakeCountData line sub object.

Add WasInserting property to transaction and batch forms.

Added PaymentMethod property to APGenerateForm and APGeneratedPaymentsForm.

COSnips.pfl updated with SFTP snippet. Server install will update this or file is available in the ftp downloads.

Added Before/After edit events to document forms. Calling abort from BeforeEdit will cancel the edit.

Add events for COPriceListForm.

Added TLSPortSecurity integer property to FTP object. Can be one of the following two numeric values: 0 = Clear; 1 = Private. Property can only be set if TLS mode is not set to 0 (i.e. utNoTLSSupport).

Added CreateMemoData function, which takes two parameters: 1. File - e.g. ARCUST; 2. Code - e.g. ASHENG. Returns an object similar to the CreateMemoList. The sub-object called Memo displays a list of matches. The Open and Insert methods of this sub-object will return the corresponding data object for the given AccountFile and AccountCode.

Add Masterfile data object boolean property AllowInactive to disable inactive join checking for Active records.

Make UserSetting function return entire UserHTMLSignature when requested.

Extend BrowseDataset function to take an optional Title parameter. If specified, Title is displayed in the title bar. BrowseDataset also now displays row and column at which it was called in the footer.

APShipmentForm and data objects AddLinesFromOrder method now returns the number of lines added.

ForceSMTP on the Mailer object will now be set if Users UseSMTPMailing setting is set to True. This now means that SMTPMailer and Mailer will have the same effect if the UseSMTPMailing setting is enabled.

OE - Order Entry

Added Setting: Allow Edit For Posted Orders, selected by default. Setting selected plus Control permission for the document are required for edit of non-financial and TD custom fields after post.

Add selection to Exclude Email Customers to OE Generated Invoices Results form Print Invoices dialog.

Prevent edit of Packing Slip No and Customer Code once Packing Slip is printed. This is an anti-fraud measure to ensure an audit trail will exist. If for some reason changes to Customer Code or Packing slip number need to be made, the document may be deleted (which moves it to history status Deleted) and duplicated to create a new Unprinted document.

Saturn only. Hint when document lines are updated for change of Branch / Department / Location Code in the header.

Make (Dis)Allow Unspecified Sales Analysis Codes disregard Inactive analysis codes when deciding if there are codes other than Unspecified.

PA - Purchase Analysis

Remove Full Year selection for Analysis reporting as redundant and confusing. Existing reports are automatically converted on load into the designer and at run time to use change the Analysis Range selection on the definition tab from Full Year to Year and the range selection on the Fields from YTDThis to FullYearThis.

Make Document / Job Contact fields available to Analysis designers.

PO - Purchase Orders

Added Setting: Allow Edit For Posted Orders, selected by default. Setting selected plus Control permission for the document are required for edit of non-financial and TD custom fields after post.

Saturn only. Hint when document lines are updated for change of Branch / Department / Location Code in the header.

Saturn only. If changing Creditor for AP Shipment / PO Order implies a change of Branch or Location (due to Creditor default values) these now update any matching lines and hint. Consistent with behaviour when Branch or Location is changed manually.

Add Site Address button to PO Order documents, available when a Job Code is selected for the PO.

Make Shipment Invoice Reference field available to display in the PO Order > View Shipments grid.

Make Supplier Comment & Supplier Standard Cost Date available read only to PO lines.

RD - Report Designers

Add OrderLine object to IN Invoice designer to allow showing Ordered Quantity for Invoice Line.

HtmlMemo component added to Report and Document Designers. Accepts .htm and .html as a HtmlMemoPath. Note that Designer Version is incremented to 65 in this build.

Added BarOrientation property to Graph Component, applies to bar graphs only.

Added Hyperlink component to Report and Document designers. Similar to Expression component but with two expression properties TextExpression (what is displayed) and URLExpression (where does it link to). Links are clickable in PDF and Excel. Note that Designer Version is incremented to 65 in this build.

BarCodeRotation property added to the Barcode component. Has four values: Rot0, Rot90, Rot180, Rot270. Rotation result depends on Alignment property. taLeftJustify - pivot point is left top corner taRightJustify - pivot point is right top corner taCenter - pivot point is centre at the top.

Made FD and RD Components help context sensitive. Select component and press F1 for help on the component properties.

RE - Report Engine

Allow report titles to wrap if necessary.

Default the Layout Name in the Customise Layout form when adding a new layout to be the same as the option in the Add Layout drop down menu.

Suppress Grand Totals automatically for grouped reports where only one group is printed.

SA - Sales Analysis

Remove Full Year selection for Analysis reporting as redundant and confusing. Existing reports are automatically converted on load into the designer and at run time to use change the Analysis Range selection on the definition tab from Full Year to Year and the range selection on the Fields from YTDThis to FullYearThis.

Make Document / Job Contact fields available to Analysis designers.

SP - Special Pricing

Allow Customisation for Print option on SP Rule Maintenance. Select Print > Options > Customise to make changes.

TD - Table Designer

Added a Data Dictionary report under Navigator > Reports > Table Designer to report Domains and Usage by table.

 

Bug Fix

ALL - All Modules

Ensure Narrative editor button is disabled for Narrative lines when editing Posted documents.

Fix 64Bit only issue with LockTimeOut returning 0 rather than specified value from System.cfg.

Fix Reminder List Party Code and Party Name not populating correctly.

Fix Open Source from Memos for Transaction Memos.

Fix maximised zoom form showing title bar.

Fix display issue when deleting an Alarm.

Suppress Inactive checks when saving Posted documents.

Fix some forms not opening floating on middle click.

Prevent sorting / moving lines on edited Posted Documents.

AP - Accounts Payable

Fix handling of JC Selling Price on Markup Basis for Shipment Lines when quantity changes from zero.

Fix Cost Mode on Shipment not editable until lines grid visited.

Fix exact half cent round off issue for AR and AP Foreign balance revaluation.

Fix email template lazy loading issue for one off AP Remittances.

Fix Move Up / Move Down not working on AP Shipment Additional Costs tab.

Fix defaults from 0000 Unspecified Customer Group not applied on Insert Customer.

Fix sort for Dissection band of Analysis Detail report layouts not being applied.

PO and AP File Recovery now fixes (reports as one time error) historic issue with non-zero Sell price / Sell price Bs for lines without a Job Code instead of just warning.

Prevent exchange rate change on posted documents.

Disable delete for additional costs on posted shipments.

Duty % in IC Product and AP Shipment increased to 2 decimal places.

Fix Manually Apportioned Additional Cost Bs editable on Posted Shipment.

AR - Accounts Receivable

Fix exact half cent round off issue for AR and AP Foreign balance revaluation.

Fix tblTran: Cannot perform this operation on a closed dataset error printing AR Statement when Include Nil Balances setting is true and batch printing for a single customer.

Fix defaults from 0000 Unspecified Customer Group not applied on Insert Customer.

Fix sort for Dissection band of Analysis Detail report layouts not being applied.

Fix Outstanding Iterator for AR Statements not handling partial allocation of future dated transactions on Days aging statement.

CB - Cash Book

Ensure dissection for CB sourced item is retained through Unbank of an AP Sourced summary.

Fix reconciliation of transactions inserted from CB Statement.

Fix Double-click on Memo tab on CB Bank Accounts not opening memo.

Fix sort for Dissection band of Analysis Detail report layouts not being applied.

CO - Company

Fix issues with MemoEditForm.AfterInsert events not firing as expected in all cases.

Make Navigator handle login with no Navigator entries.

Fix "Cannot locate period 1" error opening Prune History when periods for a module have not been set.

Fix Server 2012 issue displaying logged in users for last user logged in. Issue introduced with changes to locking model to make read locks defer to write locks in build 125.

Fix From Address overridden at run time under SMTP not being applied to email.

DI - Data Interchange

Fix COM handling for Error Log exceptions.

Fix JCInvoiceAmountsData IgnoreInvoiced not picking up default value from JC settings.

Add HideUsages boolean property to IN/OE Line data objects to allow toggling when data events are triggered from form with usages hidden.

FA - Fixed Assets

Make Change Depreciation create missing Generated Depreciation transaction if there is no depreciation transaction (Manual or Generated) for a period in the range.

Fix manual depreciation being inserted in the past not being considered when generated depreciation is reflowed. This resulted in both a manual depreciation and a generated depreciation in the period. Generated depreciation can be deleted and will not then be regenerated,

Make file recovery correct invalid split where transferred amounts and transferred percentages are mismatched.

FD - Form Designer

Fix display of MyImages glyphs on Speed Buttons when Toolbar is expanded.

Fix CopyFieldByName in FD not handling spaces in CustomTable display labels.

GL - General Ledger

Fix replication to AR / AP / CB for Expense / Income accounts added from Compare Charts of Accounts.

Fix BAS Return Form rounding adjustment GL batches not picking up Branch and Department from GST settings in Saturn.

Fix Trial Balance / Trial Balance Detail layouts not including accounts where balance is zero but other values shown on report are non-zero.

Make file recovery correct invalid split where transferred amounts and transferred percentages are mismatched.

GST - GST

Fix GST Excl calculation for the Price Code List report when reporting an Inclusive Price list.

Fix BAS Return Form rounding adjustment GL batches not picking up Branch and Department from GST settings in Saturn.

IC - Inventory Control

Only do Active Product check on Unprocessed PO Lines.

Fix IC Stock Level Report doubling TD custom ICQty quantity fields when filtered by Location.

Fix ProductCode not read-only when editing an ICTransaction.

Fix GST Excl calculation for the Price Code List report when reporting an Inclusive Price list.

Fix Serial Number editing on posted document not updating ICTran if no custom fields.

Fix IC Transfer label printing issue introduced by lazy loading for documents.

IC Components Maintenance report make Product Sell Prices 1 through 9 available to customise in.

Duty % in IC Product and AP Shipment increased to 2 decimal places.

IN - Invoicing System

Fix redundant confirmation on cancel after insert.

Fix committing of changes to Charges during INInvoiceData.BeforeSave and OEOrderData.BeforeSave events.

Exclude Adjustment Periods from IN Reprint Invoices / Email Printed Invoices drop downs.

Fix Document Number not populating for Invoice Reprice Report.

Fix Serial Number editing on posted document not updating ICTran if no custom fields.

Fix exception message: INLINE missing Record Revision update on INHEAD editing JCTransaction Cost Centre or Component code after invoicing.

Refetch SystemDate on GenerateInvoice rather than trusting value used at previous generate for the same form or data object.

Fix Back Orders for Invoice not displaying as expected, also fixed the same issue for the Backorders for Invoice iterator in IN Invoice designer.

JA - Job Analysis

Fix folding of Custom Lookup fields into Analysis reports.

Fixed Analysis report Access Violation error when only cross tab fields are included.

Fix "Missing metadata for domain JCJOB" warning for Consolidate Related Jobs.

Fixed JA reporting with Estimates when Cost Centre and Component Analysis Name fields are included and grouped.

Ensure that Budget figures can only be included for Crosstab reports when cross-tabbed by period since these are per period values.

JC - Job Costing

Fix handling of JC Selling Price on Markup Basis for Shipment Lines when quantity changes from zero.

Fix error hint focusing for Job Batches.

Fix JCInvoiceAmountsData IgnoreInvoiced not picking up default value from JC settings.

Fix issues with MemoEditForm.AfterInsert events not firing as expected in all cases.

Fix introduced exception message: List index out of bounds (1) error printing a JC Jobsheet or Quote with a filtered Lines iterator.

Fix exception message: INLINE missing Record Revision update on INHEAD editing JCTransaction Cost Centre or Component code after invoicing.

If "Use Job Site Address" setting is selected ensure the Job Site address is picked up on Insert of PO from Job Documents tab.

Fix JCBatch DuplicateReversal not recalculating extensions immediately.

Fix issue with extension for Copy Estimates From in JC.

Fix issues with data level before /after post events for JC batches posted from the JC Batch List form.

MB - Max Basic

Fix error message when ParseJSON is passed an empty string.

Fix issues with MemoEditForm.AfterInsert events not firing as expected in all cases.

Fix error on Insert from memo grid with an OnOpen event script hooked up to MemoForm.

Fix custom domains metadata not loading for scripted Login.

Fix committing of changes to Charges during INInvoiceData.BeforeSave and OEOrderData.BeforeSave events.

Fix Access Violation when using For Each statement over stringlist collection.

Fix Range Check Error when deleting a TD Custom Table shortcut.

Fix ActiveProperty not set on document line when Product selected from lookup via click.

The default charset when sending mails using SMTP was "us-ascii' now changed to UTF-8 so that the higher html entities can be encoded.

Fix error message for Invalid vs Inactive categories assigned at the data level.

Fix Print object not returned for scripting for AR receipt / AP Payment transactions opened in forms created using the OpenForm function.

Fix issues with data level before /after post events for JC batches posted from the JC Batch List form.

OE - Order Entry

Fix introduced Range Check Error printing Invoices after emailing from OE Generate Orders results form.

Fix lazy loading for Filter and Sort of Document iterator with field not referenced in code.

Fix issues with Email Invoices from OE Generated Invoices Results form.

Fix committing of changes to Charges during INInvoiceData.BeforeSave and OEOrderData.BeforeSave events.

Refetch SystemDate on GenerateInvoice rather than trusting value used at previous generate for the same form or data object.

Fix Access Violation sorting OE Order Lines when the first line is a sticky narrative.

Fix Back Orders for Invoice not displaying as expected, also fixed the same issue for the Backorders for Invoice iterator in IN Invoice designer.

Fix introduced issue (build 125) for RecalculateSupply on OE Order when the same diminishing product appears more than once on the order - earlier lines were not correctly factored into the available calculation when resupplying the later lines.

Fix OE Packing Slip not printing BinLocation for Lines.

Fix changing line type on OE order from Narrative to Sticky Narrative or vice versa resetting LineBreak to False.

PA - Purchase Analysis

Fix folding of Custom Lookup fields into Analysis reports.

Fixed Analysis report Access Violation error when only cross tab fields are included.

Ensure that Budget figures can only be included for Crosstab reports when cross-tabbed by period since these are per period values.

PO - Purchase Orders

Fix permission for PO List printing.

Only do Active Product check on Unprocessed PO Lines.

If "Use Job Site Address" setting is selected ensure the Job Site address is picked up on Insert of PO from Job Documents tab.

PO and AP File Recovery now fixes (reports as one time error) historic issue with non-zero Sell price / Sell price Bs for lines without a Job Code instead of just warning.

RD - Report Designers

Fix property selection for Ctrl+Drag when component included in Click and Drag is pre-selected.

Fix introduced lazy loading issue for document iterators when object for iterator is not referenced.

Fix iterator in Document designer not iterated if object not referenced, now iterates if there is a band associated with the iterator.

Fix introduced issue for AP Shipment document with Product Object not tracking correctly.

Fix lazy loading for Filter and Sort of Document iterator with field not referenced in code.

Fix introduced exception message: List index out of bounds (1) error printing a JC Jobsheet or Quote with a filtered Lines iterator.

Fix lazy loading for OrderHead.Category1Desc and OrderHead.Category1Desc in OE Packing Slip designer.

Fix IC Stock Level Report doubling TD custom ICQty quantity fields when filtered by Location.

Fix Access Violation in Graph Component when inserting fields.

Ensure band height is recalculated when Autoheight band is repeated.

Fix right alignment issue for bold fonts in Preview window.

Fix Bar Code component saving and loading of font changes.

Fix OE Packing Slip not printing BinLocation for Lines.

Fix Outstanding Iterator for AR Statements not handling partial allocation of future dated transactions on Days aging statement.

RE - Report Engine

Custom fields with matching names and mismatched types caused report layout error if both sets of fields were replicated, now fixed.

Fix QuotedCSV format for report layouts not quoting all strings.

SA - Sales Analysis

Fix folding of Custom Lookup fields into Analysis reports.

Fixed Analysis report Access Violation error when only cross tab fields are included.

Ensure that Budget figures can only be included for Crosstab reports when cross-tabbed by period since these are per period values.

SP - Special Pricing

Fix exception message: Index does not exist. Table: ARADDR Index: DeliveryCode error for Special Pricing. Error only occurs if AR Delivery Code is a Who criteria and JC is present for a PO or AP line without a Job Code.

SQL - SQL

Word data type was not supported in SQL engine, now fixed.

TD - Table Designer

Fix custom domains metadata not loading for scripted Login.

Word data type was not supported in SQL engine, now fixed.

Fix Upgrade Table causing data dictionary issues for Upper flag.

 

Accredo 4 – Version 4.0.10.125

Improvement

ALL - All Modules

Report layouts can now be grouped in sub folders by including subfolder structure in the layout name. \ in the Layout name is treated as indicating a sub folder under the default position for the layout. A leading \ starts from the root of the report tab, and module acronyms can be used for main module report folder. e.g. \AR\LayoutName will position the layout in Reports > Accounts Receivable > LayoutName.

Added LastYear fields to Balances/Activity tabs and Graph tabs for AR Customer, IC Product, AP Creditor, CB Bank Account, FA Asset, JC Job and GL Account maintenance forms. Allows for example graph to compare this year with last year sales values for customer or products. Note that if you want to default a second graph field this can be done with an OnOpen script for the relevant form. e.g. for AR Customer form: Dim frmARCust1 as Object frmARCust1 = GetTriggerObject if IsNull(frmARCust1) then frmARCust1 = GetActiveObject if IsNull(frmARCust1) or frmARCust1.ClassName <> "ARCustomerForm" then Error "Wrong form class for script" frmARCust1.GraphField2 = "SalesValueLastYear" frmARCust1.ActivePage = "Customer" frmARCust1.ActiveProperty = ""

Added calculated Alpha version of Reference domain fields to allow easy alphabetic sorting by OrderNo and other reference fields.

Changes to locking model to make read locks defer to write locks. For sites with high volume processing this should reduce the duration of retries and ensure forward progress can be made. Added optional /SHAREDEFER=X system.cfg setting, the default if not set in the cfg is SHAREDEFER=4 effect is to make reads defer to writes, set to SHAREDEFER=0 to turn off new locking behaviour..

AP - Accounts Payable

Make Discount Date editable on AP Approve for payment form and write back to AP Transaction.

Lazy synchronisation for objects in Shipment documents for improved printing speed.

Lazy synchronisation for objects in Remittence/Cheque documents for improved printing speed.

Restriction on Allocations for closed GST Periods relaxed to check transactions being allocated or unallocated for thei GST impact rather then a blanket restriction for the period. For closed Invoice/Accruals Basis GST periods, allocation / unallocation is not allowed if the transactions involved include settlement discount. For closed Payments/Cash Basis GST periods, transactions with no GST reporting implications (i.e. GST Code E for all dissections) only may be allocated or unallocated.

Add filter on (Payment) Transactions to AP Print Cheques.

Allow JC Cost Centre and Component Code on AP Shipment lines to be edited for Posted Shipments, change flows through to JC Transaction.

Speed improvements for posting large AP Shipments relating to Purchase orders.

Make Creditor Group, Category1 and Category 2 available to customise into the AP Approve for Payment grid.

AP Shipment invoice posting refactored to minisime time that ExpenseCode is held locked.

Improve validation and access to Approval and Hold amounts on AP Transaction entry.

Improve speed of update to IC Transactions from Receipted shipments.

AR - Accounts Receivable

Lazy synchronisation for objects in AR Statement documents for improved printing speed.

Added AgingDays and StatementAging properties to AR Statement Designer to enable Weekly or other days based aging statements to be designed. Standard example ARStatementWeekly document is now included with the Server Install, or can be downloaded from the FTP site. Days Aging statements work from Statement Date and Aging Days to calculate statement iterators. Note that the Report Design Version has been incremented to 64 with this change.

Restriction on Allocations for closed GST Periods relaxed to check transactions being allocated or unallocated for thei GST impact rather then a blanket restriction for the period. For closed Invoice/Accruals Basis GST periods, allocation / unallocation is not allowed if the transactions involved include settlement discount. For closed Payments/Cash Basis GST periods, transactions with no GST reporting implications (i.e. GST Code E for all dissections) only may be allocated or unallocated.

Added Aged Balances Days layout under Customer Reports and Aged Transactions Days layout under Transaction reports to AR. These reports allowed aged balances and transactions to be reported based on days ageing to match days based statements, e.g. for weekly ageing within a monthly period structure.

CB - Cash Book

Added Find button to CB Bank Statement to allow find by ID.

DI - Data Interchange

Improve Pricebook Import Designer UI,

FD - Form Designer

Add Select Parent button (Shift+Esc) to the Component selector above the Property Editors.

Added optional SelectionText parameter to FD Graph Print method.

Added Splitter component to FD.

GL - General Ledger

Added Select All / Unselect All buttons to the GL Compare Charts of Account Compare Fields.

Add Transaction Batch List option to Maintain > General Ledger folder in the Navigator. This is an alternative path to access the GL Transaction Batches form.

Default selection for Export Chart of Accounts and Import Chart of Accounts switched from csv to Excel.

GST - GST

Make Analysis Name field available to GST Code Detailed report layouts.

Restriction on Allocations for closed GST Periods relaxed to check transactions being allocated or unallocated for thei GST impact rather then a blanket restriction for the period. For closed Invoice/Accruals Basis GST periods, allocation / unallocation is not allowed if the transactions involved include settlement discount. For closed Payments/Cash Basis GST periods, transactions with no GST reporting implications (i.e. GST Code E for all dissections) only may be allocated or unallocated.

IC - Inventory Control

Added new UOM setting to permit relaxing the strict constraint on UOM and Base decimals relationship. If Use Strict UOM Quantities is unselected in IC Units of Measure Maintenance the constraint tying UOM to Base decimals is relaxed. This means round off may occur because UOM Quantity * UOM Multiplier = BaseQuantity (rounded) will longer have to be able to return exactly the original UOM Quantity for BaseQuantity / UOM Multiplier.

Added Count Per grouping option to IC Stocktake selections for Additive or Single stock takes, IC Generate Stocktake, and Generate Counts options. Allows generation of counts to be grouped for example by Creditor Code, Stock Group, Categories or Bin Location.

Added Variances option to Generate Count for IC Additive Stocktakes. Generates a count which includes all products which have a variance.

Add ICStocktakeEditForm before post event.

Added Supplier fields and CreditorName to Report band for the following IC report layouts: Product, Bar Codes, Product by Locations, Stock Sales and Valuation, Product Sequence, Stocktake Forms. Supplier Fields on the Report band are populated from the default Supplier (CreditorCode on Product tab) if one is specified and a supplier cost record exists.

Allow edit of SerialNo field only for IC Stocktake Adjustments.

Add Bin Location to IC Stocktake Report.

IN - Invoicing System

Lazy synchronisation for objects in Invoice documents for improved printing speed. Up to a 30% improvement for a typical invoice design in our testing.

Include Delivery Address 1 as a default field in Delivery Address lookups.

Improve speed for recalculating supply on invoices and sales orders when line events are not triggered.

Add OE Customer Back Orders form and Back Orders buttons to IN Invoice Form and OE Order Form.

JC Job > Documents Tab - PackingSlipNo is now available to customise into the Invoices grid.

Make Shipper Line ID available to IN Invoice and OE Sales Order forms and data objects.

Improve speed of update to IC Transactions from posted invoices.

JA - Job Analysis

Default Primary Key field into fields list for Analysis reports for analysing by Document or Line and Transaction.

JC - Job Costing

Change default for JC Settings "Allow IN Sourced Invoice Lines" to unselected for new companies.

Include Delivery Address 1 as a default field in Delivery Address lookups.

Lazy synchronisation for objects in Job Sheet / Quote documents for improved printing speed.

Modify Job Invoicing to only calculate total for Generated Invoice as final step rather than line by line. Significant speed improvement for large number of lines to be invoiced in a single document.

JC Job > Documents Tab - PackingSlipNo is now available to customise into the Invoices grid.

Contact fields made available to the JC Job List.

Add Contact fields to Job band on Job reports.

Make all fields available to JC Batch / Timesheet / Disbursement form grids also available to the Batch Reports.

MB - Max Basic

Added ApplicationMinimise, ApplicationMaximise and ApplicationRestore functions to the script group. They all return a boolean to indicate that the application main form's state is as requested. Note that creating a form object automatically restores the application, so if for example you want to open a floating window and minimise the application you need to first OpenWindowForm() or OpenCustomWindowForm() then ApplicationMinimise.

Add ICStocktakeEditForm before post event.

Added SetSubset method to ScriptedForm InputDeliveryAddress.

Add Set Bookmark and Go to Bookmark to Context menu in Code Editors.

Add Enum domains to Memory Table builder.

Improve speed of whole document operations which trigger line events by only re-totalling the document once the operation is complete, an example is OE Sales Order Recalculate Supply. If line event scripting is dependant on document totals a configuration switch can be added to System.cfg /LineEventSums to force totalling per line.

Added InsertNarrative(Text) and AppendNarrative(Text) methods to document and batch line subobjects. Method processes text in the same way the Narrative Editor does to append or insert the required number of narrative lines with appropriate line breaks.

Make Shipper Line ID available to IN Invoice and OE Sales Order forms and data objects.

Add CompanyPath method to CompanyList collection.

Object documentation now indicates fields with display label aliases such as Categories, e.g. On the ARCustomerData object: property Category1: String(8) [AR Category 1 Code] setting "AR\Cat1Alias" label "Buying Group" where setting is the setting string that can be passed to the ApplicationSetting function to retrieve the label if one has been applied in Display Label settings.

Improve logging for transaction rollback due to an unhandled exception in a script.

Added ApplicationTop and ApplicationLeft functions to return the Top and Left co-ordinates for the Application Main window.

Sort User Tab for script shortcuts on load.

OE - Order Entry

Include Delivery Address 1 as a default field in Delivery Address lookups.

Lazy synchronisation for objects in Sales Order Packing Slip documents for improved printing speed.

Improve speed for recalculating supply on invoices and sales orders when line events are not triggered.

Add OE Customer Back Orders form and Back Orders buttons to IN Invoice Form and OE Order Form.

Make Shipper Line ID available to IN Invoice and OE Sales Order forms and data objects.

PA - Purchase Analysis

Default Primary Key field into fields list for Analysis reports for analysing by Document or Line and Transaction.

PO - Purchase Orders

Include Delivery Address 1 as a default field in Delivery Address lookups.

Lazy synchronisation for objects in Purchase Order documents for improved printing speed.

RD - Report Designers

Add Select Parent button (Shift+Esc) to the Component selector above the Property Editors.

Find and Replace in View All Code now continues across all code not just current code block.

Lazy synchronisation of objects for document designers for faster printing.

Added RD Export Column and Row checker to Report Designers.

Added Export Wizard to report designers. Button on toolbar analyses ExportRow, ExportColumn and ExportColumnWidth properties for Label and Expression components on specified bands based on selections and proposes then optionally applies changes to give valid export properties.

Default to displaying color properties in RD in #RGB form.

Added Expression column to Report Design Wizard, if ticked then the Caption will be created as an expression component rather than a label component.

RE - Report Engine

Added new Auto Open File selection to Report dialogs. Selection is available when Destination is Disk File, if selected the file is opened after creation using the system default viewer for the file type. Selection is script enabled and included when added to Report List. Note that printing to Disk FIle in Excel format and then opening the file in Excel is usually much faster than printing to Excel which automates Excel directly.

Report Preview Window added shortcuts Ctrl+ Zoom in, Ctrl- Zoom Out, Ctrl0 100%, and zoom In or Out with Ctrl and Mouse wheel.

SA - Sales Analysis

Default Primary Key field into fields list for Analysis reports for analysing by Document or Line and Transaction.

SP - Special Pricing

Add SP > Rules > BypassMargin permission. If permission is turned off then user cannot modify the BypassMinimumMargin flag for SP Rules.

SQL - SQL

Added Record count and Refresh Record Count button to SQL list forms. Clicking the button will force the query to complete and return the Record Count if a ? is displayed

TD - Table Designer

Added Print button to Table Register toolbar.

ZIP - Backup

Assorted VSS Writer installation refinements.

 

Bug Fix

ALL - All Modules

Fix Filter button state not updating when SQL lists are run from script.

Modify documents so that first editable field focus in Lines tab occurs on Edit / Insert instead of OnOpen. Became an issue with Editing of posted documents.

Fix issue with embedding images with some file names when Outlook is the Mail client.

Ensure Narrative editor button is disabled for Narrative lines when editing Posted documents.

Fix Batch Emailing through Outlook issues with embedded images path and file names.

AP - Accounts Payable

Fix incorrect bank account no reported on AP Generated Payments report if printed prior to Acceptng the Banking.

Fix button position for Transaction entry forms when a scale factor is applied in Windows.

Fix Manually Apportion not picking up additional cost from IC Cost when ProductCode is selected after ManuallyCosted.

Fix grouping with sorted iterator for AP Remittance Designer.

AR - Accounts Receivable

Fix missing Preview button on AR Customer Batch Email form.

Validate Statement Period and Date match.

Fix Print Statement from AR Customer form not passing specified Period and Date through to statement. (i.e. always printing for current period AR).

Fix button position for Transaction entry forms when a scale factor is applied in Windows.

Fix grouping with sorted iterator for AR Receipt Designer.

CB - Cash Book

Fix incorrect bank account no reported on AP Generated Payments report if printed prior to Acceptng the Banking.

Fix System Date formatting on CB Reconciliation Report printed to Excel.

Fix Query run for CB Statement Reconciliation, Apply Rules not handling AR and AP allocation.

Fix Created / Modified information for CB transactions posted from CB Automatic Payments.

Fix introduced "Banking item does not match Banking Summary criteria" error when editing and saving a Banking summary with Media Code selection Cash/Cheque.

Fix exchange rate extracted from Rate Table for transactions created from CB Rules to use Transaction Date not System date.

CO - Company

Fix timing for Global Alarms and Reminder list on company open to ensure they open after the Navigator and so appear on top.

Fix introduced issue with Duplicate for a user not preserving user permissions.

Fix speed issue editing and saving large memos with preview pane open.

Fix SMTP mail not handling multiple email addresses for user CC and BCC SMTP settings.

Fix modified User / Date / Time not set for edit of CO Users Groups and Roles form.

Fix 64-bit issue with LockTimeOut configuration switch mishandling Exclusive Access timeout requests for Lock Company and Backup.

DI - Data Interchange

Suppress Printer Warnings on Startup for non interactive COM sessions.

Exclude COMServerMode from SingleInstance preference.

FA - Fixed Assets

Fix FA Regrouping required issues.

Fix Revaluation edit replay triggerring an error.

FD - Form Designer

Fix Application Main window brought to front when FD Field Editor, FD Memory Table Designer or FD Graph Editor opened in designer.

GL - General Ledger

Fix Access Violation on Validate ledger when PostTo account does not exist.

IC - Inventory Control

Fix introduced issue in Mercury only with OpenDetails on an empty ProductCode field failing.

Fix Alarms on products on documents not triggering if UOM was enabled.

Allow edit of IC Product Markup % for users with IC Read permission for Cost Prices and Write permission for Sell Prices. Previously required Write permission for Cost prices.

Fix IC Transactions posted from JC without SourceLineID which allows drill down. Issue introduced in build 124. File Recovery for IC will fix affected transactions.

Check setting value needs to change before locking setting for IC\RevaluedCurrentPeriod.

Fix ICCNTLN missing Record Revision update on ICCNTHD error deleting IC Product.

IN - Invoicing System

Fixed handling of changing customer/creditor on documents with fixed exchange rate.

Fix editing a posted document removing JC Invoice information. Run file recovery for JC to correct if affected.

Fix missing document no in file name when document printed to Screen then saved to PDF.

Fix batch email of Quotes depending on Customer having Invoice Email address.

JC - Job Costing

Fix reference field reporting for JC Unposted Transactions layout and JC Job Status Report - Pending transactions band.

Fix editing a posted document removing JC Invoice information. Run file recovery for JC to correct if affected.

Refine check for related job to ignore relation to self.

Fix AccessViolation saving edited SalesGroup from JC Job Invoicing form.

Fix loading JC Description and Information when editing Job in OnPrint event.

Fix editing EstimateLineType to Narrative not zeroing UOMQuantityEstimated.

Fix IC Transactions posted from JC without SourceLineID which allows drill down. Issue introduced in build 124. File Recovery for IC will fix affected transactions.

Ensure query is reexecuted for regenerate of JC WIP Detail report with a single Job selected.

JC Job Sheet Designer - Job Information object was not populated, now fixed.

Fix introduced issue with sorting of transaction grid for JC Job Invoicing form.

Fix estimate line unposted change loss with data level before save script, Issue only occurred with data level before save script and F9 with unposted change to estimate quantity (i.e. rare corner case).

MB - Max Basic

Fix BrowseDataset window growing each time it is opened.

Fix missing Index fields on Budget Data objects.

Add xlsm format to Excel formats for validation of Import files.

Fix email template loading for Data level printing of documents.

Fix estimate line unposted change loss with data level before save script, Issue only occurred with data level before save script and F9 with unposted change to estimate quantity (i.e. rare corner case).

Fix script shortcut keystroke not getting active object as expected for floating windows.

Fix Reserved Word checking for ValidFileName function to use equality not contains. The reserved words are CON, PRN, AUX, CLOCK$ and NUL.

OE - Order Entry

Fix missing document no in file name when document printed to Screen then saved to PDF.

Fix Print Product Labels from OE Sales Order not lazy loading Sales Order Line object correctly.

PA - Purchase Analysis

Fix SA / PA Analysis report issue with Narrative lines not excluded when Narrative line type not selected.

PO - Purchase Orders

Fix Quantities panel in PO Quotation Request incorrectly factoring in the quantity from the RFQ.

RD - Report Designers

Prevent User Input while custom reports are printing to disk file.

Include font information for all pages once only in pdf files for improved file size with large documents.

Fix Range Check Error when graphic is reused in a screen report.

Fix parsing error causing lost text in pdf's with embeded fonts where text string contained "TJ".

Make all Text and CSV Stream handling Regional Setting independent for Float formatting i.e. always use American/English separators.

Fix grouping with sorted iterator for AP Remittance Designer.

Fix grouping with sorted iterator for AR Receipt Designer.

RE - Report Engine

Further fixes to font embedding for pdf's and "extended" fonts.

SA - Sales Analysis

Fix SA / PA Analysis report issue with Narrative lines not excluded when Narrative line type not selected.

SP - Special Pricing

Fix SPRuleData object not setting UOMQuantity boolean for rules with UOM breaks. File recovery fixes any affected rules.

TD - Table Designer

Fix Custom Data Dictionary error not resolving.

Fix Upper not able to be set for string fields with Custom domain.

ZIP - Backup

Fix VSS Writer logging supurious error: "failed w/err 0x00000002".

VSS Writer updated to ensure Thaw if Aborted by external process after successful freeze. To update currently: Stop the service Reinstall the SetupAccredoVSS Restart the service. If there is any problem with restarting the service after the update rebooting the server should resolve it.

 

Accredo 4 – Version 4.0.10.124

Improvement

ALL - All Modules

UI improvements to allow windows to be opened from Navigators as floating windows on Middle click or Ctrl+Left click, and to be transitioned between floating and MDI child from the System menu for the Window. New MaxBasic functions added to the Script group to allow Accredo and Custom forms to be opened in a floating window from a script. OpenWindowForm(AccountFile: String[, AccountCode: String, Line: Number]) Opens the form associated with the Account File, loads the record for the AccountCode if specified, and positions on the line if specified. Opens as a floating Window form. CreateCustomWindowForm(FormName: String) Opens the specified Custom form as a floating Window form.

Added Preview pane to Memo tabs and Memo Lists. Preview pane can be toggled from the toolbar. User preference added for Show Memo Preview to control initial state for Preview Pane, defaults to selected.

Added Duplicate Shortcut option to right click menu on Form Toolbars.

Defaults when a new company is added updated as follows: Navigator > Setup > Company > Configuration > Settings > Currency Format tab: MaxBasic CurrencyFormat include Currency Symbol is false (previously true). Navigator > Setup > Accounts Receivable > Settings > General tab: AR Default Media Code is DC (previously Cheque). Navigator > Setup > Accounts Payable > Settings > General tab: AP Default Payment Method is Electronic (previously Remittance). Note that Converters use the new Company defaults.

Allow filter and sort for Links when not in Edit mode.

Toolbar shortcuts can be added to JC Transaction Batch List, CB Banking Items List, GL Transaction Batch List and GST Transaction List.

Added Workstation Preferences for Grid Row shade and Grid RO (Read Only) Row Shade, defaults to 10%. If these are not zero then alternate rows in grids and lists are shaded per the preference.

Range of periods option added to the Selection on all Balances / Activity tabs.

Batch email address fields are now validated on send.

Indicate memo / link state in tab headers.

Make Mail Bug Report use SMTP Mailing where settings indicate that.

Make word lookup results sortable by clicking on column header. Note that the columns available in the Word Lookup grid are controlled by the fields included in the lookup control which can be customised by right-click on the lookup control.

Extend grid row shading to Lookup drop down lists.

AP - Accounts Payable

Select email address on Customer and Creditor Email Documents selections assumes another address should be added if the final character in the field is a semi-colon.

AR and AP Contact List forms are now SQL based with additional selections and filters available. Auto Select defaults for the Contact Lists have been added to AR and AP Settings.

Added AR Customer Sheet and AP Creditor Sheet document designers and Print button on Maintenance forms.

Added new AP Settings > Shipments tab option if JC is present for Show Job Defaults on Lines, defaults to selected which gives no change to existing behaviour. If unselected then the Job Defaults panel does not appear on PO Orders and AP Shipments. Job code can be selected in the PO Header and AP Shipment Receipts tab.

Added workstation preference Grid Highlight Credits, defaults to selected. If selected then credit transactions and documents show in Credit Colour in Invoice List and Transaction and Document tabs for Customers and Creditors. Credit colour can also be selected if the default of Red is not preferred.

Added BeforeSend events to AR Batch Email and AP Batch Email forms.

AP Approve for Payment form: Added DiscountAmount and DiscountAmountBs to the creditor panel and PaymentAmount / PaymentAmountBs calculated as Approved - Discount / ApprovedBs - DiscountBs to the Creditor and Totals panels. Adjusted default fields for these panels.

Allow edit for Processed AP Shipments for some fields on Header and Lines including all TD Custom fields, Categories 1 & 2, Custom 1 & 2, and Comment.

Made all non-financial fields from AR Customer / AP Creditor (including the requested Categories 1 and 2) available to the AR Sales Budget / AP Purchase Budget reports.

AR - Accounts Receivable

Select email address on Customer and Creditor Email Documents selections assumes another address should be added if the final character in the field is a semi-colon.

AR and AP Contact List forms are now SQL based with additional selections and filters available. Auto Select defaults for the Contact Lists have been added to AR and AP Settings.

Added AR Customer Sheet and AP Creditor Sheet document designers and Print button on Maintenance forms.

Added workstation preference Grid Highlight Credits, defaults to selected. If selected then credit transactions and documents show in Credit Colour in Invoice List and Transaction and Document tabs for Customers and Creditors. Credit colour can also be selected if the default of Red is not preferred.

Added BeforeSend events to AR Batch Email and AP Batch Email forms.

Add 'Outstanding Paid' option to AR Clear Stop Credit When setting.

Added Print Statement button to AR Customer Form.

Made all non-financial fields from AR Customer / AP Creditor (including the requested Categories 1 and 2) available to the AR Sales Budget / AP Purchase Budget reports.

CB - Cash Book

Make Hash Total available to print on the banking summary reports.

Added new CB Settings for Statements to control the behaviour when Apply Rules is selected from a Bank Reconciliation. Apply Rules - Option for Automatic (previous behaviour) or Query (preview each rule) will create with options to Save or Skip, and tool bar button to Edit Rule. Apply Rules Prompt - if Selected, prompt for Automatic or Query each time Apply Rules is selected. Defaults for new and existing databases are Automatic and no prompt.

Modify default visible fields for CB Bank Account balances when Allow FX Bank Accounts is selected.

CO - Company

Add a Terminate button to Retrying dialogs when Retry is due to a network error message.

Make /NOSAVEDWINPOS command line switch also available as a Config file system switch.

Change shortcut for Print Image to Ctrl+G to avoid conflict with other shortcuts.

DI - Data Interchange

Add Creditor function to Import group for Price Book Import designer. Returns the Creditor selected from the Price Book Import selections.

FA - Fixed Assets

Make Category1 Description and Category2 Description available to the FA Depreciation schedule layout.

Change shortcut for Print Image to Ctrl+G to avoid conflict with other shortcuts.

FD - Form Designer

Allow positioning of Error hints on Speed buttons in FD.

Added RemoveItem(ItemIndex: Integer): string method to DropDownList. Method will remove the string given by the item index (0 based), and return the string that was removed. If ItemIndex is out of range, then a NoLogException will be thrown.

Added OnDblClick Event for Edit Grid component.

"FD Tutorial: Custom Form refreshed on a timer" topic added to the help, and matching ExampleTimerForm.pfd added to the example forms installed with the demo and server installs.

GL - General Ledger

Added topics to Saturn Help: GL Tutorial: Saturn Report to Iterate Branches, and GL Tutorial: Saturn Report to Iterate Departments. Example reports are installed with the demo system.

GL Transaction Sequence report layout - make FriendlyCode and ExternalAccountCode from GLACCT available.

Add explicit Account Type selection to Compare Charts of Accounts.

GST - GST

Add progress bar to GST Payments reports.

Help - HTML Help

Added topics to Saturn Help: GL Tutorial: Saturn Report to Iterate Branches, and GL Tutorial: Saturn Report to Iterate Departments. Example reports are installed with the demo system.

"Replacing Launchguarded Shortcuts.pdf" is available on the ftp site in the Downloads folder.

Added MB Tutorial: IC Products and Prices Pivot Table to the Help.

Added Customer by Product Range of Periods and Product by Customer Range of Periods example reports, installed with Demo and Server installs. SA Report tutorials can be found in the help.

SQL examples in the help all updated to reference Accredo tables and fields.

IC - Inventory Control

Added Unpost option to Stocktakes. Unpost is available provided the stocktake is within the available period window for IC and would not violate the rules creating a stocktake (products can't be on more than one unposted stocktake in the same period at the same location). Unpost contras the adjustment transactions and reinstates the stocktake and counts unposted.

If UOM is active IC Product Form Sell Prices has a Price UOM Selection which defaults to the Default Sale UOM Code and a calculated UOM Price column in the sell prices grid.

If UOM is active IC Product Form Quantities has a Quantity UOM Selection which defaults to the Base UOM Code. As the Quantity UOM selection is changed quantities are recalculated in terms of the Quantity UOM.

Added new JC Setting on the Integration tab to Enforce IC Cost Prices. If selected then cost price on JC transactions and batches behaves the same way as cost price on IN Invoices and OE Sales Orders, i.e. cost price for transactions or batch lines with a Product Code specified cannot be edited unless the Product is flagged Manually Costed. Costs on JC Batch lines are updated automatically from IC on post unless manually costed. If manually costed then the cost specified in JC is the cost posted to the IC usage. For existing company databases this setting will be unselected so as not to perturb existing behaviour. For new databases or newly added JC Modules it defaults to selected.

Added workstation preference Grid Highlight Credits, defaults to selected. If selected then credit transactions and documents show in Credit Colour in Invoice List and Transaction and Document tabs for Customers and Creditors. Credit colour can also be selected if the default of Red is not preferred.

Improved Units of Measure validation for changes to multiplier when in use.

Make BinLocation available to ICCountLine iterator in ICCount Designer to enable sorting by BinLocation.

Make Product (Mercury) or Location (Saturn) Quantity fields available to customise into the Count Lines grid.

Added MB Tutorial: IC Products and Prices Pivot Table to the Help.

Change shortcut for Print Image to Ctrl+G to avoid conflict with other shortcuts.

IC Count Designer - make ICProd.Barcode available to the Iterator so it can be sorted on.

Make ICProd.Barcode available to customise into the ICCount grid.

Add Basic Stocktake type.

Make Link Created and Modified fields available to Link report layouts.

Make Name / Description field available to the Batch Label grids.

Added Barcode selection to IC Product Batch Labels, loads Product default barcode initially, but any barcode for the product may be selected and is passed through to the Barcode object in the IC Product Label designer.

Added Delete button to IC Stocktake Edit form and Delete method to automation object.

Make all fields including custom ones available to IC Transfer List.

IN - Invoicing System

Find Document by Number from the invoice list now allows location by Document No or Packing Slip No. FindPackingSlip method added to INInvoiceListForm object for scripting.

Added workstation preference Grid Highlight Credits, defaults to selected. If selected then credit transactions and documents show in Credit Colour in Invoice List and Transaction and Document tabs for Customers and Creditors. Credit colour can also be selected if the default of Red is not preferred.

Allow edit for Posted IN Invoices and Processed OE Sales Order fields on Header and Lines including all TD Custom fields, OrderNo, Categories 1 & 2, Custom 1 & 2, and Comment.

JC - Job Costing

Added Word Lookup Job button to the bottom of the Job List form. Opens the Word Lookup for JC Jobs. When a Job is selected from the Word Lookup it will locate the Job record in the list adjusting the current selections if necessary,

Added new JC Setting on the Integration tab to Enforce IC Cost Prices. If selected then cost price on JC transactions and batches behaves the same way as cost price on IN Invoices and OE Sales Orders, i.e. cost price for transactions or batch lines with a Product Code specified cannot be edited unless the Product is flagged Manually Costed. Costs on JC Batch lines are updated automatically from IC on post unless manually costed. If manually costed then the cost specified in JC is the cost posted to the IC usage. For existing company databases this setting will be unselected so as not to perturb existing behaviour. For new databases or newly added JC Modules it defaults to selected.

Improve Job Invoicing exchange rate behaviour for Foreign Currency Jobs,

Make Job Status available to the JC Unposted Transactions report layout.

MB - Max Basic

Suppress Alarms during script recording since they are suppressed (by default) during play back.

Allow email properties to be set in OnPrint events when Destination is Screen and pass these through to the Preview form for use if Mail Report is then selected from the preview form. EMailAddress, EMailAttachments, EmailTemplateName, EMailBCC, EMailCC, EMailFileName, EMailFrom, and EMailReplyTo properties are now passed through.

Added GetFieldDomain(FieldName as String) as String method to MemoryTables, Accredo Tables and Custom Tables.

Added HTMLAsText read-only property to Batch Email forms and Mailer object. It returns the body of the html as text (without the HTML tags). If html does not have body, then blank string is returned.

JSON parsing in MaxBasic. Added ParseJSON function to the Environment functions group. Added IsArray to the Boolean functions group. Updated LBound and UBound array functions to handle JSON arrays. Refer to the Help for documentation of the functions.

Script enable the Print Preview button on Document forms.

CopyFromClipboard function added to the Environment group. Copies the contents of the Windows Clipboard as a string. If the Windows Clipboard contents cannot be converted to text, an empty string is returned.

Allow separator to be specified for CSV/TAB delimited files in Memory table builder.

Added MB Tutorial: IC Products and Prices Pivot Table to the Help.

Added the following functions to the Scripts group: GetAccredoDefaultPrinter: string, UseWindowsDefaultPrinter, SetAccredoDefaultPrinter(PrinterName: string)

Add SendKeys function to Environment group for MaxBasic. A generic send keys to whatever currently has input focus. SendKeys(Keys:String[,DelayMS:Integer)

Allow Current Directory (i.e. Start-In Directory) as final fall-back path for CommandLine Scripts only.

Automate page controls for tabbed forms where this was missing.

Added OutputDirectory read/write property to Accredo Directory Object to allow Get and Set for the ReportOutput directory in MaxBasic.

Add LoadCustomisation method to form FilterSort sub objects - allowing customisations for a lookup to be loaded provided the lookup can be filtered or sorted.

OE - Order Entry

Added a Related Orders button to the bottom of the OE Sales Order Entry Form. Not script enabled.

Allow edit for Posted IN Invoices and Processed OE Sales Order fields on Header and Lines including all TD Custom fields, OrderNo, Categories 1 & 2, Custom 1 & 2, and Comment.

PO - Purchase Orders

SupplierStandardCost and its UOM equivalent are now available as read only fields to be customised into the PO Purchase Order line grid and are available in the data object.

Added new AP Settings > Shipments tab option if JC is present for Show Job Defaults on Lines, defaults to selected which gives no change to existing behaviour. If unselected then the Job Defaults panel does not appear on PO Orders and AP Shipments. Job code can be selected in the PO Header and AP Shipment Receipts tab.

Allow edit for Processed PO Orders for some fields on Header and Lines including all TD Custom fields, Categories 1 & 2, Custom 1 & 2, and Comment.

RD - Report Designers

Designers now remember last saved size.

RE - Report Engine

Improve behaviour when default Accredo Printer from registry can't be located.

SA - Sales Analysis

Added Customer by Product Range of Periods and Product by Customer Range of Periods example reports, installed with Demo and Server installs. SA Report tutorials can be found in the help.

SQL - SQL

SQL examples in the help all updated to reference Accredo tables and fields.

TD - Table Designer

Added Import and Export options to Right Click menu for customisations to Custom tabs. Import loads the customisations into the Customise Tab form in an unsaved state.

Designers now remember last saved size.

Delivery code domain redefined to support automatic drop down control creation.

XConv - Prophet Conversion

Added Job Costing conversion to Prophet Converters.

When converting a Prophet company without AP to an Accredo company without AP, bring through the CreditorCode to IC Prod.

Improve CB Statement conversion to handle unwinding unreconciled transactions for Statement reconciliation reports.

ZIP - Backup

Make Accredo Volume Shadow Snapshot aware and supply as AccredoVSS plugin.

 

Bug Fix

ALL - All Modules

Fix memos not scrolling on mouse wheel.

AP - Accounts Payable

Fix population of ContactID in Batch Email Results forms.

Fix constraint on editing Creditor Code on Invoice Only / Receipt Only Shipments.

Exchange rate for FX shipments should not be editable after Invoice is posted. Now fixed.

Print to MailMessage for an APShipment now picks up the Creditor Email Address.

Fix introduced issue with Print Product Labels from documents failing if Quantity for any line is greater than 65535, now quantity is capped at 65535 (the Windows limit imposed for number of copies when printing) and a status hint is displayed.

AR - Accounts Receivable

Fix population of ContactID in Batch Email Results forms.

CB - Cash Book

Fix cash sale for credits incorrectly flipping the Exchange Rate sign on the resulting CB Banking Item. File recovery on CB will correct any affected banking items.

Fix Duplicate for CB Transfer not tracking changes to From Amount in To Amount.

Fix exchange rate extracted from Rate Table for transactions created from CB Rules to use Transaction Date not System date.

CO - Company

Fix toolbar shortcut buttons for memo forms not loading when form is opened from the Reminder list.

Fix Navigator not shown in Windows menu when opened as a normal window (not docked).

Fix "Range Check Error" running Company User report.

Fix introduced issue with saving edits to COUserData.

Fix background images not displayed correctly in all cases.

FA - Fixed Assets

Further fixes to FA Regrouping to handle change to Account Codes on FA Groups.

FX - Foreign Exchange

Fix lockup on Exchange Rate Required from IC Supplier Costs tab.

Exchange rate for FX shipments should not be editable after Invoice is posted. Now fixed.

GL - General Ledger

Fix drill down to GST Transactions from GL batch or transaction.

Make 64-bit file recovery handle re-indexing of files with greater than 52,500,625 records.

Fix Saturn IC summarised integration to GL not entering Location Code as Reference in GL Batch lines.

GST - GST

Fix drill down to GST Transactions from GL batch or transaction.

IC - Inventory Control

Ensure redundant user preference for Enable bar-code exact matches does not affect barcodes. Preference was removed in V4 so bar-code exact matches are always on for all users.

Fix lockup on Exchange Rate Required from IC Supplier Costs tab.

Fix Prior Period IC Revaluation when quantity goes to zero.

Fix IC Stock Levels report layout in Saturn not populating Custom Fields.

Fix Saturn IC summarised integration to GL not entering Location Code as Reference in GL Batch lines.

IN - Invoicing System

Fix cash sale for credits incorrectly flipping the Exchange Rate sign on the resulting CB Banking Item. File recovery on CB will correct any affected banking items.

Fix possible lost delivery address on OE Order or IN Invoice / Quote if same CustomerCode is reselected after Quote to Order, Quote to Invoice, Order from Invoice, Quote from Order.

Fix missing Product filter on batch repricing forms. Issue introduced in build 121.

Ensure WasInserting is set True on OrderFromQuote, InvoiceFromQuote, OrderFromInvoice and QuoteFromOrder for OE and IN.

Fix editing a Posted document changing the DocumentType back to Normal.

Fix introduced issue with Print Product Labels from documents failing if Quantity for any line is greater than 65535, now quantity is capped at 65535 (the Windows limit imposed for number of copies when printing) and a status hint is displayed.

JC - Job Costing

Fix Inactivate for Job Groups incorrectly checking for JobCodes with the same Code rather than Jobs for the JobGroup.

Fix Word Lookup on JC Batches incorrectly including Completed Jobs.

Fix JC EOP error "Field 'Period ID' must be between -32768 and 32767" which could be triggered if Inactivate Jobs at EOP or EOY was selected.

Fix missing Product filter on batch repricing forms. Issue introduced in build 121.

MB - Max Basic

Fix timing issue with OnOpen event for Batch Email forms and default template loading, to ensure default template is only loaded if one has not already been set by an OnOpen event.

Fix Email Address in Email results forms not using Email Address domain and hence truncating at 60 characters.

Ensure WasInserting is set True on OrderFromQuote, InvoiceFromQuote, OrderFromInvoice and QuoteFromOrder for OE and IN.

Fix Maximising of form opened from a script.

Fix introduced issue with saving edits to COUserData.

OE - Order Entry

Fix possible lost delivery address on OE Order or IN Invoice / Quote if same CustomerCode is reselected after Quote to Order, Quote to Invoice, Order from Invoice, Quote from Order.

Fix missing Product filter on batch repricing forms. Issue introduced in build 121.

Ensure WasInserting is set True on OrderFromQuote, InvoiceFromQuote, OrderFromInvoice and QuoteFromOrder for OE and IN.

Fix introduced issue with Print Product Labels from documents failing if Quantity for any line is greater than 65535, now quantity is capped at 65535 (the Windows limit imposed for number of copies when printing) and a status hint is displayed.

PO - Purchase Orders

Exchange rate for FX shipments should not be editable after Invoice is posted. Now fixed.

Further fixes for PDF generation and font substitution conflicts.

Fix introduced issue with Print Product Labels from documents failing if Quantity for any line is greater than 65535, now quantity is capped at 65535 (the Windows limit imposed for number of copies when printing) and a status hint is displayed.

RD - Report Designers

Fix colour assignment issue when printing a custom report or document to xls/xlsx file.

Fix introduced possible "Floating point division by zero" errors for designed documents and reports on Memo components.

Improve image handling in documents and reports to ensure that the entire image fits within the specified Height and Width without stretching when image properties are set to AutoHeight = False, AutoWidth = False LockAspectRatio = True. Usually only significant where image path is changing "on-the-fly" e.g. for printing Product Image on Product sheets where the images are of differing sizes and shapes.

Fix Memo Component transparency issue in RD, introduced with rtf improvements for Memo Components in build 121.

Fix possible "Control '' has no parent window" errors printing from Custom forms.

Fix issue with alignment of Euro symbol in PDF's when fonts were not embedded.

RE - Report Engine

Fix "Out of Memory while expanding memory stream" errors which could be triggered by GetFontData for some fonts.

Fix issues with pdf creation for OpenType fonts without TrueType. Pdf's were not readable in Adobe for these fonts, problematic fonts will be substituted (as previously) with Helvetica. We strongly recommend only using standard system fonts in documents which will be emailed so you can be sure what you see is what they see.

SP - Special Pricing

Fix filter/sort issues on SP Rule List report.

Fix default display label for Initial Margin field on SP Price List report.

SQL - SQL

Fix SQL ESCAPE without % on LIKE.

XConv - Accredo Conversion

Further corrections to CB Balance conversion for FX bank accounts where records are sparse.

XX - Install Scripts

Fix issue with Setup files not prompting for Installation directory if Accredo had been installed previously.

 

Accredo 4 – Version 4.0.10.123

Improvement

AP - Accounts Payable

Make BillFromAccountCode available to AP Allocation form grids.

Allow batch Reprint of Remittance advices for Computer Printed Cheques.

GL - General Ledger

Included generic GL Financial Report files TrialBalanceQuarterlyOpeningActivityClosing.pfd with Server and Demo installations. Reports can be run against any chart without modification since all Standard accounts only are reported.

IC - Inventory Control

Modify ICQTY recovery to not add empty records where quantities all net to zero.

 

Bug Fix

FD - Form Designer

Fix Custom forms not displaying in the Window menu.

IC - Inventory Control

Fix Base UOM not saved following duplicate of an IC Product if source product was edited and saved immediately prior to the duplicate.

Add Exists boolean to ICProduct Location sub object so you can tell if a record exists in ICQty.

Enable Components button for component mode None where parts exist.

Fix introduced issue for Manufacture transactions where Component products are Manually Costed. Usage and hence Manufacture costs were miscalculated. Please contact Accredo if you were affected.

IN - Invoicing System

Fix introduced Access Violation generating pdf's with Unicode characters when fonts were not embedded.

Fix "Could not convert variant of type (Null) into type (Double)" when quantity is deleted (instead of zeroing) on an invoice or order line.

MB - Max Basic

Fix scripted InsertGlobalNarrative method on Document Forms not including line breaks.

OE - Order Entry

Fix "Could not convert variant of type (Null) into type (Double)" when quantity is deleted (instead of zeroing) on an invoice or order line.

PO - Purchase Orders

Fix Base UOM not saved following duplicate of an IC Product if source product was edited and saved immediately prior to the duplicate.

RD - Report Designers

Fix introduced issues with font mapping when fonts were not embedded for some PDF readers.

Fix Access Violation error accessing Report propertied from the Print object.

Fix introduced issue for some printer drivers when duplexing: "Size Error specify the correct paper - Load the same size paper as the printer driver".

TD - Table Designer

Fix locking error saving a TD Table where a domain definition created by the table is also used on another field in the table.

Fix speed issue closing TD Custom Table Form with many records.

 

Accredo 4 – Version 4.0.10.122

Bug Fix

ALL - All Modules

Document List buttons on document forms did not set the underlying selection for the list form to match the document when Show All was on. Now fixed.

FA - Fixed Assets

Fix introduced issue with word wrap formatting on save for JC Job Description and Information tabs, IC Product Information Tab and FA Asset Description tab.

IC - Inventory Control

Fix introduced issue with word wrap formatting on save for JC Job Description and Information tabs, IC Product Information Tab and FA Asset Description tab.

JC - Job Costing

Fix introduced issue with word wrap formatting on save for JC Job Description and Information tabs, IC Product Information Tab and FA Asset Description tab.

RE - Report Engine

Workaround GMail pdf viewer not handling updated pdf format for font handling by adding ansi coding for fonts back into pdfs generated without embedded fonts.

 

Accredo 4 – Version 4.0.10.121

Improvement

ALL - All Modules

Add new decimals Max Digits settings and underlying checks to restrict significant digits to a maximum 12 for Quantities, Prices and Amounts entered via the UI or scripting to catch (in particular) accidental scanning of bar codes into these fields. Limit may be set lower and counts digits both sides of the decimal point so for example if you allow 3 decimal places for Quantities and Quantities Max Digits is set to 10 that will allow users to enter a maximum quantity of 9999999.999.

Sort Memos on Memo tabs by MemoDate, MemoTime, MemoID by default.

Add Find by Transaction ID button to Transaction tabs.

Add Show Inactive Records button to Word Lookup dialog, Button is synchronised with the Lookup control the Word Lookup is launched from.

AP - Accounts Payable

New AP setting added for Shipments and Purchase Orders to "Use Cost Prices for Manually Costed Products". If this is unselected then cost prices for Manually Costed products on Purchase Orders and Shipments will default to zero.

Improve Find behaviour on Document list to preserve selections where possible.

CB Banking Summary - Refresh Bank Account Numbers now also refreshes Particulars.

AP Approve for Payments and Generate Payments - Make Bank Reference and Bank Particulars for creditor available to grids.

Add optional Banking Reference and Banking Comment selections to AP Generated Payments export option, written back to the Banking Summary.

AR - Accounts Receivable

Added new AR Setting to Clear Stop Credit when fully paid. Interest tab in settings has been renamed to Credit Control and the new setting is on that tab. If selected then provided the user has Write permission for Stop Credit then Customers will automatically be taken off stop credit when their Total Balance goes to zero.

CB - Cash Book

CB Banking Summary - Refresh Bank Account Numbers now also refreshes Particulars.

Add optional Banking Reference and Banking Comment selections to AP Generated Payments export option, written back to the Banking Summary.

Allow deletion of an Exported but Unbanked banking summary. Deleted Summary header is stamped modified and retained in history with status Deleted.

CO - Company

Limit polling for Logged-in Users to 10 times the elapsed rate of first poll, or 5 seconds, whichever is longer.

DI - Data Interchange

Added ImportFile.Result boolean property; defaults to True. Can be set anywhere inside a DI Import definition with ImportFile.Result = True or ImportFile.Result = False The Return value of the EDIImport function would normally return True. If ImportFile.Result is set, then it is returned instead.

Added /NOPRINTERCOM as a system configuration switch. If included in a system.cfg COM sessions will not load printers.

Input Format for Data Interchange imports extended to handle varying terminators for CSV and Tab delimited files: CSV/Tab Delimited CRLF Terminated (the default and common Windows format), CSV/Tab Delimited LF Terminated, CSV/Tab Delimited Any Terminator (current CSV/Tab Delimited option maps to this). Also ASCII has been renamed to ASCII Fixed Widths for better clarity. Refer to the help for more details. Please note that this change required that the Import Definition version be incremented.

Allow edit of cost price on Usage Issue and Credit in IC if Product is Manually Costed.

GST - GST

Include Branch and Department codes in GST Code Detailed report for Saturn.

Help - HTML Help

Added help topics: Tutorial: IC Product Quantities by Location Pivot Table, Script: IC Product Quantities by Location Pivot Table.

Added help topics: Tutorial: Scripted Form to Select Multiple Products on Invoice, Script: Scripted Form to Select Multiple Products on Invoice.

Added more SA example reports and tutorials to the help.

Include Events in the documentation for form and data objects where relevant.

IC - Inventory Control

Relax constraint on UOM Groups to a single Base UOM.

Improve Find behaviour on Document list to preserve selections where possible.

Make Bin Location and Location Quantities consistently available to IC Components maintenance grid and report in Saturn.

Improve handling of zero Closing Stock value for Prior period IC transactions.

Allow edit of cost price on Usage Issue and Credit in IC if Product is Manually Costed.

IN - Invoicing System

Improve Find behaviour on Document list to preserve selections where possible.

JA - Job Analysis

Added Open in Designer button and Report File Name to Analysis report selection form.

JC - Job Costing

Added new JC setting to control Prompting re Nil Quantity lines when posting batches.

Added new JC Invoicing Setting to Hide Future lines. This sets the default state for a new toolbar button on the Job Invoicing form to Show / Hide future lines. Button can only be toggled when not in edit mode. Future is relative to the Invoice Period selection. If Future lines are hidden then Invoice Period and Date are disabled while in edit mode.

Added Branch selection to JC Job List in Saturn.

Estimates band added to Job Status report.

Consider Comment as well as Description for JC Narrative blank line trimming at end of JC Batches and JC Estimates.

Validate newly added Estimate lines for Active Products only on save. This is to catch duplicated or copied estimates without complaining on older estimates.

MB - Max Basic

Toolbar shortcuts can be added to Document, Masterfile and Contact list forms.

Made PrintMode property on Document Report objects an enum to make documentation clear. Note that is you have scripts testing this property they will need editing to just check for the enum values: S (Single), B (Batch)

Added help topics: Tutorial: Scripted Form to Select Multiple Products on Invoice, Script: Scripted Form to Select Multiple Products on Invoice.

Added SetSubset method and IndexName property to InputContact scripted form object.

ExecuteSQL function now optionally accepts a saved pfq file as first parameter.

Include Events in the documentation for form and data objects where relevant.

Log transaction rollback due to unhandled MaxBasic exceptions in the System Error Log.

Added User Defined record terminator to Memory table Builder and LoadFromFile / SaveToFile methods, and improve parsing for user defined delimiters to handle delimiters within quotes.

Input Format for Data Interchange imports extended to handle varying terminators for CSV and Tab delimited files: CSV/Tab Delimited CRLF Terminated (the default and common Windows format), CSV/Tab Delimited LF Terminated, CSV/Tab Delimited Any Terminator (current CSV/Tab Delimited option maps to this). Also ASCII has been renamed to ASCII Fixed Widths for better clarity. Refer to the help for more details. Please note that this change required that the Import Definition version be incremented.

Added Wait and Timeout as optional 3rd and 4th parameters to the Shell function: Wait - When True, the Shell function will wait for completion of the program. Defaults to False. Timeout - The number of milliseconds to wait for completion if Wait is true. If this is omitted, an infinite time is assumed.

Added GetFieldNames function to Environment function group. GetFieldNames(FileName: String[, Custom Fields: Boolean]): StringList Returns a string list of field names for the File. File Name: Required. The Accredo table or Custom table name. Custom Fields: Optional. If True only Custom field names are returned. If False (the default) all field names are returned. StringList is sorted alphabetically. Note that type for a FieldName can be obtained using the PropertyType method on the Table object.

OE - Order Entry

Improve Find behaviour on Document list to preserve selections where possible.

PA - Purchase Analysis

Added Open in Designer button and Report File Name to Analysis report selection form.

PO - Purchase Orders

Improve Find behaviour on Document list to preserve selections where possible.

Make Date of Last Sale, Date of Last Usage and Date of Last Sale or Usage fields available to PO Lines.

RD - Report Designers

Default format for date value not assigned or equal to 0 is now blank to match MaxBasic behaviour for expressions and print statements.

Improve RTF handing in Report designers and Documents.

Document and Custom Report printing now suppress printing a blank page to Screen or Printer or PDF if nothing is found to print.

Improve embedded fonts in pdf's to only embed required fonts, this reduces the size of pdf files with embedded fonts very significantly. For example, from 2.24 MB previously to 121k in this build.

Increase Zoom levels available for Report Preview window to up to 400%.

RE - Report Engine

Document and Custom Report printing now suppress printing a blank page to Screen or Printer or PDF if nothing is found to print.

Improve embedded fonts in pdf's to only embed required fonts, this reduces the size of pdf files with embedded fonts very significantly. For example, from 2.24 MB previously to 121k in this build.

Increase Zoom levels available for Report Preview window to up to 400%.

Selecting Screen as Destination when printing documents now does not also trigger a Report Filename change back to the Default Report Filename if the Email Report Filename has defaulted in. Allows preview to screen using Email Report file name and email from the preview screen.

SA - Sales Analysis

Added Open in Designer button and Report File Name to Analysis report selection form.

Added more SA example reports and tutorials to the help.

SP - Special Pricing

Improve grid customisation for Special Pricing Rule Maintenance form to allow Who / What / Where columns to be customised.

SQL - SQL

Add supported MaxBasic functions to SQL Functions menu.

ExecuteSQL function now optionally accepts a saved pfq file as first parameter.

TD - Table Designer

Make CO Text Code and CO GST Code domains have associated lookup control when applied to custom fields.

Add Table Designer to list of modules in Optimise.

XConv - MYOB

Map MYOB Number to AR/AP Reference.

XX - Launchguard

Add ;OlderVersions switch support to Guarded.txt, If included as the first line in the SaturnGuarded.txt / SaturnGuarded64.txt / MercuryGuarded.txt / MercuryGuarded64.txt then any changed version, not just newer versions will be copied.

 

Bug Fix

AP - Accounts Payable

Ensure "Divide Amount" shipments work from Inclusive state on edit.

Reactivating an Inactive Customer or Creditor now automatically re-activates Contacts for the account.

Fix "cannot delete PO - Order ID 0 refers to unposted shipment" error when deleting a PO Order with no lines.

Reprice for Shipments should not be available if InvoiceStatus = "P", now fixed.

Fix introduced issue with slow opening of Customer / Creditor print label dialogs from Customer and Creditor form.

AR - Accounts Receivable

Reactivating an Inactive Customer or Creditor now automatically re-activates Contacts for the account.

Fix introduced issue with slow opening of Customer / Creditor print label dialogs from Customer and Creditor form.

CB - Cash Book

Fix CB File Recovery mishandling balance records for nil balance FX accounts where realised and unrealised variations net to zero.

Fix Banking Summary Export file and Export Definition not printing on Office Copy for Banking Summary after it is Accepted.

CO - Company

Fix Add to Dictionary for 64-bit exe.

DI - Data Interchange

Fix Access Violation loading XLSX file in DI Import.

FA - Fixed Assets

Fix partial disposal of asset where disposed value was rounded to due to percent disposed.

Fix inconsistent reporting which grouping by Parent Asset Code to ensure Parent Asset is included in desired group.

Fix "Book Code must have a value issue" when opening a second or subsequent book.

GL - General Ledger

Fix Find Batch on GL Transaction Batches not extending the Module Selection if necessary.

Fix issue with Budget Detail Report layout when there is more than one budget code.

Fix printing for GL Account Tree not selecting Landscape early enough.

Fix lock-up when load of balances is cancelled from progress dialog.

IC - Inventory Control

Fix introduced speed issue for IC Component report.

Saturn only, fix IC detailed transfer to GL not putting Location Code in reference for Revaluation batches.

Fix Field Index out of Range error on IC Price List copy where Markup Basis is Price Code.

Fix Period range selection issues on IC Pending Stock Movements grid.

IN - Invoicing System

Fix sell price not clearing if line changed from Product to Narrative after a Product Code is selected.

Relax non Whole Kitset Backorder restrictions.

JA - Job Analysis

Fix Job Analysis Reporting when "Job Code not found" error when Include Pending Transactions is selected.

JC - Job Costing

Alarm checking for JobCode on Document header and Job Defaults panel enabled.

Fix grouping on lookup fields in report layouts behaving inconsistently.

Fix JC Invoicing possible "UOM Code not found" errors after UOM is activated.

MB - Max Basic

Add Toolbar field to COScriptShortcutData object.

Fix editing of Toolbar shortcut from Toolbar not handling removal from Toolbar correctly.

Added SPRule as a supported Account File for the OpenForm function. Pass RuleID as the Account Code, opens the SPRuleMaintenanceForm with the Rule loaded.

Fix Access Violation or "Too many SpinEnd calls made" errors with command line script /X parameter of 0.

Fix focus change on Contact record after save of Customer or Creditor form or data object.

Fix AutoInc field type handling for MaxBasic Memory table builder.

ComparePropertyValues function now correctly compares form and data enum values to remove false positives.

Fix issue with Data Level before save scripts losing Description / Information tab text at form level.

OE - Order Entry

Fix sell price not clearing if line changed from Product to Narrative after a Product Code is selected.

Relax non Whole Kitset Backorder restrictions.

PO - Purchase Orders

Fix "cannot delete PO - Order ID 0 refers to unposted shipment" error when deleting a PO Order with no lines.

RE - Report Engine

Fix introduced speed issue for IC Component report.

SP - Special Pricing

Improve validation of special pricing rules imported using SPRuleData object - extend validation to check code exists for the specified type.

Fix SP Rules list handling of effective margin with UOM breaks.

SQL - SQL

Fix Invalid Floating Point error when "Select First X" is used on a table with no records.

TD - Table Designer

Fix error message "A component named already exists" when more than one custom lookup is added to an Accredo table and logged in user is changed with the session.

XConv - Accredo Conversion

Fix 64-bit DateTime indexing issue.

 

Accredo 4 – Version 4.0.10.120

Improvement

ALL - All Modules

Only bring open reminder list to the front if new reminders are due.

AP - Accounts Payable

Improve algorithm for Auto-Allocate of receipts and payment to include outstanding credits against where this results in a cleared balance.

Improve allocation of Payment Discount when (expected) discount on Invoice does not match.

AP Generated payments that are not automatically banked through (Electronic payments & Computer Printed Cheques) now generate banking items in the Creditor currency.

AR - Accounts Receivable

Improve algorithm for Auto-Allocate of receipts and payment to include outstanding credits against where this results in a cleared balance.

Make SourceOrderID available to the Customer Form Document grid.

AR Customer Reports - Customer Layout - make Location Code available.

CB - Cash Book

AP Generated payments that are not automatically banked through (Electronic payments & Computer Printed Cheques) now generate banking items in the Creditor currency.

Added CBStatementEditForm.AfterImport event to allow for example automatic sorting of a Statement following import.

CO - Company

Make Printer Name selection in Print Setup wider to better accommodate TS printer selection.

Make Floating Navigator remember last size.

Added the following to Help > About: Load Path (where the exe is run from); System Path (where is the Accredo Server); Update Path (only shown if different from the System Path, where is the guarded folder which updates are pulled from).

Record failed User Login attempts in the Error Log.

Made User Default Branch / Department / Location / Transit location and Authorisation Code available to User band of User report.

Add Force Login Default option to Company Settings. Sets Force Login true (padlock locked) when User Login dialog is triggered and there is a logged in user.

FA - Fixed Assets

Allow Inactive Closed Asset books to be made Active and Pending.

FD - Form Designer

Added Form Designer Tutorials for the example Simple Dashboard to the help. Added a section to the help under Form Designer > Form Designer Dashboard Tutorials. Form Designer Dashboard Tutorial help topics are: Tutorial: Form Designer Dashboard Monthly Sales, Tutorial: Form Designer Dashboard Current Period Invoices, Tutorial: Form Designer Dashboard Top Customers, Tutorial: Form Designer Dashboard Budget vs Actual Expenses, Tutorial: Form Designer Dashboard Budget vs Actual Sales Group, Tutorial: Form Designer Dashboard Analysis of Expenses, Tutorial: Form Designer Dashboard Product Sales, Tutorial: Form Designer Dashboard Cash, and Tutorial: Form Designer Dashboard Reports. The example Simple Dashboard form is installed with Server and Demo Installs and requires Form Designer module.

GL - General Ledger

Added generic TrialBalanceYearOpening12PeriodActivityClosing.pfd financial report examples to Demo and Live installs.

Help - HTML Help

Added Form Designer Tutorials for the example Simple Dashboard to the help. Added a section to the help under Form Designer > Form Designer Dashboard Tutorials. Form Designer Dashboard Tutorial help topics are: Tutorial: Form Designer Dashboard Monthly Sales, Tutorial: Form Designer Dashboard Current Period Invoices, Tutorial: Form Designer Dashboard Top Customers, Tutorial: Form Designer Dashboard Budget vs Actual Expenses, Tutorial: Form Designer Dashboard Budget vs Actual Sales Group, Tutorial: Form Designer Dashboard Analysis of Expenses, Tutorial: Form Designer Dashboard Product Sales, Tutorial: Form Designer Dashboard Cash, and Tutorial: Form Designer Dashboard Reports. The example Simple Dashboard form is installed with Server and Demo Installs and requires Form Designer module.

Added Report Designer Tutorials for the example custom reports to the help: Tutorial: Report AR Outstanding Balances by Sales Area, Tutorial: AR Sales Areas by Period Graph, and Tutorial: Report IC Product Sales with Percent of Total. Example Custom reports are installed with Server and Demo Installs and require Report Designer.

Help for Report components reviewed and updated.

IC - Inventory Control

Improve handling of Unit field for UOM Products.

Script enable UOMCode selection on ICProductQuantityForm object.

Improve file recovery for mismatched ICUOM and ICProd records.

Added ICStocktakeEditForm.OnPrint event.

Added Bin Locations grid to Maintain > Inventory Control. Allows Bin Locations to be edited for a range of products subject to the user having either Write permission for IC > Products or Write permission for IC > Tasks > Stocktake > Counts (where bin locations may also be edited).

IN - Invoicing System

Add InsufficientSupply boolean property to INInvoiceData object to allow override at data level of IN\Insufficient Default setting. True will supply the quantity assigned, False will supply only to the limit of the available quantity and automatically adjust the quantity supplied down.

Make Customer Stop Credit and Credit limit available to IN / OE Document lists. Fields are subject to usual permissions.

Add QuantityShipped, QuantityCommitted and StockTake variance fields to the OE Back Order, and OE and IN Allocation report layouts.

MB - Max Basic

Extend Ctrl+Enter to open files referenced in script editor in the relevant editor or designer subject to permissions. Now covers PlayScript, EDIImport, EDIExport, CreateSalesAnalysisReport, CreatePurchaseAnalysisReport, CreateJobAnalysisReport, and CreateCustomForm.

Abort in an OnPrint event script will now close the PrintDialog automatically.

Ctrl+Enter shortcut (Open Source in the context menu) will open FD Forms referenced via CreateCustomForm in a script. Place focus in the form name. Ctrl+Enter will also open a script for EDIExport, EDIImport, and PlayScript functions.

Added automated AllCustomers / AllCreditors / AllSourceLocations / AllDestinationLocations boolean on the various document lists: IN Invoice List, OE Sales Order List, AP Shipment List, PO Order List, IC Transfer List, and IC StockTake List. The toggle Show All button will now record, for example as AllCustomers = True/False. ToggleShowAll remains scriptable for backwards compatibility but is no longer documented.

Script enable UOMCode selection on ICProductQuantityForm object.

Added ICStocktakeEditForm.OnPrint event.

ComparePropertyValues function added to Script functions group. ComparePropertyValues(DataObject1: Object, DataObject2: Object): Object Compares two Data Objects of the same class, and returns a string list of the Property Names where the objects have differing values. The string list returned is sorted alphabetically. May be used for example in a BeforeSave event script to log edits to a record with details of old value and new value per property by comparing the trigger object with the saved version of the record at the data level.

Improve GetLicensesAvailable and add GetLicenseID functions, GetLicensesAvailable from COM session would fail with 'file not open' when COM pool was exhausted. GetLicensesAvailable was not declared as having an optional parameter and also the default was always WIN rather than the group of the running Accredo instance. Now a COM instance will check the COM pool if not specified, a WIN instance will check the WIN pool, etc. Added GetLicenseID which returns string 'Win 1','COM 2', etc. or 'None' if no session license allocated.

Added CBStatementEditForm.AfterImport event to allow for example automatic sorting of a Statement following import.

Add Format Property to Memory table fields, only applies to fields which are numbers.

Add OnShow events for Documents. OnOpen event fires before the form is visible, OnShow fires after the form is visible.

OE - Order Entry

Make Customer Stop Credit and Credit limit available to IN / OE Document lists. Fields are subject to usual permissions.

Add QuantityShipped, QuantityCommitted and StockTake variance fields to the OE Back Order, and OE and IN Allocation report layouts.

RD - Report Designers

Added Report Designer Tutorials for the example custom reports to the help: Tutorial: Report AR Outstanding Balances by Sales Area, Tutorial: AR Sales Areas by Period Graph, and Tutorial: Report IC Product Sales with Percent of Total. Example Custom reports are installed with Server and Demo Installs and require Report Designer.

 

Bug Fix

ALL - All Modules

Fix Assertion failure printing Memos On grid.

Fix immediate loading of Links for LinksOn form.

Fix issue with GL balances All Periods running balance in pruned datasets.

AP - Accounts Payable

Fix CreditorName display in AP Shipment Additional Costs tab.

Relax 12 digits max check to fix "Field 'Pre Average Cost' must be less than or equal to 12 digits." error posting a shipment for a "bucket" product code.

Duplicating a Posted IN Invoice or APShipment did not clear AR / APTransactionID. Now fixed. To correct unposted documents run file recovery for AR or AP, issue self corrects as the duplicated document is posted.

Fix AP Purchases Comparison layout Purchases Last Year calculation.

Fix permissions issue for AP Shipments Save, Post Receipts, Post Invoice and Update Costs requiring PO Write access.

AR - Accounts Receivable

Fix AR Settings display issue for new AR Statement setting.

Duplicating a Posted IN Invoice or APShipment did not clear AR / APTransactionID. Now fixed. To correct unposted documents run file recovery for AR or AP, issue self corrects as the duplicated document is posted.

Fix SalesPerson / Sales Area incorrectly required for Duplicated Receipt at data level.

CB - Cash Book

Fix issue with scripting filter / sort of CB Bank Reconciliation Statement grid.

DI - Data Interchange

Fix AccessViolation opening xlsx file in Import Designer when xlsx file contains external references.

Fix Access violation saving changes to ICLocationData object..

Fix StockTransferData requiring UOMCode when UOM Pending.

Fix Field 'Line Status' must have a value issue when adding Products to a Stocktake under DI.

FA - Fixed Assets

Fix partial disposal of asset where disposed value was rounded to due to percent disposed.

FD - Form Designer

Fix Clone Type mismatch error preventing edit of Clone or Source table in FD.

Fix introduced issue with sorting of List Grids by clicking column header in FD forms.

Prevent FD User Buttons responding to click while click event is executing.

Add scroll bars to FD design area.

Fix SpinEdit validation not firing if the component was not referenced on the Code tab.

GL - General Ledger

Fix GL RW Wizard generating test for printing Unposted and Untransferred bands the wrong way round. Fix regenerate for a GL Financial Report not refreshing Untransferred and Unposted flags.

Fix missing GLBal dependency in File Recovery not creating missing balance records.

IC - Inventory Control

Improve handling of Stocktakes when Products are merged with open Stocktakes.

Fix Access violation saving changes to ICLocationData object..

Fix test for Balance mismatch in IC End of Period not handling CurrentPeriod = LastAvailablePeriod case.

Fix Field 'Line Status' must have a value issue when adding Products to a Stocktake under DI.

Saturn with UOM Active only. Fix change of location code on OE Sales Order line triggering a revert to Base UOM code.

IN - Invoicing System

Exclude Held Open Invoices from Email Printed Invoices.

Fix GST code from Sales Group not applied to Job Invoicing lines without a Product Code.

Fix Crediting a Closed job incorrectly clearing Period Complete for WIP on the Credited transactions when Job is not reopened.

JA - Job Analysis

Fix disappearing cursor issue in syntax editor.

JC - Job Costing

Ensure SalesGroupCode from Estimate line is retained for Invoice As Quoted - Estimate option.

Fix JC Job Status report regeneration after preview to screen triggering "Field Sales Group Code must have a value" error.

Fix re-synchronisation of estimate lines for scripted JCJobForm and JCJobData objects where estimate lines have changed on another instance of the data since the estimates were loaded for the job.

Job Invoicing - Invoice as Quoted with Narrative Estimate lines did not set UOMApprovalInvoiceQuantity, now fixed. If you are affected by this issue, JC File recovery will correct this.

Fix GST code from Sales Group not applied to Job Invoicing lines without a Product Code.

Fix Crediting a Closed job incorrectly clearing Period Complete for WIP on the Credited transactions when Job is not reopened.

Fix Import from Estimate for JC Batches not preserving Discount percentage from Estimate line.

MB - Max Basic

Fix Integer overflow errors for MemTable LoadFromExcel and xlsx format.

Fix out by one issue assigning Glyphs to Shortcuts by number in a Script.

Fix disappearing cursor issue in syntax editor.

Fix issue with scripting filter / sort of CB Bank Reconciliation Statement grid.

Add Users sub object to COScriptShortcutData.

Fix data level assignment of User defaults: DefaultAuthorisationCode, DefaultBranchCode, DefaultDepartmentCode, DefaultInTransitLocationCode, and DefaultLocationCode not "sticking".

Added COUsers.pfs to Example exports and COUsers.pfi to Example imports for easy transfer of Users and Permissions between systems. Run the COUsers.pfs from Reports > EDI Exporting. It will also export the permissions to a directory called UsersData within the Accredo Data Directory. This directory will need to be copied to the data directory of the company you are importing into. From the new company, run the EDI Import (COUsers.pfi) and select the csv file you created in the export. Note that passwords are not copied; if Minimum Password Length has been set in the destination company then Change Password will be set true for all Users.

Fix Formatting for Scripted Report sub totals and totals when printed to Excel.

Fix possible exceptions being triggered due to script errors after closing trigger object.

OE - Order Entry

Saturn with UOM Active only. Fix change of location code on OE Sales Order line triggering a revert to Base UOM code.

PA - Purchase Analysis

Fix disappearing cursor issue in syntax editor.

RD - Report Designers

Fix List index out of bounds error when a detail band is disabled and Select Bands dialog is opened.

Fix introduced issue formatting percentages printed to Excel from custom reports.

Fix introduced issue with assigning BrushColor White to a report component also making the component transparent.

RE - Report Engine

Fix AR and AP Ledger totals printed to Excel formatting amounts as text.

Fix Excel lockup after Printing to Excel Worksheet and getting Excel is Busy error when Dialog was closed rather than retried.

SA - Sales Analysis

Fix incorrect domain for Budget Quantity totals in Analysis reports.

Fix disappearing cursor issue in syntax editor.

SP - Special Pricing

Fix timing of initialising of buttons in SPRuleEditForm OnOpen event.

SQL - SQL

Fixed Invalid Pointer Operation error for SQL queries with very long literal strings.

XConv - Accredo Conversion

Fix conversion failing on unposted Non-Diminishing pending transactions without a location specified.

 

Accredo 4 – Version 4.0.10.119

Improvement

ALL - All Modules

Allow grid customisations to be saved for User Roles. The customisations are not loaded by default but can be loaded via customise and apply or using a new LoadCustomisation method added to grids with the customise button available.Tweaked permission settings so that Read permission for Customisations now allows Load for current user and their User Group and Roles. No change to Save.

Improve lazy loading / saving for records with many links.

Restrict digits in front of decimal point to 12 for Quantities and Prices to catch accidental scanning of bar codes into these fields.

Reset Batch Email selections when Use SMTP is unselected.

AP - Accounts Payable

Make Invoice No field from Shipments available to the Creditor Documents grid.

Relax User Prior Periods restriction for Update Costs from AP Shipment.

Add Attach Links selection to Batch Email Remittances.

AR - Accounts Receivable

Added AR Settings for Statements to set default for Include Nil Balances and Include Credit Balances. Initially Include Nil Balances (i.e. statements with Activity in the Statement period but a closing zero balance) is unselected, Include Credit Balances is selected. Add Include Credit Balances selection to Statements and Email Statements selection forms.

CB - Cash Book

CB Statement Import definition ANZOnlineBankingTransactionSummary.pfi updated to ignore header line if it is present in the file to be imported. Note that the updated file is installed with Server installs only, or may be downloaded from the ftp site.

CO - Company

Make Lock Company override User Access times.

Launchguard retired and replaced by self-updating AccredoSaturn.exe / AccredoMercury.exe. Provides better interaction with Windows "Pin to Taskbar" functionality, and no longer requires all sessions for an instance of the exe to be exited before an update can be pulled from the server.

DI - Data Interchange

Budget Export and Import examples with Year selection and budget periods as columns across added.

FD - Form Designer

Deprecated ClearAllFields method on FD Graph and FD Memory Table components and replaced it with ClearFields. Either will work but ClearFields is the documented method for consistency.

IC - Inventory Control

Add CreditorCode as an available field to IC Count lines.

Relax User Prior Periods restriction for Update Costs from AP Shipment.

Added UOM band to IC Product report layout no fields visible by default. Added new IC UOM report layout .

IN - Invoicing System

Add Email Invoices option to OE Generate/ Invoices Results form.

Fix Shipper information not carried onto Invoice or Order from Accepted Quote.

MB - Max Basic

Allow grid customisations to be saved for User Roles. The customisations are not loaded by default but can be loaded via customise and apply or using a new LoadCustomisation method added to grids with the customise button available.Tweaked permission settings so that Read permission for Customisations now allows Load for current user and their User Group and Roles. No change to Save.

OE - Order Entry

Add Email Invoices option to OE Generate/ Invoices Results form.

Fix Shipper information not carried onto Invoice or Order from Accepted Quote.

PO - Purchase Orders

PO Order Variation Report - add calculated Invoiced and Receipted Cost prices to Lines band.

SQL - SQL

SQL Query Builder make Save button have Save As behaviour.

 

Bug Fix

AP - Accounts Payable

Fix record revision not incrementing for changes to Contacts vis the Customer or Creditor forms.

Fix incorrect Permission check for AP Batch Emailing.

Fix Mercury only issue, AP Account Sequence Transaction report not picking up opening balance correctly when run for periods other than the current period.

Fix "IC Period Not Available for Posting" constraint for Make Receipt Only from AP Shipment.

Fix Select All / Unselect All not working under Add Order Lines from AP Shipment if UOM is enabled.

AR - Accounts Receivable

Fix record revision not incrementing for changes to Contacts vis the Customer or Creditor forms.

CB - Cash Book

CB Statement Import definition CBASB.pfi updated to fix date format. Note that the updated file is installed with Server installs only, or may be downloaded from the ftp site.

CO - Company

Fix return value of maxbasic ValidEmailAddress function. Was typed as string, should be boolean.

GL - General Ledger

Fix Access Violation when multiple instances of Compare Charts of Accounts are run.

IC - Inventory Control

Fix F3 key active for Dispatched Stock transfer line.

Fix IC Component report layout not showing any records if Sub Component band not visible or filtered.

Fix Copy Expected to Counted when Generating a Stocktake not working. Introduced in build 118. Workaround is to open the generated counts and select Copy Expected to Counted.

Fix Stocktake import count under UOM using Standard format not handling optional Base UOM codes.

Fix UOMCode selection for Kitset Usage or Component lines on IN Invoice / OE Order.

Check for inactivation of IC Product that ClosingStock and ClosingStockValue is zero in current and all future periods. Previously was just checking InStock figure which could cause revaluation problems.

Fix saving Parts with UOM Codes with multipliers < 1 in Component Maintenance.

Fix Saturn only issue with Bin Location changes made in IC Stocktake Counts not being saved if there was not an existing ICQty record (i.e. Quantities were all zero and bInLocation not previously specified for the Product and Location.

Fix missing scroll bar on IC Product Maintenance form - Sell Prices grid.

IN - Invoicing System

Add IsRestricted boolean to document objects. IsRestricted is true when data level before save events are fired by an another Accredo process e.g. Generate Invoice from an OE Order saves the resulting Invoice and any resulting Backorders. While IsRestricted is true Accredo fields on the document header and lines cannot be modified but TD custom fields can be modified and new lines appended.

Fix UOMCode selection for Kitset Usage or Component lines on IN Invoice / OE Order.

JC - Job Costing

Fix possible Assertion Failure for total only reports when fields include Tab characters.

Print button on JC Batches should not be disabled after printing.

Fix Purchase Analysis error if Job Costing is not present.

MB - Max Basic

Fix LoadFromExcel method for MemTable throwing Dispatch error.

Fix introduced issue with Mailer SetLine.

Fix WasInserting not set true for documents inserted from Customer / Creditor / Contact document tabs.

Fix FormatNumber handling when positive and negative segments of format string are empty and zero segment is specified.

OE - Order Entry

Add IsRestricted boolean to document objects. IsRestricted is true when data level before save events are fired by an another Accredo process e.g. Generate Invoice from an OE Order saves the resulting Invoice and any resulting Backorders. While IsRestricted is true Accredo fields on the document header and lines cannot be modified but TD custom fields can be modified and new lines appended.

PA - Purchase Analysis

Fix Purchase Analysis error if Job Costing is not present.

RD - Report Designers

Ensure all fields in CloneQuery memory table are set Not Required.

Saving as Disk file to xlsx exported Dates as Numbers. Now fixed.

Fix FormatNumber handling when positive and negative segments of format string are empty and zero segment is specified.

RE - Report Engine

Fix possible Assertion Failure for total only reports when fields include Tab characters.

SQL - SQL

Fixed SQL AVG aggregate funciton when one of the values being averaged is null.

Fix SQL Issue with Between on Left Padded string fields (e.g. Document No).

TD - Table Designer

Fix read only behaviour for Custom tab customisations.

 

Accredo 4 – Version 4.0.10.118

Improvement

ALL - All Modules

Make the entire Link line responsive to Double-Click to open the link.

Optimise Tables (Navigator > Setup > Company > Utilities > Optimise Tables) now offers options to optimise Recommended tables or All tables. File Recovery and File Statistics report - recommend optimisation where the Usage Ratio (Now Used / Max Used) is less than 75% and Max Used is greater than 1000 since the empty records may affect performance.

CB - Cash Book

Add Open Details button to CB Transactions to open the Banking Summary for the transaction (if any).

CO - Company

Prune History form (Navigator > Setup > Company > Utilities > Prune History) restructured into a grid form with toolbar. Retain years of history settings may be modified from the form subject to setting permission for the relevant module. Actual Year of History and calculated Year to Prune are shown.

Improve handling of Minimum Password Length and User Change Password flag. Allow User to be saved without a password when Minimum Password length > 0 if ChangePassword is true. Note that User must have permission to change their own password for Change Password to be permitted. Increasing Minimum Password Length in Company Settings now checks for any active users with passwords < the specified length, and sets ChangePassword to True for affected users who have permission to change their password. User Login - If Minimum Password Length is <> 0 then Users without a valid Password cannot login. They either have to change password and set one of a valid length, or if they do not have permission to do that, get someone who does to log in and set one for them. How does this affect COM and MaxBasic Login function? If the password is correct then login will succeed regardless of the Minimum length or Change Password settings, since there is no interactive user.

FD - Form Designer

Add ShowAlternateLookup property on FD data combos.

Make StampModified custom table method available to FD Table Component.

Deprecated ClearRange property on Combo components and replaced it with CancelRange. Either will work but CancelRange is the documented property for consistency.

IC - Inventory Control

Add missing Record Revision to ICSTKHD and ICCNTHD.

Prompt for confirmation and require Control permission for Stocktakes for Reload Expected Quantities.

Make Delete Nil Quantities on Single Counts consider both Counted and Expected Quantities.

Default for IC Stocktake Settings for Include Nil Quantity changed to False. Please review this setting for existing sites, performance may be significantly affected if large numbers of nil quantity products are included in a stocktake.

MB - Max Basic

Added Print button to BrowseDataset grid.

Improve handling of Minimum Password Length and User Change Password flag. Allow User to be saved without a password when Minimum Password length > 0 if ChangePassword is true. Note that User must have permission to change their own password for Change Password to be permitted. Increasing Minimum Password Length in Company Settings now checks for any active users with passwords < the specified length, and sets ChangePassword to True for affected users who have permission to change their password. User Login - If Minimum Password Length is <> 0 then Users without a valid Password cannot login. They either have to change password and set one of a valid length, or if they do not have permission to do that, get someone who does to log in and set one for them. How does this affect COM and MaxBasic Login function? If the password is correct then login will succeed regardless of the Minimum length or Change Password settings, since there is no interactive user.

The following changes and clarifications were made: 1. When scripting using the Mailer Object, the output will be HTML if HTMLAvailable function (MaxBasic function) returns true, and Text if HTMLAvailable returns false. 2. If the Contents property is used to set contents, then we will upscale the text contents to HTML if HTMLAvailable is true. This includes calling the AddSignature method of the Contents property, in which case the HTML signature will be added. However, HTML Contents will not be downscaled to Text mode. 3. AddHTMLSignature and AddSignature methods will now delay adding the signature until just before Send or ShowForm. This means reading the Contents.Text property or the HTMLContents property straight after calling AddSignature/AddHTMLSignature will not return the signature. 4. If the body of the mail is empty, we will auto-load the signature if ShowForm is used.

Add data level Before/After save events to master files.

RD - Report Designers

Add ForceNewWorksheet property to Report Designer bands, which is used when Printing to Excel or in XLS format, which starts a new worksheet and triggers the PageHeader and other properties, similarly to ForceNewPage when printed to Screen or Printer.

XX - Install Scripts

Server Install and Server Update modified to not register AccredoDB. Client Install does registration by default.

XX - OLEDB/ODBC

Server Install and Server Update modified to not register AccredoDB. Client Install does registration by default.

 

Bug Fix

CO - Company

Exclude Inactive Price Codes from Price Code dropdown on Customers and Documents.

Fix COEMAIL table not updated by Alias or Merge. Rebuild Email Table from Company Settings to fix Email lookup with incorrect Party Codes if you are affected.

DI - Data Interchange

Fix Access Violation importing from Xlsx format.

FD - Form Designer

Fix FD Access Violation introduced by changes in Build 117.

IC - Inventory Control

Make restriction on posting of stocktakes when prior unposted stocktakes exist a per location check.

Ensure Location Code selection is required for IC Product Budgets form before Edit is allowed, and then Location Code cannot be changed while in Edit mode. Saturn only issue.

Fix scripting for IC Budget Form to allow Location to be specified in Saturn.

IN - Invoicing System

Fix introduced Assertion failure saving Code in HTML Editor.

JC - Job Costing

Fix changes to Retain Years History setting in JC not being retained.

MB - Max Basic

Fix scripting for IC Budget Form to allow Location to be specified in Saturn.

RD - Report Designers

Fix screen preview issue for Generic / Text only printer drivers.

 

Accredo 4 – Version 4.0.10.117

Improvement

CB - Cash Book

CB Statement Import Designer - add support for User Delimited and Excel files.

CO - Company

File Statistics report updated to show Optimisation recommendation to match File Recovery changes.

Add Optimises to File Recovery report summary. Optimise counted for a file where the maximum number of records is > 1000 and less than 75 percent of the maximum is now used. Note: this is a recommendation for improved performance, particularly when the unused records are at the start of the file.

Improve 2 Period and 6 Period year options to work to whole calendar months and name periods accordingly.

JC - Job Costing

Add Job List button to the JC Job Form.

MB - Max Basic

MaxBasic environment function AppBits added, returns 32 or 64 depending on Accredo executable.

PO - Purchase Orders

Retain PO Delivery Code on Duplicate and Order from Quote.

RD - Report Designers

Added context menu option for components in Report Designers to Number Export Columns.

RE - Report Engine

Clarified behaviour for Report Layouts with more than one detail band when Include records with empty detail is unselected. Detail band will be considered empty when no fields are visible and no filter is applied to the detail band, in addition to when there is no detail for the record.

SQL - SQL

Query Engine optimisations to improve SQL Query speed and plan selection.

 

Bug Fix

AP - Accounts Payable

Fix banking item not deleted with AP Payment transaction edited to zero.

CB - Cash Book

Fix banking item not deleted with AP Payment transaction edited to zero.

CO - Company

Fix COM sessions using the WIN user pool in build 116, introduced by COM.Visible changes.

IC - Inventory Control

More progress bar and speed fixes for very large Stocktake and Count documents.

MB - Max Basic

Fix introduced PageCount including non visible tabs.

Fix positioning of Status and Error hints thrown against grids in event scripts.

PO - Purchase Orders

Ensure Authorisation is required when Manual PO Order Number is applied to a held open order.

RD - Report Designers

Add an editor for Report Title property and allow changes to Report Title from Code Editor panel at the bottom of the design window.

SQL - SQL

SQL Query Builder was not enclosing Or statements within a column in brackets. Now fixed.

 

Accredo 4 – Version 4.0.10.116

New Feature

RE - Report Engine

Add Append to File selection for reports printed to Diskfile in Adobe PDF, Excel XLSX File or Excel XLS File formats. If the specified file already exists and append is selected then report is appended to then end of the file instead of replacing the file, otherwise the file is created as usual.

 

Improvement

ALL - All Modules

Add Delete button to document and batch toolbars.

Added From field to Batch Email Form and Batch Document Email Form.

AP - Accounts Payable

Make AnalysisName available to PO Order Lines and AP Shipment Lines.

AR - Accounts Receivable

Make BalanceTotalExclFuture and BalanceTotalExclFutureBs fields available to the Customer report layout.

CB - Cash Book

Allow Unbank for unconsolidated banking summaries.

CO - Company

Add /NOTAPICOM System.Cfg setting to not initialise TAPI for COM sessions.

Editing User Rules now requires Permission to edit Permissions.

Add User Email for SMTP Mailing to: Show From on Mail Editor Show Reply to on Mail Editor

Added 2 Period and 6 Period Year options to Period Styles for Add Year and Company Settings, and added Plus Adjustment to Company Settings.

DI - Data Interchange

JoinTransaction(MemoryTable) function added to Script function group. Allows temporary negative record numbers generated from AutoInc fields (such as SurrogateIDs) inside a database transaction to be updated in memory tables when the transaction is committed.

Added Barcodes sub-object to DI Export Wizard for IC Product.

FA - Fixed Assets

Improve Parent Asset Code validation, delete disallowed while Asset has Child Assets, check that Parent Asset Code is valid if specified.

FD - Form Designer

JoinTransaction(MemoryTable) function added to Script function group. Allows temporary negative record numbers generated from AutoInc fields (such as SurrogateIDs) inside a database transaction to be updated in memory tables when the transaction is committed.

Simpler ExampleDashboard included with installs. Original example renamed to ExampleTabbedDashboard.

GL - General Ledger

Fix GL Replication settings unexpectedly applying at the data level. These are now correctly form level only i.e. a data entry convenience.

GL Financial Report Wizard report columns grid menu rationalised.

Help - HTML Help

Added F1 / right-click link to help for MaxBasic Statements.

IC - Inventory Control

Added Details field to the Generate Counts dialog.

Added CountedValue calculated as QuantityCounted * ValuationCost to IC Stocktake report.

IN - Invoicing System

Added a new boolean permission Invoicing System > Invoices > Packing Slips to control access to Print Packing Slip from an Invoice. Print Packing Slip on IN Invoice Entry Form and INInvoiceData now requires both the IN\Tasks\Printing permission to be Write or greater and the new permission.

Improve IN Print Quotes selections.

Ensure DocumentNo is included in the email subject line when assigned during print. A placeholder is now used for the part of the subject that will be replaced with the DocumentNo or PackingSlipNo, for example %InvoiceNo% or %PackingSlipNo%. This subject can be replaced or modified in an OnPrint script, or overwritten by a template. If the template uses the <> function, then this same place holder subject will be used. Just prior to actually printing, the placeholder will be replaced with the actual value once the DocumentNo or PackingSlipNo is available.

Added new SourceDocumentModule transient property to OEOrder / INInvoice data objects and forms - property is populated after Duplicate, QuoteFromOrder, QuoteFromInvoice, and OrderFromQuote, to allow location of the originating document, but is not saved. SourceDocumentID is already available and is now also populated for the objects on QuoteFromOrder, OrderFromInvoice, and OrderFromQuote on Duplicate. The AfterInsert event on OESalesOrderEntryForm is now triggered on OrderFromInvoice and OrderFromQuote. The AfterInsert event on INInvoiceEntryForm is now triggered on QuoteFromOrder. Collectively these changes allow replication of any desired information from the originating document that is not included through the duplicate (and equivalent) operations. The requested example was copying the OrderNo field from the originating document - this is deliberately cleared by Accredo.

Make InvoiceFromQuote and OrderFromQuote behaviour consistent: At the form level the Invoice or Order document is created and left in edit mode, the AfterInsert event is triggered, and the source Quote is not made posted and historic until the Invoice or Order is saved. At the data level the Invoice or Order is immediately saved and the InvoiceFromQuote and OrderFromQuote methods return the ID of the new document.

JC - Job Costing

Added JCBatchData events: BeforeSave / AfterSave, BeforePost / AfterPost and BeforeDelete / AfterDelete.

Added Uninvoiced Quantity, Uninvoiced Cost and Uninvoiced Sell to JC transactions as calculated fields.

New Use Job Site Address setting added to PO Settings, if JC is present. If selected then Job Site address will default as the PO Delivery address when a Job Code is selected for the PO.

Added validation so active Jobs with related Jobs cannot be deleted.

JCBatchData, JCBatchTransactionEntryForm, JCDisbursementForm and JCTimesheetTransactionEntryForm now do not delete nil lines on post. Explicit DeleteNilLines method may be used if this is not the desired behaviour.

MB - Max Basic

Added EmailCC, EmailBCC, EmailReplyTo and EmailFrom fields to OnPrint dialogs (where EmailAddress property is available).

Added JCBatchData events: BeforeSave / AfterSave, BeforePost / AfterPost and BeforeDelete / AfterDelete.

JoinTransaction(MemoryTable) function added to Script function group. Allows temporary negative record numbers generated from AutoInc fields (such as SurrogateIDs) inside a database transaction to be updated in memory tables when the transaction is committed.

Allow ActivePage property to accept and interpret a string parameter which is the Caption as an alternative to Tab number.

Added "is" and "to" support to MaxBasic case statement. Sample usage: X = 5; Select Case x; Case 1 to 3; Msgbox("Case is between 1 to 3"); Case is < 6; Msgbox("Case = " & X); Case Else; Msgbox("Else"); End Select

Added Show Button Order on Hints option to Script menu and Script Shortcut Editor.

Added F1 / right-click link to help for MaxBasic Statements.

Added OnOpen and OnClose events for the IC Product Quantities form.

Added Before/After save events to INInvoiceData, OEOrderData , ICTranferData, ICStocktakeData, ICStocktakeCountData, APShipmentData and POOrderData. Refer to Help for Events Triggering Sequence when Form and Data events interact.

Add ICSTKHD and ICCNTHD to OpenForm function Account files.

JCBatchData, JCBatchTransactionEntryForm, JCDisbursementForm and JCTimesheetTransactionEntryForm now do not delete nil lines on post. Explicit DeleteNilLines method may be used if this is not the desired behaviour.

Add checking for Data level events only valid if DI module is present.

Added new SourceDocumentModule transient property to OEOrder / INInvoice data objects and forms - property is populated after Duplicate, QuoteFromOrder, QuoteFromInvoice, and OrderFromQuote, to allow location of the originating document, but is not saved. SourceDocumentID is already available and is now also populated for the objects on QuoteFromOrder, OrderFromInvoice, and OrderFromQuote on Duplicate. The AfterInsert event on OESalesOrderEntryForm is now triggered on OrderFromInvoice and OrderFromQuote. The AfterInsert event on INInvoiceEntryForm is now triggered on QuoteFromOrder. Collectively these changes allow replication of any desired information from the originating document that is not included through the duplicate (and equivalent) operations. The requested example was copying the OrderNo field from the originating document - this is deliberately cleared by Accredo.

OE - Order Entry

Added new SourceDocumentModule transient property to OEOrder / INInvoice data objects and forms - property is populated after Duplicate, QuoteFromOrder, QuoteFromInvoice, and OrderFromQuote, to allow location of the originating document, but is not saved. SourceDocumentID is already available and is now also populated for the objects on QuoteFromOrder, OrderFromInvoice, and OrderFromQuote on Duplicate. The AfterInsert event on OESalesOrderEntryForm is now triggered on OrderFromInvoice and OrderFromQuote. The AfterInsert event on INInvoiceEntryForm is now triggered on QuoteFromOrder. Collectively these changes allow replication of any desired information from the originating document that is not included through the duplicate (and equivalent) operations. The requested example was copying the OrderNo field from the originating document - this is deliberately cleared by Accredo.

Make InvoiceFromQuote and OrderFromQuote behaviour consistent: At the form level the Invoice or Order document is created and left in edit mode, the AfterInsert event is triggered, and the source Quote is not made posted and historic until the Invoice or Order is saved. At the data level the Invoice or Order is immediately saved and the InvoiceFromQuote and OrderFromQuote methods return the ID of the new document.

PO - Purchase Orders

New Use Job Site Address setting added to PO Settings, if JC is present. If selected then Job Site address will default as the PO Delivery address when a Job Code is selected for the PO.

Make AnalysisName available to PO Order Lines and AP Shipment Lines.

RD - Report Designers

Report Writer Wizard and SQL Query Wizard now generate code for parameters where a lookup is not specified if a default value is specified.

SQL - SQL

Report Writer Wizard and SQL Query Wizard now generate code for parameters where a lookup is not specified if a default value is specified.

 

Bug Fix

AP - Accounts Payable

Fix intermittent Contact surrogate not found issues for Customer and Creditor maintenance forms.

Fix AP Update Cheques "Field 'TransactionType' cannot be 'C'" error.

Fix Periods available calculation for insert from Bank Reconciliation to AR or AP.

Fix grouping issue for AP Remittance Advices.

Contacts Report with Country Name field visible triggered an exception message: Dataset not in edit or insert mode. Now fixed.

Ensure AP and CB Integration Settings validation checks if modules is present before valid setting is required.

AR - Accounts Receivable

Fix intermittent Contact surrogate not found issues for Customer and Creditor maintenance forms.

Fix Periods available calculation for insert from Bank Reconciliation to AR or AP.

Contacts Report with Country Name field visible triggered an exception message: Dataset not in edit or insert mode. Now fixed.

Fix introduced issue allowing edit of IN sourced AR Invoice and Credit Transactions.

CB - Cash Book

Fix Periods available calculation for insert from Bank Reconciliation to AR or AP.

Fix Pruning CB incorrectly removing all CBSMITEMs.

Ensure AP and CB Integration Settings validation checks if modules is present before valid setting is required.

CO - Company

Fix Import From File for CO User settings and preferences not working under 32-bit executable.

DI - Data Interchange

Fix Import From File for CO User settings and preferences not working under 32-bit executable.

FA - Fixed Assets

Fix missing balance record warnings for inactive assets.

Ensure AP and CB Integration Settings validation checks if modules is present before valid setting is required.

FD - Form Designer

Fix loading of Memory Table lookup customisations for FD forms. Note: Customisations are not saved or loaded when run at design time (i.e. from the Form designer).

GL - General Ledger

Make Argument checking for GL Functions handle variables which are not explicitly DIM.

Fix lockup on cancel for Inactivating GL account with budgets.

IC - Inventory Control

Fix missing scroll bar on IC Units of Measure form.

Fix issue with Posting a Stocktake hanging if a Stock Transfer with the same ID has ICPend records.

Show progress bar while opening an IC Count.

Fix error hint on save "Product Not Found" for edited Stocktake Counts where a Product Code was deleted from a line.

Ensure Description is available for Sorting during Generate Counts for IC Stocktake.

JC - Job Costing

Ensure all validation checks are passed before system assigns Job Code.

Fix JC Regrouping batch issue.

Fix JC Job Invoicing not storing custom field values.

Fix Customer Name column not populated in Related Jobs window.

Fix accepted Requests for Quotation incorrectly remaining in Job Pending Costs. If you have Jobs affected by this issue a Job Costing File Recovery will correct it.

MB - Max Basic

Added Com.Visible switch. 1 = true, 0 = False, 1 by default. The following needs to be present in an ini file with the same name as the Accredo executable in the same folder as the executable (for example, AccredoSaturn.ini) to make use of this: [Debug] Com.Visible = 1

Fix introduced AccessViolation triggered by UpgradeTable function in MaxBasic.

Fix introduced issue with formatting of dates loaded into MemoryTable from Excel.

Add missing ReloadQuantites method to ICStocktakeData object.

Make AddStandardYear method on COYearForm use Period Style and Plus Adjustment settings from Navigator > Setup > Company > Configuration > Settings > General tab.

OE - Order Entry

Fix line fields not editable from Line.BeforeSave script triggered as a result of change to location in OE Sales Order header, or Recalculate Supply option.

RE - Report Engine

Improve handling of invalid or no printers.

Refine check for Invalid Printable Area for report.

Fix Print to Excel setting Option got Worksheet to Show Page Breaks.

SQL - SQL

Further fixes to resolve speed issues with SQL index selection.

TD - Table Designer

Fix introduced AccessViolation triggered by UpgradeTable function in MaxBasic.

Coordinators created in code for custom lookups were not being destroyed on change of User. Now fixed.

XConv - MYOB

Handle missing Exchange rates where possible.

 

Accredo 4 – Version 4.0.10.115

New Feature

MB - Max Basic

Added TerminalServer() as Boolean function. Return true if client is running in a terminal server session.

 

Improvement

GL - General Ledger

Add GL Budget per Budget Code selection "Preserve Period 1" to control behaviour as budgets roll into current year or prior year journals, affects opening balances for years up to the current year. Options are: * Closing (the default) - closing budget for Period 1 will be unchanged, Budget activity is adjusted to compensate for any change to Budget Opening as there are set to match Actual Opening. * Activity - budget activity for Period 1 will be unchanged, any change to Budget Opening as there are set to match Actual Opening will flow forward. (This is the current behaviour).

MB - Max Basic

DateValue and TimeValue functions will now accept a String, Date, Time or DateTime as the first parameter.

SQL - SQL

Fix DateTime parameters being always passed as Dates to SQL Queries.

XX - Install Scripts

Install sample Import and Export definitions with Server and Demo installs.

 

Bug Fix

CO - Company

Fix HTML vs Plain email selection when there is no signature.

FD - Form Designer

Fix introduced issue with saved izes for Custom Forms.

GL - General Ledger

Fix missing balance column printing Account Sequence report to Excel.

Fix issues introduced by GL Parameter checking.

Fix introduced issue with Add to Report List for GL Reports.

GST - GST

Fix unwinding of FXVars for Payment Basis GST Return Unreported for GST figures.

PO - Purchase Orders

Fix introduced issue with Duplicated PO Order not requiring initial Authorisation.

XX - OLEDB/ODBC

Fix introduced issue with SQL and custom fields causing OLEDB / ODBC errors.

 

Accredo 4 – Version 4.0.10.114

New Feature

MB - Max Basic

Selections wizard added to SQL Query Builder. Based on the wizard in the Report Designer, will generate MaxBasic code to create a scripted forn to prompt for the parameters in your query, execute the query and create a MemoryTable.

SQL - SQL

Selections wizard added to SQL Query Builder. Based on the wizard in the Report Designer, will generate MaxBasic code to create a scripted forn to prompt for the parameters in your query, execute the query and create a MemoryTable.

 

Improvement

CB - Cash Book

Make F4 in the Unreconciled grid on CB Bank Reconciliation trigger Insert in the Reconciled grid.

CO - Company

Allow multiple instances of the User, Groups and Roles form.

DI - Data Interchange

Add Open In Designer button to print dialogs where a report file name is specified.

Add Open In Designer button to Import and Export dialogs.

GL - General Ledger

Improve parameter checking for GL Financial Report functions.

Make GL Financial Report Wizard generate reports that look better in Excel by passing Display Width into ExportColumnWidth and left aligning Report Title and Selections.

Help - HTML Help

In any code editor place cursor in the Accredo Object or Table name and press F1 or right click for the context menu to document the Object.

IC - Inventory Control

Check on save for Active Products that Creditor is Active.

IN - Invoicing System

Set accepted Quote post status to Posted on save of the Accepting document rather than when it is created to allow for cancellation.

Make Product Category 1, Category 2, Stock Group and Creditor fields available to be customised into OE Order and IN Invoice lines.

MB - Max Basic

Added Memory Table Builder to Setup tab.

Add Snippet support to Code Editors. Code snippets can be saved and accessed quickly in code editors by typing the Snippet Text (key word) and Snippet Key (defaults to #). Snippet Manager is available under the Script menu. Your Code Snippets are stored in MySnips.pfl file in the System Directory, built in code snippets are in COSnips.pfl file installed and updated as new builds are installed. Snippet files are merged in the snippet drop down for selection, Your Snippets override Accredo Snippets if the same Snippet Text is used.

Script enabled Duplex support in automated reports. To set Duplex use Printer.Duplex property e.g.: Report = CreateObject("Accredo.ARAgedBalancesReport") Report.Layout = "Aged Trial Balance" Report.Destination = "Printer" Report.Printer.Duplex = "Long Edge" Report.Period = PeriodName(CurrentPeriod("AR")) Report.Run Values can be: "One side", "Long edge", "Short edge" case insensitive.

Add code snippets for Accredo Objects and Tables when selected from the Code Editor dropdown or ObjectName and snippet key are typed.

In any code editor place cursor in the Accredo Object or Table name and press F1 or right click for the context menu to document the Object.

Ctrl+Enter shortcut will open Imports script in a new script editor. Place focus in the script name.

MaxBasic function AppendPDFs(File1,File2[,File3...]) or AppendPDFs(StringList) added to Environment functions group. Appends second and subsequent Accredo-generated PDF files in the order they are listed and to the first file, appended files are not deleted. Returns the consolidated filename. Assumes the starting path is the system directory if given a partial path or just a file name.

Script recording now uses the same variable names as the Automation snippets for form objects.

OE - Order Entry

Make Product Category 1, Category 2, Stock Group and Creditor fields available to be customised into OE Order and IN Invoice lines.

RD - Report Designers

New Introduction band type added to report and document designers. Equivalent to a Summary band but fires before all Detail and Group bands rather than after.

Add Open In Designer button to print dialogs where a report file name is specified.

Make Report Wizard generate reports that look better in Excel by passing Display Width into ExportColumnWidth and left aligning Report Title and Selections.

 

Bug Fix

AP - Accounts Payable

AP Shipment document designer, ensure POHead object is positioned on the PO for the first Shipment Line if there is one. Allows POHead fields to be included in the Page Header if desired.

Fix LocationCode required check incorrectly firing for Receipt Status "Not Applicable" shipment lines.

CO - Company

Fix HTML vs Plain email selection when there is no signature.

GL - General Ledger

Fix GL Budget Report Account selections not applied.

IC - Inventory Control

Sort generated Stocktake Count Lines by Product Code if no overriding sort order is applied.

Fix painting issue on Image tabs.

MB - Max Basic

Add missing properties to Mercury User object: DefaultAuthorisationCode Details SessionCode

PO - Purchase Orders

AP Shipment document designer, ensure POHead object is positioned on the PO for the first Shipment Line if there is one. Allows POHead fields to be included in the Page Header if desired.

RE - Report Engine

Fix introduced issue with loading of Printer preferences for Accredo if these differ from the Windows default printer.

Printing to Excel - second and subsequent sheets in a Workbook do not get correct column widths. Now fixed.

SP - Special Pricing

Stamp Modified for SPRule edits using the SPRuleData object.

 

Accredo 4 – Version 4.0.10.113

Improvement

AP - Accounts Payable

Add AP Setting on Shipment tab to Preserve Extended Cost on Receipts and Usages. If unselected (current behaviour) then for IC transactions from AP we extend CostPrice * Quantity to arrive at the Extended cost. This minimises later revaluation, since revaluations are calculated as the difference between InStockQuantity * ValuationCost and OpeningCostValue + MovementCost from Transactions. If selected we preserve the extended receipt cost on IC transactions from AP so they match the shipment line.

Fixed introduced Assertion when updating IC transactions from AP shipment.

GL - General Ledger

Added SourceID to find in GL Batch.

IC - Inventory Control

Add AP Setting on Shipment tab to Preserve Extended Cost on Receipts and Usages. If unselected (current behaviour) then for IC transactions from AP we extend CostPrice * Quantity to arrive at the Extended cost. This minimises later revaluation, since revaluations are calculated as the difference between InStockQuantity * ValuationCost and OpeningCostValue + MovementCost from Transactions. If selected we preserve the extended receipt cost on IC transactions from AP so they match the shipment line.

IN - Invoicing System

Ensure OrderNo field is cleared on Duplicate as Quote or Quote From Order.

Add PeriodFullyAllocated, UnallocatedAmount and UnallocatedAmountBs as calculated fields to: Print Invoices, Print Quotes, Reprint Invoices, Email Invoices, Email Printed Invoices, IN Status Report, IN Invoice List. These are joined from the AR Transaction and are available to filters.

MB - Max Basic

Make Module specific functions fail when called if Module not present rather than failing Syntax check to make writing generic scripts with a ModuleAvailable test easier.

OE - Order Entry

Ensure OrderNo field is cleared on Duplicate as Quote or Quote From Order.

 

Bug Fix

MB - Max Basic

Fix 64Bit exe issue in MergePDFs function triggering an Access Violation in some instances.

Fix check code validating existence of Files for MergePDF's check should be on execute only.

Fix introduced issue with format for zero defaulting to "-".

RD - Report Designers

Fix introduced issue with format for zero defaulting to "-".

Fix introduced issue with formatting passed to Excel from custom and financial reports.

RE - Report Engine

Fix introduced issue which was setting Workbook calculation to Manual on Print to Excel.

Print to Excel now inserts new worksheet beside active worksheet if adding to existing work book.

Fix introduced print to Excel OLE Exception error when Windows List Separator is not a comma.

 

Accredo 4 – Version 4.0.10.112

Improvement

ALL - All Modules

Lookups will now push to the left if they cannot fit to the right of the control they are dropped from.

Record date, time and user for End of Period updates. These are displayed on the End of Period Update dialog. If less than half a period has expired since the last roll over, a further confirmation dialog is shown.

Update example documents to print CountryName if Country <> Base.

AP - Accounts Payable

Added Tax No to the Navigator > Setup > Company > Configuration > Settings > Display Labels tab. If a label is specified it is used in Company Setting and on AR Customer and AP Creditor forms. For new Companies this is set to GST No for NZ Tax Regime, ABN No for AU Tax Regime and left blank for Other tax regimes.

Making a Customer / Creditor Inactive will now automatically set Contacts for the Customer / Creditor to Inactive.

AR - Accounts Receivable

Allow Editing of Banking Items on unbanked Cash Sale Receipts.

Added Tax No to the Navigator > Setup > Company > Configuration > Settings > Display Labels tab. If a label is specified it is used in Company Setting and on AR Customer and AP Creditor forms. For new Companies this is set to GST No for NZ Tax Regime, ABN No for AU Tax Regime and left blank for Other tax regimes.

Making a Customer / Creditor Inactive will now automatically set Contacts for the Customer / Creditor to Inactive.

CB - Cash Book

Allow Editing of Banking Items on unbanked Cash Sale Receipts.

CBSMDISS table made TD extensible.

Add delete option when editing duplicate rules from CB Bank Reconciliation.

CO - Company

Added Tax No to the Navigator > Setup > Company > Configuration > Settings > Display Labels tab. If a label is specified it is used in Company Setting and on AR Customer and AP Creditor forms. For new Companies this is set to GST No for NZ Tax Regime, ABN No for AU Tax Regime and left blank for Other tax regimes.

Navigator > Setup > Company > Configuration > Mail Settings > SMTP tab, added Add Batch Emails Per Minute setting. If set, then batch emails will be sent according to setting, if blank, all emails will be sent in one go.

FD - Form Designer

Fixed introduced issues with FormatNumber not always applying Currency formatting as expected, and improved interpretation of Format strings.

FD Form and Grid Navigators default MenuButtonVisible to True.

Add ShowInactive support for data combos backed by Memory Tables. The memory table needs to have 2 indexes to make this work: one called "PrimaryKey" and another called "ActivePrimaryKey", where Active is a key on a boolean field called "Inactive". At design time, the datacombo and memory table must be using the non-active index (in the IndexName properties). For example, if the Primary Key is CustomerCode, then Index 1 could be "Customer" and Index 2 could be "ActiveCustomer".

GL - General Ledger

Batch Class can be customised into the GL Maintenance form Transaction Grid.

Added Budget Variance, YTD (Budget) Variance and (Full) Year Budget to GL Ledger Tree.

GL Financial Report Wizard updated to generate column labels for Projected balances to say "Projected" not "Budget".

Added SourceID to find in GL Batch.

IC - Inventory Control

Added a MaxBasic Accounting function to RevalueICStockOnHand.

Added Location selection to IC Component Maintenance form in Accredo Saturn. If Location is selected then Quantities In Stock etc. are for the location, if not selected they are summarised for all locations.

Added Product data panel to JC Job Estimates tab.

IC Receipts now fall back to use Valuation Cost if Latest Cost is zero.

Added Product Quantities button to IC Product Maintenance form toolbar.

Added new IC Settings to Stocktake tab for Generate Stocktake: Default Sort Order for generated counts, and Copy Expected to Counted (only for Single Counts). Added Copy Expected to Counted (only for Single Counts) selection to Generate Stocktake. This option replicates the version 3.6 stocktake behaviour of starting with count figures matching the system expected figures.

Added Include Nil Variance selection and filter to the IC Stocktake Report.

IN - Invoicing System

Modified accelerator key assignments to remove conflict on Charges tab for IN Invoice and OE Order form.

JC - Job Costing

Added Product data panel to JC Job Estimates tab.

Added InvoiceExclusiveCostBs, InvoiceExclusiveAmout and InvoiceExclusiveAmountBs to Job Maintenance Form > Documents tab as available fields. These include the full invoice value, as opposed to the JobAmount and JobCost values which are the values relating to the selected Job, useful where more than one Job is included on the same invoice, or non-job amounts are included on Invoices.

MB - Max Basic

Added Duplex support to Printer Settings. Note that your printer, driver and properties must support duplexing to make use of this. Added Duplex column to Document Defaults. As for other printer related selections this must be set per workstation.

If an Email template does not have a subject specified, then the subject set by the OnPrint event will apply. If there is not an OnPrint script, or the OnPrint script does not set the subject, then the default subject for the report type will apply.

Added new MaxBasic String functions: ValidCode(aCode as String[, ExcludeChars as String]) as Boolean. Returns a boolean value indicating whether the given code has passed validation. If the optional ExcludeChars is specified, the final Filter/SQL/CSV validation takes into account ExcludeChars. MakeValidCode(aCode as String[, ExcludeChars as String]) as String. Returns a string value stripping off all non-printing characters and leading spaces. If the optional ExcludeChars is specified, the final Filter/SQL/CSV validation takes into account ExcludeChars. ValidCodes are defined as no non-printing characters, that is nothing less than Ascii(32) or greater than Ascii(126), no leading spaces, and not used in filter or SQL wildcards (* ? % _) or for csv punctuation (" ,). Option ExcludeChars parameter overrides the restriction on Wildcard and CSV punctuation chars. Non-printing and leading spaces are always invalid and are stripped.

Added a MaxBasic Accounting function to RevalueICStockOnHand.

MaxBasic function MergePDFs(File1,File2[,File3...]) or MergePDFs(StringList) added to Environment functions group. Merges Accredo-generated PDF files in the order they are listed and deletes the merged files so you end up with a single file1.pdf with all content. Returns the consolidated filename. Assumes the starting path is the system directory if given a partial path or just a file name.

Added GetFileList method to Accredo.Directory object. Given a file mask, returns a StringList object containing the file names that match the mask. Dim Dir as Object Dir = CreateObject("Accredo.Directory") Dir.Directory = "c:\Data" FileMask = "*.*" Dim List as Object List = Dir.GetFileList(FileMask) 'DocumentObject(List) For I = 0 to List.Count - 1 Print I & ": " & List[I] Next I

Fixed introduced issues with FormatNumber not always applying Currency formatting as expected, and improved interpretation of Format strings.

Added native order Sort(SortFields as String) method to memory tables.

OE - Order Entry

Shared Custom Fields on OEHead/INHead are now available to customise into the OE Generate Invoice Results form.

Modified accelerator key assignments to remove conflict on Charges tab for IN Invoice and OE Order form.

PO - Purchase Orders

Supplier Cost of zero where there is a Supplier Cost record is now treated as no supplier cost for Purchase Orders and Shipments, so falls back to the Cost if No Supplier Cost setting.

PO Re-Authorisation test relaxed to only require password to be re-entered for a saved authorised order which is edited when there is a change to : * Creditor (who are you ordering from) * Order Status allowing Held Open without Authorisation as before * Change in QuoteGross from initial QuoteGross * Change in AuthorisationCode

RD - Report Designers

Add Report functions to MaxBasic to allow duplexing to be controlled within a report or document design. Duplex: String Returns the printer duplex mode. Modes available are: "One side" - prints on one side of paper. "Long edge" - prints on both sides of paper, flips on long edge. "Short edge" - prints on both sides of paper, flips on short edge. SetDuplex(DuplexMode: String) Set the printer duplex mode. Options for DuplexMode are: SetDuplex("One side") - Prints on one side of paper. SetDuplex("Long edge") - Prints on both sides of paper, flips on the long edge. SetDuplex("Short edge") - Prints on both sides of paper, flips on the short edge.

Fixed introduced issues with FormatNumber not always applying Currency formatting as expected, and improved interpretation of Format strings.

Made JobGroupName, Category1Description and Category2Description available on the Job object in the Job Sheet / Quote designer.

OE Packing Slip and IN Invoice designers, join Bin Location into SortOrder for Supply band.

RE - Report Engine

Tweaks to make generated email file names consistent, space between document class and document no.

SP - Special Pricing

SP Rule Maintenance now jumps to the correct rule when you get the error-hint "UOM Codes must be specified for all or no breaks".

Made Delete Rules with Inactive Criteria and Inactivate Rules with Inactive Criteria options on SP Rule Maintenance also handle Invalid Criteria.

Added "Prompt for Delete line" button to SP Rule Maintenance form Rules grid.

SQL - SQL

Fixed SQL selectivity for Source index on ICTran.

TD - Table Designer

CBSMDISS table made TD extensible.

ZIP - Backup

Backup and Restore Save Settings now just saves the path, not the file name, to allow for auto-generated file names.

 

Bug Fix

ALL - All Modules

Fix issue with email template images not getting attached to email.

Fix Unicode issue with Sorting Integer values (such as LineIDs).

AP - Accounts Payable

Fix timing issue when creating Shipment from Order with markup percent for lines with a Job Code not set.

CB - Cash Book

Fix lurking references to Cheque instead of Withdrawal in some grids and reports.

DI - Data Interchange

Fix issue with Values for Book not populated for first Asset added to a ledger at the data level.

FA - Fixed Assets

Fix issue with Values for Book not populated for first Asset added to a ledger at the data level.

GL - General Ledger

Fix issue with GL financial report cache past last available period to ensure Projected Values flow as expected.

Fix Projected Balances calculation for Income and Expense accounts without budgets for some periods.

Fix issue with GL Batch entry form for user without Links or Memos permission.

IC - Inventory Control

IC Stocktake Status report layout can now report for all Locations if Location selection is cleared. (Saturn only).

Fix timing issue when creating Shipment from Order with markup percent for lines with a Job Code not set.

Fix introduced speed issue with IC Product Balances report.

Fix scrolling for IC Transfer List.

Fixed issue with scripted ProductFilterSort on Generate Counts.

IN - Invoicing System

Quote from Order was not clearing PackingSlipNo and DeliveryDate fields. Now fixed.

JC - Job Costing

Fix timing issue when creating Shipment from Order with markup percent for lines with a Job Code not set.

Fix refreshing of Extended Cost and Sell in JC Transaction Form without UOM.

Fix Duplicated Automation Object issue with JC Batch Form and custom fields for JCHEAD.

Fix default JC Transaction Quantity set to 1 not applying correctly for Disbursement transactions.

MB - Max Basic

Fix "StartRow value is outside of valid sheet range (0 - 0)" error when using LoadFromExcel method on a Memory Table and XLSX format.

Fix Alt+F1 not reliably breaking out of scripting.

CheckUserPassword function was always returning false in v4. Now fixed.

OE - Order Entry

Quote from Order was not clearing PackingSlipNo and DeliveryDate fields. Now fixed.

PO - Purchase Orders

Fix Access Violation in batch repricing for PO Orders without JC module present.

RD - Report Designers

Improve Column header band printing.

Fix introduced issue with repeating summary band running through page footer.

RE - Report Engine

Fix loading of saved multi-level descending sorts on report layouts.

Improve speed for printing to Excel.

SP - Special Pricing

Fix Effective margin calculation on SP Price List.

Fix SP Fixed Sell Price and Fixed Cost Price rules with UOM Code breaks miscalculating effective sell price.

Fix handling of Customer and Product Discount codes as SP Criteria in Rule List Designer.

TD - Table Designer

Fix Duplicated Automation Object issue with JC Batch Form and custom fields for JCHEAD.

 

Accredo 4 – Version 4.0.10.111

Improvement

AR - Accounts Receivable

Make Quotation Reference available to the AR Customer Form Transactions grid.

GL - General Ledger

Minimise work load for GL Totalling and Validation for improved speed. Exclude Inactive Budgets from loading and totalling for GL.

IC - Inventory Control

Added UOM to Base button to IC Transfer form in Saturn for systems with UOM active..

Added Sort list button and Sort method to IC Stock Transfers.

Added OverrideCost boolean to ICTransactionData to allow overriding of ValuationCost for Adjustment and other non cost contributing transactions.

IN - Invoicing System

Add BeforeAccept script event to INInvoiceForm and POOrderForm, fires before a Quote is Accepted.

Order from Invoice and Quote From Order operations now leave the new document in Inserting state rather than saved and edited.

MB - Max Basic

Add BeforeClose events for Results forms, timing allows Abort within the event script to prevent exit.

PrintMode property which returns Single or Batch has been added to the Document and Label report objects.

Add BeforeAccept script event to INInvoiceForm and POOrderForm, fires before a Quote is Accepted.

OE - Order Entry

Order from Invoice and Quote From Order operations now leave the new document in Inserting state rather than saved and edited.

PO - Purchase Orders

Add BeforeAccept script event to INInvoiceForm and POOrderForm, fires before a Quote is Accepted.

 

Bug Fix

AP - Accounts Payable

Exclude deleted shipments from the Additional Costs report layout.

Include bank reference and bank particulars on AP Creditor report.

AR - Accounts Receivable

Add check for Jobs on Customer change of Currency.

CB - Cash Book

FIx issue with AfterAllocation event script suppressing subsequent allocation prompts during CB Bank Reconciliation Apply Rules.

FA - Fixed Assets

FA - Regroup batch does not get created if Transfer to GL has been done for the period prior to changing groups. Now fixed.

FE - File Exporting

Fix File Exporting not including Column Headers when selected for save to Disk File.

GL - General Ledger

Fix Projected Balance calculations so that Opening and Posting account projections flow as expected.

Fix introduced error for Mercury GL Financial reports for Budget Year and Budget Last Year percentages.

Fix introduced Access Violation for Mercury Financial Reporting.

Fix issue with GL Budgets for open to / post to accounts not flowing as expected when there is not budget activity in Closing / Post from accounts for all periods in a year. File recovery will now correct any issues and budgets for these accounts will then load and save as expected.

GST - GST

Printing GST Return to Disk File in Excel format gave "Invalid class typecast" error. Now fixed.

IC - Inventory Control

Fix drilldown from IC Transaction Form for Adjustment.

Fix IC Revaluation trusting valuation basis in CO Period when valuation basis is changed.

IN - Invoicing System

Fix FormatNumber rounding inconsistency for exact half cents.

JA - Job Analysis

Fix issue with replicating blank lines in Comment tab of Analysis Report designers and SP Rule List designer.

JC - Job Costing

PO - Order from Quote - gave warning about JCJOB not found where company does not have Job Costing. Now fixed.

Add check for Jobs on Customer change of Currency.

MB - Max Basic

Fix FormatNumber rounding inconsistency for exact half cents.

Fix InputList and InputPrinter not responding to single mouse click.

PA - Purchase Analysis

Fix issue with replicating blank lines in Comment tab of Analysis Report designers and SP Rule List designer.

PO - Purchase Orders

PO - Order from Quote - gave warning about JCJOB not found where company does not have Job Costing. Now fixed.

SA - Sales Analysis

Fix issue with replicating blank lines in Comment tab of Analysis Report designers and SP Rule List designer.

SP - Special Pricing

Fix possible race condition triggering "RuleID surrogate -X unknown" errors in SP Rule maintenance.

Fix AP Rule Maintenance cancellation loading all SP Rules.

TD - Table Designer

Saving a table after adding custom field triggers Error Message: Field Heat must be between 1 - 9, heat field now visible so this can be set. Default value is 2.

 

Accredo 4 – Version 4.0.10.110

Improvement

ALL - All Modules

Make single click drop Enumerated lookups.

Display Last History period for Inactive masterfiles on the Balances / Activity tab.

Open form now uses Maximum of saved size and width, and minimum size and width.

Show modules with untransferred transactions in GL report warnings.

Make UOM Multiplier required and non-zero (default value 1) for all instances other than COUOM.

AP - Accounts Payable

Allow edit of AP Payment transactions if Banking item is unbanked for consistency with AR Receipts.

Document lists on AR/AP accounts and contacts now have a print button to print the grid list report.

Narrative Lines with nil quantities are no longer set to NotApplicable for InvoiceStatus and ReceiptStatus as this was causing confusion if the shipment line was subsequently edited.

Analysis Detail layouts - Allow sorting within Dissection bands.

Make ExportDefinition, ExportFileName and DueDate available to report in CB Banking Summary Office Copy and AP Generate Payments reports.

AR - Accounts Receivable

Document lists on AR/AP accounts and contacts now have a print button to print the grid list report.

Analysis Detail layouts - Allow sorting within Dissection bands.

CB - Cash Book

CB Apply rules now prompts for allocation for all Open Item Customers and Creditors including when there are no debit items to allocate.

Analysis Detail layouts - Allow sorting within Dissection bands.

Make ExportDefinition, ExportFileName and DueDate available to report in CB Banking Summary Office Copy and AP Generate Payments reports.

DI - Data Interchange

Add Excel as an EDI Exporting format. Refer to the Help for details.

Add method ApplyOrder(Order: Array of Variant) to ordered sub objects and memory tables.

GL - General Ledger

Default unspecified parameters for the GL Functions from the iterator, regardless of number of specified parameters. Previously if only Budget code and Period range parameters were specified all other parameters defaulted from the iterator, otherwise defaults were by type. Report Designer Version incremented for changes to GL Functions.

IC - Inventory Control

Stocktake Improvements in response to feedback:

Check for unposted stock transfers before allowing merge of stock locations. (Saturn only)

Added more ICProduct fields to IC Sales and Usage report.

IC Sales and Usage layout includes Inactive Products if they were Active as at the reporting period, excludes them otherwise.

IN - Invoicing System

Reprice for GST Code for IN Invoices and OE Sales Orders did not include GST Code on charges. Now fixed.

IN Quote - make the Shipping Grid available on the Charges tab.

JA - Job Analysis

Make Job BudgetCost available to Summary on Job Analysis when analysing by Job.

MB - Max Basic

Add method ApplyOrder(Order: Array of Variant) to ordered sub objects and memory tables.

Prevent AfterInsert event firing when a Form is aborted or closed in the OnOpen event.

OE - Order Entry

Reprice for GST Code for IN Invoices and OE Sales Orders did not include GST Code on charges. Now fixed.

PO - Purchase Orders

Added new Line Variation report layout to PO Order Reports. Reports for PO lines, Quantities and Values, Received Not Invoiced and Invoiced Not Received. Report can be grouped by GL Account, Expense Code, Creditor, or Product as desired.

Narrative Lines with nil quantities are no longer set to NotApplicable for InvoiceStatus and ReceiptStatus as this was causing confusion if the shipment line was subsequently edited.

SP - Special Pricing

SP Rule Maintenance form UI improved.

Delete All Rules from SP Rule Maintenance now prompts for a Backup and logs confirmation in the recovery log.

 

Bug Fix

ALL - All Modules

Fix issue on logout via COM from .Net using IDisposable under Windows 8.1 or later with docked Navigator.

AP - Accounts Payable

Fix Prune of inactive Customers and Creditors not handling EmailAddress lookup.

Fix changing cost mode on shipment allowing edit of posted invoice costs.

Email Remittances from Generated Payments form was not passing correct remittance information to the email template. Now fixed.

Fix AP Generate Payments - Print Remittances not excluding Email Creditors.

Make Address Line 5 and Physical Address Line 5 available to AP Creditors Report Layout.

AR - Accounts Receivable

Fix Prune of inactive Customers and Creditors not handling EmailAddress lookup.

Ensure AR Receipt Banking Items Reference flows through to CB Transaction Reference.

CB - Cash Book

Fixed List index out of bounds error when opening a Banked Banking Summary for an Inactive Media Code.

Ensure AR Receipt Banking Items Reference flows through to CB Transaction Reference.

FD - Form Designer

Updated FDImports.pfs for new modal form results. Updated FDImports.pfs is installed with a Server Install or can be downloaded from ftp://ftp.accredo.co.nz/downloads/scripts/.

When an exception occurs inside ExecuteSql where a memory table has been passed in the exception handling, will no longer attempt to destroy it (as it did not create it).

GL - General Ledger

Fix Quote Jobs triggering Untransferred batch warning. Next transfer from JC will silence these.

GST - GST

Fix GST Audit reports speed issue.

IC - Inventory Control

Ensure Product Balances report includes inactive products with non zero revaluation value or non zero closing stock value.

Fixed stocktake count and import barcode entry not implying UOM code.

Fix introduced speed issue with IC Group Sales and Valuation layout.

Fix issue with UOM Sell Price not being updated when UOM Code is changed, Special Pricing is Active and Quantity Breaks are not enabled.

Fix possible "Floating point division by zero" error during JC File Recovery.

IN - Invoicing System

Fixed accelerator key clash for Delivery Instructions on Invoices, Sales Orders and Purchase Orders form.

Usage Lines for Manual Kitsets incorrectly picked up sell prices and extended into OE and IN totals if a Product Code was reselected. Now fixed.

Fix reprice not triggering re-extension for Invoice and Order lines when Discount % is the only field changed and Special Pricing is not active.

Fix issue with UOM Sell Price not being updated when UOM Code is changed, Special Pricing is Active and Quantity Breaks are not enabled.

JC - Job Costing

Fix JC Batch Reprice issue when Special Pricing not present.

Fix JC Reprice issue when UOM is Active and Special Pricing is not Active.

Fix Quote Jobs triggering Untransferred batch warning. Next transfer from JC will silence these.

MB - Max Basic

Limit scope of shortcut keys assigned to Form Toolbar script shortcuts to the form concerned.

Fix introduced error talking to Document Lines from an AfterInsert script.

OE - Order Entry

Fixed accelerator key clash for Delivery Instructions on Invoices, Sales Orders and Purchase Orders form.

Usage Lines for Manual Kitsets incorrectly picked up sell prices and extended into OE and IN totals if a Product Code was reselected. Now fixed.

Fix reprice not triggering re-extension for Invoice and Order lines when Discount % is the only field changed and Special Pricing is not active.

PO - Purchase Orders

Fixed accelerator key clash for Delivery Instructions on Invoices, Sales Orders and Purchase Orders form.

SP - Special Pricing

Fix JC Batch Reprice issue when Special Pricing not present.

 

Accredo 4 – Version 4.0.10.109

Improvement

ALL - All Modules

Maintain list of floating windows for the Application instance in the Windows menu.

AP - Accounts Payable

Added new IC Setting, Update Non Diminishing Costs under Navigator > Setup > Inventory Control > Settings > Prices tab. Selected, the default then Latest and Average costs are updated when Receipts for non diminishing products are posted, Clear they are excluded from update on post receipts.

Improve prompts when there is nothing to allocate for AR Receipts / AP Payments.

AR - Accounts Receivable

AR Customer Report - add selections for Sales Area and Sales Person.

Improve prompts when there is nothing to allocate for AR Receipts / AP Payments.

If Banking Item reference is empty for AR Receipt use the Receipt reference.

CB - Cash Book

Exchange Variation Sequence report layout added to CB Account Reports. Allows easy reporting, grouping and totalling of Variations over a range of periods.

If Banking Item reference is empty for AR Receipt use the Receipt reference.

CO - Company

Recovery log viewer and Error log viewer now open in a floating window.

Tighten permission checking for User, Groups and Roles Maintenance.

FA - Fixed Assets

Added Split band to FA Asset report layout in Saturn.

FD - Form Designer

Added the following graph properties. Note: Report version incremented to 60 with this change. * KeyCalloutLength (Integer) - Determines the length of the key callouts if keys are displayed * RightWall (Boolean) - Toggle visibility for right hand side wall. Only apparent in 3D mode. * LeftWall (Boolean) - Toggle visibility for left hand side wall. Only apparent in 3D mode. * BottomWall (Boolean) - Toggle visibility for bottom wall. Only apparent in 3D mode. * BackWall (Boolean) - Toggle back wall visibility. This controls the top and right border in non 3D mode, and the back wall in 3D mode. * LeftAxis (Boolean) - Toggle visibility for left axis. * BottomAxis (Boolean) - Toggle visibility for bottom axis. * BottomAxisPosition (Float) - Position of the bottom axis relative to the bottom of the chart. Specified as a percentage i.e 50 will position bottom axis in the middle of the chart (half way up). * LeftAxisPosition (Float) - Position of the left axis relative to the left hand side of the chart. Specified as a percentage i.e 50 will position left axis in the middle of the chart (half way in from the left). * Per series field, KeyFont property which controls the font/font size and font color used for displayed series keys. Available as a lookup (on font) field in the Graph Field editor. * Per series field, a Show Key Border property, which controls whether or not borders are displayed around key values. Available as a boolean field in the graph editor.

Added the following Tutorials under Form Designer in the Help: Tutorial: Create a Top Customers Dashboard Tutorial: Filter Top Customers Dashboard Tutorial: Display a Memory Table in a Grid

Enable CreateCustomForm for command line scripting.

GL - General Ledger

Report Wizard now adds page header bands to show if there are Unposted Batches / Unposted Transactions. Note these will always be true when run from within the report designer.

GST - GST

GST and BAS return forms updated to have a Form Toolbar. Allows shortcuts to be added to the toolbar, e.g. shortcut to a report list with the GST reports.

Fix Duplicate for GST Transaction not resetting the TransferredToGL boolean.

IC - Inventory Control

Add Stock Quantities data panel to IC Batch Adjustments / IC Batch Receipts forms.

Added Supplier band to IC Product report layout.

Make all fields available on IC Stocktake Lines available to IC Stocktake Report, including Value Variance.

Added new IC Setting, Update Non Diminishing Costs under Navigator > Setup > Inventory Control > Settings > Prices tab. Selected, the default then Latest and Average costs are updated when Receipts for non diminishing products are posted, Clear they are excluded from update on post receipts.

Replicate custom fields from JCTran to matching ICTran custom fields.

IN - Invoicing System

Pick up OrderNo from JC Job when Job Code is selected in Invoice Header.

Swap position of Internal Reference and Quotation Reference on IN Invoice Header and OE Order Header.

Add OELineID, Custom1 and Custom2 to the InvoiceBackOrder object in the IN Invoice designer.

If Banking Item reference is empty for AR Receipt use the Receipt reference.

JA - Job Analysis

Analysis Reports now handle filters for Products as outer joins.

Fix Display labels in Analysis Reports for Category fields not allowing override.

JC - Job Costing

Allow PO Requests for Quotation to be raised against JC Quote Jobs. PO Requests for Quotation are included on the JC Job Form > Documents tab.

Pick up OrderNo from JC Job when Job Code is selected in Invoice Header.

Added JC Reprice Batches option.

Replicate custom fields from JCTran to matching ICTran custom fields.

MB - Max Basic

Added GetTypedObject function to MaxBasic. GetTypedObject(ClassNames) where ClassNames is a ';' separated list of classes. Returns the first matching Object on Null if not found. e.g. Dim Form1 as Object Form1 = GetTriggerObject if IsNull(Form1) then Form1 = GetTypedObject("INInvoiceEntryForm;OESalesOrderEntryForm") if IsNull(Form1) then Error "Wrong form class for script" Else Print Form1.ClassName End If

Added a button to Display Navigator Item Ordering to Add Shortcut and Customise Layout dialogs.

Allow Glyphs for script shortcuts to be selected by number. To view glyph numbers Script > Show Glyph Names on Hints and hover cursor over a glyph.

Added Company.ExpandNavigator and Company.MinimiseNavigator methods to the Company object. * Company.ExpandNavigator will expand the navigator if it is currently docked, and minimised. * Company.MinimiseNavigator will minimise the navigator if it is currently docked, and not minimised.

Company group added to MaxBasic functions, contains the following functions: AddCompany(CompanyCode: String, CompanyName: String; DataPath: String): Boolean Add an entry to the Company List, does not add data files. CreateCompany(CompanyCode: String, CompanyName: String; DataPath: String, [ModuleList: String, [Country: String, [Currency: String, [TaxRegime: String]]]]): Boolean Create new company database and add to the Company List. If module list is not specified then all installed modules are included. DeleteCompany(CompanyCode: String): Boolean Delete entry from Company List, does not delete data files.

Enable CreateCustomForm for command line scripting.

OE - Order Entry

Move Internal Reference on OE Order to match position on IN Invoice.

Swap position of Internal Reference and Quotation Reference on IN Invoice Header and OE Order Header.

Add OELineID, Custom1 and Custom2 to the InvoiceBackOrder object in the IN Invoice designer.

PA - Purchase Analysis

Analysis Reports now handle filters for Products as outer joins.

Fix Display labels in Analysis Reports for Category fields not allowing override.

PO - Purchase Orders

Allow PO Requests for Quotation to be raised against JC Quote Jobs. PO Requests for Quotation are included on the JC Job Form > Documents tab.

RD - Report Designers

Added the following graph properties. Note: Report version incremented to 60 with this change. * KeyCalloutLength (Integer) - Determines the length of the key callouts if keys are displayed * RightWall (Boolean) - Toggle visibility for right hand side wall. Only apparent in 3D mode. * LeftWall (Boolean) - Toggle visibility for left hand side wall. Only apparent in 3D mode. * BottomWall (Boolean) - Toggle visibility for bottom wall. Only apparent in 3D mode. * BackWall (Boolean) - Toggle back wall visibility. This controls the top and right border in non 3D mode, and the back wall in 3D mode. * LeftAxis (Boolean) - Toggle visibility for left axis. * BottomAxis (Boolean) - Toggle visibility for bottom axis. * BottomAxisPosition (Float) - Position of the bottom axis relative to the bottom of the chart. Specified as a percentage i.e 50 will position bottom axis in the middle of the chart (half way up). * LeftAxisPosition (Float) - Position of the left axis relative to the left hand side of the chart. Specified as a percentage i.e 50 will position left axis in the middle of the chart (half way in from the left). * Per series field, KeyFont property which controls the font/font size and font color used for displayed series keys. Available as a lookup (on font) field in the Graph Field editor. * Per series field, a Show Key Border property, which controls whether or not borders are displayed around key values. Available as a boolean field in the graph editor.

RE - Report Engine

Add Report Preference to Suppress Grand Totals to report layouts. When selected no grand totals for the top level of grouping are printed.

SA - Sales Analysis

Analysis Reports now handle filters for Products as outer joins.

Fix Display labels in Analysis Reports for Category fields not allowing override.

TD - Table Designer

Prompt for Backup if modifying Tables in TD and do not allow load or save of tables from TD outside the company data directory. N.B. Prompt applies only on first accessing Table Designer within a session.

Contact ID fields in Custom Tables now give a Contact Lookup in live edit generated forms.

Replicate custom fields from JCTran to matching ICTran custom fields.

Custom tables should not have the same filename as Accredo tables. Recommendation is that Custom table names should either be longer than 8 char, or include an underscore character to avoid possible future conflicts as new Accredo tables are added. Rebuild custom data dictionary, and Table Register > Rebuild and Save Register options now check for and warn about any conflicting tables.

Add Rename option to Table Register.

 

Bug Fix

AP - Accounts Payable

Fix Bank Account detail not showing on banked AP Payments.

Fix Update Costs button visibility on AP Shipments.

Fix issue with wrong contact loaded for email template when emailing an individual Receipt or Remittance.

Fix flip signing of Payment.NetAmount on AP Remittance Email Templates.

Push change of Branch / Department / Location code due to Job selection on a document through document lines.

Receipting Products incorrectly rounded Average Cost to QuantityDecimals instead of Base Currency Cost Price decimals. Now fixed.

AR - Accounts Receivable

Ensure Valid Filenames are generated by email templates.

Fix issue with wrong contact loaded for email template when emailing an individual Receipt or Remittance.

Fix AR Sales Area Budgets not saved beyond last available period for AR.

"Fix Field Memo Time must have a value" error for 12:00 a.m. in Memos.

CB - Cash Book

Fix Print All selection for printing Bank Reconciliation reports not working for Closed statements.

Fix introduced issue selecting Unreconciled transactions on CB Bank Account Maintenance.

Fix CB Period Opening Unrealised Bs not updating correctly at EOP for new balance records. If you have FX Bank Accounts please backup and run file recovery for Cash Book after installing this update, then revalue your FX bank accounts from the earliest period that Period Opening Unrealised Bs changes for to correct this issue.

CO - Company

Fix permissions issue with editing HTML Signature if User belongs to a Permission Group.

Fix validation errors relating to Period and Year to date figures when reducing Quantity Decimals.

FD - Form Designer

Fix introduced lockup in FD grids which trigger a dialog.

Fix Memory Table designer in FD not allowing descending indexes.

Disabled FD Focus checking as the default to fix various FD focussing issues.

GL - General Ledger

Fix Mercury and Saturn GL Batch import / Export formats to retain cross system compatibility.

GST - GST

Fix scaling for GST Return Form printed with changed Report Fonts.

IC - Inventory Control

Fix "Cannot focus a disabled or invisible window" in Edit Count for a stocktake in Saturn where the user does not have a default Location Code setting.

Deleting a stocktake could back out variance quantities when this was not required. IC file recovery corrects this. Now fixed.

Fix Creditor selection not applied during Stocktake Generation.

Fix issue with Stocktake import in UOM format.

Fix validation errors relating to Period and Year to date figures when reducing Quantity Decimals.

IC Stocktake - Reload Expected Quantities was reloading from the first Location instead of the Location of the Stocktake. Now fixed.

Fix issues with deleting stocktake not backing of variances correctly.

Fix issue editing Product Budgets.

Fix issue with Print Count Sheets from Reports.

Fix issue with loading of MovementExpected when Products are added to a Stocktake by importing a count.

Receipting Products incorrectly rounded Average Cost to QuantityDecimals instead of Base Currency Cost Price decimals. Now fixed.

Fix UnitName issue on Count Sheets.

IN - Invoicing System

Duplicating an Invoice when sell price basis changed did not preserve Gross Amount and GST. Now fixed.

Fix missing Product filter on Batch Reprice forms.

Fix spurious message about reopening a Job when deleting an invoice with no Job Code.

JA - Job Analysis

Fix "Missing Metadata" error on JC Analysis report when BranchName is selected in Saturn.

JC - Job Costing

Fix scaling issues on JC Transactions Form.

JCBatchData returned surrogate BatchID when inside a transaction, after committing. Now fixed.

MB - Max Basic

Fix issues with EmailSubject not getting set via scripting for new documents.

JCBatchData returned surrogate BatchID when inside a transaction, after committing. Now fixed.

Fix issue with script run from form toolbar with wrong trigger object set causing a "References still existing on destruction" error on close from an AfterSave event.

OE - Order Entry

Fix missing Product filter on Batch Reprice forms.

PO - Purchase Orders

Fix missing Product filter on Batch Reprice forms.

RE - Report Engine

Improve period range recording for Add to Report List.

SP - Special Pricing

Fix shortcut for SP Price List not loading the Price List Report Definition.

SQL - SQL

Fix SQL Count Distinct handling.

TD - Table Designer

Fix GLHead and JCHead custom fields not available on GLBatchData and JCBatchData objects.

Check for conflicting Custom Table names with new Accredo Table names before conversion proceeds. Custom tables can not use the same filename as Accredo Tables.

Added Rename Table option to Table Register.

XConv - Accredo Conversion

Check for conflicting Custom Table names with new Accredo Table names before conversion proceeds. Custom tables can not use the same filename as Accredo Tables.

Ensure changes to non lookup domains are applied to custom tables during conversion.

Fix missing conversion for customisations to AP Shipment List, PO Order List and IC Transfer List.

Fix introduced conversion issue for Custom Tables truncating Custom fields.

XX - OLEDB/ODBC

Update OLEDB/ODBC driver for missing v4 Data changes.

 

Accredo 4 – Version 4.0.10.107

Improvement

ALL - All Modules

Make single click drop Enumerated lookups.

 

Bug Fix

ALL - All Modules

Fix introduced issue with All Periods selections.

FD - Form Designer

Prevent other messages being processed while an FD event is being executed.

 

Accredo 4 – Version 4.0.10.106

Improvement

ALL - All Modules

Make + / - (numeric keypad) move forward / backward a period in period lookups. Make CTRL++ / CTRL+- (numeric keypad) move forward / backward a year in period lookups.

Show underlying period range for Year / Full Year etc.

Make None permission for Company / Users / Password prevent change of password.

Fix script recording not recording some toolbar options.

AP - Accounts Payable

Improve behaviour when invoice documents are duplicated or deleted for a Completed Job to prompt for desired action.

Allow set / clear of Primary Contact from Contact form or data subject to Primary Contact Required setting and Customer / Creditor permissions.

AR - Accounts Receivable

Allow set / clear of Primary Contact from Contact form or data subject to Primary Contact Required setting and Customer / Creditor permissions.

CB - Cash Book

Ensure Control permission for CB Banking is required for Export.

Make Other Party fields available on CB transfer form.

CO - Company

Make Accredo MDI frame remember it was maximised across sessions, so if forms were opened full screen last time you ran Accredo, it will remember that next time.

Added Single Period Year option to Period Styles for Add Year and Company Settings.

FD - Form Designer

GetActiveObject function now takes an optional Boolean parameter to IncludeCustomForms, defaults to False.

GL - General Ledger

Export / Import Chart of Accounts now supports Excel xlsx and xls formats.

GL Report Designer Wizard - added the following to the calculations available in the Report Columns grid: Projected Balances > Projected Year Percent and Projected Year Incl Adjustment Percent Budgets > Budget 7 Periods Ahead to Budget to 12 Periods Ahead Year > Renamed Total Year Budget to Full Year Budget in the menu to make it consistent with the new Full Year Variance calculations Budget Variance > Budget Variance 1 Percent the Budget Variance 12 Percent Budget Variance > Full Year Budget Variance and Full Year Budget Variance Percent

Improve Variance and Variance Percent fields generated from the GL Report Wizard to consistently show favourable variances as positive and unfavourable variances as negative. Affects both Budget Variance and Last Year Variance. Class and FavSign added to the Iterators and to the Account object in order to get sign correct base on Account class. Report version is incremented.

A new GL Setting "Validate Chart Based Totalling" which is selected by default, makes Validate Ledger treat Standard accounts which do not Add / Consolidate anywhere as Validation Errors.

IC - Inventory Control

Add Count List to Edit Count option for IC Stocktakes.

IN - Invoicing System

Improve behaviour when invoice documents are duplicated or deleted for a Completed Job to prompt for desired action.

Post Invoice will now create nil value JC Transactions where Invoice line has a JobCode, ProductCode and Quantity but no cost or sell prices and no JCTransactionID.

JA - Job Analysis

Analysis Designers now open in separate window as for Report and Document Designers.

JC - Job Costing

Improve behaviour when invoice documents are duplicated or deleted for a Completed Job to prompt for desired action.

Add JC Setting to use Default Sell UOM for JC Transactions and Batches.

Post Invoice will now create nil value JC Transactions where Invoice line has a JobCode, ProductCode and Quantity but no cost or sell prices and no JCTransactionID.

MB - Max Basic

Reminder List form is now script enabled.

GetActiveObject function now takes an optional Boolean parameter to IncludeCustomForms, defaults to False.

PA - Purchase Analysis

Analysis Designers now open in separate window as for Report and Document Designers.

PO - Purchase Orders

Improve behaviour when invoice documents are duplicated or deleted for a Completed Job to prompt for desired action.

Make ICCost Minimum Order Quantity available to the Quantities panel on PO Orders.

RD - Report Designers

NewPageAfter runtime property added to report bands. Affects only the following band types: btPageHeader, btTitle, btDetail, btSummary, btGroupHeader and btGroupFooter, and only in AfterBand code. If the property is set, a new page command is issued after the band is printed.

Add BrushColor property for Expression and Label Components to allow background colour to be set when component is not transparent. BrushColor is passed through to Excel as the Fill Color for cells.

SA - Sales Analysis

Analysis Designers now open in separate window as for Report and Document Designers.

SP - Special Pricing

Allow update by Amount for SP Batch Update.

 

Bug Fix

AP - Accounts Payable

Fix AP Generated Payments form not displaying BankAccountNo for generated payments.

Fix Access Violation applying a Filter/Sort to the Approve for Payments form.

Make Reference and Comment editable from Generated Payments form for Electronic Payments.

Insert from Rule on CB Bank Reconciliation will always use Direct Debit payment method on AP Transactions.

AR - Accounts Receivable

Delete button on Contact grids in Customer / Creditor maintenance is now always available, check for whether contact may be deleted is deferred until delete is called. Fixes speed issue for contacts tab on customers with many contacts.

CB - Cash Book

Make Reference and Comment editable from Generated Payments form for Electronic Payments.

Insert from Rule on CB Bank Reconciliation will always use Direct Debit payment method on AP Transactions.

FA - Fixed Assets

Fix deleted transactions / replayed depreciation in FA not contra'd in GL on Transfer.

GL - General Ledger

Fix GL Batch Import in Mercury giving "Line 2 of import file contains invalid data - import cancelled" error.

IC - Inventory Control

Fix Batch Adjustments using Latest Cost instead of Valuation cost.

Fix Import Count to check exact Product Code match before Bar Code match, and report Bar Code matches.

Fix Stock Group selection not applying on IC Generate Stocktake.

IN - Invoicing System

Fix rebasing triggered when not required for UOM with fractional multipliers.

Fix email template referring to Contact fields causing Batch Emails to error if there is no Contact record for the Customer / Creditor.

JC - Job Costing

Fix rebasing triggered when not required for UOM with fractional multipliers.

Fix "Branch Code must have a value" error when printing Reprice Estimates results in Mercury.

Reinstate Print Job Label button on JC Job.

Fix JC Budget figures not editable.

MB - Max Basic

Fix Integer division in Max Basic not working for currencies.

Fix ActivePage scripting on COUser form.

XConv - MYOB

Add Currency mapping support to MYOB Converters.

 

Accredo 4 – Version 4.0.10.105

Improvement

ALL - All Modules

Improve Global Narrative UI.

AP - Accounts Payable

Improve Shipment form selection for Cost Mode, this now appears in the Shipment header as a drop down selection, and the selected mode may be saved back to the Creditor.

Make Payee Name available to AP Transaction Form for one-off payments.

Make Custom fields added to ARTran available to the Credit and Debit grids on the Allocations form.

AR - Accounts Receivable

Make Custom fields added to ARTran available to the Credit and Debit grids on the Allocations form.

CB - Cash Book

Add Unmatched for Statement report to CB Bank Reconciliation reports.

Added Unbank option to Banked banking summaries. Control permission for Banking summaries is required, on only summaries within the CB Available Periods window can be unbanked. Unbanking a Summary contras the CB Transaction, and returns the Banking Summary and Lines to status Unbanked.

Add GL Account Code for Bank Account to Bank Reconciliation Report.

Ensure Other Party details are preserved when inserting transactions from a Bank Reconciliation.

Adding or Editing a CB Rule from a Bank Reconciliation now triggers a Match All so all Unreconciled lines are retested for a match.

CO - Company

Capture Form now also copies to the clip board to match behaviour of Print Screen. Affects both the script function and the File > Capture Form option.

GL - General Ledger

Merging Branches, Departments, GL Account Codes or Budget Codes requires a GL File Recovery afterwards to reflow the balances. Accredo now tracks and enforces the need for a GL recovery following Merge for these records and also following edits to GL Accounts which affect Post To / Open to flow.

GST - GST

GST and BAS return forms updated to have a Form Toolbar. Allows shortcuts to be added to the toolbar, e.g. shortcut to a report list with the GST reports.

IC - Inventory Control

Allow Unit to be edited if UOM is Active but not required, and Product does nto have a BaseUOMCode specified.

IN - Invoicing System

Weight and Volume for Automatic kitsets on Invoices and Orders are taken from Component lines only in all cases.

New Company defaults for Next Computer assigned Invoice, Credit, Packing Slip and Purchase order numbers are now initially blank and require that these are set rather than defaulting to 1.

JC - Job Costing

Insert Transaction button on JC Job Invocing form moved from Grid toolbar to Form Toolbar. Transactions inserted from here will now automatically refresh into the Invoicing grid. Refresh button added to the Invoicing grid.

Add Invoiced Sell / Invoiced Sell Bs as available fields for the JC Transaction Sequence Report Summary Band .

New Company defaults for Next Computer assigned Invoice, Credit, Packing Slip and Purchase order numbers are now initially blank and require that these are set rather than defaulting to 1.

MB - Max Basic

Add Code button added to Report Lists, insert code in a report list for example to prompt for Selections to be passed to each of the reports in the list. The example report list in the Demo data has been updated with a Period selection.

Added InputContact Maxbasic function with the following parameters InputContact(CodeType as String, CodeValue as String, Prompt as String, [Title as String], [DefaultValue as Number], [Filter as String], [FilterButtonVisible as Boolean], [AllowInactive as Boolean]) CodeType can be "ARCONTCT" or "APCONTCT" CodeValue can either be blank (i.e all contacts) or set to creditor/customercode based on CodeType. Default value for DefaultValue = 0 Default value for FilterButtonVisible = False Default value for AllowInactive = False Returns the ContactID of the contact selected, Null if Cancelled, and 0 if nothing is selected but OK is pressed. Added InputDeliveryAddress Maxbasic function with the following parameters InputDeliveryAddress(CustomerCode as String, Prompt as String, [Title as String], [DefaultDeliverycode as String], [Filter as String], [FilterButtonVisible as Boolean]) Default value for FilterButtonVisible = False. Returns the selected DeliveryCode or Null if Cancelled.

Expose Customer / Creditor code and refresh method to ARAllocateTransactionsForm and APAllocateTransactionsForm.

OE - Order Entry

Weight and Volume for Automatic kitsets on Invoices and Orders are taken from Component lines only in all cases.

PO - Purchase Orders

New Company defaults for Next Computer assigned Invoice, Credit, Packing Slip and Purchase order numbers are now initially blank and require that these are set rather than defaulting to 1.

 

Bug Fix

AP - Accounts Payable

Fix "Edited Transaction Cannot be Saved" error updating JC usages from an AP Shipment.

AP Shipment Update Costs / Post Invoice does not update JCTran UOM Unit Cost Price / UOM Approval Invoice Cost. Now fixed.

CB - Cash Book

Apply Analysis filters to Analysis Codes in CB Rule Maintenance.

Fix introduced speed problem with Opening Banking Summary list.

Do not match CB Rules to nil value unmatched lines, do not insert transactions when applying rules if amount is zero.

CB GST Audit Report was not reporting Withdrawal Transactions, now fixed.

CO - Company

Fix issues with Body and Signature fonts for HTML email.

GL - General Ledger

Improve GL File Recovery messages and don't make blance changes when Ledger is not valid.

Make FIle Recovery for JC clear invalid Period to Transfer flags on Standard jobs.

GST - GST

CB GST Audit Report was not reporting Withdrawal Transactions, now fixed.

IC - Inventory Control

Fix "Edited Transaction Cannot be Saved" error updating JC usages from an AP Shipment.

Fix speed issue when importing lage stocktake count files.

IN - Invoicing System

Discount Code was not being carried from OE Sales Order to IN Invoice on Generate. Now fixed. Affects pricing if new lines are added to the invoice or invoices are repriced after generate.

JC - Job Costing

Fix "Edited Transaction Cannot be Saved" error updating JC usages from an AP Shipment.

AP Shipment Update Costs / Post Invoice does not update JCTran UOM Unit Cost Price / UOM Approval Invoice Cost. Now fixed.

Fix JC Batch DuplicateReversing not flipping underlying UOMQuantity.

Shortcuts can now be added to JC Timesheet Batch form navigator.

MB - Max Basic

Fix Automation properties and script recording for Documents tabs on Masterfile and Contact forms.

Check script shortcut user list when script is fired via shortcut keys.

OE - Order Entry

Discount Code was not being carried from OE Sales Order to IN Invoice on Generate. Now fixed. Affects pricing if new lines are added to the invoice or invoices are repriced after generate.

SP - Special Pricing

Fix script shortcuts for SP Rule Maintenance form toolbar.

XConv - Accredo Conversion

Data conversion rounds UOMCostPrice / UOMSellPrice instead of exactly matching to CostPrice / SellPrice, now fixed.

 

Accredo 4 – Version 4.0.10.104

Improvement

AP - Accounts Payable

Show default Job Code on PO Header and AP Shipment Receipt tabs.

CB - Cash Book

Add Exported status to CB Banking Summaries and require Export before Accept for Electronic Payment and Direct Debit summary types.

CB Rules now support * and ? wildcard characters as used in Filters.

CO - Company

Make Accredo MDI frame remember it was maximised across sessions, i.e. if forms were opened full screen last time you ran Accredo it will remember that next time.

GL - General Ledger

Making a GL Account inactive will now also make any replicated analysis codes inactive.

Trial balance reports now indicate in report selections if Untransferred batches / unposted batches exist up to the period reported. Added Boolean properties to the Report Object in GL Financial reports UnpostedBatches UntransferredBatches

IC - Inventory Control

Added Hide Unchanged Sell Prices / Show All Sell Prices button to the toolbar on the IC Price Update Query form which is shown during a Query run for an IC Global Price Update. Default is to Hide Unchanged Sell Prices.

Add display label settings for Count Custom 1 and Count Custom 2 fields.

IN - Invoicing System

Made more fields available to the Results grids in IN and OE Processes.

JC - Job Costing

Allow Cost Centre and Component for JC Tran to be edited from the Job Invoicing form and write back to the JCTran.

Add disbursement from AP or CB transaction now sets the JC batch line description to the expense/analysis code and name from the source AP or CB dissection line.

MB - Max Basic

New MaxBasic functions in the Environment group. GetLicencesCount returns the number of user licences, and GetLicencesAvailable([LicenseGroup]) returns the number of licences currently available for the group, where LicenseGroup is optional and defaults to "WIN", licence groups are "WIN" "COM" or "CMD".

New ValidEmailAddress function added to String functions group. Uses the same validation used in email fields in Accredo and returns True or False.

Added new MaxBasic function to the Environment group. ClientName function returns WTSClientName if running in a TS session, MachineName otherwise.

OE - Order Entry

Made more fields available to the Results grids in IN and OE Processes.

PO - Purchase Orders

Add Reprice Results form to Reprice Purchase Orders.

Show default Job Code on PO Header and AP Shipment Receipt tabs.

RD - Report Designers

BankAccount object added to Document and Email designers. If CB is present this returns the default Bank Account for the Customer or Creditor. The default Bank Account comes from the Customer or Creditor Group if specified, falling back to the CB Default Bank Account in CB Settings. This can be used for example to include the correct bank account details for electronic payments on the Statement or Invoice document,

 

Bug Fix

ALL - All Modules

Fix emailing from Screen Preivew not loading correct font and signature for email.

CO - Company

Fix exception under COM "Cannot focus a disabled or invisible window" when Navigator preferences is set to Docked.

DI - Data Interchange

Fix exception under COM "Cannot focus a disabled or invisible window" when Navigator preferences is set to Docked.

GL - General Ledger

Fixed GL Account Tree not displaying balances.

Fix GL PeriodBudget and YearBudget functions not handling missing Budget parameter as implying Default budget code in Financial Reports.

IC - Inventory Control

Fix missing Report filter for IC Stocktake Status layout in Mercury, and make the Report filter Sortable in Saturn and Mercury.

Fix scripting for Import Count.

Fix incorrect error about missing Base UOM when UOM is required and BaseUOM has not been loaded.

IN - Invoicing System

Settings and selection for Repricing Weight and Volume combined into a single selection since they are always triggerred in tandem.

JC - Job Costing

Fix introduced "Unable to set the number property of the range class" error printing to Excel.

Fix discount not being picked up from Estimate for Invoice as Quoted on the Job Invoicing form.

MB - Max Basic

Expose Export method on CBBankingSummaryForm and CBBankingSummaryData.

OE - Order Entry

Settings and selection for Repricing Weight and Volume combined into a single selection since they are always triggerred in tandem.

PO - Purchase Orders

Settings and selection for Repricing Weight and Volume combined into a single selection since they are always triggerred in tandem.

TD - Table Designer

Fix "Exception: Invalid Class Typecast" error when running File Recovery on Custom Tables which include fields using ID domains.

XX - OLEDB/ODBC

The string fields from a Query in OLEDB that are empty or null will now return as an empty string as they did in 3.6.

 

Accredo 4 – Version 4.0.10.103

Improvement

ALL - All Modules

Added Option DisableAutoApply statement to MaxBasic to allow the SQL ListForms (e.g. INInvoiceListForm) to be opened without AutoApply firing so that selections may be made in an on open script without executing the query for each change made, then Select called after all changes have been made. Default is False.

AP - Accounts Payable

CB Electronic Banking Designer, AP Electronic Banking Designer and GL Accountants Export Designer remodelled as a tabbed form.

CB - Cash Book

CB Electronic Banking Designer, AP Electronic Banking Designer and GL Accountants Export Designer remodelled as a tabbed form.

GL - General Ledger

CB Electronic Banking Designer, AP Electronic Banking Designer and GL Accountants Export Designer remodelled as a tabbed form.

IC - Inventory Control

Add Stocktake button to IC Count Form.

SQL - SQL

Added Option DisableAutoApply statement to MaxBasic to allow the SQL ListForms (e.g. INInvoiceListForm) to be opened without AutoApply firing so that selections may be made in an on open script without executing the query for each change made, then Select called after all changes have been made. Default is False.

 

Bug Fix

AP - Accounts Payable

Fix Access Violation error in Mercury on Update Costs from AP Shipment.

DI - Data Interchange

Make Index properties and methods available to ICUnitsOfMeasureData object.

Fixed introduced Exception loading into Import Designers.

 

Accredo 4 – Version 4.0.10.102

Improvement

ALL - All Modules

Add Preview to the Email Designers .

Ensure Auto Select settings are respected on Open for Memo, Link and Document lists.

AP - Accounts Payable

Custom fields added to APTran are now available to and editable from the AP Approve for Payment grid

Script enable DeleteNilLines in AP Shipment.

Data conversion copies AP Creditor Other Party Code to AP Creditor Bank Particualrs.

Fall back code to assign the Customer / Creditor code as the BankParticulars for a Banking Item if it is otherwise blank.

Include Customer / Creditor name and Contact Name in Batch Email Exports, fields are ignored during import.

AR - Accounts Receivable

Packing Slip No can be customised into AR Allocation grids.

Made Credit Limit available for edit from AR Receipt transaction entry subject to permission.

Fall back code to assign the Customer / Creditor code as the BankParticulars for a Banking Item if it is otherwise blank.

Include Customer / Creditor name and Contact Name in Batch Email Exports, fields are ignored during import.

CB - Cash Book

Added Duplicate for CB Sourced banking items. If Bank Account No has been entered duplicate is subject to Bank Account No permission.

Added Module Selection to CB Banking Items list.

Add OpenForm methods to the CBBankingItemsData and CBBankingSummaryData objects

Add Find button to CB Banking Item List to Find by Item ID.

CO - Company

Navigator > Setup > Company > Configuration > Settings > General tab. Forced exit interval (minutes) allows you to specify the length of the count down to a forced exit. Default is 5 minutes.

Extend User report layout to make bands for Settings, Preferences, Permissions and Members (of Group or Role) available. Report is available per user from the Users, Groups and Roles form, and as a layout under Reports > Company > User Reports.

Blank Navigator tabs are not displayed if all permissions for a tab are set to none.

FD - Form Designer

Added Component Menu to FD.

TabSheet component - Added property ShowSingleTab. Default value False. To make an FD page control with a single tab behave as it did in 3.6 set ShowSingleTab to True

GL - General Ledger

GL Trial Balance layouts extended with more fields available to allow Opening / Credit Activity / Debit Activity / Closing style reporting for Period and Year.

Add Print button tor GL Account Tree > Report layout tab.

Retain headers for deleted children of unposted GL batches.

IC - Inventory Control

Make IC EOP check and warn about more unposted transactions up to period - Shipment receipts, JC Batches, Stock Transfers.

Changed Products Per Count in IC Stocktake generation and settings to Number of Counts. For Additive Counts this is number of count documents generated with each count including all Products for the stocktake, and for Single Counts the products for the stocktake are divided between the number of counts specified.

IN - Invoicing System

Packing Slip No can be customised into AR Allocation grids.

Add Job object to Invoice and Purchase Order Email Editors - gives access to Default Job for document if specified.

MB - Max Basic

Add transient SourceTransactionID to Transaction data and form objects to provide access to ID of Transaction which was duplicated.

Script events form is now edit/save style with a grid.

Add /X [minutes] command line parameter to support forced exit when running a command line script. Parameter allows setting forced exit after a specified amount of time, with capture of a stack trace into the diag.log if forced exit is triggered.

Script enable DeleteNilLines in AP Shipment.

Added second optional StartDate parameter to WeekNo function. If specified week nos are counted from start date, defaults to 1/1 if not specified.

Add transient SourceBatchID to Batch data and form objects to provide access to ID of Batch which was duplicated.

PO - Purchase Orders

Added Print as Copy selection to PO Print Purchase order. Standard documents updated. Custom PO Orders will need modifying to test the CopyOrder function and add "COPY ONLY" to the Document name.

RE - Report Engine

Column headers selection added for Reports layouts and Analysis reports output to Diskfile in delimited formats. A Report preferences for the default for Column Headers has been added to Navigator > Setup > Company > Reporting > Report Preferences.

TD - Table Designer

Prevent unique custom indexes from being added to Accredo tables, and remove uniqueness during data conversion.

Custom fields added to APTran are now available to and editable from the AP Approve for Payment grid

 

Bug Fix

AP - Accounts Payable

Fix Bank Charges from AP Payment / AR Receipt bank through not passed through to CB transaction.

CB - Cash Book

Fix Apply Rule for Transfer on Bank Reconciliation locking up.

Fix Bank Charges from AP Payment / AR Receipt bank through not passed through to CB transaction.

CO - Company

Fix MDI child window scaling with Medium or Large fonts selected in Windows Display options.

FD - Form Designer

Fixed FD Window State property tracking during runtime.

GL - General Ledger

Fix sub ledger permission being checked when GL Up-to-date check is performed for reporting.

TD - Table Designer

Conversion from 3.6 Mercury to V4 loses Domains for Custom Fields, Saturn is not affected. Now fixed.

XConv - Mercury2Saturn

Mercury2Saturn and Saturn2Mercury converters updated for V4 file changes.

XConv - Saturn2Mercury

Mercury2Saturn and Saturn2Mercury converters updated for V4 file changes.

 

Accredo 4 – Version 4.0.10.101

New Feature

ALL - All Modules

Changed model for transfer to GL. Relax constraint on transfer up to period, continue to remember and default to the high water mark in the sub ledgers, current period GL in GL.

Filter criteria for lookup fields, periods and contacts can be selected from a lookup. No change to existing behaviour for filters - multiple criteria, wild characters and field names can all be used as usual.

Vertical form toolbars added to most forms. Advanced menus on forms are expended into the new form toolbars. Script shortcuts can be linked to the form toolbar for a specific form. When the shortcut is triggered the form is set as the trigger object for the script.

Add default email template selection to document defaults, and email template selection to one off printing for Invoices and Remittances.

Drop down list for Enum selections in Filters.

Add Record Revision field to relevant Accredo tables. Record Revision is incremented each time a record is changed. Record Revision field may also be added to Custom Tables and the database engine will maintain it.

AP - Accounts Payable

Added Email Lookup, similar to the Phone Lookup, to allow easy locating of a Customer, Creditor, Contact etc. via the email address.

Email buttons for Customers, Creditors and Contacts offer a menu with a choice of Create mail message / Add to Batch Email.

Electronic Payments and Direct Debits from Cashbook Banking Summaries. Improved AP Generate Payments work flow.

AR - Accounts Receivable

Added Email Lookup, similar to the Phone Lookup, to allow easy locating of a Customer, Creditor, Contact etc. via the email address.

Email buttons for Customers, Creditors and Contacts offer a menu with a choice of Create mail message / Add to Batch Email.

Electronic Payments and Direct Debits from Cashbook Banking Summaries. Improved AP Generate Payments work flow.

CB - Cash Book

CB rules for Statement importing / inserting to match.

Electronic Payments and Direct Debits from Cashbook Banking Summaries. Improved AP Generate Payments work flow.

Added Max Basic string functions DropChars(String1: String, String2: String): String Removes all occurrences of each character in String2 from String1 KeepChars((String1: String, String2: String): String Removes all occurrences of any character not contained in String2 from String1

CO - Company

Users, Groups and Roles form replaces Users and Permissions, User Settings and User Preferences forms. User may have many Roles, Roles are considered for Script shortcuts, Report layouts and Analysis Reports. Only Users and Groups may have Permissions and Customisations.

ACCREDO > View > Preferences > Display tab preference for Navigator added. Docked window, Normal Window or Floating Window.

FD - Form Designer

FormNavigator component added to FD.

GL - General Ledger

GL Budgets separated into Opening and Activity figures to allow Balance sheets, Opening, Closing and Post To account budgeting to work better. For Current and prior years Period 1 opening for budget is the same as the actual opening, for future years Period 1 openings may be entered. Year end rollover updates budget openings for new current year. Data conversion derives activity figures, but reviewing budgets for Balance sheet / Opening / Closing and Post to accounts is recommended.

Changed GL Batch Export and Import to include CurrencyCode and BatchClass in the export format. Export format now creates one line for the header record, new format is: {Signature (A40)},{BatchClass},{Details},{SourceModule},{PeriodID},{CurrencyCode} The import can still read files with old signatures, eg MGB81. If a file is imported that has a different currency code than the base currency code of the company it's being imported into, then an exchange rate required dialog is shown. The transaction amounts are converted to base, using the exchange rates (IE or ALC) in the same way as GL subledger import.

IC - Inventory Control

Units of Measure.

Minimum Order quantity for Product per Supplier added to ICCost and used in PO for order generation.

IC Product track Revaluation PTD and YTD and make available to Product report layout.

Stocktaking completely remodelled. Stocktakes as documents Counts as batches within a stocktake - may be many batches per Stocktake. Two types of Count: Single - one count per product (and location) per stock take, equivalent to the way this is done in 3.6 Additive - many counts per product (and location) per stocktake, allows UOM support and scanners etc. Stocktake is for a Period (within Available periods IC) / location / date (implied as end date for period). Limit of one current (i.e. unposted) stocktake per product / location / period. Many batches of counts may be entered for a given stocktake allowing multiple users to enter counts. Counts are summarised to update / create stocktake lines which also record the Instock Quantity which the count is to be compared with, calculate variances and create ICPends.

IN - Invoicing System

Make IN\Invoices\Cash Sales permission independant of the IN\Tasks\Posting permission. During conversion for existing users if IN\Tasks\Posting permission is None then IN\Invoices\Cash Sales permission is set to None, to preserve the status quo for existing sites.

Electronic Payments and Direct Debits from Cashbook Banking Summaries. Improved AP Generate Payments work flow.

JC - Job Costing

Add Sell Discount Percent on JCTran and Proxies to align with IN Line and allow explicit discounting in JC.

Reprice Job Estimates option added to Tasks tab to allow batch repricing of estimates.

MB - Max Basic

BeforeClose events added to all live edit grid forms (Categories, Groups etc). Event fires before the form is closes and an Abort or Error in the triggered script will prevent the form closing.

Added Max Basic string functions DropChars(String1: String, String2: String): String Removes all occurrences of each character in String2 from String1 KeepChars((String1: String, String2: String): String Removes all occurrences of any character not contained in String2 from String1

OE - Order Entry

Electronic Payments and Direct Debits from Cashbook Banking Summaries. Improved AP Generate Payments work flow.

PO - Purchase Orders

Minimum Order quantity for Product per Supplier added to ICCost and used in PO for order generation.

SP - Special Pricing

If UOM is Active (or Pending) and Quantity Breaks are selected from Special Pricing then UOM Code and UOM quantities may be specified in the breaks for a Special Pricing rule. Either all breaks for a rule must contain a UOM Code or no breaks for a rule may contain a UOM code. Breaks with a UOM code only apply when that UOM Code is entered in the context for the special price, and changing UOM code will refire the pricing decision.

XX - PDB8

Add Record Revision field to relevant Accredo tables. Record Revision is incremented each time a record is changed. Record Revision field may also be added to Custom Tables and the database engine will maintain it.

 

Improvement

ALL - All Modules

Make ApplicationSetting functions case insensitive for the Setting parameter.

Insert button added to Masterfile Transaction grids.

Navigator > Setup > Company > Configuration > Display. Form Background colour added to Company Display preferences . Allows companies to be differentiated by colour at a glance. Display settings may be deployed as Company Settings optionally overridden at the workstation level subject to permissions. Background colour and an Image may both be specified and Image positioned in any corner of main application window.

Add Inactive fields, indexes and behaviour to JC Cost Centre and Component Codes, IN Shipper Codes, CB Automatic Payments, CO Media Codes, FA Asset Locations, PO Authorisation Codes.

Added Inactive field, indexes and behaviour to Categories.

Customising data panels, such as the primary contact panel on the Customer tab of customer maintenance, now allows Label Width and Row properties to be specified for better formatting.

All changes subject to the version of Windows you have having the new fonts available, Windows Vista and later will have them. This brings us in line with current generation Windows and Office default fonts. Window font to changed to SegoeUI. Report default fonts changed to Calibri and Cambria Report designers use Report data setting for default font. FD components use SegoeUI. Update sample documents to use Calibri instead of Arial

Added Backup Taken confirmation to critical processes.

Improved sorting of fields when customising reports, grouped fields are sorted to the top in descending grouping order.

Report permissions extended. Separated the permissions for Add / Delete / Customising layouts in each module from the permission for running reports. Permission which controls Customisation for layouts also control the right click menu for layouts for the module. Make all the Report > Access permissions four levels interpreted as follows: None - Reports not available Read - Access only to reports where user is specified in the User List and Form/Grid/Standard reports Write - Reports available unless there is a User list, in that case restricted to User List (current control behaviour) Control - All reports available regardless of User List Data conversion maps permissions for users to the new [Module] > Reports > Layouts permission and the extended [Module] > Reports > Access permissions. Changes also apply to Analysis reports, Custom Reports and Financial Reports.

Inserting a reminder now defaults Memo Date and Time to Current Date & Time + Reminder Interval, rounded to next nearest hour/half hour.

Tabbed forms stack tabs rather than having a scroller when tabs do not fit current form size.

Added Change Memo Target User option to Utilities, and prompt for change of target user when a User Code is deleted or inactivated. Note that it is not required that Target User is changed - Accredo does not perform a check - it relies on the answer to the prompt.

Add IsBatch:Boolean function available in all email designers to return True when Template fires from a batch process.

Menu button (Alt+F9) on form toolbars gives access to all toolbar options.

Custom1 and Custom2 fields may have customised Display labels. Category tabs in Settings forms renamed to Display Labels and now contain a grid with Categories and Custom1 and 2 fields.

Tab characters are accepted in narrative editors and memo bodies. Ctrl+Tab moves out of the narrative block.

Tab characters in string controls display as »

Email Designers added for all Documents, these allow you to design template emails which can then be selected in Document Defaults.

Refresh field button added to Customise grids / lookups / report layouts. Refreshes Display label and Display Width for current field.

AP - Accounts Payable

Word Lookups added for Bank Accounts, Analysis Codes and Branch / Department / Location in Saturn.

Saturn only added Branch Code a Location code to AP Creditors. These behave in the same way as the equivalent fields on AR Customer - they are optional, and if set they override the users Branch and Location codes as the defaults for Documents and Transactions.

AP Shipment Settings updated: Update Cost Prices for Non diminishing Products - setting removed, since receipts are now posted for non-diminishing items costs are updated. Update IC/JC Cost Prices from Shipments - setting removed, costs in IC and JC are always updated.

Email Address domain increased from 60 to 120 characters.

A default reference per Payment Methods can be set in Navigator > Setup > Accounts Payable > Settings > Payments tab for Payment methods other than Computer Printed Cheque, Remittance and Manual Cheque which are assumed to require a cheque number. The default reference will be automatically applied when payments are inserted or generated and may be overridden.

JC Disbursement Batches now link to source AP or CB transaction with drill down. Check for duplicate occurs when Disbursements instered from AP or CB transaction.

Store default JC Transaction Type for Invoices, Purchase Orders, Shipments.

Other Party added to CB Transaction and CB Statement Line. Bank Payee extended to 40 characters for AP Creditor and AR Customer, note that actual length in banking files depends on banks file format.

UnallocatedAmount / UnallocatedAmountBs and FullyAllocated fields are available to customise into to the IN Invoice List / AP Shipment list. Information is looked up from the AR Transaction which was posted from the document.

Change Their Code label to Other Party Code in AR and AP for consistency with field name.

Add Customer / Creditor filters to AR and AP Aged Balances layouts and Aged Transaction layouts.

Add explicit permission or AP Cost Codes.

Exclude email Customers / Creditors settings in AR / AP / IN settings now defaults to selected for new companies.

JC Disbursement Code setting in AP and CB replaced by JC Disbursement boolean on AP Expense Codes and CB Analysis Codes. Data conversion sets JC Disbursement true for the Code specified in the settings in 3.6 (if any).

Added default settings for IN/OE and AP/PO Reprice. Note that these defaults relate to the UI only, not to scripting. For the scripted methods if no parameters are specified then all are treated as true, if any parameters are specified then any which are not are treated as false.

Warn if Invoice reference for Additional cost on Shipment has already been used.

Added Generate Payments button to Approve for Payment form. Selections are passed through to the Generate Payments dialog where valid.

AP Transaction Form for Invoices / Credits Approval amount and discount are shown and may be entered if user has Approval permission. Approve for Payment (Shift+F4) button added to the form toolbar will select the Transaction Amount less any Hold Amount, and Transaction Discount as the Approved values.

GST Inclusive vs GST Exclusive analysis for dissections is now inferred from the column you enter the amount into. Analysis mode buttons and settings are removed.

Analysis mode on AP Shipments is replaced by a simpler CostMode which determines the behaviour when the Quantity is changed. Divide - Extended Cost is divided by quantity to obtain unit cost Multiply - unit cost is multiplied by quantity to obtain extended cost. AP and Supplier setting Shipment Cost Mode replaces Analysis Mode.

Fourth pricing mode added for JC: Markup and Discount. Markup percentage is taken from the product based on the job's Price code and Discount% is taken from the Discount Schedule for the Job and Product Discount codes which in turn will reduce the Markup i.e. the same result you would get if you keyed Markup % then Discount Percent. When cost prices change the Markup and discount are preserved, and the Sell Price is re-calculated. Discount is always explicit.

Added JC Fully Invoiced field to PO Order and AP Shipment lines.

Allow Opening Values Addition to assets with transactions.

AP Creditor Banking / Physical Tab added Bank Particulars Code and Bank Reference for Payments.

Add Asset from AP or CB Transaction now checks for and warns about duplicates.

Improve Average Cost calculation by resetting to latest cost if the Average wanders beyond "reasonable" levels due to negative transactions. Calculation for averages is mathmatically “correct” but mathmatically things get weird when you have negative transactions at low stock levels. Calculation now identifies the valid range of costs over the quantity currently held and resets Average cost to Latest cost if it wanders outside that.

AP Shipment and PO Order for Jobs - default Branch / Department / Location from the Job. Inserting a Purchase Order or Shipment from the Job Pending Costs grid now defaults Branch / Department / Location from the Job - i.e. overriding User defaults if any. Selecting a Creditor on a Purchase Order or Shipment sets BranchCode and LocationCode from Creditor (if any) if DefaultJobCode is empty. Selecting a Default Job Code on a Purchase Order or Shipment updates the Branch / Department / Location in the Header from the Job and hints about the changes.

GL Account Name, Branch Name (Saturn) and Department Name (Saturn) are available to customise into all dissection grids.

Added boolean GLAccountOverridden field to Dissection Lines to allow easier reporting and better behaviour on Duplicate / Duplicate Contra.

Drill up buttons added to IN Invoice Form and AP Shipment Form. Allow drill up to posted AR or AP transaction.

Replicate changes to integration settings to matching Groups. Add Default GL Accounts buttons to Group grids.

New Address selection added to Customer and Creditor label printing to allow easy selection of Customer Address vs Delivery address, and Creditor Address vs Physical address without needing to select a different label design. AR Customer / AP Label designers Address object has been added to the selected address. To make use of the Address selection label designs will need modifying to pull Address information from the Address object - refer to the updated example labels. MaxBasic function AddressType has been added to the Reports group to return the type of address selected.

Added drop down selection for Customer / Creditor email / Contact email to Batch Email To field and default a selection regardless of where form is opened from. Expression builder is still available for more complex selections.

Make Origination Date available to Dissection band on AP Expense Detail report.

PO Order List, AP Shipment List and IC Transfer Lists are now SQL based to match IN Invoice list and OE Order List.

Save Subject, and Email To, and Attachment expressions with Email templates.

JC Discount selection added to PO Order and AP Shipment repricing.

Improved revaluation

Payment Method for Cash Purchases now defaults from Creditor to allow DD payments to be more easily recorded.

AP Enter Transactions > Payment Payment reference defaults when Creditor / Payment method / Bank Account (if a Cheque Payment Method) is selected. Defaults as follows: For Cheque payment methods (Computer Printed/Remittance/Manual), next cheque no from CB Bank Account - no change to current behaviour. For Other payment methods, Bank Reference from Creditor record if specified, falling back to AP Setting for default reference for Payment method. Payment reference always editable. If Creditor or Payment method changed the reference is reset.

AR - Accounts Receivable

Word Lookups added for Bank Accounts, Analysis Codes and Branch / Department / Location in Saturn.

Email Address domain increased from 60 to 120 characters.

Other Party added to CB Transaction and CB Statement Line. Bank Payee extended to 40 characters for AP Creditor and AR Customer, note that actual length in banking files depends on banks file format.

Change Their Code label to Other Party Code in AR and AP for consistency with field name.

Add Customer / Creditor filters to AR and AP Aged Balances layouts and Aged Transaction layouts.

Exclude email Customers / Creditors settings in AR / AP / IN settings now defaults to selected for new companies.

AR Customer and IC Product maintenance - added an Open Discount Schedule button next to the Discount Code field.

GST Inclusive vs GST Exclusive analysis for dissections is now inferred from the column you enter the amount into. Analysis mode buttons and settings are removed.

AP Creditor Banking / Physical Tab added Bank Particulars Code and Bank Reference for Payments.

GL Account Name, Branch Name (Saturn) and Department Name (Saturn) are available to customise into all dissection grids.

Added boolean GLAccountOverridden field to Dissection Lines to allow easier reporting and better behaviour on Duplicate / Duplicate Contra.

Replicate changes to integration settings to matching Groups. Add Default GL Accounts buttons to Group grids.

New Address selection added to Customer and Creditor label printing to allow easy selection of Customer Address vs Delivery address, and Creditor Address vs Physical address without needing to select a different label design. AR Customer / AP Label designers Address object has been added to the selected address. To make use of the Address selection label designs will need modifying to pull Address information from the Address object - refer to the updated example labels. MaxBasic function AddressType has been added to the Reports group to return the type of address selected.

Added drop down selection for Customer / Creditor email / Contact email to Batch Email To field and default a selection regardless of where form is opened from. Expression builder is still available for more complex selections.

Save Subject, and Email To, and Attachment expressions with Email templates.

Improved revaluation

CB - Cash Book

Word Lookups added for Bank Accounts, Analysis Codes and Branch / Department / Location in Saturn.

Add CB Setting for default Banking Media selection for Banking Summary.

JC Disbursement Batches now link to source AP or CB transaction with drill down. Check for duplicate occurs when Disbursements instered from AP or CB transaction.

Other Party added to CB Transaction and CB Statement Line. Bank Payee extended to 40 characters for AP Creditor and AR Customer, note that actual length in banking files depends on banks file format.

Add warning before CB EOP if there are open CB Reconciliations for periods up to Current Period CB.

Improve Reconciliation for Statement report to exclude transactions dated after statement date which are either unreconciled or reconciled on a later statement.

JC Disbursement Code setting in AP and CB replaced by JC Disbursement boolean on AP Expense Codes and CB Analysis Codes. Data conversion sets JC Disbursement true for the Code specified in the settings in 3.6 (if any).

Improve default period selections for CB Bank Statements, CB Banking Summaries, CB Banking Items, GL Transaction Batches and JC Batch List when Posted or All is selected.

GST Inclusive vs GST Exclusive analysis for dissections is now inferred from the column you enter the amount into. Analysis mode buttons and settings are removed.

Allow Opening Values Addition to assets with transactions.

Add Asset from AP or CB Transaction now checks for and warns about duplicates.

Added Match After Import to Bank Account Statement Importing settings.

GL Account Name, Branch Name (Saturn) and Department Name (Saturn) are available to customise into all dissection grids.

Added boolean GLAccountOverridden field to Dissection Lines to allow easier reporting and better behaviour on Duplicate / Duplicate Contra.

Change CB Transaction Type from C(heque) to W(ithdrawal). Form and Data objects for scripting have aliases for backward compatibility, filters on report layouts / report listas and Custom reports or SQL queries will be affected.

Dissections for Banking Items are retained after Banking.

All current AP Electonic banking definitions restructured as CB Electronic banking defintions and installed during the server install in SystemPath>Reports>CBElectronic

Cash flow report layouts use Budget Activity figures from specified GL Budget.

Statement import definitions updated to import Other Party details where available.

Statement reconciliation options condensed. Match (Ctrl+Up) combines reconcile and match with current transaction functionality. Unmatch combines unmatch and unreconcile functionality

Improved revaluation

Improve the algorithm for Automatic statement matching on CB Bank Reconciliations.

Added Comment to CB Banking Items and Banking Lines on Invoice / Sales Order and Receipt.

Insert button on Statement grid now handles Insert transaction and insert IUmatched line.

Payment Method for Cash Purchases now defaults from Creditor to allow DD payments to be more easily recorded.

CO - Company

Word Lookups added for Bank Accounts, Analysis Codes and Branch / Department / Location in Saturn.

Export All option added to Setup > Company > Reporting > Report Layouts.

Email Address domain increased from 60 to 120 characters.

Script Shortcuts now have a User List rather than just for all users or a single user. Data conversion consolidates shortcuts where all properties other than user code are the same into a single shortcut with a User List.

Display preferences added for Calendar, Normal / Floating / Floating always on top to match preferences for calculator.

Added ReplyTo to Batch Emails, note the ReplyTo is not supported by SimpleMAPI.

Add Warning on startup if exe is being run across the network.

Added Reminder list option (Ctrl+F5) to View Menu and Global toolbar. Opens the Reminder list.

Capture Form added to File menu and Global Toolbar, captures the Active Form for output to Email, Printer or File. MaxBasic function FormCapture added to the Environment group to allow triggering this from a script or FD form.

Accredo > Shortcut menu added, provides a menu of the shortcuts on the Global Toolbar.

Navigator > Setup > Company > Configuration > Settings > General tab. Forced exit interval (minutes) allows you to specify the length of the count down to a forced exit. Default is 5 minutes.

Initial focus in Navigator on open is now on the first tab which may be a Custom tab, preveiously always the Maintain tab.

Too many users "Retrying dialog" can be sorted and filtered.

Profax Report Viewer is no longer supported.

Make Excel (.xlsx) the default Excel format in Report Preferences for new companies.

Add Company data path defaults from Company Name when Company Name is entered.

Default fonts for reporting updated to Calibri (from Times New Roman) and Cambria (from Arial) respectively.

HTML Editor, default font is now taken from Report Preferences Data font.

Added View > Preferences > Display tab option for Calendar: Normal Window / Floating Window /Floating Window always on top.

New PeriodName domain added and applied to COPeriod.

Company Display configuration can now be set and apply to all users. If Local Display Settings are allowed then Local Display settings override Company Display settings.

User Report layout added to Company reports.

Toolbar and Status bar preferences moved to View > Preferences > Display tab from View menu.

Accredo > Script menu added, groups all menu options relating to scripting and adds direct links to Script Shortcuts, Script Events and SQL Query Builder. Show Glyph Names on Hints option added - Shows the Glyph Name and Image Index in button hints when your pointer is hovered over a button or menu option. This is useful for identifying a Glyph to use in a custom form.

System Date and User Login moved to View menu from Edit menu.

Document Form option moved from Help menu to new Script menu.

Added Global Memos, System Date, System Period and Logged-in Users buttons to the Global Toolbar.

DI - Data Interchange

Added Line object menu to the Objects dropdown on Line Type tabs in the Import Designer.

FA - Fixed Assets

FA Books - Add Disposal Option Default per book instead of one for all books.

Added Location index to FAAsset, and Location selection to the FA Asset List.

Allow Opening Values Addition to assets with transactions.

Add Asset from AP or CB Transaction now checks for and warns about duplicates.

Replicate changes to integration settings to matching Groups. Add Default GL Accounts buttons to Group grids.

Turning on Integration to GL for IC, JC or FA modules after transactions have been processed, now prompts for "Start integration from Period". GL batches will not be generated for periods prior to the selected period, and all transactions up to the specified period are flagged as transferred.

Add Inactive field and Active index to PO Authorisation codes and FA Asset Location codes. Navigator > Setup > Purchase Orders > Authorisation codes Navigator > Maintain > Fixed Assets > Asset Locations Inactive allowed anytime - just drops the codes from the lookups, up to you to find and change any in use.

FD - Form Designer

Add Alternate Colour property for FD Panels and Navigators.

Graph Components for Form and Report designers, added LabelsAngle property this can be set for example to make labels on the bottom axis vertical by setting LabelsAngle = 90.

Form Designer and Report Designer added to the Accredo > Script menu if the modules are present.

Added Component Menu to FD.

GL - General Ledger

Friendly Code and External Code now available to select in the GL Report Wizard.

Make GL and JC Batch forms tabbed and GLHead / JCHead TD extensible.

IC transfer to GL on a summarised basis breaks out Usages by source so these are flagged as JCUsage (used on a job) / ICUsage (used in a Manufacture) / INUsage (used in a kitset). Note that scripts which post process IC batches transferred to GL will need to be reviewed if Summarised transfer is used.

Improve default period selections for CB Bank Statements, CB Banking Summaries, CB Banking Items, GL Transaction Batches and JC Batch List when Posted or All is selected.

Analysis codes button added to GL Account Maintenance form. List all Analysis Codes from AR / AP and CB that map to the GL account.

Improve IncludeNilBalances code in GLRW to exclude nil balance Inactive accounts.

GL Report Design Wizard now has a Page Orientation selection on the bands tab. Automatic selects based on fitting the columns across the page without the font getting too small.

Turning on Integration to GL for IC, JC or FA modules after transactions have been processed, now prompts for "Start integration from Period". GL batches will not be generated for periods prior to the selected period, and all transactions up to the specified period are flagged as transferred.

GL Budget Copy updated and option to copy from Actuals added.

Check GL is up-to-date to period when printing Trial Balances / Financial Reports. Checks for untransferred transactions in subledgers and unposted batches in GL.

Added check for untransferred / unposted batches before EOP in GL.

New BudgetOpening and BudgetActvity GL functions added.

Budget Report and Budget Detail Report layouts updated for changes to GL Budgets.

Removed cached budget figures for Default budget from GLBal table.

Improved revaluation

GL Budget layouts now report for any span of periods within a financial year.

GST - GST

Add warning when accepting Payments Basis GST return if there are unreported Receipts or Payments.

Add FX totals to GST Code Detailed report summary. If report is across more than one currency FX totals will be empty.

GST Transactions entry form now explicitly shows the effect of the Transaction on the Return / BAS form.

IC - Inventory Control

Source IC and IN Usage transactions now record their parent transaction ID. For IC Manufacture transactions this means when opened from the transaction tab the Manufacture and associated usages are displayed in the Manufacture form.

Generate Receipt transactions for Non-diminishing Products.

IC Pending Stock Movement records are now created for non-diminishing products.

Added "Default Other UOM" (Ctrl+D) button to Other UOM grid navigator. Added Product level Method DefaultOtherUOM to Form and Data objects.

IC transfer to GL on a summarised basis breaks out Usages by source so these are flagged as JCUsage (used on a job) / ICUsage (used in a Manufacture) / INUsage (used in a kitset). Note that scripts which post process IC batches transferred to GL will need to be reviewed if Summarised transfer is used.

AR Customer and IC Product maintenance - added an Open Discount Schedule button next to the Discount Code field.

Manually Costed is not allowed for IC Manual Kitsets since cost are derived from components on Post of Invoice.

Double click or open details for a manufacture Usage transaction will open the Manufacture form and focus on the product in the parts list.

Improve Average Cost calculation by resetting to latest cost if the Average wanders beyond "reasonable" levels due to negative transactions. Calculation for averages is mathmatically “correct” but mathmatically things get weird when you have negative transactions at low stock levels. Calculation now identifies the valid range of costs over the quantity currently held and resets Average cost to Latest cost if it wanders outside that.

Added Supplier Standard Cost Date to Supplier Costs. This is set during PriceBook Importing or Supplier Cost update if the Supplier Standard Cost is updated, or may be edited manually.

Enforce Maximum Quantity must be >= Minimum Quantity. Any existing violations are fixed during Data Conversion.

Replicate changes to integration settings to matching Groups. Add Default GL Accounts buttons to Group grids.

PO Order List, AP Shipment List and IC Transfer Lists are now SQL based to match IN Invoice list and OE Order List.

Turning on Integration to GL for IC, JC or FA modules after transactions have been processed, now prompts for "Start integration from Period". GL batches will not be generated for periods prior to the selected period, and all transactions up to the specified period are flagged as transferred.

UOM iterator and Object added to IC Product sheet designer.

Improved revaluation

Change Revalue Stock to just calculate new Revaluation Values and mark as needing transfer. Change IC Transfer to GL to also transfer outstanding revaluations.

Product Labels updated for UOM. UOM code added to Product Batch Labels grid and passed through with UOM Quantity from Print Product labels options on documents.

IN - Invoicing System

Optionally hide Job Defaults panel for Invoicing with new JC Setting. Job Code appears on the Invoice Header tab.

Allow Print as Packing Slip for Credits and update sample Documents to call these "CREDIT RETURN SLIPS".

Store default JC Transaction Type for Invoices, Purchase Orders, Shipments.

InvoiceBackOrder iterator added to IN Invoice designer and BackOrder iterator renamed to CustomerBackOrder. The InvoiceBackOrder iterator iterates back orders relating to the same Order(s) as the invoice lines and excludes other backorders for the customer.

UnallocatedAmount / UnallocatedAmountBs and FullyAllocated fields are available to customise into to the IN Invoice List / AP Shipment list. Information is looked up from the AR Transaction which was posted from the document.

Make the following Invoice header fields update from Default Job Code consistently Sales Person Code, Price Code, Discount Code, Contact, Email Contact and Branch, Department Default Location code in Saturn. I.e. Job values override Customer values in all cases.

Added default settings for IN/OE and AP/PO Reprice. Note that these defaults relate to the UI only, not to scripting. For the scripted methods if no parameters are specified then all are treated as true, if any parameters are specified then any which are not are treated as false.

Drill up buttons added to IN Invoice Form and AP Shipment Form. Allow drill up to posted AR or AP transaction.

JA - Job Analysis

Added User List tab to Analysis Designers to allow restriction of users who can access a specific analysis report.

2.7 Analysis options are no longer available. Command line switch has been removed.

JC - Job Costing

Added Branch and Department codes to JC Estimate in Saturn.

Optionally hide Job Defaults panel for Invoicing with new JC Setting. Job Code appears on the Invoice Header tab.

Extend the Reprice option on JC Job Estimates and JC Batches to take a set of optional parameters in line with the Reprice options in IN / OE and PO.

JC Disbursement Batches now link to source AP or CB transaction with drill down. Check for duplicate occurs when Disbursements instered from AP or CB transaction.

Make GL and JC Batch forms tabbed and GLHead / JCHead TD extensible.

Optional Control total added to JC Batches with Balance batch button. For JC Disbursement batches inserted from AP or CB Transactions the Control total is populated automatically.

SalesGroupCode added to JC Estimates.

Make the following Invoice header fields update from Default Job Code consistently Sales Person Code, Price Code, Discount Code, Contact, Email Contact and Branch, Department Default Location code in Saturn. I.e. Job values override Customer values in all cases.

JC Disbursement Code setting in AP and CB replaced by JC Disbursement boolean on AP Expense Codes and CB Analysis Codes. Data conversion sets JC Disbursement true for the Code specified in the settings in 3.6 (if any).

Improve default period selections for CB Bank Statements, CB Banking Summaries, CB Banking Items, GL Transaction Batches and JC Batch List when Posted or All is selected.

Fourth pricing mode added for JC: Markup and Discount. Markup percentage is taken from the product based on the job's Price code and Discount% is taken from the Discount Schedule for the Job and Product Discount codes which in turn will reduce the Markup i.e. the same result you would get if you keyed Markup % then Discount Percent. When cost prices change the Markup and discount are preserved, and the Sell Price is re-calculated. Discount is always explicit.

Added JC Fully Invoiced field to PO Order and AP Shipment lines.

Job Information tab added to JC Jobs. Same structure and behaviour as the Job Description, but for internal rather than customer facing use. Assumption is Description will be used for information to show on Quotes / Invoices.

Make more information available for JC Pending Costs grid: Comment, Details, Reference, Creditor Name.

AP Shipment and PO Order for Jobs - default Branch / Department / Location from the Job. Inserting a Purchase Order or Shipment from the Job Pending Costs grid now defaults Branch / Department / Location from the Job - i.e. overriding User defaults if any. Selecting a Creditor on a Purchase Order or Shipment sets BranchCode and LocationCode from Creditor (if any) if DefaultJobCode is empty. Selecting a Default Job Code on a Purchase Order or Shipment updates the Branch / Department / Location in the Header from the Job and hints about the changes.

Replicate changes to integration settings to matching Groups. Add Default GL Accounts buttons to Group grids.

Job Access permissions tweaked to allow Insert and Edit with Write permission. Previously Insert required Control permission.

Added JC Setting to copy Job Information to Invoices, default False.

Do not prompt for type on batch on JC Timesheet and JC Disbursement batches, and remove Timesheet and Disbursement options for JC Transaction Batch.

Turning on Integration to GL for IC, JC or FA modules after transactions have been processed, now prompts for "Start integration from Period". GL batches will not be generated for periods prior to the selected period, and all transactions up to the specified period are flagged as transferred.

Display label renaming for JC Cost Centre and Component Codes in JC Settings.

JC Discount selection added to PO Order and AP Shipment repricing.

UOM Code added to JC Batch Headers, enabled once a Product Code is specified and if specified overrides the base UOM Code for the product as batch lines are added.

MB - Max Basic

CTRL+F1 shortcut added for Document Form (ACCREDO > Script > Document Form)

New MaxBasic Period function added: PeriodDifference(PeriodFrom: Number; PeriodTo: Number; [IncludeAdjustment: Boolean = False]) The third parameter is optional, defaulting to False. Calculates the difference (number of periods) between two periods.

Added WeekNo function with the following params WeekNo(aDate: Date): Number n.b 1st of January is considered to be Week 1.

New MaxBasic string function: CopytoClipboard(aVariable) Copies the variable to the Windows clipboard. Note, only string, number, date and Boolean data types are supported.

UserSetting function added to the Environment group. Returns the User Setting value for current user or specified user, User Setting strings are documented in the Help. UserSetting(UserSettingName: String [UserCode: String]): Variant

Script events form is now edit/save style with a grid.

Add /X [minutes] command line parameter to support forced exit when running a command line script. Parameter allows setting forced exit after a specified amount of time, with capture of a stack trace into the diag.log if forced exit is triggered.

Capture Form added to File menu and Global Toolbar, captures the Active Form for output to Email, Printer or File. MaxBasic function FormCapture added to the Environment group to allow triggering this from a script or FD form.

Make FilterSort.Edit in Report layout code reliably pause for filter input.

Added new MaxBasic number function: FormatQuantity(Number,String,Boolean) Number is the Quantity String is an optional UOMCode Boolean is BlankZero, default True If String empty or not supplied format to Quantity decimals else to UOMDecimals.

Update SPEnquiryData object for UOM changes. Setting Product Code will default the UOM Code to base which will default the UOM Multiplier to 1 Setting UOM Code will validate UOM Code and default UOM Multiplier Setting UOM Quantity will calculate to Quantity Setting Quantity will validate Multiplier is 1 before allowing and then set UOMQuantity = Quantity

Accredo > Script menu added, groups all menu options relating to scripting and adds direct links to Script Shortcuts, Script Events and SQL Query Builder. Show Glyph Names on Hints option added - Shows the Glyph Name and Image Index in button hints when your pointer is hovered over a button or menu option. This is useful for identifying a Glyph to use in a custom form.

OE - Order Entry

InvoiceBackOrder iterator added to IN Invoice designer and BackOrder iterator renamed to CustomerBackOrder. The InvoiceBackOrder iterator iterates back orders relating to the same Order(s) as the invoice lines and excludes other backorders for the customer.

Added default settings for IN/OE and AP/PO Reprice. Note that these defaults relate to the UI only, not to scripting. For the scripted methods if no parameters are specified then all are treated as true, if any parameters are specified then any which are not are treated as false.

PA - Purchase Analysis

Added User List tab to Analysis Designers to allow restriction of users who can access a specific analysis report.

2.7 Analysis options are no longer available. Command line switch has been removed.

PO - Purchase Orders

Saturn only added Branch Code a Location code to AP Creditors. These behave in the same way as the equivalent fields on AR Customer - they are optional, and if set they override the users Branch and Location codes as the defaults for Documents and Transactions.

Store default JC Transaction Type for Invoices, Purchase Orders, Shipments.

PO Authorisation Codes Grid added filter/sort and print buttons.

PO Stock On Order report, added ICProd.BarCode as an available field for the Stock On Order band. Not visible by default.

Added default settings for IN/OE and AP/PO Reprice. Note that these defaults relate to the UI only, not to scripting. For the scripted methods if no parameters are specified then all are treated as true, if any parameters are specified then any which are not are treated as false.

Fourth pricing mode added for JC: Markup and Discount. Markup percentage is taken from the product based on the job's Price code and Discount% is taken from the Discount Schedule for the Job and Product Discount codes which in turn will reduce the Markup i.e. the same result you would get if you keyed Markup % then Discount Percent. When cost prices change the Markup and discount are preserved, and the Sell Price is re-calculated. Discount is always explicit.

Added JC Fully Invoiced field to PO Order and AP Shipment lines.

AP Shipment and PO Order for Jobs - default Branch / Department / Location from the Job. Inserting a Purchase Order or Shipment from the Job Pending Costs grid now defaults Branch / Department / Location from the Job - i.e. overriding User defaults if any. Selecting a Creditor on a Purchase Order or Shipment sets BranchCode and LocationCode from Creditor (if any) if DefaultJobCode is empty. Selecting a Default Job Code on a Purchase Order or Shipment updates the Branch / Department / Location in the Header from the Job and hints about the changes.

PO Order List, AP Shipment List and IC Transfer Lists are now SQL based to match IN Invoice list and OE Order List.

Add Inactive field and Active index to PO Authorisation codes and FA Asset Location codes. Navigator > Setup > Purchase Orders > Authorisation codes Navigator > Maintain > Fixed Assets > Asset Locations Inactive allowed anytime - just drops the codes from the lookups, up to you to find and change any in use.

JC Discount selection added to PO Order and AP Shipment repricing.

RD - Report Designers

Report designers now display the (Code) text of methods that actually contain code in Bold.

Graph Components for Form and Report designers, added LabelsAngle property this can be set for example to make labels on the bottom axis vertical by setting LabelsAngle = 90.

Improve shrink to fit algorithm for Report Wizard / GL Report Wizard.

Form Designer and Report Designer added to the Accredo > Script menu if the modules are present.

Report designers now use Calibri as the base font if available.

New BudgetOpening and BudgetActvity GL functions added.

UnitName property added to DocumentLines objects in designers. UnitName returns the UnitName for the UOMCode on the line or the Unit from the line if no UOMCode is present.

Product Labels updated for UOM. UOM code added to Product Batch Labels grid and passed through with UOM Quantity from Print Product labels options on documents.

UOM Object and UOM Iterator added to IC Product Sheet designer to allow printing UOM detail for a product.

RE - Report Engine

Start new page on main group break for report layouts now also starts a new worksheet when printing to Excel.

Validate Grouping levels on Report layouts - must start at 1 and if there are multiple levels must be consecutively numbered.

Navigator > Setup > Company > Reporting > Report Preferences New default settings: New Excel Workbook sets the default state for Print dialogs to match. Note that if you change this you will need to review report lists and scripts that print to Excel to ensure the property is explicitly set as desired. Double Spacing sets the default for new report added from layouts and analysis reports. Shade Alternate Rows sets the default for new report added from layouts and analysis reports. ACCREDO > View > Preferences > Display tab Add a new Workstation preference: Report row shade (%) Report Preferences Tab in Customise Layout and Report Preferences tab in Analysis designers Double Spacing, if selected the detail level of the report is double spaced. Shade Alternate Rows, if selected alternate rows at the detail level of the report are shaded.

Make FilterSort.Edit in Report layout code reliably pause for filter input.

Profax Report Viewer is no longer supported.

SA - Sales Analysis

Added User List tab to Analysis Designers to allow restriction of users who can access a specific analysis report.

2.7 Analysis options are no longer available. Command line switch has been removed.

SP - Special Pricing

Show Effective Sell and Margin % on SP Price Query results.

Update SPEnquiryData object for UOM changes. Setting Product Code will default the UOM Code to base which will default the UOM Multiplier to 1 Setting UOM Code will validate UOM Code and default UOM Multiplier Setting UOM Quantity will calculate to Quantity Setting Quantity will validate Multiplier is 1 before allowing and then set UOMQuantity = Quantity

SP Price Query updated for UOM. Prices returned if UOM is Active or Pending are prices for the UOM Code specified.

SQL - SQL

Remove automatic rewrite support for SQL Queries in Custom Reports designed in report version 35 or earlier (prior to the Accredo SQL engine). Load and save custom reports in the 3.6 Report designer to rewrite queries if necessary.

TD - Table Designer

Prevent unique custom indexes from being added to Accredo tables, and remove uniqueness during data conversion.

Make GL and JC Batch forms tabbed and GLHead / JCHead TD extensible.

Make all Memo files TD extensible.

XX - Install Scripts

Example email templates installed with Server install. Installed and selected in demo systems.

XX - Launchguard

New version of Launchguard responds to any two of Shift, Ctrl, Alt when shortcut is run. Change made because Windows uses Ctrl+Shift for shortcuts on Taskbar to Run as Administrator.

New version of Launchguard is auto-updating. Launchguard now installs with both Server and Client installs, and will automatically update itself from new server versions. Requires a manual update initially to move to this version, reinstall the Client on workstations or copy the Launchguard.exe from the Server install.

 

Bug Fix

DI - Data Interchange

Fix CONarrativeData object Text property to handle line breaks.

 

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

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

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