You’re offline. This is a read only version of the page.
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
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.
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
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.
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
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?
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.
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.
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 (