Skip to main content
CCH Software User Documentation

CCH Audit Automation (SQL) - Known Issues

  1. Last updated
  2. Save as PDF

userdocs-productinformation-page-header.jpg

 

CCH Audit Automation (SQL) - Known Issues

Last update: 16 Sep 2022

Date Raised ITS Description Workaround (if applicable) Scheduled
/Resolved
May 2023 66656 Upgraded to 2023.100 the client list appears as normal and then resizes the window and zooms out the text. Once the windows is set to full size again the font size is really small ie it remains zoomed out, even when in the client
 		 Recommendation is to set the display to 100% and the display resolution to 1680 x 1050.

If this does not work may be take a look at the KB article below to see if it helps at all.

https://help.wolterskluwer.co.uk/Cus...he-information
 		 TBC
Feb 2023 66565 Data conversion from BDE to SQL crashes when converting a document with Pivot tables The workaround is to remove the document before conversion N/A
Feb 2023 66553 In this scenario;
The user has balanced forward a client and changed the master pack from IMER17 to 18. Then some of the documents (not all - and any doc type like Word, Excel or PDF) cannot be accessible on the current year with the error;

Access violation at address 11EF4390. Read of address 00000000.

Previous year documents are accessible

Run a query to check if there's document on Central database, but script returns the result with these document references and names

Check out not possible with some error;

2023-02-01 09:48:43,805 [1] ERROR AuditAutomation.COM.AuditAutomationExport - CheckOutDocument failed:
System.NullReferenceException: Object reference not set to an instance of an object.
at CCH.DM.Gateway.Importers.DMFacade.CheckOutDocument(String filepath, Int32 contactId, Int32 docId)
at AuditAutomation.COM.AuditAutomationExport.CheckOutDocument(String fileName, Int32 contactId, Int32 documentId)

It looks like that when balancing forward, document metadata was copied from previous year but document itself was not copied



 		 The work around is to delete the current period and roll forward again TBC
Feb 2023 66548

Issue with risk mitigation tests in identified risk

In Identified audit risks – if you select a risk and go to the Residual risk covered by sampling box at the bottom, there are no tests listed.

However if you click on pool the test you want it is already ticked and the tick box is greyed out and you can’t add it.
There are also other tests already ticked and if you wish to remove them you can’t either.
So if there’s no other test you wish to add than the ones already ticked you get a waning that no procedures have been selected.
If you go to risk mitigation tests in the current audit file, these tests are there.


There is a work around to remove the partly linked work programme; from the main identified risks window, highlight the risk (but not clicking into it), select "work programme" at the bottom, then remove the linked tests.
Then click into a specific risk, select residual risk covered by sampling, then click work programme from within the specific risk window. After re-linking the desired tests, the system should now properly recognise the programmes selected
 		 TBC
Feb 2023 66546 On the main index clicking on Key Accounting Estimates data base opens Idenitfied audit risk database
Another way to access this is from Planning > Risk Analysis > KAE - this works on MERCHA16
TBC
Feb 2023 66543 Cannot sign off planning as getting error "No procedures planned for Risk X: [name of risk ] Control Risk, but control risk is set to N/A There is a workaround to fix the issue.
  • The user with the MNGR account must logon to AA
  • Change the System Options settings.
  • Untick the Assess risk level on identified risks.
  • The user can sign off all the clients in the new MP which had the issue.

Note: The user need to revert the tick box, once the plannings have been signed off.

 TBC
Feb 2023 66545
This seems to occur when one updates the master pack from IMER17 to IMER18.
Not only is one unable to add a selected test from the Pool to a Key Accounting Estimate but the Pool seem corrupted with no numbering in the test.
The error message that appears is:

---------------------------
CCH Audit Automation
---------------------------
The statement has been terminated.

Cannot insert the value NULL into column 'TestLevel', table 'Central.AA.AccountingPeriodPoolTestHierarchy'; column does not allow nulls. INSERT fails.
---------------------------
OK
---------------------------

 
The work around is to use ADD button on the Pool of Tests dialog to create a test
TBC
Feb 2023 66557 2022.320 PAAPCH16
When a pack has been updated to PAAPCH16 there appears duplicated mandatory procedures for area D, Goodwill and area H, Financial instruments.
 		 Script fix available 2024.1
Jan 2023 66492 In audit pack based on PCASAD10 Master pack it is not possible to sign off as partner on the completion menu.
A script exists to resolve this issue. This script removes the word Partner from the newly added Second Partner Review area in the master pack
2024.3
Dec 2022 66481 After update to 2022.320 why is the conversion routine from the BDE version of the software failing?

Please apply the fix in the KB article

https://help.wolterskluwer.co.uk/Cus...ftware-failing

 2023.1
Dec 2022  

When using the master pack merge routine the following error message may appear when loading the data for each area:

clipboard_e81dcab4a4fda9213011f9c0a34f81617.png

 

 This message can be ignored, clicking continue will close the message box and the merge routine will continue. 2024.1
Oct 2022   PCAS master pack - area names missing from identified risks when moving to IPCAS17 When moving to IPCAS 17, due to a change in the master pack if any risks were linked to financial statement areas that have now been removed from the master pack the name of the area will no longer appear in the identified risk. Remove the area from the risk and link it to a new area. N/A
Sep 2022  

Travelling from audit will result in the following error:

 

clipboard_e1ef1177a90cf0480ef85a34798df553c.png

The plugin required to load the client data for travelling is being loaded at the point that travelling is started. It is taking several minutes to load the plugin before travelling can place. After trying to travel for the first time waiting for the plugin to load and then trying to retravel will resolve the issue.

Alternatively traveling the client from central instead. Once travelled you will be able to access the client data via logging into audit in the normal way.

 

 2023.1
Sep 2022   Logging into offline mode In some scenarios the local database data path may not be set up by the software automatically. If this is the case the user will be asked to provide the database connection details the first time they try to log into the local database. Select the Server name from the drop-down list, select windows authentication and then the CCH_Offline database from the available database name drop down list.
clipboard_eccf9712684429ef5ed08b690e8ca1947.png

 

 

 

 

 

 

 

 

 
Sep 2022   Unable to start document management service If both CCH Central and CCH Audit Automation are opened when either of them are already running or if either is opened twice the user will be presented with the following error message.
clipboard_e4467d58163af0aa153ca2774adf5362d.png
The message can be ignored as the local document manager service is already running.		  
Sep 2022   Travelling Limitations – Corporation Tax Data In some scenarios the local database data path may not be set up by the software automatically. If this is the case the user will be asked to provide the database connection details the first time they try to log into the local database. Select the Server name from the drop-down list, select windows authentication and then the CCH_Offline database from the available database name drop down list.  
Sep 2022   Synchronising travelled data Client data that is travelled from CCH Central must be synchronised back to the office database from the offline database. Failure to do this will result in documents not being correctly uploaded to the office database.  
Sep 2022   Network at client log in When using the network at client log in the target machine's firewall must allow inbound connections for the machine to be visible on the list of available connections.  
Sep 2022   Deleting a client from CCH Central When using the delete client option from CCH Central the documents attached to the audit periods are left as orphaned entries in the document database. When removing a client from central the audit periods should be removed first from audit as this will correctly delete the audit documents.  
Sep 2022   Error when opening MS Word documents Some users have reported the following error message appearing when opening MS Word documents.
clipboard_ed13550743dc7dc5d7a544c4966a4d5a7.png
The issue is caused by the trust settings in MS word and can be fixed as follows:
  • Open Word and browse to the Trust Canter tab from the options menu and open the Trust Centre Settings.
    clipboard_ed0f185446fe55cd4705ddd348efe8e19.png
  • Open the Trusted locations tab and click Add new location.
    clipboard_eba5dfcb4d69ce0178b0ba6d3b7d5e3fe.png
  • Add the location of where the documents are downloaded to and check the option for Subfolders of this location are also trusted and select Ok
    clipboard_ef81531d7b3b72e82318ae3a4fc40e54d.png
  
    When importing a TB from CCH Accounts Production to CCH Audit Automation (SQL) by 'Update from CCH Accounts' option at Data Entry tab - only the current TB is available and the previous year TB is not imported. If you can find only current year TB and you cannot find prior year TB, then please export the TB file as a .csv file and import it into CCH Audit Automation (SQL).  
    Why is there a ? sign instead of the £ sign in my lead schedule? To fix this please load the client and go to File > Control > Control Data > TB Control tab > change the sign in Reporting Currency > OK

Note: There is no fix at master pack level, each client which displays the wrong sign will need to be updated accordingly.		  
July 2020  

In some scenarios the local database data path may not be set up by the software automatically.

If this is the case the user will be asked to provide the database connection details the first time they try to log into the local database. Select the Server name from the drop-down list, select windows authentication and then the CCH_Offline database from the available database name drop down list.

Logging into offline mode.png

 
July 2020  

Could not start local Document Management service
Could not start local Doc manager sce.png

If both the Central and Audit Automation are opened when either of them are already running or if either is opened twice the user will be presented with the error message above.

The message can be ignored as the local document manager service is already running.

  
July 2020  

In some scenarios when travelling a client that contains Corporation Tax, Accounts Production and Audit Automation data. If all three products are travelled the amount of data to be travelled may become too large and cause the travelling to fail.

    
July 2020   Client data that is travelled from central must be synchronised back to the office database from the offline database. Failure to do this will result in documents not being correctly uploaded to the office database.    
July 2020  

When using the network at client log in the target machine’s firewall must allow inbound connections for the machine to be visible on the list of available connections.

    
July 2020  

Error when opening word documents
Some users have reported the following error message appearing when opening word documents.

AA word issue1.png
The issue is caused by the trust settings in MS word and can be fixed as follows:
  • Open Word and browse to the Trust Center tab from the options menu and open the Trust Centre Settings.

AA word issue2.png

  • Open the Trusted locations tab and click Add new location.

AA word issue3.png

  • Add the location of where the documents are downloaded to and check the option for Subfolders of this location are also trusted and select Ok

AA word issue4.png

  
    Opening Excel Workbooks
Some users had reported that when opening an excel workbook any existing workbooks would be closed by the software.		 This issue has now been resolved. Nov 2020
    Main Index
Previously when changing the master pack, the audit period was based on the main index was not loading correctly.		 This issue has now been resolved. Nov 2020
   

Reset user count
Previously when resetting the user count in some cases the users were not removed from the audit period.

 This issue has now been resolved. Nov 2020
    The audit client data converter routine should be forcefully closed via the task manager when performing multiple client conversions.    
    If a document is password protected the conversion will pause until the password is entered or the cancel button is selected.    

Useful Information! Join the CCH Audit Automation 'Group' on our Support Portal for automatic 'Posts' relating to CCH Audit Automation (SQL).

 

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Article type
    Topic
    Product
    CCH Audit Automation
  2. Tags
    This page has no tags.