I have 2 Store and HQ. But I can't Access Store directly.
Anyway, I want to Delete One item at HQ and store. I do that at HQ. But I can't do that at Store. Because Store are in another area
How Can i Do that?
It's generally better to make the item inactive if at all possible. If you abosolutely must delete the item, you can use a Worksheet 51 to run the following SQL:
DELETE from Item WHERE ItemLookupCode = 'X'
Where X is the Item Lookup Code for the item you want to delete.
Again, if there are any transactions associated with the item in question, it would be best to make the item inactive. For more info, check out your HQ Help - look at 'inactive items' in the Help Index.
Tom
Although i don't agree with u in the idea of deleting an item, but anyways u already deleted it from hq u can delete the item in store by executing worksheet 51 "Execute SQL statement", add the following line in the worksheet:-
DELETE Item WHERE ItemLookupCode='YourItemCode'
Please be carefull and backup first Nashat
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.