ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Deleting price codes
http://www.istechforum.com/YaBB.pl?num=1118260122

Message started by apsupplies on 06/08/05 at 11:48:42

Title: Deleting price codes
Post by apsupplies on 06/08/05 at 11:48:42

Is there a way to delete ALL price codes in our system? We have the add on to delete records for specific price codes but somehow some got entered under price code "0" and "100" which the program won't acknowledge. We are looking to reload all new price codes but would like to remove the exsisting ones from our system.

Title: Re: Deleting price codes
Post by Danimal on 06/08/05 at 12:25:03

apsupplies wrote:

Is there a way to delete ALL price codes in our system?

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.

Title: Re: Deleting price codes
Post by Lynn Pantic on 06/08/05 at 17:20:13

Be VERY careful. This will probably work and UT-A, program DBAIF (DBAIF.RUN in EVO), file BKICPMAT will certainly work but Customer Contract Prices live in the same file and you will wipe them out too.

Title: Re: Deleting price codes
Post by Danimal on 06/09/05 at 05:04:09

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! ;D

Title: Re: Deleting price codes
Post by apsupplies on 06/09/05 at 07:56:57

Thanks but I think we will try deleting just those that the program recognizes - I don't want to mess up contract pricing. Speaking of - is there a program that will down load an entire spreadsheet of contract pricing or are we struck entering one at a time?

Title: Re: Deleting price codes
Post by Danimal on 06/09/05 at 09:00:46

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)

Title: Re: Deleting price codes
Post by Lynn Pantic on 06/09/05 at 09:16:43

Yes, IS Tech has an Import Price Code/Contract Pricing add-on.