Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #31211

    Good morning.

    Due to a change in upcoming circumstances we would like to reset all patients financial info to zero. Outstanding, in credit, payment history, every thing back to zero.
    Just like we had done a fresh install of CoV4 but without loosing any of the patients other details, such as patient number, address, phone etc.

    Thanks in advance



    Hi – thanks for your post. Please follow these steps :-

    [1] Click TOOLS | Backup Database to take a backup of your database before you start 🙂

    [2] Click TOOLS | Check for Program Updates and make sure that your installation is the latest version

    [3] Click TOOLS | Advanced DB Operation and then copy and paste the following code into the box :-

    delete from inv;
    delete from invline;
    delete from refund;
    delete from pay;
    delete from credit;
    delete from creditline;
    delete from alloc;
    delete from po;
    delete from poline;
    delete from charge;

    *** IMPORTANT *** Make sure that you UNTICK the “Can Adjust SQL” box

    [4] Click the EXECUTE button

    The above steps will remove all financial data from your database.


    Great, thanks for that.

    Now just got to remember to back the database up :-“

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.