FoxPro Purge Data for Migration
This document outlines all data purged as part of your Ezy Wine Pro migration.
The standard data retention period is seven years, unless advise otherwise. Historical records will continue to be retained and can be accessed through your existing Ezy FOX database.
This purge is an important step to help maintain optimal system performance.
Below is the list of purged items
System Audit Trail/Log – delete all entries older than 2 years
Menu Access Log - delete all entries older than 2 years
F5 Notes – delete all entries older than purge date
EFT (Creditor, Payroll, Growers) – delete all entries older than purge date
Bank Deposits – delete all entries older than one year
Sales Invoice History – delete all entries older than purge date
Sales Credit Note History – delete all entries older than purge date
Sales Order History – delete all entries older than purge date
Mail Order Sales History – delete all entries older than purge date
Cellar Door Sales History – delete all entries older than purge date
Service Invoice History – delete all entries older than purge date
Sales Analysis – delete all entries older than purge year
GST Register History – delete all entries for BAS date older than purge date
WET Register History – delete all entries for BAS date older than purge date
Sales Budgets – delete all entries older than purge year
Sales Forecasts – delete all entries older than purge year
Purchase Order History – delete all entries with order date older than purge date
Stock Movements History – delete all entries with date older than purge date, created an opening balance record where necessary.
GL History and Balances – delete all entries older than purge year, creating an opening balance record where necessary.
GL Budgets – delete all entries older than purge year
GL Forecasts – delete all entries older than purge year
Debtor History – delete all entries with date older than purge date, created an opening balance record where necessary.
Creditor History – delete all entries with date older than purge date, created an opening balance record where necessary.
Payslip History and Balances – delete all entries older than purge year
Leave Audit Trail – delete all entries older than purge year
Bottling History – delete all entries with run date older than purge date
Weighbridge History – delete all entries older than purge vintage
Grower Deliveries – delete all entries older than purge vintage
Grower Ledger – delete all entries older than purge vintage
Levy Rates & Dates – delete all entries older than purge vintage
Payment Terms – delete all entries older than purge vintage
Grower Payment History – delete all entries older than purge vintage
Bulk Receival History – delete all entries older than purge date
Bulk Despatch History – delete all entries older than purge date
Cellar Worksheet History – delete all entries older than purge date
Crush History – delete all entries older than purge vintage
Wine Composition History – delete all entries older than purge date
Vessel Analysis History – delete all entries older than purge date
Vineyard Operations History – delete all entries older than purge date
Vineyard Analysis History – delete all entries older than purge date
Debtors – Delete debtor with no current transactions or history with commencement date prior to purge date. Includes deleting delivery address and messages.
Stock Items – Delete stock items with no current transactions or history with creation date prior to purge date. Includes deleting units, prices, discounts and packaging specifications.