Skip to main content

Notifications

Microsoft Dynamics RMS forum

No receipt to display

Posted on by 70

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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,335 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 Microsoft Employee 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,335 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

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans