Skip to main content

Notifications

Microsoft Dynamics RMS forum

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

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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

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