No receipt to display

(0) Share

Report

Posted on by bbarn

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

All responses (4)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: No receipt to display

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
TheNeos 1,335 on at

Like (0)

Report

RE: No receipt to display

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.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: No receipt to display

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.
Suggested answer

TheNeos 1,335 on at

Like (0)

Report

RE: No receipt to display

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