You’re offline. This is a read only version of the page.
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:
In the Customer Properties window, click the Account Information tab.
Select the applicable invoice, and then click Adjust.
What those this affect in the RMS system. Please advise.
Thanks
Danny
*This post is locked for comments
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.
Bump
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (