How do I delete pricing levels without doing it manually?

I need to change pricing levels for items and i've been going into item maintenance, pricing, then going into every single price level and deleting it manually.  Is there an easier way to change the price level, I have about 1500 items that need price level changing and it's taking me forever.

  • 0

    Export the whole table to Excel.  Reinit the IM_PriceCode table.  Edit your spreadsheet to remove everything but what you want to keep.  Import using VI.  Do not try this without testing first.

    (You can even do all this in a copy / test company, and copy the IM_PriceCode file between company codes).

    I've also done this by script, when a customer wanted to delete individual PL's on demand.