VeriFone PINPAD and Sales Tax

First you need #203 which sends the definition of the tax you created in hq to the stores, but then changing the taxid of each item is more difficult.

You could change the HQ Item - Store Tax entry and then download with a worksheet #250. You would need a sql script in hq first that would look like:

update d set d.taxid=(select id from itemtax where description='Georgia Tax'), d.snapshottaxid=(select id from itemtax where description='Georgia Tax') from itemdynamic d join store on d.storeid=store.id where state='GA'

You could use the worksheet #320 to change the tax individually for each item, but might be a pain to set the tax on each line before sending the worksheet. You could create the worksheet, modify the details with a sql script before sending, try:

update x set taxid=(select id from itemtax where description='Georgia Tax') from worksheet w join worksheet_itemtax x on w.id=x.worksheetid where style20 and status=1

my preference would be to just send instruction to the stores to change their own taxid with a worksheet #51 containing sql script something like:

update item set taxid=(select id from itemtax where description='Georgia Tax')

For Verifone, see Jeff@Checkpoint's post of 1/12/10 about Verifone and OPOS.

Not to try to be offensive here, but a reseller-> HElpppp,

Thanks,

You are right I work for the store directly they do not want to hire any extra help. So, it is on me to set up the computers, POS, VOIP, 63 camera system, run the cables etc.

The taxes are wotking now thanks the only problem I am having now is with the LOTTO no tax should be charger any ideas on how to stop taxes being charged on Lotto?

As for the PIN PAD with in RMS their is a configuration you can do and it seems to work fine.

Thanks for all the help Jameer

"Matt Hurst" wrote:

any of the methods would work to fix this: change the hq lotto item store tax to Unassigned for each store then send worksheet 250, or send worksheet 320 for lotto item and leave the tax unassigned, or send worksheet 51 with script like:

update item set taxid=0 where descripti> Thanks,