<< Click to Display Table of Contents >> Navigation:  HearAid On-Line Help > Frequently Asked Questions > Removing Claims Prepared Automatically in Advance

You can remove the automatically generated claims using a SQL script in Database|Query, which identifies maintenance claims with service dates after a defined date

1.Have all other users exit HearAid

2.Make a fresh backup of your database by opening HearAid then exiting immediately, making a backup as you exit

3.Log in to HearAid using the SYSDBA username and password

4.Select Database|Query

5.Click the New Query button

6.Copy the following text into the editor

   DELETE FROM

     CLAIMS

   WHERE

     (SERVICE_DATE >= '2020-10-01') AND

     (ITEM = '777') AND

     EXISTS

       (SELECT

          *

        FROM

          CLAIMS C

        WHERE

          (C.ITEM IN ('700', '710')) AND

          (C.SERVICE_DATE = CLAIMS.SERVICE_DATE) AND

          (C.CLIENT_PK = CLAIMS.CLIENT_PK));

   DELETE FROM

     CLAIMS

   WHERE

     (SERVICE_DATE >= '2020-10-01') AND

     (ITEM IN ('700', '710'));
 

7.Change the cut-off date by editing the dates shown in bold red above... in the example shown, the cut-off date is 1 October 2020

8.Click the Execute SQL button

9.Install the fee update and then re-run the auto-maintenance function

You will also find a copy of this script in ..\HearSoft\HearAid\Reports\SQL\Remove Maintenance Claims.sql