Delete all Micros 3700 Price levels except level 1

[ianstrainor]

A lot of our PLUs have multiple price levels. They are never ever used and its grown into a bit of a mess. When we run certain legacy reports we get them with all the price levels on them that we dont want

Is there any command that I could run in DBISQL that would delete all price level entries except level 1?

 

[Jackba]

Hi you can try below code

update micros.mi_price_def
set

preset_amt_2 = null,
preset_amt_3 = null
,preset_amt_4 = null
, preset_amt_5 = null
, preset_amt_6 = null
, preset_amt_7 = null
, preset_amt_8 = null
, preset_amt_9 = null
, preset_amt_10 = null
where mi_seq in (
select m.mi_seq from
micros.mi_def m
join micros.mi_type_class_def c
on m.mi_type_seq = c.mi_type_seq
where c.obj_num in (x,y,z)
);
commit;

replace x,y,z with your menu item class object number