Latest threads in Point-Of-Sale Softwareshow only best voted threads

Subject Author Posted Replies
 
syntax for "contains"
Need to run a query to find all the items that contain a + sign I don't know the syntax/symbol to use in the query for "contains" Can anyone help me on that? select * from item where lookupcode...
3
3
 
Purging old transactions
good day, Is there any way in which i can purge old transaction in the system given a specific period....i am using rms 2.0...with sql express.....thanks.... Best regards, Uttam
4
4
 
How do gift cards work?
I'm new to MS POS 2.0, so please forgive me if this is off base... I want to be able to sell and accept gift cards in my store. I do not want to use pre-loaded Visa cards, but rather just a custom...
6
6
 
Adding supplier info to multiple items?
Please help? How do I add supplier info to multiple items at one time without going into each item individually and adding the supplier info such as supplier names and cost?
1
1
 
Default backup location
When backing up the database, it used to default to the previous location you backed up to. Since upgrading to RMS 2.0 it now defaults to My Documents and you have to re-navigate to the appropriate...
2
2
 
can't print to star printer
I have a star tsp100 futurePRNT receipt printer that has been working fine with RMS. It all of a sudden stopped working from RMS. I get the message "printer error - unkown error". I can still print to...
3
3
 
Does anybody use a Mac to access RMS 2.0 on XP?
Is anybody using a Mac to access RMS 2.0 running on a Windows system? I am considering replacing one of my XP system with a Mac but need to ensure that I still can use Admin and Manager to connect to...
4
4
 
SQL to enter Item.SupplierID for all child items
I just started doing some sales by supplier reports, but realized that my thousands of child items do not have suppliers associated with them (because I never put the child item on the PO, and they do...
2
2
 
Customer Tax Exempt
I was talking with Michael about how We can have a customer Tax Exempt on the invoice. I was entering the information in the field of last name in Customer Profile so it would print on the invoice and...
 
Can someone give me a sql script please
Hi I have a current database and an old one, I need to be able to take a date range of records in the journal table in the old database and insert them in the new database journal tabe without...
1
1
 
Please Help with Item import Terrible Tom
Hi I need to import about 300 item ( urgently ofcouse) I do not have any import tool nor wish to purchase one. Can you help me with the below post by Terrible Tom: Quote:******************* Contact me...
1
1
 
Is Crystal Report ver:11.5.8.826 supported?
Please tell me: Do reports made in CR Professional ver: 11.5.8.826 supported by RMS v2.0?
3
3
 
Quickbooks 2008
Will I have any problems importing/integrating RMS data to Quickbooks 2008? I am currently looking to upgrade from Quickbooks 2005. I know that RMS 2.0 is compatible with QB 2007 but what about QB...
7
7
 
SQL to get sales by Supplier
I would like to get output of total sales by supplier via SQL with output like: Supplier Name Sales --------------- -------------- If the sales can be formatted like #,###.##, that would be great. Can...
2
2
 
Trouble Importing Vendors into Items in a New Database
We are using a Microsoft SQL database import utility and have successfully imported all items into their respective departsment with the correct tax IDs ect. We cannot import the supplier choices into...
1
1