web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / No receipt to display
Microsoft Dynamics RMS (Archived)

No receipt to display

(0) ShareShare
ReportReport
Posted on by bbarn 72

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    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 Profile Picture
    TheNeos 1,347 on at
    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 Profile Picture
    Community Member on at
    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 Profile Picture
    TheNeos 1,347 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans