Skip to main content
Skip table of contents

Error: "Tax Reconciliation report shows #ERR..."

This support note applies to:

  • AE Reporter (NZ)
Article ID: 38600

In MYOB Reporter version 3.4.300 in the Reporter Year 2016 for the Entity Type Charitable Trust or Incorporated Trust, you may experience the Tax Reconciliation reports shows #ERR instead of the line "Net Surplus Subject to Taxation".

To resolve this issue update the format of the Taxation Reconciliation - Trusts (Internal Use Only) to have the following for Cell A9:


 =IF(AND(B9<=0),IF(AND(DB.EntityDetails.ClientDetails.EntityType<>"Charitable Trust",DB.EntityDetails.ClientDetails.EntityType<>"Incorporated Society"),"Net Profit Subject to TaxationNet Surplus Subject to Taxation"), IF(AND(DB.EntityDetails.ClientDetails.EntityType<>"Charitable Trust",DB.EntityDetails.ClientDetails.EntityType<>"Incorporated Society"),"Net Profit (Loss) per AccountsNet Surplus (Deficit) per Accounts"))

To open Design Practice Reports refer to Accessing Practice Level Report Designer

To amend the format

Perform the following steps in Design Practice Reports.

  1. Click the Formats tab. The list of formats displays in the left hand pane.
  2. Double click on Taxation Reconciliation - Trust (Internal Use Only). The format opens in the right hand pane.
  3. Navigate to Cell A9 and enter the following: =IF(AND(B9<=0),IF(AND(DB.EntityDetails.ClientDetails.EntityType<>"Charitable Trust",DB.EntityDetails.ClientDetails.EntityType<>"Incorporated Society"),"Net Profit Subject to TaxationNet Surplus Subject to Taxation"), IF(AND(DB.EntityDetails.ClientDetails.EntityType<>"Charitable Trust",DB.EntityDetails.ClientDetails.EntityType<>"Incorporated Society"),"Net Profit (Loss) per AccountsNet Surplus (Deficit) per Accounts"))  
  4. Save and close the format and close Report Designer.  

 

 

MYOB INTERNAL STAFF ONLY

Insert PR# 143197015640

SR#  142846672518

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.