web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Journal problems with RMS 2.0

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    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)

  • Suggested answer
    MaxIT Support Profile Picture
    90 on at

    Hi Heidi

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

  • Suggested answer
    airplusdan Profile Picture
    5 on at

    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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans