Skip to main content
CCH Software User Documentation

Converting Accounts pages from VAP: Automatic changes

  1. Last updated
  2. Save as PDF

Product Help Banner.png

 

After linking CCH Trust Accounts to CCH Central, the user can convert a client from CCH Accounts Production (VAP) to CCH Accounts Production.

This section describes changes that are made automatically when an accounts page is converted.

Summary

Detail

Adding =AP(“”) or TA(“”)

TA(“”) is only used for the sched command

Adding styles

VAP supports direct cell formatting, but in AP every cell has a style that determines the cell format. The conversion adds styles automatically, although some manual changes may be required (see below).

Updating PageRange commands

VAP supports commands such as =PageRange,4,0. The parameter 4 means the fourth page in the page index. AP does not support this syntax. So the conversion changes the command to =AP(“PageRange,page4acc,0”) automatically. However this change only happens if a whole client is being converted. If an individual page is being converted using Browse to Format then the page references will need to be updated manually.

Replace #total commands

They are replaced with SUM() commands where possible.

Replacing schedpagerange commands

AP does not have a schedpagerange command. So the conversion converts the command to =AP(“PageRange,pagesched,0”). Note that it assumes the investment schedule page is called PAGESCHED. If not, the commands will need to be amended manually.

Convert =RangeDef,0020..005Z,,a,-1,0,ab

To

=AP(“RangeDef,0020,005Z,a,-1,0,ab”)

AP does not support the “..“ syntax within a RangeDef.

Convert:  =a,6051+a,7051

To: =AP(“(a,6051+a,7051)”)

The extra brackets are required as explained in the Differences from VAP.

Convert: =be2,#1 #2

To: =AP(“be2,#51 #52”)

The field codes for Personnel have changed as explained in Contacts.

Convert : =pr24,... to: =AP("#de1,...")

Convert: =#te2,... to =AP("#pe2,...")

 [ Estates only ] The formulae for the deceased and for personal representatives are different in AP from VAP. 

Convert Enhanced text to merged cells

AP does not have the concept of Enhanced Text, but supports merged cells like Excel.

Convert: {LastPage}

To: {LastNotePage}

 AP does not support a LastPage command.

Convert certain ‘DST+1’ formulae

To using Excel date arithmetic		 [ Estates only ] VAP supported a date format of ‘DST+1’ meaning to add 1 on to a day. This was used on the Income Accounts to calculate the period start date as one day after the previous period end date. This is converted to a rather complicated expression using Excel date formulae. This conversion is only performed if the headings match the CCH master headings.

Contacts

For a trust or probate client, the different VAP Contacts are converted as follows:

Type in VAP

Relationship in Central

Example Formula

Settlor

Has settlor of

=AP("#st1,#51 #52")

Where #st1 is the first settlor, #51 is the first name and #52 is the last name.

Accountants

Has auditor of

=AP("#au1,#2")

Where #2 gives the Pre Name and Main name

Trustees

Has trustee of

=AP("#te1,#51 #52")

Beneficiaries

Has beneficiary of

=AP("#be1,#51 #52")

Solicitor

Has solicitor of

=AP("#so1,#2")

Banker

Has bank/(bs) of (accts prod)

=AP("#bk1,#2")

Investment Advisors

Has investment advisor of

=AP("#ia1,#2")

Other Advisors

Has other advisor of

=AP("#oa1,#2"). See also Contacts.

Deceased

Has testator of

=AP("#de1,#51 #52")

Personal Representatives

Has personal representative of

=AP("#pe1,#51 #52")