Yes, I think... But I don't want to assign the price level per customer... if I leave the "Price Level" field blank on the Customer Maintenance (Additional) screen, then it will default to the price code system that I set up.

I'm trying to sort it by item type (via price code) and then individual price levels from there...

I just know that I tested this process, by adding a price level for a particular price code to one account (that had individual pricing uploaded previously) and it did not do anything... the items still read the uploaded price, not the price code/price level that I had specified for that price code for that account...

When I went into that account, into item pricing through Customer Maintenance, it still ready "Price Override" for the item I was testing.  So I switched it to "Price Discount Amount" manually, and I had to then manually enter the Discount Amount, because it didnt automatically pull the price code/price level for that item type...

Make sense?

Ugh I hate pricing!

If I put "Price Level = A" on Customer A, then all items under Customer A will default to Price Level A for all Price Codes.

But if I want Customer A to follow Price Level A for Item A but Price Level B for Item B, then I can specify under Price Level By Customer Maintenance that I want the account to follow different price levels for different items under that one Customer Account.

The problem is that I cant use these Price Levels as a blanket price level per account.  It has to be item specific, not customer specific, but usable across many accounts in many different item/price code variations...

At it's simplest level,  the thing to remember is that there are price levels (customer) and price codes (items) that essentially form a two dimensional grid.

Getting more complex there are price levels by Customer where you can set price levels and price codes by different product lines as well.

You do have to turn this last option on in sales order options.

One way or another you do have to understand what is available and plan it out.

Also remember that pricing has a hierarchy.  From the help files:

Yes - this screenshot is precisely what i am working on doing now - leaving that Customer Price Level blank, but designate different price levels by product line & price code...

the problem that i was trying to fix is like i said - getting items that were manually uploaded to revert to this setting... which i cant seem to do, so any item that was manually uploaded will have to continue to be manually maintained is what it seems.  setting up the price codes/levels by customer this way will only affect new items entered into the system, or items that were never manually adjusted.

and thank you Kevin - I've been referring to that Hierarchy plenty! thats why i think the manual uploads are superceding everything - because it uploaded it as a customer price schedule...

That's where reinitializing the price code file comes in.   Essentially you start from scratch.

A VI job can't delete old records.

You can delete the overrides through the interface, one by one, but with many records it is impractical.  There should be an easier way, but there isn't.  Wiping out the table and starting from scratch (as Tom suggests) is the fastest way.

Yessssss - OMG, Thank you - this is what I need to do!  This changed the "Price Source" to Price Code instead of Item/Customer Price just like I wanted!

Is there a way to do all items under a customer at once? or do I have to do it one by one on each account?

Thank you thank youuuuuu

As Tom suggested, you can reinitialize IM_PriceCode if it is not set up as you desire. I would suggest copying to a test company, reinitialize the file in your test company and examine KB47758 which explains how to import Price Overrides for Item Pricing.