When tendering a transaction, the pos freezes and a receipt does not print. It does give a transaction number, but when trying to view the transaction shows "no receipt to display". If the tender is credit or debit, the card is charged but we have no receipt to give the customer. The items being rang up are normally reduced in inventory, but not always and the sales tax is not always accumulated for that transaction. It also sometimes causes the register the error occurred on not to batch out at the end of the day.
*This post is locked for comments
Thank you for your question.
In additional to the steps others provided about deleting old journal entries, if you need to preserve this data, you can look at upgrading your version of SQL.
If you are running SQL 2005 or 2008 Express, the database size limit is 4GB.
If you are running SQL 2008 R2, 2012 or 2014 Express, the database size limit is 10GB.
The standard and enterprise editions of all SQL versions offer unlimited database size, but you must purchase these licenses, they are not free as the Express versions are.
Thank you,
Scott Wardzinski
Microsoft Dynamics RMS & POS Support Engineer
When unloading Journal it is good practice to check the time of last transaction and also think if any slow paying accounts may be there with receipts worth keeping, before deleting.
Query "Select Min(Time) from Journal" will get you the earliest record date.
query to delete old journal entries.
delete from Journal where [Time] < '2013-01-01';
time is in 'yyyy-mm-dd' format
Run this from a new query window. The example above with delete everything prior to 2013.
Hello BBarn,
Which Country are you in?
Do you have RMS for long time? It may be due to database going full.
To check this goto RMS Administrator - File - Connect ( if no sql password known use Windows authentication).
Then Database - Select - your database file. At the screen footer you will see Database: .... (yours).
Database again - Properties. Here will see the size and space available. if close to capacity (99%) you must delete some old transactions from Journal.
If you don't know how to delete Journal Please send me an email I will give you instructions. theos.sif727@gmail.com
TheNeos, Australia
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156