myob exo businesshelp.myob.com.au/exo/releasenotes/verhist/myob exo... · new features improved...

MYOB Exo Business

Version History

2016.x

MYOB Exo Business 2016.x Version History of 62 Copyright 2017 MYOB Technology Pty Ltd.

Contents Introduction 1

Exo Business 2016.3.2 2

New Features ............................................................................................ 2

Updates to TPAR Submission .................................................................................. 2

Resolved Issues ......................................................................................... 4

Exo Business Core ................................................................................................... 4


New Features ............................................................................................ 5

Improved Excel Export ............................................................................................ 5

Parameters on Report Previews ............................................................................. 8

Enhancements to Parameter Labels ....................................................................... 9

Update to the ABN Verification Service ............................................................... 11

Resolved Issues ....................................................................................... 12

Exo Business Core ................................................................................................. 12

Exo Job Costing ..................................................................................................... 12

Exo Clarity ............................................................................................................. 12

Exo POS ................................................................................................................. 12

Exo Distribution Advantage .................................................................................. 13

Exo Business 2016.3 14

New Features .......................................................................................... 14

Updates to Business Alerts ................................................................................... 14

Maximum Number of Extra Fields ........................................................................ 16

Provisional Tax ...................................................................................................... 16

Update to Stock Search ........................................................................................ 18

Update to the Integrated Cashbook ..................................................................... 19

Updates to the GL Report Writer ......................................................................... 19

ABN Verification ................................................................................................... 22


Online Connectivity Check .................................................................................... 22

New Clarity Methods ............................................................................................ 23

Geolocation Updates ............................................................................................ 24

Interface Updates ................................................................................................. 25

Cashbook Periscope .............................................................................................. 27

Session Idle Timeout ............................................................................................. 27

Resolved Issues ....................................................................................... 28


Exo Job Costing ..................................................................................................... 30

Exo Clarity ............................................................................................................. 30

Exo Fixed Assets .................................................................................................... 30

Exo POS ................................................................................................... 31

Exo Distribution Advantage ..................................................................... 31


Resolved Issues ....................................................................................... 32



New Features .......................................................................................... 34

Updates to the Purchase Orders Window ............................................................ 34

Standard Business Reporting ................................................................................ 37

Clarity Report Print to File Options ...................................................................... 42

GL Trial Balance Tree Options............................................................................... 43

Display of Currency Symbols ................................................................................ 44

Job Costing Date Validation .................................................................................. 44

Extra Search Field Formatting .............................................................................. 45

Posting GL Ledgers from the Command Line ....................................................... 46

Update to Geolocation Features .......................................................................... 46

Resolved Issues ....................................................................................... 47


Exo Job Costing ..................................................................................................... 50

Introduction



New Features .......................................................................................... 51

Updates to Non Accounts ..................................................................................... 51

Composite Business Alerts ................................................................................... 52

Deposits on Sales Orders in Exo POS .................................................................... 53

Documents on Works Orders ............................................................................... 54

Line Ordering on Subscriptions ............................................................................ 54

Resolved Issues ....................................................................................... 55


Exo Job Costing ..................................................................................................... 57

Exo Intercompany ................................................................................................. 57

Exo CRM ................................................................................................................ 58

New Profile Settings 59

Added in 2016.1 ...................................................................................... 59

Added in 2016.2 ...................................................................................... 59

Added in 2016.3 ...................................................................................... 60

MYOB Exo Business 2016.x Version History Page 1 of 60 Copyright 2017 MYOB Technology Pty Ltd.

Introduction This document contains a compilation of the Release Notes information for all previous MYOB Exo Business releases from 2016.1 onwards. Information for each release includes, where appropriate:

• New Features, which describes all new features introduced in the release.

• Resolved Issues, which describe all issues that were addressed by the release.

The New Profile Settings section at the end of this document details any new profile settings that were introduced in each release.

Note: For details of the most recent release, see the MYOB Exo Business Release Notes document.


Exo Business 2016.3.2

New Features

Updates to TPAR Submission

The 2016.2 release of Exo Business added the ability to submit the Taxable Payments Annual Report (TPAR) to the ATO electronically using Standard Business Reporting (SBR).

The ATO’s SBR service has new authentication requirements; this release updates Exo Business so that it can continue to use this service.

Submitting the TPAR Electronically

The ability to track taxable Creditor payments was added in Exo Business 8.6 SP1; when the Track Taxable Payments to suppliers for building and construction related activity profile setting is enabled, Exo Business tracks payments for all Creditors who have the Track Taxable Payments setting ticked. Taxable payments can be reported on using the Taxable Payments Reporting Worksheet window:

Exo Business 2016.2 added an SBR button to this window. When this button is clicked, the TPAR is validated and, if all checks pass, it is sent to the ATO electronically.



Additional setup steps are required to enable electronic TPAR submission—the following resources are available on the Exo Business Education Centre to provide information on tracking taxable payments, setting up Exo Business for SBR and submitting the TPAR electronically:

• The Release Notes for Exo Business 2016.2.

• The Taxable Creditor Payments video.

• The topic “Tracking Taxable Creditor Payments” in the Exo Business Help.

http://help.myob.com.au/exo/releasenotes/exo20162/MYOB%20EXO%20Business%20Release%20Notes.pdf

http://help.myob.com.au/exo/videos/setup.htm

http://help.myob.com.au/exo/help/exo2016/desktop/Tracking_Taxable_Payments.htm



Resolved Issues

Exo Business Core

Service Request ID Description

141847980251 141596410541 142262875741

When a GL Report was exported to Excel 2007 or later (XSLX Data), negative values in the report would not appear as negative. This has been resolved.

- In some cases, the Recent Items widget could steal focus from the window in front of it. This has been resolved.



Exo Business 2016.3.1 The 2016.x release is a Service Pack release to Exo Business 2016.3, which focusses on updates to Clarity reports. It contains improvements to the Excel export functionality, usability improvements to the reporting interfaces and fixes to issues identified in previous releases.

New Features

Improved Excel Export

This release introduces improvements when exporting reports to Microsoft Excel. These improvements relate to the XLSData output format, which produces an Excel file in columnar format with the emphasis on ensuring the data is formatted to allow further data manipulation. (The other Excel output format, XLSReport, places the emphasis on preserving the appearance and layout of the original report.) A new XLSXData output format is available, which functions the same as the XLSData format, but produces an .XLSX file, rather than an .XLS.

On screens where reports can be exported to Excel, e.g. the Clarity Report Parameters window or the Sales Analysis Designer, the Export to XLS Report button on has been replaced with a new Export to Excel dropdown:

The new dropdown contains three options:

• Export to Excel 2007 and later (XLSX) – this uses the XLSXData output format to produce an Excel file in the .XLSX format.

• Export to Excel 97 – 2003 (XLS) – this uses the XLSData output format to produce an Excel file in the older .XLS format.



• Export to XLS Report – this uses the XLSReport output format to produce an Excel file in the .XLS format.

When selecting either of the first two options, the system now analyses the report and produces an automatically formatted Excel file that presents the data as clearly as possible. All report values and totals are presented with the columns, headings and formatting from the original report (including column widths, colours, text formatting and any data formatting like the number of decimal places or percentage signs). Any extraneous report elements, e.g. titles and other labels, appear to one side, where they can be easily deleted if necessary.

Setting up Reports for Excel Export

The default behaviour for the Excel export function is to analyse reports and auto-format them as described above; however, if the Clarity report has been set up for Excel export, using the Print to File Setup window in the Exo Business Report Designer, the system will use this setup to produce the Excel report.

The Print to File Setup window includes a new option to make it easier to set up reports for exporting to Excel. (Open the Print to File Setup window by selecting Print to File Setup from the File menu while on the Design tab.)

Clicking the new Auto Layout button automatically populates the Selected Controls pane, using the same analysis as the default Excel export function. The report data



columns are sorted to the top of the pane (meaning they will appear on the left of the Excel file) and the titles, labels, etc. are sorted to the end. You can then delete any unnecessary columns or re-order them as necessary. Once the report is saved with the new Print to File Setup configuration, this configuration will be used whenever the report is exported to Excel.

The new and buttons let you add and remove blank columns in the Excel output. This can be useful for rows that contain section totals—you can include only those columns that you want to be totalled, and tell the output to skip the other columns by adding blank columns in their place. These blank columns have the prefix <SKIP> on the Print to File Setup window—they do not appear in the printed output; only in Excel.

To determine whether or not the Print to File Setup has been configured, the system looks at the Save property under Output - File for the Details section of the report. If this property is ticked, it knows the Print to File Setup has been configured, so it will use the saved configuration instead of trying to auto-format the report.

Note: All default reports that are installed with Exo Business have been configured for XLSData export. It may be useful to look at some of these reports to see how they have been configured, and use this as a guide when configuring your own custom reports.



Parameters on Report Previews

When previewing a Clarity report, the report parameters now appear in a resizable pane on the left, so that you can change the preview without having to exit back to the Clarity Report Parameters window. This means that you can print out several versions of the report, or search for exceptions within a report quickly and easily.



Enhancements to Parameter Labels

In previous versions, report parameters’ labels were always hard-coded; the release adds the ability to use the Display Names set up in Exo Business Config in parameter labels. To use a Display Name in a parameter’s label, enter @PARAMETER_ID in the Caption field of the Parameters Editor window, where PARAMETER_ID is the field’s ID on the Display Names screen in Exo Business Config:

For example, on the Stock Transaction Listing report (STTTransList.clr), the captions for the Stock Group parameters are hard-coded on the Parameters Editor window to “From Primary Stock Group”, “From Secondary Stock Group”, etc.



If you have set up a different Display Name for the STOCKGROUP_SECONDARY field, you can enter @STOCKGROUP_SECONDARY into the caption—at runtime, this will be replaced with the relevant Display Name. You can choose from a list of available Display Names by clicking on the new dropdown control on this field:



Changing the hard-coded caption names to use @STOCKGROUP_PRIMARY and @STOCKGROUP_SECONDARY results in the following captions when the report is run:

In the screenshot above, the captions for the Primary Stock Group have been changed to “Other” and “Main”, as per the Display Names.

Update to the ABN Verification Service

This release updates the ABN verification feature for company records; the system will now display a warning message if the verification fails, but will still allow the record to be saved. This gives administrators more flexibility to record company names as they see fit, which may be in a way that does not exactly match the name associated with the ABN.



Resolved Issues

Exo Business Core


138636758892 138627316501 The History tab on the Sales Orders search window was not displaying data from the selected Sales Order. This has been resolved.

- A “closed recordset” error could occur when clicking Save & Exit on the Creditor Account Details windows. This has been resolved.

- A confirmation message is now displayed before a user runs the System > Purge Records utility in Exo Business Config.

- Access violation errors could occur in GL Reports when using the 2016.3 version of Exonetlib.dll with versions prior to 2016.3. This has been resolved.

Exo Job Costing


114517968580 114507491481 114639197721 124346611281 127057463881 137619963741

An Access Violation error occurred after creating a Purchase Order for a Job, if the Debtor associated with the job had a pop-up alert defined. This has been resolved.

Exo Clarity


138636758892 138627316501 After closing Clarity, it still showed on the Windows task bar. This has been resolved.

Exo POS


- Due to the rebranding changes introduced in Exo Business 2016.3, running exonet.exe in POS mode was not supported. This has been resolved; the core Exo Business module now supports running in POS mode.



Exo Distribution Advantage


140299717759 139121298301 Custom buttons that were set up to open the Batch Sales Order Line Processing (BSOLP) function from the Sales Order window did not pass in the current Sales Order; the BSOLP window opened at a blank Sales Order search screen. This has been resolved.


Exo Business 2016.3 The 2016.x release delivers over twenty of the most requested enhancements registered and voted for on the Exo Business ideas portal, together with a refresh of the user interface that makes ‘Windows Aero-Flip’ the default behaviour for all modules and allows for main form panels to expand proportionally when you enlarge the form size. Also significant is a further enhancement of the New Zealand GST return web service to handle provisional tax payment or refund offset.

New Features

Updates to Business Alerts

This release adds the ability to set up new Business Alerts for a wide range of events. New event categories are available in the Rules for Event dropdown on the Business Alerts screen in Exo Business Config:

• Save Debtor

• Save Creditor

• Save Non-Account

• Save Contact

• Save Stock Item

• Save GL Account

• Save Serviceable Unit

The Business Alerts screen has been redesigned to group events into sections:

Exo Business 2016.3


New Parameters

The following new parameters are available for Business Alerts:

Parameter Meaning

General (available for all types)

@NOW_STR The current date and time as a string in the format 'yyyy-mm-dd hh:MM:ss' (including quote marks).

@TODAY_STR The current date as a string in the format 'yyyy-mm-dd' (including quote marks).

Company accounts

@ACCNO The Debtor, Creditor or Non Account's ID number.

@ALHPACODE The Debtor or Creditor account's name. (Not available for Non Accounts.)

@H A specified field from the DR_ACCS, CR_ACCS or PROSPECTS table.

Contacts

@CONTACTID The contact record's ID number.

@ACCOUNTNAME The name of the company account that the contact is associated with.

@H A specified field from the CONTACTS table, e.g. @H.FIRSTNAME.

General Ledger accounts

@ACCNO The GL account's ID number.

@H A specified field from the GLACCS table, e.g. @H.BALANCE.

Stock items

@STOCKCODE The Stock item's ID code.

@ACCNO The ID number of the stock item's supplier.

@H A specified field from the STOCK_ITEMS table, e.g. @H.SELLPRICE1.

Serviceable Units

@UNITNAME The Serviceable Unit's name.

@STOCKCODE The ID code of the stock item on the unit (this may be null).

@H A specified field from the SU_MAIN table, e.g. @H.UNITDESC.

@W A specified field from the SU_WARRANTY table, e.g. @W.EXPDATE.

Exo Business 2016.3


Maximum Number of Extra Fields

In previous versions, the maximum number of Extra Fields that could be added to a table was 24. This version increases the limit to 38 for most tables; for tables that are accessible via the Exo API only, the limit has been increased to 100.

Provisional Tax

The NZ GST Return function can now include provisional tax information when submitting the GST Return to the IRD. You can pay provisional tax along with your GST, or, if your GST return shows a refund, you can apply some or all of this refund against the provisional tax amount.

Note: Exo Business does not support the Ratio method for calculating provisional tax. You will need to manually calculate and file your GST return if you are on the Ratio method.

A new GST Return Type dropdown on the Header tab of the NZ GST Return window lets you specify whether or not the GST return should include provisional tax:

Note: If you pay provisional tax, you will need to select the “Provisional Taxpayers: GST 103B” option every period, even for periods where you are not paying provisional tax.

Exo Business 2016.3


When the “Provisional Taxpayers: GST 103B” option is selected, an extra Provisional Tax tab becomes available. Once the GST return is calculated, you can enter provisional tax details into this tab. The available fields differ depending on whether or not the GST return indicates a payment (to which the provisional tax payment will be added) or a refund (which can be used to offset the provisional tax amount):

The amounts on this tab are displayed on the printed GST Return report, and included in the return when it’s submitted to the IRD using the IRD button. (This was formerly the SBR button—as Standard Business Reporting is specific to Australia, this terminology has been changed in the New Zealand interface).

Exo Business 2016.3


When submitting a return that includes provisional tax, the provisional tax fields are added to the Submit GST Return Confirmation window:

In New Zealand, the SBR Manager window has been renamed to Inland Revenue Lodgements. This window now includes extra columns related to GST returns.

Update to Stock Search

In previous releases, when entering a stock code and using the ? wildcard, if there was a record that matched the code exactly, it would be selected automatically and the Stock Search window would not appear. As of this release, when the ? wildcard is included in a stock code search, the Stock Search window always appears, showing any entries that match code.

This can be useful when entering stock codes, as it shows the user any records that may be related to the entered code, which would not have been visible otherwise, e.g. related barcodes or stock items that have superseded the entered item.

Exo Business 2016.3


Update to the Integrated Cashbook

The Integrated Cashbook now supports more than 200 rows. By default, it pre-allocates 200 rows (the maximum in previous versions), but it is now possible to add more rows by pressing the down arrow key while on the last row.

Updates to the GL Report Writer

This release adds setup options to the GL Report Writer, which provide more flexibility when setting up percentage-based columns, and allow report columns to be organised more neatly. Two new properties are available on the Report Column Setup window:

In previous versions, columns with the type “PERCENTAGE” would calculate all values in the column as percentages of a nominated total (the total is taken from the row specified by the % Row sequence setting). The new %Range Row Seq setting lets you specify a range for the percentage calculations—the report will calculate percentage values for all rows between the %Range Row Seq row and the % Row sequence row, and leave all other rows blank.

The new %Column Destination value lets you insert a range of percentage values into a different column. This allows you to set up multiple columns to calculate multiple ranges as percentages, then display all ranges in a single column on the printed report.

The new options are supported when printing GL Reports, when printing them with a Clarity template, and when exporting them to Excel.

Note: If %Range Row Seq is set to -1, the system will behave as it did in previous versions and the %Column Destination setting will be ignored.

Exo Business 2016.3


Example

The screenshot below shows a “% of Sales” column, which expresses the values from column 30 (<PERIOD>) as percentages of row 35 (Total Sales). The %Range Row Seq property is set to 25, which means that percentages will only be calculated from row 25 (<Range of GL Account Groups>) to the Total Sales row.

A “% of Profit” column has also been set up to express the values from column 30 (<PERIOD>) as percentages of row 65 (Cost of Goods sold). The %Range Row Seq property is set to 55, which means that percentages will only be calculated from the second <Range of GL Account Groups> section to the Cost of Goods Sold row.

Exo Business 2016.3


The effects of these settings can be seen when the report is previewed:

The “% of Sales” column contains percentage values for the Sales section only and the “% of Profit” column contains percentage values for the Less Cost of Sales section only.

This report contains a lot of blank space in the columns—the values from the “% of Profit” column can be moved into the “% of Sales column” by setting the “% of Profit” column’s % Column Destination to 70 (the ID of the “% of Sales” column):

Exo Business 2016.3


When previewed, the report now shows both sets of percentage values in the same column (which has been renamed to “% of Total”).

ABN Verification

For Australian companies, Exo Business can now verify the Australian Business Numbers (ABNs) entered for Debtors and Creditor accounts using an online service provided by MYOB. A new profile setting, Verification of the ABN against online resources, is available to control what sorts of account the system should use the verification service for. This setting has the following options:

• None

• Debtors

• Creditors

• Debtors and Creditors (this is the default)

Online Connectivity Check

A new Check Online Connectivity button is available on the About Exo Business window (Help > About). Clicking this button checks the status of the Exo Cloud Services, which provide functions such as geolocation services, Bank Feeds and ABN verification (see above). If there are any problems with connectivity, an error message containing details of the problems will be displayed.

Exo Business 2016.3


New Clarity Methods

This release adds new methods that can be used in Clarity reports.

ShowGLCode

procedure ShowGLCode(GLCode: string; HasBranch: Boolean);

This opens the specified GL account from a Clarity report. The GLCode can be either a single number, e.g. 1000, or a formatted string, e.g. 1000-10 or 2-1000-10.

For example, assuming a DBText field called GLAccNo, you can add an OnDrawCommandClick handler as follows:

procedure GLAccNoOnDrawCommandClick(aDrawCommand: TObject);

var

lDrawText: TppDrawText;

begin

lDrawText := TppDrawText(aDrawCommand);

if lDrawText.Text <> '' then

ShowGLCode(lDrawText.Text, False);

end;

FormatExoProtocolLink

function FormatExoProtocolLink(Command, Value: string):

string;

This will return an Exo protocol link for a specified Command and Value, e.g.

Link := FormatExoProtocolLink('draccount', 10);

This will return “exo://<current alias>/draccount(10)” into the link.

This function can be used with the DBText.Hyperlink property in Clarity. Add a BeforePrint handler to the detail band, e.g.

procedure DetailBeforePrint;

begin

DBText1.HyperLink := FormatExoProtocolLink('draccount',

MASTER['ACCNO']);

end;

Clicking on this link will then launch/open Exo Business, then open the relevant Debtor account.

Note: ShowGLCode uses the Exo protocol handler to enforce security constraints, i.e. as with all Exo protocol links, users cannot use them to access part of the Exo Business system that they do not have access rights for.

Exo Business 2016.3


Geolocation Updates

This release includes updates to the window that opens when Exo Business attempts to retrieve geolocation information for an address. The window has been reorganised to make it more compact, and features new controls that let you fine tune the way that accounts’ addresses are matched to geolocation data.

The tick boxes next to each line in the Search Address panel can be used to exclude certain address lines from being matched; for example, if addresses have a building or unit number as the first line, this could be excluded from searches.

Note: You can also use the existing Geo coding address format for Australia and Geo coding address format for New Zealand profile settings to control how geolocation data is mapped to account addresses.

Ticking the new Add Country button automatically appends the country to the end of addresses if it is not already there, which can be useful if accounts’ addresses do not usually include a country. (For Australian databases, “Australia” is appended; for New Zealand databases, “New Zealand” is.)

You can save these settings for all future searches by clicking the new Save Settings toolbar button.

Exo Business 2016.3


Interface Updates

Windows Aero Theme

The Windows Aero theme is now enabled by default, providing a more modern interface that supports the Aero Flip and Peek features. These include enhanced ALT+TAB, CTRL+TAB and WINDOWS+TAB functionality which improve multitasking when working across several modules at once.

In previous versions, this theme had to be enabled by running Exo Business executables with the /AERO flag. This flag is no longer supported; instead a /NOAERO flag is now available to disable the default Aero theme.

Window Resizing

The Exo Business interface now resizes proportionally to match the dimensions of the window. This affects the panes that make up each screen and various text entry fields, e.g. address fields.

Note: To save a window’s size and position, right-click on the window’s title bar and select Form Position > Save.

Rebranding

The MYOB Exo Employer Services suite of products has been rebranded with an all new look and feel:

When the DBUpdate process is run to upgrade to this version, the system attempts to install the new default Business Flow Menus. If no Business Flow Menus are in use, the

Exo Business 2016.3


default ones will be installed; if an older default menu is in use, the system will attempt to upgrade it to the new look.

For systems that use customised Business Flow Menus, new template menus are available in MYOB Exo Configurator at Staff > Menus > Business Flow Menu—these templates can be used as the basis for new customised menus.

Bank Feed Setup Columns

The columns on the Setup Bank Feed Rules window to make the setup process more intuitive. The Link Operator and Invert columns are now on the left side of the Rule Conditions and Action Conditions sections, making it clearer that these operators apply to the current row, not the rows that follow it.

Exo Business 2016.3


Cashbook Periscope

The Options column on the Integrated Cashbook window contains an edit button for Expense and Income transactions; this button opens the Cashbook Periscope window, where GST details for the line can be edited:

Session Idle Timeout

This release adds the ability to configure an idle timeout for users, by configuring the new Idle session timeout period in minutes User-level profile setting. If this setting has a value greater than zero, then users will be logged out after a period of inactivity that exceeds the entered value (in minutes).

Note: Because this is a User-level profile setting, you can set different timeouts for different users, or have no timeout for some users.

A warning message appears when the idle timeout has been exceeded:

The user has 60 seconds to cancel, after which their session is ended and they are logged out of Exo Business. Their database connection is closed, any locks they had on records will be removed, and their licence will be freed up. If they had left any changes unsaved, these changed will be lost.

Note: Some key business processes are exempt from the timeout, including the MYOB Exo Configurator application.

Exo Business 2016.3


Resolved Issues

Exo Business Core


138636758892 138627316501 This issue was resolved in the Exo Business 2016.3.1 Service Pack.

The History tab on the Sales Orders search window was not displaying data from the selected Sales Order. This has been resolved.

12352902445 11302389807 11515306213 11515956252 11515956440 11379930268 11379930498 11063280732 11379930611 12233122561 12596471411 12596471416 19684004841 122129855511 133831029671

When a GL Report was set up with one or more columns of the “PERCENTAGE” type, percentages were not calculated correctly; the report would calculate all values in the column as a percentage of the nominated total row, even if those values were not related to the total row. This has been resolved; new properties on the Setup GL Reports window let you specify the range of values that should be calculated as percentages—see page 14.

12352902445 11302389807 11515306213 11515956252 11515956440 11379930268 11379930498 11063280732 11379930611 12233122561 12596471411 12596471416 19684004841 122129855511

This release adds features to the GL Report Writer that improve the behaviour of percentage columns and allow multiple percentage ranges to be included in one report—see page 19.

13235219285 17216787952 18018803531 15903398501 13260369741 13156398801 13034026311 132278101371 128120253431 124824014861 113992313731 113292901361 111377650945

This release adds the profile setting Suppress contact history notes, which allows you to prevent history notes being created when adding or removing contacts from CRM contact lists and/or when emailing invoices to customers—see “Error! Not a valid result for table.” on page 59 for details.

12597484594 12580392125 13307252531

The Integrated Cashbook now supports more than 200 rows—see page 19 for details.

11141712784 127355264001 12082928065 11140342613 12082928017 12293056199 18113206171 18113206176 18113206180 18113206184 18113206196 18113206200 12082928071 12082928053 12082928059

This release resolves the following issues involving the End of Period/End of Year process:

• After running the End of Year process, the first period in the new year would have start and end dates from the previous year.

• If the End of Year process was run for one ledger, then run again for the remaining ledgers, the year would become incorrect.

• To prevent a user accidentally rolling the same period twice, the system now checks if any ledgers are being posted before their period end date, and warns the user if they are.

12295703977 12288245295 116334346101 116468533364 116468533341 119273598511 121041451435 120671201461 136190626941

GL Reports would not display any data if the Period Year in Header option was ticked on the Setup GL Reports window. This has been resolved.

Exo Business 2016.3


11075722975 11018048658 11990950021 13030789391 18771499761

This release makes it easier to copy Business Flow Menus for Exo Job Costing and Exo CRM from one menu to another.

16972344449 15953474361 16933645641 135029221071

In previous versions, stock item images (specified on the Web tab of the Stock Item Details window) supported the GIF, JPG and BMP formats only. This release adds support for PNG, ICO, EMF and WMF image files.

134304289620 134402430491 113992313941

When documents were imported to the Documents tab of an account, the document date would NULL if the file was open in another application. This has been resolved.

12330152604 136188115531 12320409901

The Validate debtor order numbers profile setting saved the wrong default value, which meant that orders could be saved without an order number even if the Debtor’s Need Ord No option was ticked. This has been resolved.

121041451435 120671201461 136190626941

GL Reports showed no data if the Period Year in Header option was ticked. This has been resolved.

12016709708 12837745666 On the Rows and Columns tab of the Setup GL Reports window, after adding, editing, or deleting a row, focus always jumped to the top row of the grid. This has been resolved.

125444195225 125126178911 Processing an Inwards Goods Receipts with a manual on-cost wrote an incorrect GL batch number to the STOCK_TRANS table, which meant that when transactions were posted to the General Ledger, the system would update the GL batch number of unrelated transactions. This has been resolved.

136306006888 136279426721 When using fully-tracked serial numbers, old serial numbers (more than 10,000 records back) were not updated to “In Stock” following Adjust In stock adjustments. This has been resolved.

11698333175 11693304101 138461512757 138457032352

This release includes enhancements to the Stock Search functionality when using the ? wildcard—see page 18.

11609682359 11596213551 134251696601

11696803008 11613582591 11050594878

This release addresses the following issues relating to the Manual Cheque screen of the Creditors Payment Processor:

• The error message ‘Grid out of range.’ appeared when tabbing to a new line. This has been resolved.

• The error message ‘List index out of bounds (-1).’ appeared when entering a negative Expense. This has been resolved.

• This release adds support for Analysis Codes to the Manual Cheque screen.

12312747338 12302338353 If the Analysis Codes column on the Integrated Cashbook windows was hidden (by enabling the Hide Analysis Codes Column profile setting), some of the other columns, such as GST, could not be seen without scrolling. This has been resolved.

Exo Business 2016.3


116259668941 This release adds support for NVARCHAR Extra Fields. While it was always possible to manually insert Extra Fields as NVARCHAR, changes in recent releases meant that such Extra Fields could not be edited in Exo Business Config; this has been resolved.

131782658581 When emails or documents were dragged onto an account’s Documents tab, they were always stored in the Exo Business database, which could cause the database to become overly large over time. Drag and drop operations onto the Documents tab now use the Documents stored in database profile setting to determine whether documents should be stored or linked to.

- If a widget that expected a contextual link to a record was added to a general dashboard, an exception would occur. This has been resolved; in such cases the system now handles the exception and the widget simply displays no data.

Exo Job Costing


11094254364 136050627971 14635646251 11035344731

When using the Create Asset function to create a batch-tracked item from batch-tracked component items, the system did not prompt for a batch number for the output item. This has been resolved.

114517968580 114507491481 114639197721 124346611281 127057463881 137619963741

This issue was resolved in the Exo Business 2016.3.1 Service Pack.

An Access Violation error occurred after creating a Purchase Order for a Job, if the Debtor associated with the job had a pop-up alert defined. This has been resolved.

Exo Clarity



After closing Clarity, it still showed on the Windows task bar. This has been resolved.

Exo Fixed Assets


11856719335 130650687134 11848056300 11848056308 11848056316 11848056324 12180703628

Disposing of an Asset after the End of Year process had run did not adjust Retained Earnings, which resulted in a GL imbalance. This has been resolved; when revaluing, selling or disposing of an Asset in the previous financial year, a GL transaction is now created for the Retained Earnings account which is the sum of the amount for transactions that affect profit and loss.

Exo Business 2016.3


Exo POS


- This issue was resolved in the Exo Business 2016.3.1 Service Pack.

Due to the rebranding changes introduced in Exo Business 2016.3, running exonet.exe in POS mode was not supported. This has been resolved; the core Exo Business module now supports running in POS mode.

Exo Distribution Advantage



Custom buttons that were set up to open the Batch Sales Order Line Processing (BSOLP) function from the Sales Order window did not pass in the current Sales Order; the BSOLP window opened at a blank Sales Order search screen. This has been resolved.



Exo Business 2016.2.1 The 2016.x release is a low impact Service Pack release that contains improvements to the Stock search templates and Purchase Order grids—areas where there were significant changes in 2016.2.0, and for which there was a degree of enthusiasm for what the new features offered. We received many suggestions as to how they could be further refined after the release, and we saw no reason not to release these refinements and potential blockers of adoption as a Service Pack rather than holding them to the next full release. This release also contains refinements to the SBR Taxable Payments Annual report validation and submission process based on experience from 2016 submissions. For partners who have users who have not yet submitted, we would like to hear from you, and you should use this version to further streamline the process.

Resolved Issues

Exo Business Core


127157066706 14107908997 16601462764 19555422421 125217536331 127122423111 127122423124 127122423136 127122423148 128480458851

On the Setup GL Reports window, if a user added a new report, then closed the window without saving, whichever report was highlighted on the search window before the user clicked New would lose the entire report definition. This has been resolved.

133153237565 132755975623 131800383432

When the profile setting Disable serial number screen popup for inwards goods receipts with fully assigned serial numbers was enabled, unless the user manually confirmed the serial numbers at the costing stage, the second and subsequent lines did not update the InStock flag to “Y”, which left these serial numbers in limbo and unable to be sold. This has been resolved.

134304289620 113992313941 When importing documents to the Documents tab of the Debtor Account Details window, the document’s Document Date would be null if the document was open in another application at the time it was imported. This has been resolved.

135107721921 135263496906 The Purchase Order grid was not populated when the bar code of a stock item was used instead of stock code.

- Forecast-based Purchase Orders always used the new Purchase Order window (introduced in Exo Business 2016.2), even when the Use old purchase order screen profile setting was enabled. This has been resolved.

- The Forecast-based Purchase Orders feature was passing in the stock requirements in terms of stock keeping unit quantity as a portion of the supplier pack multiple – users found this unintuitive.


- Forecast-based Purchase Orders was not passing through the supplier discount values to the column in the new Purchase orders grid.

- It was not possible to use the CTRL key to select multiple items on the Stock Search window when using a search template. This has been resolved.

- The new Purchase Order grid had a minimum size constraint. This has been resolved.

- The Order Total field on the new Purchase Order grid was not refreshed when lines were inserted by means other than keying. This has been resolved.

- The new Purchase Order grid did not support the Auto narrative feature. This has been resolved.

- Statement/remittance contact logic should apply only to statements (not invoices) when emailing from an account’s Transaction tab. More extensive work is planned in this area, but in the interim the previous logic has been re-instated: Invoices will go to the account email address by default rather than contacts when emailing an invoice from the Debtor’s Transaction tab.

- Taxable payments logic was missing from the Creditors Payment Processor for Direct Credits and Cheques if Payments basis GST was not enabled. This has been resolved; now it always populates regardless.

-

This release includes performance improvements to the confirmation screen when submitting taxable payments via SBR.

- The taxable payments confirmation screen did not reflect the actual values that would be submitted to the ATO by electronic submission. Values were rounded to the nearest dollar; however, the ATO specifies that only dollar amounts should be submitted with no cent portion. e.g. 100.99, 100.55 and 100.45 all become 100, i.e. the values should be truncated, not rounded.

This has been resolved; the system now truncates values instead of rounding them. The Clarity forms CITP_Details.CLF and CITP_TaxReturn.CLF have been modified to reflect this.

Note: The ATO will reject any account where the GST is a negative value.

Exo Business 2016.2


Exo Business 2016.2 The 2016.2 release is focussed on addressing items most requested by users and implementers of the Exo Business system. A new feature highlight for New Zealand users is the ability to submit and review GST returns via a new MYOB cloud service. For Australian users involved in construction related activity, there is a new cloud-based Taxable Payments Annual Report (TPAR) submission process using Standard Business Reporting (SBR). Previously, this report has been a significant pain point for users each year, as it was very complex and time-consuming to submit electronically or manually.

Significant for all users will be the enhancements to Purchase Order entry, which are aligned with recent work in Sales Orders to utilise the popular framework features, such as search templates, line-level Extra Fields and grid column controls. This allows you to further simplify or enhance the Purchase Order entry process to better suit your business needs.

New Features

Updates to the Purchase Orders Window

This release includes several changes to the Purchase Orders window, making it more powerful and flexible.

New Grid

The main grid on the Purchase Orders window has been replaced with a new grid control, adding extra functionality such as copy-paste functionality, the ability to hide and re-order columns, the ability to add Extra Fields to the grid and use search templates (see page 36).

Exo Business 2016.2


Access to the new grid is controlled by the Use old purchase order screen User-level profile setting. By default, this setting is enabled, meaning that the new grid will not appear. To activate the new grid, disable the profile setting.

Columns can be shown or hidden by clicking the control at the left of the column headers.

Note: Some columns can also be controlled by profile settings; if a column has been hidden by a profile setting, it cannot be shown using this control.

The new grid supports Extra Fields; any fields added to the PURCHORD_LINES table with the Grid Column option ticked will appear in the grid.

Exo Business 2016.2


Clicking on a cell in the grid and dragging allows you to select multiple cells across one or more lines. The right-click menu for the new grid includes options to copy and paste the selected cells, so you can, for example, copy the cells to a spreadsheet, edit them, then paste the edited data back into the grid.

Note: You can select the entire grid by clicking in it and then pressing CTRL+A. If you delete all lines from the grid, you will need to press INSERT to add a new line.

Stock Search Templates

Stock search templates are now available when searching for stock from the Purchase Orders window (previously this feature was only available from the Sales Orders and Debtors Invoice windows). When opened from a Purchase Order, the Stock Search window contains a dropdown that allows you to select a search template to apply:

Note: Stock search templates are only available when using the new Purchase Order grid (see page 34).

Exo Business 2016.2


A new Purchase option is available on the Availability tab of the Search Template setup screen when editing a stock search template. Ticking this option means that the search template will be available from the Purchase Orders window.

Standard Business Reporting

This release adds Standard Business Reporting (SBR) features, which provide the ability to submit tax reports electronically from within Exo Business.

Setting up Exo Business for SBR

The following details are needed to submit the Taxable Payments Annual Report electronically (see page 39):

• A my.MYOB account – your Business Partner will need to contact MYOB’s administration team with your details to sign you up for an account.

• A Business Reference Number (BRN), which uniquely identifies an Exo Business database – contact your Business Partner for the BRN for your database (they will be given it after your my.MYOB account is created). Once you have a BRN, enter it in the Business Reference Number field on the Company > Company Details section of Exo Config.

• A software ID – this is generated in Exo Config at Business Essentials > SBR. Click the Request Software ID button to generate the software ID (the ID is based on your BRN).

Note: If you are already using the Bank Feeds feature, you will already have a my.MYOB account and BRN—you do not need to apply for these again.

The following details are needed to submit NZ GST returns to the IRD electronically (see page 40):

• A myIR account – you can register for myIR at http://www.ird.govt.nz/online-services/ir-online-services-register.html.

• Your company must be registered for GST.

http://www.ird.govt.nz/online-services/ir-online-services-register.html

http://www.ird.govt.nz/online-services/ir-online-services-register.html

Exo Business 2016.2


Validating Addresses

The ATO requires that all addresses submitted to it comply with a specific format. You must review the address details of your own company and of all Creditor accounts that will be included in the Taxable Payments Annual Report (TPAR).

When gathering address details to include in the TPAR, Exo Business uses the new Purpose property of address Display Names to determine which details to include. For example, whichever address field has been given the “Street” property will be used to populate the street detail for all accounts included in the TPAR. Before you can generate the TPAR, you must assign purposes to the relevant address details. Do this by selecting a value from the new Purpose dropdown in Exo Config at System > Display Names:

Each purpose can be assigned only once; for example, once you have assigned the “Street” purpose to one address field, “Street” will not be available in the Purpose dropdown for any other address fields. All purposes should be assigned to an address field.

Note: You should assign purposes to the Delivery Address fields, i.e. DELADDR1 – DELADDR6, rather than the Postal Address fields.

Once each purpose has been assigned to an address field, you can review your company’s address details in Exo Config at Company > Company Details, and Creditors’ address details on the Details 1 tab of the Creditor Account Details window to ensure that the correct data has been entered into all fields.

Note: See Appendix 2 on page Error! Bookmark not defined. for details of the required format for address details.

Exo Business 2016.2


Taxable Payments Annual Report (AU)

The Taxable Payments Annual Report (TPAR) can now be submitted to the ATO electronically. The Taxable Payments Reporting Worksheet window includes new toolbar buttons for submitting the report online and managing submissions:

Clicking the SBR button ( ) opens a confirmation window that displays details of all payments that will be submitted:

Any validation errors that have been encountered will be displayed here—you must correct any errors before the report can be submitted. You can double-click on an error to go to the related Creditor account.

If there are no errors, you can click Submit to submit the report to the ATO—at this point, you must enter your my.MYOB account details.

Exo Business 2016.2


A confirmation message appears once the report has been submitted. You can check the progress of your submission on the new SBR Manager window, which can be opened by clicking the toolbar button on the Taxable Payments Reporting Worksheet window.

Note: You can re-submit a report if necessary; records that have already been submitted will be overwritten.

Electronic GST Report (NZ)

The NZ GST Return can now be submitted to the IRD electronically. The NZ GST Return window includes new toolbar buttons for submitting the report online and managing submissions:

Exo Business 2016.2


Clicking the SBR button ( ) calculates the GST Return and displays the results on a summary window:

Tick the confirmation box, then click Submit. An authentication window appears, where you can enter your myIR login details.

As with TPAR submissions, you can check the progress of your submission on the SBR

Manager window, which can be opened by clicking the toolbar button on the NZ GST Return window.

Exo Business 2016.2


Clarity Report Print to File Options

The Print to File Setup window in the Clarity Report Designer has been redesigned, making it easier to produce XLS data files with properly aligned rows and columns from Clarity reports.

The window is now resizable, so it can be enlarged when there is a long list of available controls. It is now easier to see what each available control represents:

• Controls are now shown with their more user-friendly names, using the format “DataField (UserName)” for database controls, or “Caption (UserName)” for labels.

• The controls in the Selected Controls pane are now displayed in the order that they appear on the Clarity report (ordered left-to-right, top-to-bottom), rather than appearing alphabetically.

Exo Business 2016.2


GL Trial Balance Tree Options

New options are available on the GL Trial Balance Tree window:

Using the new check boxes, you can choose to show or hide inactive or zero-balance accounts in the tree.

Exo Business 2016.2


Display of Currency Symbols

The currency symbols that can be defined for different currencies, e.g. €, £, ¥, are now displayed on all relevant common windows such as the Debtor and Creditor account detail windows, and the Purchase Order and Sales Order search grids, as well as on numerous reports.

Job Costing Date Validation

To better support perpetual inventory integration, validation has been added to the transactions dates entered in the following places in Exo Job Costing:

• Job Details window > Costs tab

• Job Details window > Timesheets tab

• Direct Material Entry window

• Direct Timesheet Entry window

Once a job has been saved, it is no longer possible to change a transaction’s date to one in a different period; the date can only be changed to one in the same period as the original date.

When entering transactions on the Quote/Budget tab of the Job Details window, the date defaults to the current date, unless you have not rolled over to the current period; in this case it will display the last date of the period you are currently in.

Note: The Enforce transaction period dates during invoice entry profile setting is still applicable to Job Costing; this setting is used to validate the date initially entered for a job transaction.

Exo Business 2016.2


Extra Search Field Formatting

This release adds enhancements to the user-level profile settings that add extra fields to the various search screens and grids that support them, e.g. Extra stock items search fields, Extra creditor account search fields. The formatting of extra fields added to search windows can now be customised; these profile settings now allow entries in the format:

DatabaseFieldName=DisplayName=SearchBehaviour=Format

The new =Format parameter controls how each extra field will be formatted. It can contain one of the following values:

• Cost – Use standard cost price formatting, without a currency symbol

• Sell – Use standard sell price formatting, without a currency symbol

• Balance – Use standard balance formatting (2 decimal places), without a currency symbol

• Qty – Use standard quantity formatting

• Disc – Use standard discount formatting, with a percent symbol (%)

• DateTime – Show date/time as dd.MM.yyyy hh:mm:ss

• Date – Show date as dd.MM.yyyy

• BillQty – Use standard bill quantity formatting

• BillCost – Use standard bill cost formatting

• a number between 0 and 15 – Use the specified number of decimal places, e.g. 3 will give 123.450

The formatting parameter is optional; if it is not specified, formatting will be applied to the field based on its field name and display name:

Field name or display name contains

Formatting applied

“COST” Use standard cost price formatting, without a currency symbol

“SELL” or “PRICE” Use standard sell price formatting, without a currency symbol

“BAL” Use standard balance formatting (2 decimal places), without a currency symbol

“QTY” or “QUANTITY” Use standard quantity formatting

“DISC” Use standard discount formatting, with a percent symbol (%)

Exo Business 2016.2


Posting GL Ledgers from the Command Line

The Post Ledgers to GL function can now be run from the command line, allowing you to process the default ledger posting in a scheduled, automated, unattended mode out of hours. To run the posting process from the command line, run Exonet.exe with the /POST_LEDGERS flag, i.e.:

Exonet.exe <database> <username> <password> /POST_LEDGERS

When run from the command line, the ledger posting process uses the following settings:

• Source Ledgers Period: All Unposted

• Destination GL Period: Source Ledger Period

• Date Stamp: The date that would normally appear on the Post Ledgers to GL window (usually today’s date)

• Initials: ATO

All of the profile settings that can normally be used to control ledger posting apply when posting from the command line.

When the ledger posting process is run from the Post Ledgers to GL window, the user is prompted to copy any invalid GL accounts to the clipboard; when running from the command line, invalid accounts are sent to the event log.

When run from the command line, the process does not prompt you to print the GL Post Run Report once the process is complete.

Update to Geolocation Features

When retrieving geolocation information for an account’s Delivery Address, if a structured “official” address is found for the account, the system will now overwrite the existing address with the structured address.

Exo Business 2016.2


Resolved Issues

Exo Business Core


11094790563 110925782941 110634184864 110634568381 17729857675 13070552899 12738329021 12636730571 12056798101 11152068851 11123964691 11090707101 11276968536 14445190591 12596471111 11818891496 11818891492 11818891488 11818891482 11818891476 11818891470 11818891464 11818891458 11818891451 11819161288 11819161284 11819161278 11819161271 11561971511 11276968540 11262529793 11343131066 11343131112 11343131037 11463593473 11463593444 11463593796 11463593868 11463593693 11463593539 11463593496 11463593482 11269524119 14228996263 12370016761 11701556964 11677966803 11243689608 12495964431 14983359761 12492622451 111409284273 111372601911 12495964431 14983359761 12492622451 11049690854 114655586321 117284664641

This release updates the Purchase Order window with a new grid control, adding new functionality to the window—see page 34 for details.

11305622207 11287953316 12056904319 11305622350 11305622344 11305622331 11305622325 11305622319 11305622307 11305622313

This release displays the defined currency symbols on windows where they should appear—see page 43 for details.

11242462924 11242463028 11242462903 11649372164 15808687351 15808687377 15845366441 15845366455 15845366487

This release adds the ability to hide inactive and zero-balance accounts from the GL Trial Balance Tree—see page 41 for details.

Exo Business 2016.2


11761017082 117818923904 117818923891 113362603954 12293056374 12288245114 12288245108 12288245104 12288245088 12288245081 11848056471 11796517971 11759131051 11755532780 11674594501 11300449672 11551574541 11517822582 11505765896 11505765718 11505752601 11502576657 11492980281 11474251570 11302391114 11302391107 11302391101 11290314751 11664150135 11661460951 11766769570 11689973671 11910533309 11799442431 11769021051 11759527241 11632334502 11637130542 11629865131 11573554231 11542472702 11881899207 11877293031 11935596821 14288730151 11730075201 11770968791

This release updates the Print to File Setup window in the Clarity Report Designer, making it easier to export Clarity reports to an Excel file—see page 42 for details.

12559705511 110428551393 16043108676 12664294641 11516391200 11252027827 11245056351 12322803545 12671751744 12320631731 12741531852 12731085211 12773099966 12739937731 15977991259 112791626205 11031811231

Allocations could be incorrect when prompt payment discounts were in use: When allocating a payment to multiple invoices, if the customer had paid more than what was required, the prompt payment amount was included in the allocation, putting the allocation batch out of balance and incorrectly updating the Debtor account balance. This has been resolved.

11967018161 128254803711 124577909021 114810245861 111882191681 15580227721 12813710841 11954392552 16739104069 117735750571 16510633671 16510633659 16510633647 16510633635 16510633621

This release resolves the following issues regarding emails:

• When emailing invoices or statements from the Transaction tab of the Debtor Account Details window, the system did not use the Statement Contact specified on the Details 2 tab, if one was available.

• When emailing invoices or statements from the Transaction tab of the Creditor Account Details window, the system did not use the Remittance Contact specified on the Details 2 tab, if one was available.

• If the selected statement contact was unlinked from the Debtor account, the mailshot for Debtor statements or invoices would not use the correct email address.

12873071198 111939667438 110186832741 17539277111 19435902312 19819911191 12837745798 12908858051

When a new Contact was created from a Debtor account, the Delivery Address entered would be overwritten with the Postal Address. This has been resolved.

Exo Business 2016.2


11658229741 127918774471 11506563434 11462359321 11463594178 11517447679 11583490888

When Extra Fields were added to the Stock Search window, they would display decimal places as per the Quantities decimal place setting on the Essentials > General Settings of Exo Config. This has been resolved; the functionality of all of the various Extra … search fields profile settings has been extended to allow formatting to be specified. See “Extra Search Field Formatting” on page 45 for details.

111433080216 128654594949 119112895180 118090544411 111122159066 11846327311 13722004531

When sending creditor remittance advices using the mailshot function no CLE file was selected by default, even if one was available, which meant that users had to browse to find the CLE every time they used the mailshot. This has been resolved.

129180475312 128480458891 130264857631 130464734241 130507416391 130510832471 130635266686

It was not possible to open the Invoice Line Periscope for duplicated Creditor Invoices. This has been resolved.

11343130903 11343130681 11343130909 11343131002 118441690271

128163664608 127355264401 135727474771

When processing a Purchase Order Receipt without going through Inwards Goods, if the Allow manual entry/override of discounts on purchase order lines profile setting was enabled, the system ignored any discounts that were applied to the order. This has been resolved.

128982751000 128321016271 The system behaved very slowly when saving updates to a stock item record that had a large number of serial numbers associated with it. This has been addressed; performance has been improved in this area.

130063647971 Unnecessary document management prompts appeared when a user saved a Sales Order by clicking Save & Exit (but not when clicking Save). This has been resolved.

- In some situations, the End of Period process took a long time to complete the Debtor Allocations phase. This has been addressed; system performance has been improved in this area.

- When entering a Debtors Invoice, after using ?+TAB to select a line item, the user was returned to a new line, rather than the selected line. This has been resolved.

- On the Bank Feeds window, the Hide Transactions button was initially greyed out until the view was changed. This has been resolved.

- The Bank Feeds function added a UTC offset to 00:00:00 times, which could cause issues with date matching and bank reconciliation (at the end of month transactions for the last day of the month may appear in the first day of the next month). This has been resolved.

- Indexes have been added to the WORKSORD_HDR and WORKSORD_LINES tables to improve system performance.

- The Copy to clipboard right-click option on ExoGrids now copies column headers.

Exo Business 2016.2


Exo Job Costing


19319433929 118630037971 117073962521 113983034374 113983034361 113983034051 19228841261

When crediting a job invoice that included a retention, the retention value would be missing. This has been resolved.

15952302444 127821926836 116960145301 19379720021 15869351681

When a job line was cancelled, the GL transactions were always created in the current period, not the period in which the transaction originally took place. This has been resolved; users are asked to confirm a cancellation if the transaction’s period differs from the current period, and the period can be changed on cancelled lines if necessary.

Exo Business 2016.1


Exo Business 2016.1 The 2016.1 release is focussed on addressing items most requested by users and implementers of the Exo Business system. Some of these are entirely new features to the system; others are sometimes subtle but valuable changes aimed at further improving the efficiency of existing functionality or removing complexity. The changes are not localised; rather, they are across the scope of the entire Exo Business suite with circumspect changes in almost every area including Job Costing, CRM, Subscriptions, Serviceable Units, Enhanced POS and the Intercompany module.

New Features

Updates to Non Accounts

Active Flag

A new Active flag is available on the Non Account Details window:

This flag works in the same way as the Active flag on Debtor and Creditor accounts; if the flag is unticked, then the account is inactive, and will not appear on search windows.

Restricting the Ability to Convert Non Accounts

A new User-level profile setting is available to control users’ ability to convert Non Accounts to Debtors or Creditors. When the Allow conversion of non-accounts to Debtor or Creditor accounts setting is unticked, the Convert to Debtor and Convert to Creditor buttons on the Non Account Details window are disabled. Also, when converting an Opportunity to a Sales Order in Exo CRM, users are not asked if they want to convert the Non Account on the Opportunity to a Debtor.

Exo Business 2016.1


Composite Business Alerts

This release adds the ability to create complex Business Alert rules that reference other rules.

The Active checkbox on all rules has been replaced with a dropdown, containing the following options:

• Active – the rule will be applied to the selected event whenever it occurs.

• Inactive – the rule will not be applied.

• Sub Rule – the rule will be applied when it is used as part of a composite rule. If it is not part of a composite rule, it will not be applied.

A new “Composite (list)” type is available in the Rule Type dropdown when adding a new Business Alert. If this type is selected, the event conditions are replaced with a table where you can add existing Business Alerts and specify how they should be used together:

Click Add Rule to select an existing rule to add to the composite rule. You can select any rule for the same event as the composite rule that has its status set to “Sub Rule”.

The Operator column lets you determine whether the selected rules should be evaluated with and AND or and OR condition, e.g. if rules A, B and C are all added with the AND operator, the composite rule will be triggered if all three are triggered; if the rules are added with an OR operator, the composite rule will be triggered if any one of them is triggered.

Exo Business 2016.1


Deposits on Sales Orders in Exo POS

Exo POS now allows deposits to be entered on Sales Orders when using the shopping cart functionality.

Note: The shopping cart is available as part of Exo POS Advantage, which is a separately licensed add-on to Exo POS.

When processing the sale through the shopping cart, if any of the lines are marked as “Order”, a new Deposit column will be available on the payment screen:

This column can be set to “Yes” to indicate that a payment line is a deposit on the order. When the Sales Order is saved, the payment will be recorded as a deposit:

Exo Business 2016.1


Documents on Works Orders

The Works Orders window now has a Documents tab:

This tab behaves in the same way as the Documents tabs that are available on other records. You can add and remove documents using the standard document toolbar buttons, and you can attach a document by dragging and dropping it onto the Documents tab.

Line Ordering on Subscriptions

It is now possible to control the order of line items on subscriptions. New arrow buttons are available on the Subscriptions window to move line items up or down:


Resolved Issues

Exo Business Core


127043737215 126783397985 Originally resolved in Exo Business 2015.5.1

The Generate Credit right-click menu option on the Transactions tab of the Debtor Account Details window did not create a stock transaction to put the item back into stock on hand, as it was incorrectly processing it as a credit for a job proforma invoice. This has been resolved.

14412592512 14351984481 14351984573 14351984567 14351984561 14351984549 14351984535 14351984521 14351984497 14351984481 12373995217 125014104018 116264485851 12364823431 11186846746 11220411631 11184069761 127194475338 127194475221

This release adds an “<All Branches>” option to the Branch dropdown on the Direct Debits window:

11803439395 111939667414 12700864671 11893574491 11799532561 11613472532 11993539759 11965022036 15073330633 111400765381 15005906264

This release addresses issues with the Variable Cost function of Stock items:

• The Variable Cost function was only available in Debtors invoicing and Exo POS; this release adds the function to Sales Orders.

• The Variable Cost function did not work for freight lines where freight was a Variable Cost item. This has been resolved.

111689051292 111528117776 117883964111 121130678591 126631146848 126631146861 126631146888 126631146912 126631146833 126631146874 126631146925

The mailshot function on the Invoice Batch Printing window did not use the invoice form file logic; it always used Invoice.clf, instead of Invoice1.clf, Invoice2.clf, etc. as appropriate. This has been resolved.

114492956835 114472037891 114472037904 114472037917 114472037929 114472037941 114472037953 114472037965 114472037977 114472037989 114472038001

When a .SAM report was saved from the Sales Analysis Designer, if the report included an In List filter of string values, extra quote marks were added around the values, which meant that the report returned no data when run. This has been resolved.

Exo Business 2016.1


11986061645 11285627030 11285627110 11944007881 12232347031 12995696679 114995966216 114810018764

The Inwards Goods Costing window did not update the Sup Price column when a discount was applied. This has been resolved.

14719339707 14428321001 11573886228 11561970537

On the Transactions tab of the Stock Item Details window, right-clicking on a transaction and selecting View Source Transaction did nothing if the transaction was a Works Order transaction. This has been resolved.

114995966216 114810018764 This release adds the ability to show a Sup Price FOREX amount in the summary bar at the bottom of the Inwards Goods Costing window.

18462630037 16749762871 When performing a bank reconciliation, the prompt for allocations only appeared when processing a refund. This has been resolved; the prompt now appears for positive and negative transactions.

127869146136 128305558701 127733788861

When using the Integrated Cashbook in a company that uses foreign currencies, the GST rate column was mislabelled Ex Rate. This has been resolved.

- When checking for pending applications in Bank Feeds, the error “Unable to load bank feed data due to invalid login information. Unauthorized to access this Bank Feed error 404.” always appeared if there were no applications pending. (The error did not occur once an application had been entered.) This has been resolved.

- Negative stock checks on Sales Orders ignored the location(s) on order lines and only used the header location, which could result in incorrect negative stock warnings if the locations differed. This has been resolved.

- Some of the error messages that can appear on the Sales Orders windows have been re-worded to make them more descriptive of the problem that triggers them.

- When entering a Creditors Invoice, if the selected Creditor account has its Default Invoice Mode set to “GL” and a default GL code specified, then the GL code would be automatically populated on the Creditor Invoice Entry window. In previous versions, this auto-population would occur for the first line on the invoice only; as of this release, the default GL code is now populated automatically for all lines added to a Creditor Invoice.

- When creating transactions in the Integrated Cashbook, if the Enforce transaction period dates during invoice entry profile setting was set to “Do not Enforce”, transactions with a date outside the range of the selected period would have their period changed to a period within the specified date range, i.e. the system behaved as though the profile setting was set to “AutoEnforce”. As this happened after any validation had taken place, it was possible to post a transaction to a locked period. This has been resolved.

Exo Business 2016.1


Exo Job Costing


12138661472 12137672912 12352737621 17475755241 16933645116 12676494441 111821902431 114730137754 127150997184 13721546961

The Serviceable Units search window now includes an option to exclude inactive units:

18848223214 111741361184 17993841101

When the Prevent processing to negative stock levels profile setting was enabled, negative stock checks on jobs only looked at individual lines, and not the job as a whole, which resulted in incorrect negative stock warnings in cases where stock items were added and removed and the net effect was positive stock. This has been resolved.

120687070584 119869557601

Converting stock items to a serialised output item in Job Costing generated the error “Error ExistingSNQuery: Duplicate index name 'Filters'”. This has been resolved.

Exo Intercompany


112400868583 124254367911 122185905031 112389940631 15467655461

If a GL journal transaction from the previous financial year is entered into an Exo Intercompany source database, and this transaction affects the profit or loss for that year, then the previous year’s profit figure (retained earnings) in the balance sheet needs to be adjusted by that amount.

When this transaction gets replicated to the consolidation database, it is inserted into the period corresponding to the transaction date (the financial year may be different in the consolidation database). If, when this transaction is inserted, it corresponds to a prior year, it too needs to create a retained earnings adjustment in that database; however, in previous versions, the system did not do this. This has been resolved; retained earnings adjustments are now created as they should be.

18040257672 122023603501 17825794241

In some cases, Creditors invoice suspended batches in a source database were entered into an incorrect period in the consolidated database. This has been resolved.

Exo Business 2016.1


Exo CRM


11782247028 17965243131 12983805061 11770969611

This release adds the ability to restrict users’ access to the Convert to Debtor or Convert to Creditor buttons on the Non Accounts window—see page 51.


New Profile Settings

Added in 2016.1

Name Profile Name Level Description Default

Allow conversion of non-accounts to Debtor or Creditor accounts

CRM_CANCONVERT_PROSPECTS User If this setting is disabled, users will not be able to convert Non Accounts to Debtors or Creditors.

Enabled

Added in 2016.2


Extra … search fields

User For all of the profile settings that allow extra fields to be added to a search window, an extra parameter can now be specified to determine the formatting to apply to each extra field.

Use old purchase order screen PURCHORD_USE_OLD_FORM User If this setting is enabled, the old Purchase Order window will be used. If it is disabled, the new Purchase Order window with enhanced grid functionality will be used.

Enabled

New Profile Settings


Added in 2016.3


Idle session timeout period in minutes

IDLETIMEOUT User Users are logged out if they remain active for the entered amount of time entered here (in minutes). If a value of zero is entered, no idle timeout will be applied.

0

Suppress contact history notes CONTACT_HIST_SUPPRESS_ ACTIONS

Company Specify the actions for which history notes should not be created. Enter one or more of the following options:

• L – Suppress history notes when adding or removing contacts from CRM contact lists.

• I – Suppress history notes when emailing invoices to customers.

blank

Verification of the ABN against online resources

ABNCLOUDVALIDATION User Choose whether or not to verify ABNs entered for Debtors and/or Creditors using the MYOB’s online service.

Debtors and Creditors