web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / help - AR Payment appl...
Microsoft Dynamics SL (Archived)

help - AR Payment application - Doc Balance larger than Doc Amount.

(0) ShareShare
ReportReport
Posted on by rodi 3,205

hi there,

I need help.

one of batch on AR Payment Application has abnormal. somehow unapplied balance larger (double) than Payment orig amt. this cause:

- on GL Trial balance, no effect (correct amount is payment orig amt).

- on Customer Trial balance, the balance not correct, because it's following unapplied balance.

need help, why this happen and how to fix it?

thanks.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    It sure sounds like you might have an application reversal involved that went wrong.  To further diagnose, first look and see if you have any suspended (S status) AR batches.  You can use the batch register to look for these.  Second, pull up the customer and payment reference number on the application inquiry screen and look in the grid section for multiple applications/reversals of the payment.  Let us know if you find either of the above and then we can go from there.

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    Hi,

    thanks for reply.

    first, there isn't s status for ar batch (I looked into batch table).

    second, I put its customer id and reference no., and show 2 record. (image as attached)

    each one has same amount applied, but row 2 is negative.

    need help please. thanks.

  • Community Member Profile Picture
    Community Member on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    OK, so it looks like application inquiry/reversal was used on this payment since you have one positive line and one negative line.  since the amount is the same, it appears that this process did not get run more than once.

    It sounds like you are comfortable running a SQL query so I would next suggest that you run the following query.

    Select * from aradjust where custid = 'xxxxxx' and adjrefnbr = 'yyyyyy'.

    xxxxxx would be the customer in question and yyyyyy would be the reference number of the payment.

    Based on the result of the application inquiry screen, there should only be two line found and the adjamt on one line should be positive and the adjamt on the other line should be negative and both should be for the same amount and the amount of the payment or the amount of the invoice or debit memo the payment was applied to (whichever is less)..  If you see something other than that then we need to discuss.

    Also, run the following query and tell me what you see in the following fields:

    origdocamt, docbal, curydocbal

    Select * from ardoc where custid = 'xxxxxx' and refnbr = 'yyyyyy'

    Finally, what currency was the invoice in and what currency was the payment in?

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    hi,

    result for aradjust is as you said, there are 2 lines and so on.

    result for ardoc:

    origdocamt 1000

    docbal, 2000

    curydocbal 2000

    about the currency, for invoice with refnbr = 000199, same with the payment.

    but, amount of the invoice is not same with the payment.

    also, it might be useful information, on payment application screen, for that payment, payment orig amt is half than unapplied balance. those suppose same each other, correct?

    thanks in advance

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    Thanks for the added information.  From what you have said, I cannot tell exactly what happened but my guess is that you had a timing situation with a batch that was maybe suspended but subsequently released involving this payment and/or reversal of the application.

    Since ARAdjust looks fine, the GL side is fine and the original amount on the payment document is fine I believe that you can execute the following query to resolve the issue with no side effects.

    begin transaction

    update ardoc set docbal = 1000, currydocbal = 1000 where custid = 'xxxxxx' and refnbr = 'yyyyyy'

    commit transaction

    Be sure to just execute the first two line first and make sure that only 1 record is updated.  If so, execute the commit transaction.  If not execute a rollback transaction instead and we will need to discuss.

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    hi,

    thanks for query, I've tried and it say so,only 1 row updated.

    so, is the problem clear? I mean, I don't know whether any table(s) also updated by this screen (payment application), regarding this issue.

    anyway, thanks for help

  • Community Member Profile Picture
    Community Member on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    You should be fine.  The reason I asked the other questions was to ensure this was all that had to be done.  the payment application screen modifies the payment document (reducing its balance by the amount applied), the invoice document (reducing its balance by the amount applied to it) and it creates one or more aradjust entries to map the payment to the invoice.  As long as the origdocamt of the payment was correct, you should be fine.

  • rodi Profile Picture
    rodi 3,205 on at
    RE: help - AR Payment application - Doc Balance larger than Doc Amount.

    hi. well then, thanks so much for help. :)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans