Page Comparison - Linking to references in external documents (v.4 vs v.5) - PS Help: Client Accounting Help

HTML Wrap

class	section group

HTML
<span data-swiftype-index="true">

This feature does not support password protected files. Only the Entire document reference option is available.

HTML Wrap

class	col span_3_of_5

When you link a PDF file or Excel spreadsheet, you can specify the PDF bookmark or Excel worksheet as a reference.

References are bookmarks in PDFs and, from AE/AO version 2017.1, worksheets in spreadsheets.

UI Text Box

type	note

You can link to worksheets with Excel 2013, Excel 2016, and XLS, XLSX and XLSM file types

are supported for adding Excel spreadsheets with references

.

UI Text Box

type	note

In password-protected files, you can only link to the entire document, not to references in the document.

To use bookmarks when linking the document, make sure you've added bookmarks to the document before you start. For example, using PDF Manager, you can save the bank statement and asset purchase contract as one document with bookmarks for each section. You can then link the bookmarks to specific accounts in the Trial Balance (Workpapers). From AE/AO version 2017.1, you can also link to spreadsheet worksheets.

UI Expand

expanded	true
title	To link to specific

references

bookmarks in an external document

Open the workpapers period. See Opening an existing period. The Prepare Trial Balance (Workpapers) table is displayed

Go to the client’s Client Accounting > Trial Balance (Workpapers) tab and click a period in the Select Period section.
On the TASKS bar, click Open Period. The table for the period appears.
Select the detail or header account in the table

.

, or

Click

select the checkbox in the first column for the selected account.

Click Link document on

On the TASKS bar

.

UI Text Box

type	tip

Another way of linking an external file to a selected account in the table, right-click and select Link document.

The

, click Link Document. The Link External File window

opens

appears.
Ensure that the correct account is displayed in

the Account drop-down field

the Account field.

Click Browse in

In the Select external file

section

section, click Browse. The

Attach

Attach External

File

File window

opens

appears.
Navigate to the location where the PDF file is stored and find the file.

Click

Ensure that the path and filename in the File field are correct.

If you are linking to a specific PDF bookmark or Excel worksheet, select the reference from the Reference drop-down.

If the external file does not contain any references, then a link will be created to the Entire Document.

The Document name field is automatically filled with the name of the file that is to be linked to the period. If you are linking to a PDF bookmark or Excel worksheet, then the bookmark/worksheet name enclosed in brackets is added as a suffix to this value. You can change this value by deleting the existing text and entering a new Document name.

Click Open.

UI Text Box

type	note

If the Document name is already in use, a message will appear asking if you wish to add the document with a suffix attached. If you click OK, the document will be automatically added to the account.

Select the Rollover this document to the next period checkbox. This will

If your document is a PDF with bookmarks or a spreadsheet with worksheets and you want link to a specific bookmark or worksheet, select the bookmark or worksheet from the Bookmark or Reference drop-down list, depending on your version. Otherwise the link will be to the entire document.
UI Text Box
type note

The Document name must be unique. An error message is displayed if the Document name is already in use.

Linking to worksheets using the Reference column is available from AE/AO version 2017.1.
If you want to include the document in the next rollover period, select the Roll forward checkbox. During rollover, the previous

workpapers

workpaper period is used as a base.

If this option is selected the

The link to the document will be recreated and included on the same account in the next period.

Click Preview.

If you

are linking to a specific PDF bookmark or Excel worksheet, the file opens at the specified reference. If you are linking to the entire file as it does not have any references, then the document opens at the first page. Preview the displayed information and check that the reference is correct.Click

want to check that the link opens correctly, click Preview and close the document when you're done.
Click Link. The external file is linked to the selected account. The

external file is