You’re offline. This is a read only version of the page.
2,305
Hello,
I have an open invoice for a customer that shows in RM20101. However, when I am trying to apply a payment to the invoice, it is not showing up as an option.
When I check in the RM20201 table, it is not there. Is there an easy fix for this?
TIA,
Jae
*This post is locked for comments
Hi,
Check Links will not do anything to a document with respect to Document Amount not matching the Amount Remaining.
If there are no applied documents against the invoice and the Amount Remaining is not equal the Document Amount, the best thing is to use Reconcile (Outstanding Document Amount option).
If that does not work, run the script below:
UPDATE RM20101 set CURTRXAM = ORTRXAMT where DOCNUMBR = 'XXX'
**Where XXX is the invoice in question
Let me know if you have further questions.
Both the document amount and applied amount match up but the remaining amount is 0. Do I need to update the record to say the CURTRXAM should be the same as the ORTRXAMT? Afterwards, run check links?
Currently, the payment does not show applied to the invoice and has a CURTRXAM for the matching invoice amount.
To add up to what's mentioned above, use the following script in order to check the Document Amount along with the applied and unapplied amount,
SELECT CUSTNMBR,
DOCNUMBR,
CASE RMDTYPAL
WHEN 1 then 'invoice'
WHEN 3 then 'debit_memo'
WHEN 4 then 'finance_Charge'
WHEN 5 then 'Service_Repair'
WHEN 6 then 'warranty'
WHEN 7 then 'credit_memo'
WHEN 8 then 'return'
WHEN 9 then 'payment'
else 'n.a'
END Document_Type,
ORTRXAMT Document_Amount,
ORTRXAMT-CURTRXAM AS Applied_Amount,
CURTRXAM Remaining_Amount
FROM RM20101
WHERE CUSTNMBR = '#CustomerNumber'
Note:
Debit and Credit amounts are not distinguished with signs (+/-)
In case the reconciliation didn't solve it up, I might expect "posting corruption" resulting with incorrect flag in the "RM20101" RM Open Transaction table.
Your feedback is highly appreciated in order to dig for further details if required.
Hi,
Check the invoice in the Receivables Transaction Inquiry - Document window (Inquiry | Sales | Transaction by Document) and expand the lines. Is the Document Amount equal to the Amount Remaining?
If it is not, highlight the document then click the Amount Remaining link. Verify if there are any applied documents. If there aren't any, run Reconcile (MDGP | Tools | Utilities | Sales | Reconcile) then use the Outstanding Document Amounts option against the Debtor in question.
Once done reconciling, go back to the Receivables Transaction Inquiry - Document window and verify again if the Amount Remaining is corrected.
This should be corrected now and you should be able to apply payments against it.
Have you tried the Check Links ?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (