Run time error '457

Go to your Item Tax list in the Database menu. Delete the Item Tax that says or something to that affect. Then try the Wizard again.

Rob

if you remove the tax code how do you create a non tax item? I have posted a related question but no one has answered yet

How do you assign a tax code to an item which is not taxable ie coupons, labor and others?

DD,

Database | Items Taxes | New | Non-Tax | Non-Tax | OK

You now have a non-taxable selection.

You can report on it now too.

akpetshop's original question is different from your situation. You have two options you can either leave them not assigned to any tax or if you want you can create an Item Tax that has no Sales Taxes assigned to it.

Rob

Thank you Jeff for the answer about setting up a non-tax item. I will do that and assign our nontax items to it

I could not find this advice on nontax items in the RMS Help file.

Rob thanks for the reply. jeff had replied to this post that removing would relieve a runtime error 457. we have not had any errors yet. but we are currently missing a 19.99 sale from the non tax reports. will removing previously used tax codes cause RMS database problems.

I will clarify our situation

we have 2 extra entries in tax codes NT and Blank, I would like to create a new Nontax and deleted the other 2 after reassigning the items to the new Nontax code.

We imported 7500 items in 2 or 3 different files and there was confusion in the tax setting on the import, thus it created 3 or 4 tax codes that were not set up yet.

DD,

That's why you (or you should) pay us the big bucks!! Practical experience almost always pays off better than a book experience does!!

DD,

I would leave the existing ones and not try to fix the older sales as it can be a mess. While you can change the database for the reports for old sales, you won't be able to change the receipts and if you try to match them at a later date, they won't ever match.

Create a new Item Tax and call it Non-Tax or whatever. To change your item sales tax rate for future sales;

Manager | Wizards | Inventory Wizard | Task 170 Assign Sales Tax | Select all of the non tax departments | OK | click on the first line of the New Item Tax column | Select your Non-Tax | Right click on the same line and select Copy | Right click and Paste to all rows | OK. This will change all of the items selected as using your new Non-Tax Item Sales Tax type.

Well the bad part is we did pay a Nationally known MS Partner to install and setup the system. The left with it partially installed and not "LIVE", took 2 weeks just to get it to stay stable. (database connection errors) As of now

45 days later the Check Verification is not running and our cc reciepts are still not correct.

We still have reciept changes we want done to Statements and PO's.

We paid for an add on, they could not get to run on time, so we are not using it.

I was told they would hook me up with customer source and that still has not happened. I don't even know where to get it or how much it will cost.

I prefer to have both routes open to me a Setup manual sholud be part of the Package. The Help file does not even say how to set up a non tax item,

DD,

Ahh, you're another one. ;-) Unfortunately, not all resellers are created equal and MS likes to push the box movers instead of the ones with real life experiences. I have one of you too. They transferred to us on a referral after going through a similar thing with the same reseller as you.

I'm assuming you are attempting to use PCCharge for your check checking? What's the issue?

What do you need for the cc receipts. statement and PO's that's different? Lots of customizations for all of them have been uploaded to this newsgroup (community in MS speak)

CustomerSource is included when you purchase the Annual Maintenance Plan for RMS and MSPOS. Is this something you paid for? The cost is 18% of the MSRP. You should have received a letter from MS welcoming you to the fold that contains your login name and password. If not, try contacting MS Support for the info. 888-400-4266. While speaking to them, you might ask for a Reseller Transfer form be sent to you, just in case!

There were real Getting Started and User printed manuals with 1.2. Starting with 1.3, only the Getting Started is included (also on the CD) and you will have to print out your own User Manual which is really a printout of the Help screens (Always was, basically!). Go into Help in SO Manager, Admin or POS, Contents and go to the first entry. Select Print on the top and the select the second option, something like "Print the Selected Heading and all subs". 300+ pages as I remember.

Jeff: Thank you for the continued replies.

We are using Smart Service Abanco interface for checks and credit cards. All of our checks are coming back denied or unknown error we are working with abanco and Positive Tech to fix.

All of our CC receipts print a signature ticket even though we have signature capture device, used for CC transactions.

We got access to customer source today, but I can't click on the tiny.url links that are posted in this group. Is this group we are in now the same as the paid for group only now I have a monitored email address? if so how do the tiny.url's work?

On PO's I found xml on that prints the Supplier Acct Number in customer source.

But the PO entry is not very well thought out. RMS does not show how much of a partial PO has been recvd and will not let you print out a PO with the partial recvd amounts showing.

Statements we want to delete Credit limit, Remaining Credit, Minimum Payment required, and on some statement types to remove due date and set due date as "ON Receipt" of bill. or 10th of Month

Help files I have printed them out, but it still does not show how to edit xml, it does not show how to run sql queries. It does not show a lot of setup information

DD,

No experience with Abanco yet.

In your receipt properties, do you have the CC Signature set to False and/or your credit card tender set to require signature?

Tinyurl.com is a website that converts long website addresses to shorter ones. After a period of time, they expire. Other times, when clicking on the link, it will either open a new web browser window and take you to the site. Any chance you are using a different web browser than IE or have some kind of restrictions with it?

for the link about it. This is the only group that the public has access to. What you need to do is to register and post with a registered email address. I'm assuming that you are using the web interface instead of OE or some other type of newsgroup reader.

In the upper right corner of the web interface there is a Sign In icon and right next to it is a Edit Profile icon. Select it and enter in an email address. Within 48 hours that address will be "registered" with MS as an address to watch for questions from you. If your question hasn't been answered and "is for the benefit of the group", a MS employee will supposedly answer it.

The PO print what was ordered, sounds like you want a receiving worksheet, find one attached.

I would really recommend using OE or some other newsgroup reader software to access this group as its much easier to use, you can download attached files and depending on the reader, can save all posts, as the posts here roll off the website after approx. 90 days. Search Google for "newsgroup readers" free to $100.

There was a post within the last week here that had a modified statement attached that had most of the changes you are asking for.

The help files do not and probably should not contain sql scripts and XML programming. For most people, it would be a waste of effort. SQL can be dangerous with your data and there are thousands of books on XML programming.

While not the most complete, Admin Help and Manager Help give you the basics of getting the program up and running, but consider the variables of each installation. Look through this newsgroup _just_ about receipt printer setups, a relatively simple process, but between the many manufactures, their different drivers and interfaces, how would MS keep up?

This is NOT a $100 word processor, its a very sophisticated, purpose built program with support, both hardware and software, coming from many sources. This is why you should hire or be on some kind of support program with your reseller and use MS, as a last resort.

This report errors with a divide by zero error and closes

DD,

Odd, let me see if I can figure out why it doesn't work over there.