HQ on sale Flag


T

TomT

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
 
Ad

Advertisements

M

Matt Hurst

the Update Inventory - Items #250 worksheet will update the sale dates and
flag. For sale pricing use worksheet #301 Set Item Sale Prices.
 
T

TomT

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
 
M

Matt Hurst

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 salestartdate<getdate()
and saleenddate>getdate()
 
Ad

Advertisements

M

Matt Hurst

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 (salestartdate<getdate()
and saleenddate>getdate() )
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top