HQ on sale Flag

The sale price and dates change in SO after the 301 but the Sale checkbox doe not get unchecked in SO. This is what i need to update as we have reports that look at that flag as well as product uploads to our website that key off that flag.

I think a 260 might update the flag in SO from HQ, but that will mess inventory up.

Any other thoughts?

Thanks,

TomT

have you tried worksheet 250? You could also set the flag with a worksheet 51 sql command, something like:

update item set saletype=1 where salestartdategetdate()

"TomT" wrote:

OK, I get it, you want to turn off the flag when not in the sale period, try this

update item set saletype=0 where not (salestartdategetdate() )

"Matt Hurst" wrote: