You’re offline. This is a read only version of the page.
620
What would the query be to mark inactive items that have 0 qty and have not sold since 01-31-2010 in HQ?
Thanks in advance
*This post is locked for comments
I've found that if you follow the steps I mentioned above and under block sales specify a date to block sales after then run a 250 it seems to work to block the store level from selling the item.
Try blocking the sale of the item until 2099
OR
FP2 (2.0.1000) includes a new option to Block sales of Inactive Items in the POS options menu in Configuration
you wont see those items in reports if they are inactive neither
I'm working on doing this now during my yearly physical inventory...after running the sql I am then running a 250 for the items I'm making inactive, placing a do not order on, and blocking sales. The problem I'm having is I can still key/scan the items into a sale in POS. Is there no way to prevent this? Or does this indicate some other issue?
Thanks again. everything worked great.
update item set donotorder = 1 where inactive = 1
This will set all items currently inactive to Unorderable state, the same happens when you check the "May not be placed on purchase order" on the Options tab when editing in SO manager on Item screen.
Thanks for the query. How would I set the inactive list so that it could not be put on a PO?
update i set inactive = 1
from item i left join transactionentry te on i.id = te.itemid left join [transaction] t on te.transactionnumber = t.transactionnumber and te.storeid = t.storeid and t.time > '1/31/2010' where isnull(t.time,0) = 0 and i.quantity = 0
This will update the items in HQ. You will then need to use worksheet 250 to update items at stores.
Hope this helps.
Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (