Home Page link  

SQL Statement for Adding Food Stamp Option to Non-Tax Items

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
SQL Statement for Adding Food Stamp Option to Non-Tax Items FoodStorer 08-10-2008
Posted by FoodStorer on August 10, 2008, 9:00 pm
Please log in for more thread options

Hi,

I have a grocery store and have inputted about 1600 items. However, I only
recently realized that I need to check the 'Accept Food Stamps for this Item'
option for each item I add.

It would take me quite a long time to do this. Can anyone help me with an
SQL statement that I can use in SO Admin to apply the Food Stamp Option to
all NON-Tax Items?

If this is not possible, can some help me with a statement that will make
all the items in the database have the 'food stamp option' checked? I have a
lot less tax items, and unchecking them would be alot faster.

Thanks!

Posted by Koit Lahesoo on August 13, 2008, 3:59 am
Please log in for more thread options

Hi,

To make all items to accept food stamps:
update Item set FoodStampable=1
To add that to NON-Tax Items:
update Item set FoodStampable=1 where TaxID=0

Koit Lahesoo

> Hi,
>
> I have a grocery store and have inputted about 1600 items. However, I only
> recently realized that I need to check the 'Accept Food Stamps for this
> Item'
> option for each item I add.
>
> It would take me quite a long time to do this. Can anyone help me with an
> SQL statement that I can use in SO Admin to apply the Food Stamp Option to
> all NON-Tax Items?
>
> If this is not possible, can some help me with a statement that will make
> all the items in the database have the 'food stamp option' checked? I have
> a
> lot less tax items, and unchecking them would be alot faster.
>
> Thanks!



Similar ThreadsPosted
EBT Food Stamp Processing? December 29, 2007, 3:15 pm
Food Stamp Allowed (rounded) Vs Exact amount to pay November 29, 2006, 5:26 am
Print Food items to Kitchen Printer August 14, 2007, 11:20 am
Shelf label with date stamp April 15, 2008, 4:33 am
Looking for a Sql Statement to delete items never sold or received January 30, 2006, 1:41 pm
SQL Statement for attaching Item Messages to Items June 21, 2007, 4:49 pm
Adding items from HQ vs SO April 14, 2007, 4:52 am
adding items to a matrix September 16, 2005, 4:28 pm
Adding Items Through QSRules November 21, 2005, 9:36 pm
Adding items to database March 17, 2006, 4:11 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap