Stage 5: Doing housekeeping in Opera 3 (Visual Foxpro database or Opera 3 SQL)

What you need to do

In this stage, you should consider doing 'housekeeping' on the existing Pegasus Opera 3 (Visual Foxpro database) or Opera 3 SQL data before migrating the data to Opera 3 SQL SE.

 This can be done at any time before migrating data to Opera 3 SQL SE.

Prerequisites

Actions - Housekeeping routines

It is recommended that these housekeeping and period end processes are run in the latest version of Opera 3 (Visual Foxpro database) or Opera 3 SQL before the migration:

  1. Install the latest version of Opera 3 (Visual Foxpro database) or Opera 3 SQL, depending on the software being used. That software should have been downloaded as part of Stage 2: Installing server software.

  2. Log on to the latest version and complete the housekeeping routines listed below.

These processes may take some time to complete. Some also change accounting period so should be done only at the relevant time. Please read the relevant help topic for details.

Module

Menu

Command

 

System

Utilities – Reorganise System Files

Delete VAT history

Sales

History – Action – Tidy History

Remove data

Sales

Utilities 

End of Period

Purchase

History – Action – Tidy History  

Remove data

Purchase

Utilities 

End of Period

Nominal

Utilities 

Period End

Cashbook

Utilities

Reorganise

Costing

Utilities

Reorganise

Stock

Utilities

Period End

SOP/Invoicing

Utilities

Reorganisation

POP

Utilities

Reorganise

Next Stage

After completing this stage, follow stage 6 to migrate company data from Opera 3 (Visual Foxpro database) or Opera 3 SQL.