We have important changes to our email addresses that you should be aware of, please click here to find out more.

Kindly Note: Our support desk will be closed from 2pm (SAST) on Thursday 12 December 2019.  Click here for annual company and support desk closure dates and times  Access our knowledge base for further assistance.

CaseWare Working Papers | What to do when a Btrieve error 20 (002) appears when importing from Pastel?

Published:  22/11/2016
When I import from Pastel into CaseWare Working Papers, I get a ‘Btrieve error  20 (002)’, how do I resolve this?


Solution 1

The first solution would be to re-install the updated version of the Pervasive Software. CaseWare Working Papers enables you to import your Trial Balance from various accounting software packages. With Pastel Trial Balances, you don't need Pastel installed on your PC. All you need to import a Pastel Trial Balance into CaseWare Working Papers is to have the Pervasive software installed.

Solution 2

As an alternative, you will need to export the trial balance from Pastel into Microsoft Excel then import from Microsoft Excel by following the steps below:
1. On the CaseWare interface, select ‘Engagement’ then ‘Import’.
2. Select ‘Excel File’ as the source of the import.

User-added image

3. Browse to where the Excel file is saved then click on ‘Next’.

User-added image

4. Deselect the rows you are not using such as table headings and totals then click on ‘Next’.

User-added image

5. Select the account number, account description and the balances by right clicking on ‘ignore’ on the relevant columns in order to label the columns. Then click on ‘Next’.

User-added image

6. Under advanced specifications, tick next to ‘Clear balances of periods being imported’.

User-added image

7. Click on ‘next’ then ‘import’.
(Popularity = 21/100, Rating = 0.0/5)

Didn't find what you were looking for?

Watch a video

Check out our helpful video guides

Contact Support

Contact our support team
CaseWare and the CaseWare logo, are registered trademarks of CaseWare International Inc. and are licenced for use to CaseWare Africa and Adapt IT. © 2018. All rights reserved.

For more information, visit www.casewareafrica.co.za

If you would like to keep up to date with the latest CaseWare Africa news:

For South Africa clients follow us on:
LinkedIn   Twitter   Facebook   YouTube  

For Nigeria, Kenya, Mauritius and the rest of Africa you can connect with us on:
LinkedIn   Twitter   Facebook   YouTube
Copyright © 2019 | All Rights Reserved