Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Journal problems with RMS 2.0

Posted on by 90

Hello All

I have a customer running RMS 2.0, there was an issue with a cash draw and subsequent troubleshooting lead me to delete and recreate the Register account used,.

This has had the effect of "Splitting" the transaction Journal into 2 and when staff try to look up a transaction from before when the register account was deleted they are not able to simply look up the customer and click on transaction history. Doing so shows a blank invoice.

The old Journal data is still there and I can look up any transaction by Batch but as there as over 2000 batches this is a slow process.

Is there any what to "Merge" the journals back into 1 continuous journal?

The attached screen shots show the "Register" field has number 1 in the transaction I can look up directly from the customer account page and the 2nd shows an invoice I've had to manually look up (no register number)

The register account I deleted / re created can be seen in the final screenshot and was done under the "database > Registers > Register List" menu in Store operations Manager software


5554.NFC2.png 
6114.NFC3.png 

Assiatance is greatly appreaciated

*This post is locked for comments

  • Suggested answer
    airplusdan Profile Picture
    airplusdan 5 on at
    RE: Journal problems with RMS 2.0

    Just wanted to follow-up on this same issue. We did a new install to Server 2012 & Win 7 from XP. The drawers were renumbered. (bad mistake) So put the same drawer numbers back into the register list like before, and ran the Query as above. It worked perfectly.  Our many Thanks goes out to Heidi.

  • Suggested answer
    MaxIT Support Profile Picture
    MaxIT Support 90 on at
    RE: Journal problems with RMS 2.0

    Hi Heidi

    Thanks for the quick response, query worked like a charm.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal problems with RMS 2.0

    You should be able to run an update query on the Batch table to update the old register # with the new register number.  Without looking at your database, I would only recommend this if you have used a brand new (never been used before) register number.  Edit the "X" below be to be the NEW register number.  ALWAYS do a database backup before you run an UPDATE query.

    UPDATE Batch SET RegisterID = (SELECT ID FROM Register WHERE Number = X) WHERE RegisterID NOT IN (SELECT ID FROM Register)

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