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

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

customer account closing balance discrepancies - I need help!!!!!!!!!!!!!

(0) ShareShare
ReportReport
Posted on by 30

I closed billing cycle on 8/30 but i forgot to change the closing date to match.  When I went to do my 9/30 statements, computer told me 14 accounts have discrepancies and "accounts will not be closed".  I have wasted at least a 1/2 day so far entering adjustments dated for 8/31 to remove those transactions and then going back in and entering new adjustments for those transactions that I removed dated for 9/1.  Every single time I do this, I get the same message for the same customer accounts but different closing balances.  I am at a total loss on how to proceed.  

This program sucks!  I hate it, it is NOT user friendly whatsoever!  the help section, what a joke!  I've been using this RMS for the last 4 1/2 years, my employer got it in 2006 and I really feel like they were bamboozled on this program (they are not happy either).  I know of 2 other companies in my very small town that use it and they all have the same complaints as us.

How do you generate a report for customer accounts showing payments and how those payments were applied?  I get asked this a lot but there is absolutely no way to do this.  I've tried in RMS manager and Administrator both.  I don't even see the point of administrator, you can't do anything in there either and I'm the admin!  

How do you print out the finance charge transactions other than on the statements?  I have several customers who cannot pay those from the statement but I can't for the life of me figure out how to print just the finance charge transaction to fax or mail it to them.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
    Re: customer account closing balance discrepancies - I need help!!!!!!!!!!!!!

    I have previously seen this imbalance occur when the "Assess finance charges" is checked against the affected customers (detailed in the error) but your cause may differ.

    To fix the problem the Microsoft Support article linked below details how. support.microsoft.com/.../869930 .

    Any solutions involving the running of SQL requires great care & I'd recommend employing the help of your RMS supplier if you have one.

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…

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