Quote from apsupplies   on 06/08/05 at 11:48:42:

Although I have never encountered this specific problem, I would probably go about it as such, with the understanding that you want to clear the entire price matrix table of your default company (BKICPMAT_B). I recommend backing up all of your files before attempting this, and only do so if you are comfortable with performing the operation. PROCEED WITH CAUTION!
 
Enter the Pervasive Control Center application, traverse the tree on the left to get to the table view of your DBA database and click the "Execute SQL Query" button (green arrow with pencil and ellipses). Enter the following exactly...
DELETE FROM "BKICPMAT_B"
...and click the "Execute Query" button (green arrow with document). With any luck the function will execute successfully and clear your price code entries.

True, if you want to delete price codes with the exception of those assigned to a specific customer (contract pricing), use the following...
DELETE FROM "BKICPMAT_B" WHERE BKIC_PMAT_CUST=''
...those are TWO single quotes (apostrophes) following the equal sign. I had to remove the asterisk from the statement as PCC does not require it and will display an error if included (driver not capable). Long live the syntax error.
 
...and congratulations, Lynn, on your 2000th post!

Well, do whatever works best for you. I actually performed this same operation this morning as we were in the process of updating our price codes, and it worked well (thus discovering the syntax problem). We are only working with about a dozen entries separate from our contract pricing, so entering the new records by hand through Evo was not a problem.
 
As far as importing from a spreadsheet, I am not aware of such a program; however, I do have a method that I could recommend using... but if you are not confident in performing the process above, I don't think that it will be worth my time describing. Best of luck to you! 8)