HQ on sale Flag

Apr 29, 2009 5 Replies
T

After I turn off the on sale flag in HQ for an item, what worksheet is used to propigate the change to SO?



Thanks,



TomT


Vote
Twitter Facebook LinkedIn
T

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

Vote
Twitter Facebook LinkedIn
M

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:

Vote
Twitter Facebook LinkedIn
M

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:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required