Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Z Report causing POS t...
Microsoft Dynamics RMS (Archived)

Z Report causing POS to crash

(0) ShareShare
ReportReport
Posted on by hpryor4 55

I have at least 6 stores out of 30 that have started crashing (intermittently) during the Z out process at the end of the night. After the associate tries to Z out, the POS program will at times crash or cause the computer to freeze. Upon rebooting - they are unable to create a new Z report (because it allegedly was already created just before causing RMS POS to crash). 

Furthermore, when looking in the receipt journal, the aforementioned Z report is not listed in the journals. Because of this, we cannot even go to reprint the Z report. The issue does not happen consistently.

Can somebody please please please pleaseeeee provide some insight on why this might be happening? We are using Radiant Terminals using Windows XP with Microsoft Dynamics RMS version 2.0.0116.

*This post is locked for comments

  • hpryor4 Profile Picture
    hpryor4 55 on at
    RE: Z Report causing POS to crash

    Chaz - Thank you for your reply.

    I ran the query on all 7 of my stores that are having the issue and it returned no results. The query was executed successfully.

    Any other ideas?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Z Report causing POS to crash

     I have seen this problem with duplicate Alias or duplicate Itemlookupcodes.  

      You run the following query in SQL Management Studio to verify:

    use  (databasename)

    select  a.itemlookupcode, COUNT(*) AS Duplicates

    from dbo.item AS A

    group by a..itemlookupcode

    having COUNT(*) > 1

    use (databasename)

    select a.alias, COUNT(*) AS Duplicates

    from dbo.alias AS A

    group by a.alias

    having COUNT(*) > 1

        Post your results here.

  • hpryor4 Profile Picture
    hpryor4 55 on at
    RE: Z Report causing POS to crash

    Hello.

    Yes, the batches are posting and getting back to HQ. The issue is happening at over 5 of my stores now and it happens intermittently.

    Any other ideas on why the Z report would cause my registers to lock up/crash?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Z Report causing POS to crash

     Are you posting your batches? Can you see them in HQ?  

     I have had similar errors but they are actually when trying to update the "Offline Database", the Batch closes fine.   This can be caused by duplicated alias/Itemlookupcodes.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans