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.  

2. Customer Data

Enter the number of periods to retain sales information by customer.  

3. Salesperson Data

Enter the number of periods to retain sales information by salesperson. 

4. Item Data

Enter the number of periods to retain sales information by item.  

5. Item Class Data

Enter the number of periods to retain sales information by item class.  

6. Customer/Item Data

Enter the number of periods to retain sales information by customer/item.  

7. Customer/Item Class

Enter the number of periods to retain sales information by customer/item class.  

8. Salesperson/Item Class

Enter the number of periods to retain sales information by salesperson/item class.  

9. Item/Warehouse Data

Enter the number of periods to retain sales information by item/warehouse.  

10. Item/Invoice Data

Enter the number of periods to retain sales information by item/invoice.  

11. Temporary Item Data

Enter the number of periods to retain sales information by temporary item.  

12. Serial Item Data

Enter the number of periods to retain sales information by temporary serial item.  

13. Lot Item Data

Enter the number of periods to retain sales information by lot item.  

14. Invoice Master Data

Enter the number of periods to retain Invoice Master File 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.