Hep - Adjusting customer accounts

(0) Share

Report

Posted on by Community Member

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.
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

I have the same question (0)

All responses (4)

Answers (0)

Kevin Antosh 1,649 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Hep - Adjusting customer accounts

Bump

Was this reply helpful? Yes No
TheNeos 1,347 on at

Like (0)

Report

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.

Was this reply helpful? Yes No