Royalty Information Screen:
File Maintenance Menu

Top  Previous Topic  Next Topic

 

This is a Level 7 Feature

Note: This file maintenance function refers specifically to a special file that holds pricing level information.  If you need to re-index all of the royalty data files, you can access that function by starting at the Main Menu and selecting File >> Re-index file.

RoyInfo12

 

Background

If you use pricing levels in your calculations, and if you also based those calculations on the quantity of the items sold (i.e. you select both "Pricing Levels" and "Variable Structure: Quantity)," then the data file named RoyLevel.dbf will be used.

It's very unlikely, but if RoyLevel.dbf is negatively impacted in some way -- such as a power failure during a file operation process -- it may be necessary to delete one or more records from the database.  This function has been included to allow you to do that.

It may be helpful to understand when this database is used by the program.  The first pricing level, "Retail," is handled by the RoyInfo.dbf database, the main database.  Any additional level information which is associated with quantity breakpoints is held in the Royalty Pricing Level Database:  RoyLevel.dbf.

How to Use this Function

If you are having problems when entering data associated with levels on one for one of your royalty holder (and the rest are fine), you can delete the problem record from RoyLevel.dbf.  To remove the problem record, select File >> File Maintenance >> Delete This Record from Pricing Level Database.  

If you are having problems enter pricing level data for all royalty holders, select File >> File Maintenance >> Delete All Records from Pricing Level Database.  This will remove all records and allow you to start fresh.

Note that this process only removes the data stored in RoyLevel.dbf.  All other databases are protected and not effected by this process.  That means general settings such as name, address, counting, calculation and structuring methods remain the same.  Also all the settings for the first level stay the same.  It's only the second level and higher, associated with quantity breakpoints, that are removed.