Micros 3700 Temporary price increase

[NorNev]

I have a city wide event coming up and would like to raise my liquor/beer prices for this event and then return to the original pricing structure after the 3 day event is over. Is there a way to do this through the Family Groups and if so how?

 

[NorNev]

I agree with the analysis of Well Rum being multi-priced
I changed the Well Rum to mirror the setup for all other Well drinks prior to running the query copying Price 1 to Price 5 & 6.
Tested it and there were no issues.

Looking at your last paragraph, do I run the query I just ran again (changing the query to "preset_amt_5 = preset_amt_1" to "preset_amt_5 = preset_amt_1 + 1")?

 

[pmegan]

Good deal, so make your changes to price 5 and they'll be ready to go.

When you're ready to use the temp prices run this query. It copies price 5 into price 1, and has a filter to skip over any items where price 5 is either blank or 0, just in case something was deleted by mistake.

update 
	micros.mi_price_def
set 
	preset_amt_1 = preset_amt_5
where 
	preset_amt_5 is not null and
	preset_amt_5 <> 0 and
	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;

When you're done with the event run this one to copy the original prices in price 6 back into price 1

update 
	micros.mi_price_def
set 
	preset_amt_1 = preset_amt_6
where 
	preset_amt_6 is not null and
	preset_amt_6 <> 0 and
	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;

 

[pmegan]

Looking at your last paragraph, do I run the query I just ran again (changing the query to "preset_amt_5 = preset_amt_1" to "preset_amt_5 = preset_amt_1 + 1")?

Sure, it will write over whatever's in prices 5 and 6 though, so if you've started making changes in the price 5 slot manually already you'll have to do it again.

 

[NorNev]

A big THANX!! to both of you for walking me through this!
Can't tell you enough how much I appreciate it.
Your company should be very appreciative of your work.
Thanx again!

 

[Moregelen]

Heh. It is very useful for me to attempt to answer questions in this forum; I've only been using Micros for about 8 months now, so I'm trying to read through and fix as many problems people list as I can to get some experience in it.. so thanks for presenting your problem; having already had to think through it now will make it easier later on if I have to do it ^_^

 

[pmegan]

Wow, you've picked up a lot in a short time. I thought you'd been working on Micros for a bit longer.

 

[Moregelen]

Nope.. I'm fairly young too at 22.. >.>

Picked me up straight out of school =D Its been interesting working on Micros. So many things that make me go 'What the heck were these people thinking?!?!'

But like like I said, it has at least been interesting... trying to pick it up as fast as I can.