Bug in MRMS 2.0

Has anyone experienced discounts working on some line items and not on others? I have tried several ways to get a discount to stick, i.e. I had a very large order and each item had some sort of discount and I tried using the discount key, changing the price and entering the quantity and I tried just typing over the price and quantity then to hit the tender key and have maybe only 4 out of 20 items keep the changes?

This is a real pain!! Does anyone know of any fixes? Help!

Reply to
Kathleen
Loading thread data ...

Yes on the SP1 level, Microsoft has recreated this problem with me and will create a fix.

As a temporary solution, I created a SQL stored procedure to set OrderEntry.FullPrice to OrderEntry.Price when they are not equal. This procedure runs every hour. If you need a copy of the procedure, let me know.

TomT

Reply to
TomT

Somewhat off topic, but how do you get a proecdure to run every hour? I want to do a SQL query every so often, and it sounds like you know how...

On that note, I was trying to come up with another solution to do a SQL query for sales that is sent to a .txt file that gets saved on my web server so I can access up to date sales information from anywhere on the net. Any thoughts on how to do this? It doesn't have to be pretty - it's just for my own use.

Reply to
Jason

For scheduling, you can either use SQL Server Agent (not sure if it's available in MSDE/Express .. might only be in Standard editions), or you can use the windows scheduler (Starts -> Programs -> Accessories -> System Tools ->

Scheduled Tasks) to run a batch file command, which could then in turn use OSQL.EXE to execute any commands you want to run.

As for saving the results of a query to a text file, in SQL 2000 Standard edition you can use DTS, although in 2005 they phased it out and replaced it with something called SSIS, which I assume has all the same functions as DTS. With DTS you could setup a mapping from a table into a text file, and then use a scheduler or SQL Agent to run that DTS package on a regular basis.

However I don't think any of these features are available in MSDE/Express

Reply to
Jason Hunt

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.