SA Sales Data Removal (SAU890)

Use this program to periodically purge Sa data from your files to limit file storage requirement so you do not exceed your disk space usage .

If your system is running a Providx database instead of using an SQL database, running this program will not get rid of files. Running the purge does not shrink files table structure but removes the data to make room for new data.

When you run this program, it removes the period records in each file according to user input. You can create a template so that this data does not have to be entered every time the program is run.

For each file that is set up in the SA Static Control record as being used, you can the number of periods to retain this information. Each SA data file can have a different number of periods to store the information. The program will remove the records that are older than the number of periods selected.

The Commission File is not affected by the End-of-Period Update. The commission file is cleared by the optional update at the end of the Commission Report.

Use the following fields to close out the current period in sales analysis:

1. Branch Data

Enter the number of periods to retain sales information by branch. Press F1 or to retain all periods of information.

2. Customer Data

Enter the number of periods to retain sales information by customer. Press F1 or to retain all periods of information.

3. Salesperson Data

Enter the number of periods to retain sales information by salesperson. Press F1 or to retain all periods of information.

4. Item Data

Enter the number of periods to retain sales information by item. Press F1 or to retain all periods of information.

5. Item Class Data

Enter the number of periods to retain sales information by item class. Press F1 or to retain all periods of information.

6. Customer/Item Data

Enter the number of periods to retain sales information by customer/item. Press F1 or to retain all periods of information.

7. Customer/Item Class

Enter the number of periods to retain sales information by customer/item class. Press F1 or to retain all periods of information.

8. Salesperson/Item Class

Enter the number of periods to retain sales information by salesperson/item class. Press F1 or to retain all periods of information.

9. Item/Warehouse Data

Enter the number of periods to retain sales information by item/warehouse. Press F1 or to retain all periods of information.

10. Item/Invoice Data

Enter the number of periods to retain sales information by item/invoice. Press F1 or to retain all periods of information.

11. Temporary Item Data

Enter the number of periods to retain sales information by temporary item. Press F1 or to retain all periods of information.

12. Serial Item Data

Enter the number of periods to retain sales information by temporary serial item. Press F1 or to retain all periods of information.

13. Lot Item Data

Enter the number of periods to retain sales information by lot item. Press F1 or to retain all periods of information.

14. Invoice Master Data

Enter the number of periods to retain Invoice Master File information. Press F1 or to retain all periods of information.

Note: The Invoice Master file is designed to allow future access for detailed information on each of the individual data files. For this reason, the Invoice Master file cannot purge data more current than the largest number of periods being retained for any of the other files listed above.