How to reference the ABN number using Connector

CaseWare Connector allows users to connect to most of the Engagement Properties' fields in CaseWare Working Papers.

However, one field is currently not available to select in CaseWare Connector, is the E.I.N / BN field. This field is used for the ABN in our Financial Statements.

To reference to this field, the following formula can be entered: =cw_clp("clp253")

• Related Articles

• What is CaseWare Connector

  Connector is an add-in for Microsoft® Word and Microsoft® Excel® that enables you to link data between Working Papers and Microsoft documents. The Connector Add-in appears as its own toolbar in Microsoft® Word and Microsoft® Excel®. Using ...

• Connector Getting Started 1: Basic Connector Linkages

  Within minutes of watching the Caseware Connector Getting Started videos, build simple automated Excel® Working Papers and link up Word documents to Caseware engagement data. 

• How do I modify a Connector formula or link?

  You can edit formulas to modify or correct Connector links in Word or Excel documents. Prerequisites Ensure Connector can establish a connection to the source client file. Procedure This procedure is different for DDE links and UDF links. UDF Select ...

• CaseWare Connector linkage to worksheet error: #NAME

  When your linked worksheet within CaseWare defers to #NAME, it is an indication of a problem with CaseWare Connector.  1. Open Excel. Look for the 'Add-Ins' tab in the top ribbon. If the Add-Ins tab is there, then proceed to Step 2. If the Add-Ins ...

• How do I format Connector values in Microsoft Word

  Transform Caseware Connector values in Microsoft Word by adding custom character formatting to the cell calculation. This can be used to present numbers in a neater presentation, such as 10000 to $10,000.00. 1. Insert data by selecting the Caseware ...