Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Hep - Adjusting custom...
Microsoft Dynamics RMS (Archived)

Hep - Adjusting customer accounts

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Help

One register store using RMS.

Trying to clean up an RMS system that has a 40 or more user account with old account receivables amounts that were done years ago. How can I adjust the outstanding balance back to zero - without affecting any amounts on the x-reports or z-reports.  I see that you make adjustment by doing:

  1. In the Customer Properties window, click the Account Information tab.

  2. Select the applicable invoice, and then click Adjust.

  3. In the Adjust Customer Account window, modify the appropriate information, and then click OK. 

What those this affect in the RMS system.  Please advise.

Thanks

Danny

*This post is locked for comments

  • TheNeos Profile Picture
    TheNeos 1,339 on at
    RE: Hep - Adjusting customer accounts

    Hello Danny,

    Since you are not linking or even if you were to an accounting you probably need to have a record of what you writing off.

    I would go about this way:

    Create a new account Named "Write Offs" and pay those old balances on this. Yes you will have in Z reports these not as sales but paid to Account but also as separate account which may be easier to manually process on accounting.

    Make accountant aware of this and they will adjust your records accordingly.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Hep - Adjusting customer accounts

    Bump

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Hep - Adjusting customer accounts

    Hi Kevin

    Thanks for the info.

    I could see the various accounting tables -ie: Accounting, AccountsAccounts, AccountsReceivables, AccountsReceivablesHistory, etc... but since we are not using any links/exports to our accounting system I was hoping to be able to clean-up this issue of having 40 very old account balances from several years ago by issuing an adjustment for each account. I also noticed a LastClosingBlance field in the customer table but all those entries are zero.

    As long as it doesn't affect overall sales and cost amount for this year. Guess I will have to setup a test system to try out.

    Am handy with sql but just not sure what tables need to be adjusted and any impact it could have on other tables due to constraints or triggers or store procedures.

    Danny

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at
    RE: Hep - Adjusting customer accounts

    Hi Danny, making an adjustment does create a debit or credit entry in RMS - it may be possible to run a SQL Query to zero out the balance without making a debit or credit entry. Have you talked to your Microsoft Dynamics RMS Partner about this? If you do not have a Microsoft Dynamics RMS Partner, our toll free support line is 888-267-7483.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans