Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

RMS Headquarters, customer account payment and account receivables problem

(0) ShareShare
ReportReport
Posted on by

I have RMS Headquarters Server and two separate stores running HQ Client. If I check Customer 'X' account receivables from POS in store# 1, it does not coincide with account receivables if I check from POS in store #2(Shift+F4).

Worksheet 401 has been issued. 101 as well.  

Also, Client Account Receivable summary report in HQ Manager does not coincide with total when trying to apply a payment to account. 

*This post is locked for comments

  • eliud mugo Profile Picture
    eliud mugo 1,440 on at
    RE: RMS Headquarters, customer account payment and account receivables problem

    Are you customers Global or Local?While checking the balances via POS do you see the POS connecting to HQ?

    You might be required to check Your Global customers configuration.

  • RE: RMS Headquarters, customer account payment and account receivables problem

    Sorry Peter my email notifications here seem to have stopped working. I would submit that to RMS support if I were you, since no one else has answered it here.

  • RE: RMS Headquarters, customer account payment and account receivables problem

    Closing balance is in fact incorrect. If I try to make payment in POS, then I can view correct balance. Both should match if no other transactions have taken place after closing billing cycle.

    In store 1, balance when trying to apply payment through POS is correct.

    In store 2, balance when trying to apply payment through POS matches incorrect closing balance.

    Client Reports in HQ Manager also show incorrect balances.

  • RE: RMS Headquarters, customer account payment and account receivables problem

    Please read the issue info from MS for one of our customers, and see if it applies to yours:

    After reviewing all of the information that you have provided within the .rar file I was able to confirm that the “Closing Balances” are correct for the accounts that have been experiencing the issues. We then talked about what the difference is between the “Closing Balances”  and “Balance” fields represented within the account receivables windows. I was able to explain to you that the follow can be found within the help files in both HQ and RMS:

    “Account type: Specifies the type of account (e.g., Revolving Charge Account; Preferred Customer, etc.) the customer will use. Use the Account Types menu option to define your store's account types. If desired, you can create a default account type for new customers by going to the File menu, clicking Configuration, clicking the Accounts tab, and selecting the default account type.

    Account opened: Displays the date when the customer account was created.

    Credit limit: The maximum amount the customer may charge on the credit account. If the new charge amount causes the customer to exceed this limit, Store Operations will display a warning at the POS.

    Balance: Displays the current account balance.

    Available credit: Displays the customer's available credit. It is the difference between the Credit Limit and Balance.

    Assess finance charges: If selected, Headquarters will calculate finance charges for the customer's account.

    Closing date: Displays the date that the billing cycle was last closed.

    Closing balance: The customer's balance at the time the billing cycle was closed.

    Activity/Receivables button: Click Activity to display the customer's account history and running balance. Click Receivables to display the customer's account receivables and the balance due for each invoice”

    I was explain to you that as long as the “Closing Balances” are the same at both HQ and at the Store locations then your customers are keeping up properly on the monthly updates to the customers’ accounts regarding the account receivables.

    HOWEVER, I was able to explain to you that the “Balances” field is always going to change. This is because the “Balance” is updated every time a 401 worksheet is ran to HQ from the stores. What your customer needs to keep in mind is that the “Balances” will never match if there is local credits still pending to a customer’s account.

    If there is even 1 single local credit pending the “Balances” will never be the same. I also informed you that if your customer is doing manual changes to the customers’ accounts the “Balances” can also get effected. After explaining this information you understood that your  customer should be primarily concerned that the “Closing Balances” match at the end of each month as this will indicate that RMS in general is detecting the balance information correctly.  

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans