News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Original Amount / Amou...

Microsoft Dynamics GP (Archived)

Original Amount / Amount Remaining not matching up again after reconciliation and checklinks

(0) Share

Report

Report

Posted on by Huan

180

Hi,

The Original Amount and Amount Remaining do not match when amounts are not applied. Amount Remaining (or Unapplied Amount) is greater than Original Amount. I performed Tools>>Utilities>>Sales>>Reconcile on both Current Customer Information and Outstanding Documents Amounts. It did not fix the problem.

So that I run the following update query.

update RM20101 set CURTRXAM = XXXXX.XX where DOCNUMBR = 'YYYYY'

It fixed the problem at the time. However when I run the reconcile again. The amount changed back to wrong number as before.

Please advise how to fix this.

Thanks in advance.

Huan

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

soma 24,406 on at

Like (0)

Report

RE: Original Amount / Amount Remaining not matching up again after reconciliation and checklinks

What is your original Document Amount and unapplied amount for the document?

Run the below query against company database and attach the result to us.

SELECT * FROM RM20101 WHERE DOCNUMBR= 'XXXX'

SELECT * FROM RM20201 WHERE APFRDCNM = 'XXXX'

Note: XXXX replace with your document number.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Original Amount / Amount Remaining not matching up again after reconciliation and checklinks

Hi Huan,

Please have a look on the below community forum link related to this

community.dynamics.com/.../90500.aspx

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans